cc_plaintiffs

8436 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('cc_plaintiffs_id_seq'::regclass)
cc_attorneys.plaintiff_id cc_attorneys_plaintiff_id_fkeyR
cc_party_addresses.plaintiff_id cc_party_addresses_plaintiff_id_fkeyR
cc_party_alias.plaintiff_id cc_party_alias_plaintiff_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_plaintiffs_case_number_fkeyC

Indexes

Constraint Name Type Sort Column(s)
cc_plaintiffs_pkey Primary key Asc id
ixh_cc_plaintiffs_case_number Performance Asc case_number

Relationships

Close relationships within degrees of separation