cc_defendants

17812 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('cc_defendants_id_seq'::regclass)
cc_attorneys.defendant_id cc_attorneys_defendant_id_fkeyR
cc_party_addresses.defendant_id cc_party_addresses_defendant_id_fkeyR
cc_party_alias.defendant_id cc_party_alias_defendant_id_fkeyR
party_type varchar 2147483647 √ null
party_number int4 10 √ null
name varchar 2147483647 √ null
business_org_name varchar 2147483647 √ null
case_number varchar 2147483647 √ null
cc.case_number cc_defendants_case_number_fkeyC

Indexes

Constraint Name Type Sort Column(s)
cc_defendants_pkey Primary key Asc id
ixh_cc_defendants_case_number Performance Asc case_number

Relationships

Close relationships within degrees of separation