odytraf

294761 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('odytraf_id_seq'::regclass)
court_system varchar 2147483647 √ null
location varchar 2147483647 √ null
citation_number varchar 2147483647 √ null
case_title varchar 2147483647 √ null
case_type varchar 2147483647 √ null
filing_date date 13 √ null
filing_date_str varchar 2147483647 √ null
violation_date date 13 √ null
violation_date_str varchar 2147483647 √ null
violation_time time 15,6 √ null
violation_time_str varchar 2147483647 √ null
violation_county varchar 2147483647 √ null
agency_name varchar 2147483647 √ null
officer_id varchar 2147483647 √ null
officer_name varchar 2147483647 √ null
case_status varchar 2147483647 √ null
case_number varchar 2147483647 √ null
odytraf_aliases.case_number odytraf_aliases_case_number_fkeyC
odytraf_attorneys.case_number odytraf_attorneys_case_number_fkeyC
odytraf_bail_bonds.case_number odytraf_bail_bonds_case_number_fkeyC
odytraf_bond_settings.case_number odytraf_bond_settings_case_number_fkeyC
odytraf_charges.case_number odytraf_charges_case_number_fkeyC
odytraf_court_schedule.case_number odytraf_court_schedule_case_number_fkeyC
odytraf_defendants.case_number odytraf_defendants_case_number_fkeyC
odytraf_documents.case_number odytraf_documents_case_number_fkeyC
odytraf_involved_parties.case_number odytraf_involved_parties_case_number_fkeyC
odytraf_reference_numbers.case_number odytraf_reference_numbers_case_number_fkeyC
odytraf_services.case_number odytraf_services_case_number_fkeyC
odytraf_warrants.case_number odytraf_warrants_case_number_fkeyC
cases.case_number odytraf_case_number_fkeyC

Indexes

Constraint Name Type Sort Column(s)
odytraf_pkey Primary key Asc id
ixh_odytraf_case_number Performance Asc case_number
odytraf_case_number_key Must be unique Asc case_number
uq_odytraf_case_number Must be unique Asc case_number

Relationships

Close relationships within degrees of separation