court_case

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('court_case_id_seq'::regclass)
charge.merged_from_case_id charge_merged_from_case_id_fkey R
court_appearance.court_case_id court_appearance_court_case_id_fkey R
court_case.merged_to_case_id fk_merged_to_case_id R
court_case_history.original_court_case_id court_case_history_original_court_case_id_fkey R
prisoner_id varchar 2147483647 null
case_unique_identifier varchar 2147483647 null
latest_court_appearance_id int4 10 √ null
court_appearance.id latest_court_appearance_fk R
created_at timestamptz 35,6 null
created_by varchar 2147483647 null
legacy_data jsonb 2147483647 √ null
created_prison varchar 2147483647 √ null
merged_to_case_id int4 10 √ null
court_case.id fk_merged_to_case_id R
merged_to_date date 13 √ null
updated_at timestamptz 35,6 √ null
updated_by varchar 2147483647 √ null
status_id varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
court_case_pkey Primary key Asc id
idx_court_case_booking_id Performance
idx_court_case_case_unique_identifier Must be unique Asc case_unique_identifier
idx_court_case_latest_court_appearance Performance Asc latest_court_appearance_id
idx_court_case_merged_to_case_id Performance Asc merged_to_case_id
idx_court_case_prisoner_id Performance Asc prisoner_id
idx_court_case_status_id Performance Asc status_id

Relationships

Close relationships within degrees of separation