Table: holiday
Columns
| |
Column Name |
Data Type |
Default
Value |
References
Table |
Foreign Key
Name |
| 1. |
PK |
holiday_key |
decimal(15) |
|
|
|
| 2. |
|
holiday_date |
datetime |
|
|
|
| 3. |
|
project_key |
decimal(15) |
|
project |
fk_holiday1 |
| 4. |
|
task_key |
decimal(15) |
|
task |
fk_holiday2 |
| 5. |
|
description |
varchar(50) |
|
|
|
Foreign Keys
| Column |
References |
Foreign Key Name |
| Table |
Column |
| project_key |
project |
project_key |
fk_holiday1 |
| task_key |
task |
task_key |
fk_holiday2 |
Indices
| Index Name |
Unique |
Column Name |
Asc Or Desc |
| pk_holiday |
true |
holiday_key |
Asc |
| idx_holiday1 |
true |
holiday_date |
Asc |
| |
|
project_key |
|
| |
|
task_key |
|