data_salary

209219 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('data_salary_id_seq'::regclass)
pay_grade varchar 16 null
rank varchar 64 √ null
salary int4 10 null
employee_status varchar 32 null
org_hire_date date 13 √ null
spp_date date 13 √ null
start_date date 13 √ null
year int2 5 null
age_at_hire int2 5 √ null
officer_id int4 10 null
data_officer.id data_salary_officer_id_8d6c46ab_fk_data_officer_idR
rank_changed bool 1 null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
data_salary_pkey Primary key Asc id
data_salary_officer_id_8d6c46ab Performance Asc officer_id
data_salary_year_51b276_idx Performance Asc year

Check Constraints

Constraint Name Constraint
data_salary_salary_check ((salary >= 0))
data_salary_year_check ((year >= 0))
data_salary_age_at_hire_check ((age_at_hire >= 0))

Relationships

Close relationships within degrees of separation