Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| change_request_id | bigserial | 19 | √ | nextval('tbl_change_requests_change_request_id_seq'::regclass) |
|
|
|||||
| entity_type | text | 2147483647 | null |
|
|
||||||
| entity_id | int8 | 19 | null |
|
|
||||||
| requested_by | int8 | 19 | null |
|
|
||||||
| proposed_patch_json | jsonb | 2147483647 | null |
|
|
||||||
| status | text | 2147483647 | 'PENDING'::text |
|
|
||||||
| reviewed_by | int8 | 19 | √ | null |
|
|
|||||
| reviewed_at | timestamp | 29,6 | √ | null |
|
|
|||||
| reviewer_note | text | 2147483647 | √ | null |
|
|
|||||
| created_at | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
||||||
| updated_at | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
||||||
| requester_reason | text | 2147483647 | √ | null |
|
|
|||||
| base_snapshot | jsonb | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_change_requests_pkey | Primary key | Asc | change_request_id |
| idx_tbl_change_requests_entity | Performance | Asc/Asc | entity_type + entity_id |
| idx_tbl_change_requests_requester_created_at | Performance | Asc/Desc | requested_by + created_at |
| idx_tbl_change_requests_status_created_at | Performance | Asc/Desc | status + created_at |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| tbl_change_requests_status_check | (status = ANY (ARRAY['PENDING'::text, 'APPROVED'::text, 'REJECTED'::text])) |