odycrim

93413 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('odycrim_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
tracking_numbers varchar 2147483647 √ null
case_number varchar 2147483647 √ null
odycrim_aliases.case_number odycrim_aliases_case_number_fkeyC
odycrim_attorneys.case_number odycrim_attorneys_case_number_fkeyC
odycrim_bail_bonds.case_number odycrim_bail_bonds_case_number_fkeyC
odycrim_bond_settings.case_number odycrim_bond_settings_case_number_fkeyC
odycrim_charges.case_number odycrim_charges_case_number_fkeyC
odycrim_court_schedule.case_number odycrim_court_schedule_case_number_fkeyC
odycrim_defendants.case_number odycrim_defendants_case_number_fkeyC
odycrim_documents.case_number odycrim_documents_case_number_fkeyC
odycrim_involved_parties.case_number odycrim_involved_parties_case_number_fkeyC
odycrim_probation.case_number odycrim_probation_case_number_fkeyC
odycrim_reference_numbers.case_number odycrim_reference_numbers_case_number_fkeyC
odycrim_restitutions.case_number odycrim_restitutions_case_number_fkeyC
odycrim_services.case_number odycrim_services_case_number_fkeyC
odycrim_warrants.case_number odycrim_warrants_case_number_fkeyC
cases.case_number odycrim_case_number_fkeyC

Indexes

Constraint Name Type Sort Column(s)
odycrim_pkey Primary key Asc id
ixh_odycrim_case_number Performance Asc case_number
odycrim_case_number_key Must be unique Asc case_number
uq_odycrim_case_number Must be unique Asc case_number

Relationships

Close relationships within degrees of separation