dsk8

3054 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('dsk8_id_seq'::regclass)
court_system varchar 2147483647 √ null
case_status varchar 2147483647 √ null
status_date date 13 √ null
status_date_str varchar 2147483647 √ null
tracking_number varchar 2147483647 √ null
complaint_number varchar 2147483647 √ null
district_case_number varchar 2147483647 √ null
cases.case_number Implied ConstraintR
filing_date date 13 √ null
filing_date_str varchar 2147483647 √ null
incident_date date 13 √ null
incident_date_str varchar 2147483647 √ null
case_number varchar 2147483647 √ null
dsk8_bail_and_bond.case_number dsk8_bail_and_bond_case_number_fkeyC
dsk8_bondsman.case_number dsk8_bondsman_case_number_fkeyC
dsk8_charges.case_number dsk8_charges_case_number_fkeyC
dsk8_defendant_aliases.case_number dsk8_defendant_aliases_case_number_fkeyC
dsk8_defendants.case_number dsk8_defendants_case_number_fkeyC
dsk8_events.case_number dsk8_events_case_number_fkeyC
dsk8_related_persons.case_number dsk8_related_persons_case_number_fkeyC
dsk8_trials.case_number dsk8_trials_case_number_fkeyC
cases.case_number dsk8_case_number_fkeyC

Indexes

Constraint Name Type Sort Column(s)
dsk8_pkey Primary key Asc id
dsk8_case_number_key Must be unique Asc case_number
ixh_dsk8_case_number Performance Asc case_number
uq_dsk8_case_number Must be unique Asc case_number

Relationships

Close relationships within degrees of separation