cc_attorneys

14703 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('cc_attorneys_id_seq'::regclass)
plaintiff_id int4 10 √ null
cc_plaintiffs.id cc_attorneys_plaintiff_id_fkeyR
defendant_id int4 10 √ null
cc_defendants.id cc_attorneys_defendant_id_fkeyR
related_person_id int4 10 √ null
cc_related_persons.id cc_attorneys_related_person_id_fkeyR
name varchar 2147483647 √ null
appearance_date date 13 √ null
appearance_date_str varchar 2147483647 √ null
removal_date date 13 √ null
removal_date_str varchar 2147483647 √ null
practice_name varchar 2147483647 √ null
address_1 varchar 2147483647 √ null
address_2 varchar 2147483647 √ null
city varchar 2147483647 √ null
state varchar 2147483647 √ null
zip_code varchar 2147483647 √ null
case_number varchar 2147483647 √ null
cc.case_number cc_attorneys_case_number_fkeyC

Indexes

Constraint Name Type Sort Column(s)
cc_attorneys_pkey Primary key Asc id
ixh_cc_attorneys_case_number Performance Asc case_number

Relationships

Close relationships within degrees of separation