odycrim_defendants

93608 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('odycrim_defendants_id_seq'::regclass)
odycrim_aliases.defendant_id odycrim_aliases_defendant_id_fkeyR
odycrim_attorneys.defendant_id odycrim_attorneys_defendant_id_fkeyR
name varchar 2147483647 √ null
race varchar 2147483647 √ null
sex varchar 2147483647 √ null
weight int4 10 √ null
DOB date 13 √ null
DOB_str 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
height varchar 2147483647 √ null
hair_color varchar 2147483647 √ null
eye_color varchar 2147483647 √ null
case_number varchar 2147483647 √ null
odycrim.case_number odycrim_defendants_case_number_fkeyC

Indexes

Constraint Name Type Sort Column(s)
odycrim_defendants_pkey Primary key Asc id
ixh_odycrim_defendants_case_number Performance Asc case_number

Relationships

Close relationships within degrees of separation