charge

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('charge_id_seq'::regclass)
appearance_charge.charge_id appearance_charge_charge_id_fkey R
charge.superseding_charge_id charge_superseding_charge_id_fkey R
charge_history.original_charge_id charge_history_original_charge_id_fkey R
sentence.charge_id sentence_charge_id_fkey R
charge_uuid uuid 2147483647 null
offence_code varchar 2147483647 null
offence_start_date date 13 √ null
offence_end_date date 13 √ null
charge_outcome_id int4 10 √ null
charge_outcome.id charge_charge_outcome_id_fkey R
superseding_charge_id int4 10 √ null
charge.id charge_superseding_charge_id_fkey R
terror_related bool 1 √ null
created_at timestamptz 35,6 now()
legacy_data jsonb 2147483647 √ null
created_by varchar 2147483647 'UNRECORDED'::character varying
merged_from_case_id int4 10 √ null
court_case.id charge_merged_from_case_id_fkey R
created_prison varchar 2147483647 √ null
updated_at timestamptz 35,6 null
updated_by varchar 2147483647 √ null
updated_prison varchar 2147483647 √ null
merged_from_date date 13 √ null
status_id varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
charge_pkey Primary key Asc id
idx_charge_lifetime Performance Asc charge_uuid
idx_charge_merged_from_case_id Performance Asc merged_from_case_id
idx_charge_status_id Performance Asc status_id
idx_charge_superseding_charge_id Performance Asc superseding_charge_id

Relationships

Close relationships within degrees of separation