dscivil

40167 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('dscivil_id_seq'::regclass)
court_system varchar 2147483647 √ null
claim_type varchar 2147483647 √ null
district_code int4 10 √ null
location_code int4 10 √ null
filing_date date 13 √ null
filing_date_str varchar 2147483647 √ null
case_status varchar 2147483647 √ null
case_number varchar 2147483647 √ null
dscivil_complaints.case_number dscivil_complaints_case_number_fkeyC
dscivil_events.case_number dscivil_events_case_number_fkeyC
dscivil_hearings.case_number dscivil_hearings_case_number_fkeyC
dscivil_judgments.case_number dscivil_judgments_case_number_fkeyC
dscivil_related_persons.case_number dscivil_related_persons_case_number_fkeyC
dscivil_trials.case_number dscivil_trials_case_number_fkeyC
cases.case_number dscivil_case_number_fkeyC

Indexes

Constraint Name Type Sort Column(s)
dscivil_pkey Primary key Asc id
dscivil_case_number_key Must be unique Asc case_number
ixh_dscivil_case_number Performance Asc case_number
uq_dscivil_case_number Must be unique Asc case_number

Relationships

Close relationships within degrees of separation