Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| promoteitemid | serial | 10 | √ | nextval('promoteitem_promoteitemid_seq'::regclass) |
|
|
||||
| promoterequestid | int4 | 10 | null |
|
|
|||||
| packagename | varchar | 255 | null |
|
|
|||||
| platform | varchar | 10 | null |
|
|
|||||
| dependencies | text | 2147483647 | √ | null |
|
|
||||
| status | varchar | 10 | √ | 'WAITING'::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| promoteitem_pkey | Primary key | Asc | promoteitemid |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| promoteitem_platform_check | (((platform)::text = ANY ((ARRAY['Manual'::character varying, 'ChangeMan'::character varying, 'Jenkins'::character varying, 'Azure'::character varying, 'ARCAD'::character varying])::text[]))) |
| promoteitem_status_check | (((status)::text = ANY ((ARRAY['WAITING'::character varying, 'BUSY'::character varying, 'ERROR'::character varying, 'DONE'::character varying])::text[]))) |
Relationships
Close relationships within degrees of separation
