dscr

22773 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('dscr_id_seq'::regclass)
court_system varchar 2147483647 √ null
tracking_number varchar 2147483647 √ null
case_type varchar 2147483647 √ null
district_code int4 10 √ null
location_code int4 10 √ null
document_type varchar 2147483647 √ null
issued_date date 13 √ null
issued_date_str varchar 2147483647 √ null
case_status varchar 2147483647 √ null
case_disposition varchar 2147483647 √ null
case_number varchar 2147483647 √ null
dscr_bail_events.case_number dscr_bail_events_case_number_fkeyC
dscr_charges.case_number dscr_charges_case_number_fkeyC
dscr_defendant_aliases.case_number dscr_defendant_aliases_case_number_fkeyC
dscr_defendants.case_number dscr_defendants_case_number_fkeyC
dscr_events.case_number dscr_events_case_number_fkeyC
dscr_related_persons.case_number dscr_related_persons_case_number_fkeyC
dscr_trials.case_number dscr_trials_case_number_fkeyC
cases.case_number dscr_case_number_fkeyC

Indexes

Constraint Name Type Sort Column(s)
dscr_pkey Primary key Asc id
dscr_case_number_key Must be unique Asc case_number
ixh_dscr_case_number Performance Asc case_number
uq_dscr_case_number Must be unique Asc case_number

Relationships

Close relationships within degrees of separation