cases

905892 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
case_number varchar 2147483647 null
cc.case_number cc_case_number_fkeyC
cc_district_case_numbers.district_case_number Implied ConstraintR
dscivil.case_number dscivil_case_number_fkeyC
dscr.case_number dscr_case_number_fkeyC
dsk8.case_number dsk8_case_number_fkeyC
dsk8.district_case_number Implied ConstraintR
odycivil.case_number odycivil_case_number_fkeyC
odycrim.case_number odycrim_case_number_fkeyC
odytraf.case_number odytraf_case_number_fkeyC
scrape_versions.case_number scrape_versions_case_number_fkeyC
scrapes.case_number scrapes_case_number_fkeyC
court varchar 2147483647 √ null
query_court varchar 2147483647 √ null
case_type varchar 2147483647 √ null
filing_date date 13 √ null
filing_date_original varchar 2147483647 √ null
status varchar 2147483647 √ null
caption varchar 2147483647 √ null
loc int4 10 √ null
detail_loc varchar 2147483647 √ null
url varchar 2147483647 √ null
last_scrape timestamp 29,6 √ null
last_parse timestamp 29,6 √ null
scrape_exempt bool 1 false
parse_exempt bool 1 false
active bool 1 true

Indexes

Constraint Name Type Sort Column(s)
cases_pkey Primary key Asc case_number
ix_cases_filing_date Performance Asc filing_date
ixh_cases_case_number Performance Asc case_number

Relationships

Close relationships within degrees of separation