data_award

656116 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('data_award_id_seq'::regclass)
award_type varchar 255 null
start_date date 13 √ null
end_date date 13 √ null
current_status varchar 20 null
request_date date 13 null
rank varchar 100 null
last_promotion_date date 13 √ null
requester_full_name varchar 255 √ null
ceremony_date date 13 √ null
tracking_no varchar 255 √ null
officer_id int4 10 null
data_officer.id data_award_officer_id_92c5d789_fk_data_officer_idR
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
data_award_pkey Primary key Asc id
data_award_officer_id_92c5d789 Performance Asc officer_id

Relationships

Close relationships within degrees of separation