odycivil

7409 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('odycivil_id_seq'::regclass)
court_system varchar 2147483647 √ null
location varchar 2147483647 √ null
case_title varchar 2147483647 √ null
case_type varchar 2147483647 √ null
filing_date date 13 √ null
filing_date_str varchar 2147483647 √ null
case_status varchar 2147483647 √ null
case_number varchar 2147483647 √ null
odycivil_aliases.case_number odycivil_aliases_case_number_fkeyC
odycivil_attorneys.case_number odycivil_attorneys_case_number_fkeyC
odycivil_bail_bonds.case_number odycivil_bail_bonds_case_number_fkeyC
odycivil_bond_settings.case_number odycivil_bond_settings_case_number_fkeyC
odycivil_cause_remedies.case_number odycivil_cause_remedies_case_number_fkeyC
odycivil_causes.case_number odycivil_causes_case_number_fkeyC
odycivil_court_schedule.case_number odycivil_court_schedule_case_number_fkeyC
odycivil_defendants.case_number odycivil_defendants_case_number_fkeyC
odycivil_dispositions.case_number odycivil_dispositions_case_number_fkeyC
odycivil_documents.case_number odycivil_documents_case_number_fkeyC
odycivil_involved_parties.case_number odycivil_involved_parties_case_number_fkeyC
odycivil_judgment_comments.case_number odycivil_judgment_comments_case_number_fkeyC
odycivil_judgment_statuses.case_number odycivil_judgment_statuses_case_number_fkeyC
odycivil_judgments.case_number odycivil_judgments_case_number_fkeyC
odycivil_reference_numbers.case_number odycivil_reference_numbers_case_number_fkeyC
odycivil_services.case_number odycivil_services_case_number_fkeyC
odycivil_warrants.case_number odycivil_warrants_case_number_fkeyC
cases.case_number odycivil_case_number_fkeyC

Indexes

Constraint Name Type Sort Column(s)
odycivil_pkey Primary key Asc id
ixh_odycivil_case_number Performance Asc case_number
odycivil_case_number_key Must be unique Asc case_number

Relationships

Close relationships within degrees of separation