Work_calendar_holidays

Columns

Name Type Length Precision Scale References In Description
date_holiday TIMESTAMP Date of holiday
description VARCHAR2 100 Description
work_calendar_id NUMBER 39 0 work_calendar_id
Work_calendars
Work calendar ID

Primary key (Composite)

PK Column Name
work_calendar_id
date_holiday

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
work_calendar_holidays_work_calendars_fk work_calendar_id Work_calendars work_calendar_id 1