Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| promoterequestid | serial | 10 | √ | nextval('promoterequest_promoterequestid_seq'::regclass) |
|
|
||||
| buildnoteid | int4 | 10 | null |
|
|
|||||
| targetenvironment | varchar | 3 | null |
|
|
|||||
| promotiondate | date | 13 | null |
|
|
|||||
| status | varchar | 10 | √ | 'REQUESTED'::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| promoterequest_pkey | Primary key | Asc | promoterequestid |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| promoterequest_targetenvironment_check | (((targetenvironment)::text = ANY ((ARRAY['TST'::character varying, 'GTU'::character varying, 'UAT'::character varying, 'PTP'::character varying, 'PRD'::character varying])::text[]))) |
| promoterequest_status_check | (((status)::text = ANY ((ARRAY['REQUESTED'::character varying, 'PREPARED'::character varying, 'STARTED'::character varying, 'DONE'::character varying])::text[]))) |
Relationships
Close relationships within degrees of separation
