cc_defendants - mjcs Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

serial

10

√

nextval('cc_defendants_id_seq'::regclass)

cc_attorneys.defendant_id	cc_attorneys_defendant_id_fkeyR
cc_party_addresses.defendant_id	cc_party_addresses_defendant_id_fkeyR
cc_party_alias.defendant_id	cc_party_alias_defendant_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_defendants_case_number_fkeyC

Showing 1 to 6 of 6 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
cc_defendants_pkey	Primary key	Asc	id
ixh_cc_defendants_case_number	Performance	Asc	case_number

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees