cc_related_persons

12148 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('cc_related_persons_id_seq'::regclass)
cc_attorneys.related_person_id cc_attorneys_related_person_id_fkeyR
cc_party_addresses.related_person_id cc_party_addresses_related_person_id_fkeyR
cc_party_alias.related_person_id cc_party_alias_related_person_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_related_persons_case_number_fkeyC

Indexes

Constraint Name Type Sort Column(s)
cc_related_persons_pkey Primary key Asc id
ixh_cc_related_persons_case_number Performance Asc case_number

Relationships

Close relationships within degrees of separation