data_officerhistory - cpdb Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

serial

10

√

nextval('data_officerhistory_id_seq'::regclass)

effective_date

date

13

√

null

end_date

date

13

√

null

officer_id

int4

10

√

null

data_officer.id

data_officerhistory_officer_id_db19fe27_fk_data_officer_id R

unit_id

int4

10

√

null

data_policeunit.id

data_officerhistory_unit_id_c33c0072_fk_data_policeunit_id R

Showing 1 to 5 of 5 entries

Table contained 101 874 rows

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
data_officerhistory_pkey	Primary key	Asc	id
data_officerhistory_e1d6855c	Performance	Asc	officer_id
data_officerhistory_e8175980	Performance	Asc	unit_id

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees