Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('next_court_appearance_id_seq'::regclass) |
|
|
|||||
| appearance_date | date | 13 | null |
|
|
Description: The date of the next court appearance for the court case. Source System: Remand & Sentencing |
|||||
| court_code | varchar | 2147483647 | √ | null |
|
|
Description: The code of the court where the next appearance will take place. These codes are held in Court Register Source System: Court Register |
||||
| appearance_time | time | 15,6 | √ | null |
|
|
Description: The time of the next court appearance. Optional Source System: Remand & Sentencing |
||||
| future_skeleton_appearance_id | int4 | 10 | null |
|
|
Description: The id of the next future court appearance, no outcome or warrant type will be populated yet. Source System: Remand & Sentencing |
|||||
| appearance_type_id | int4 | 10 | √ | null |
|
|
Description: The id for the type of the appearance of the next court appearance. The type can be a court appearance or video link. Source System: Remand & Sentencing |
||||
| court_appearance_subtype_id | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| next_court_appearance_pkey | Primary key | Asc | id |
| idx_next_court_appearance_future_skeleton_id | Performance | Asc | future_skeleton_appearance_id |