tbl_staff_toil_adjustment_log

290478 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uid serial 10 √ nextval('tbl_staff_toil_adjustment_log_uid_seq'::regclass)
staff_refid int4 10 √ null
tbl_staff_lookup.refid tbl_staff_toil_adjustment_log_staff_refid_fkeyC
affected_time_sheet int4 10 √ null
tbl_office_time_sheet.refid tbl_staff_toil_adjustment_log_time_sheet_refid_fkeyC
action varchar 100 √ null
value numeric 5,2 √ null
timestamp timestamp 29,6 √ now()
source_time_sheet int4 10 √ null
tbl_office_time_sheet.refid tbl_staff_toil_adjustment_log_source_time_sheet_fkeyN
previous_value numeric 5,2 √ NULL::numeric
author_refid int4 10 √ null
tbl_staff_lookup.refid tbl_staff_toil_adjustment_log_author_refid_fkeyN

Indexes

Constraint Name Type Sort Column(s)
tbl_staff_toil_adjustment_log_pkey Primary key Asc uid

Relationships

Close relationships within degrees of separation