cc

7815 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('cc_id_seq'::regclass)
court_system varchar 2147483647 √ null
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_disposition varchar 2147483647 √ null
disposition_date date 13 √ null
disposition_date_str varchar 2147483647 √ null
case_number varchar 2147483647 √ null
cc_attorneys.case_number cc_attorneys_case_number_fkeyC
cc_court_schedule.case_number cc_court_schedule_case_number_fkeyC
cc_defendants.case_number cc_defendants_case_number_fkeyC
cc_district_case_numbers.case_number cc_district_case_numbers_case_number_fkeyC
cc_documents.case_number cc_documents_case_number_fkeyC
cc_judgment_modifications.case_number cc_judgment_modifications_case_number_fkeyC
cc_judgments.case_number cc_judgments_case_number_fkeyC
cc_judgments_against.case_number cc_judgments_against_case_number_fkeyC
cc_judgments_in_favor.case_number cc_judgments_in_favor_case_number_fkeyC
cc_party_addresses.case_number cc_party_addresses_case_number_fkeyC
cc_party_alias.case_number cc_party_alias_case_number_fkeyC
cc_plaintiffs.case_number cc_plaintiffs_case_number_fkeyC
cc_related_persons.case_number cc_related_persons_case_number_fkeyC
cc_support_orders.case_number cc_support_orders_case_number_fkeyC
cases.case_number cc_case_number_fkeyC

Indexes

Constraint Name Type Sort Column(s)
cc_pkey Primary key Asc id
cc_case_number_key Must be unique Asc case_number
ixh_cc_case_number Performance Asc case_number
uq_cc_case_number Must be unique Asc case_number

Relationships

Close relationships within degrees of separation