odycivil_defendants - mjcs Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

serial

10

√

nextval('odycivil_defendants_id_seq'::regclass)

odycivil_aliases.defendant_id	odycivil_aliases_defendant_id_fkeyR
odycivil_attorneys.defendant_id	odycivil_attorneys_defendant_id_fkeyR

name

varchar

2147483647

√

null

race

varchar

2147483647

√

null

sex

varchar

2147483647

√

null

height

int4

10

√

null

weight

int4

10

√

null

DOB

date

13

√

null

DOB_str

varchar

2147483647

√

null

address_1

varchar

2147483647

√

null

address_2

varchar

2147483647

√

null

Showing 1 to 10 of 14 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
odycivil_defendants_pkey	Primary key	Asc	id
ixh_odycivil_defendants_case_number	Performance	Asc	case_number

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees