Unlocked_time_periods

Columns

Name Type Length Precision Scale References In Description
date_created TIMESTAMP
date_last_modified TIMESTAMP
date_period_end TIMESTAMP
date_period_start TIMESTAMP
date_valid_until TIMESTAMP
employee_id NUMBER 39 0 employee_id
Employees
is_inactive VARCHAR2 3
last_modified_by_id NUMBER 39 0 employee_id
Employees
unlocked_time_period_extid VARCHAR2 255
unlocked_time_period_id NUMBER 39 0

Primary key

PK Column Name
unlocked_time_period_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
unlocked_time_periods_employees_fk employee_id Employees employee_id 1
unlocked_time_periods_employees_fk_2 last_modified_by_id Employees employee_id 1