data_officerhistory


Columns

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

Table contained 106874 rows

Indexes

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

Relationships

Close relationships within degrees of separation