dscivil_complaints - mjcs Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

serial

10

√

nextval('dscivil_complaints_id_seq'::regclass)

dscivil_hearings.complaint_id	dscivil_hearings_complaint_id_fkeyR
dscivil_judgments.complaint_id	dscivil_judgments_complaint_id_fkeyR
dscivil_related_persons.complaint_id	dscivil_related_persons_complaint_id_fkeyR

complaint_number

int4

10

√

null

plaintiff

varchar

2147483647

√

null

defendant

varchar

2147483647

√

null

complaint_type

varchar

2147483647

√

null

complaint_status

varchar

2147483647

√

null

status_date

date

13

√

null

status_date_str

varchar

2147483647

√

null

filing_date

date

13

√

null

filing_date_str

varchar

2147483647

√

null

Showing 1 to 10 of 14 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
dscivil_complaints_pkey	Primary key	Asc	id
ixh_dscivil_complaints_case_number	Performance	Asc	case_number

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees