court_appearance

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('court_appearance_id_seq'::regclass)
appearance_charge.appearance_id appearance_charge_appearance_id_fkey R
court_appearance_history.original_appearance_id court_appearance_history_original_appearance_id_fkey R
court_case.latest_court_appearance_id latest_court_appearance_fk R
next_court_appearance.future_skeleton_appearance_id next_court_appearance_future_skeleton_appearance_id_fkey R
period_length.appearance_id period_length_appearance_id_fkey R
uploaded_document.appearance_id uploaded_document_appearance_id_fkey R
appearance_outcome_id int4 10 √ null
appearance_outcome.id court_appearance_appearance_outcome_id_fkey R
court_case_id int4 10 null
court_case.id court_appearance_court_case_id_fkey R
court_code varchar 2147483647 null
court_case_reference varchar 2147483647 √ null
appearance_date date 13 null
next_court_appearance_id int4 10 √ null
created_at timestamptz 35,6 null
created_by varchar 2147483647 null
created_prison varchar 2147483647 √ null
warrant_type varchar 2147483647 'REMAND'::character varying
overall_conviction_date date 13 √ null
appearance_uuid uuid 2147483647 gen_random_uuid()
legacy_data jsonb 2147483647 √ null
updated_at timestamptz 35,6 √ null
updated_by varchar 2147483647 √ null
updated_prison varchar 2147483647 √ null
source varchar 2147483647 'NOMIS'::character varying
status_id varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
court_appearance_pkey Primary key Asc id
idx_court_appearance_appearance_date_asc Performance Asc appearance_date
idx_court_appearance_appearance_date_desc Performance Desc appearance_date
idx_court_appearance_court_case_id Performance Asc court_case_id
idx_court_appearance_lifetime Performance Asc appearance_uuid
idx_court_appearance_status_id Performance Asc status_id
idx_court_appearance_status_id_date Performance Asc/Asc appearance_date + status_id

Relationships

Close relationships within degrees of separation