TIME_PERIOD_SETUP |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| time_period_key | decimal (15,0) | |||
| period_name | varchar (20) | |||
| code | varchar (1) | VALID_TIME_PERIOD | fk_time_period_setup1 | |
| begin_date1 | datetime | |||
| begin_date2 | datetime | YES | ||
| enabled | varchar (1) | |||
| description | varchar (100) | YES | ||
References made to TIME_PERIOD_SETUP |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| PERSON | time_period_key | fk_person4 |
| TIME_PERIOD | time_period_key | fk_time_period1 |
| TIME_PERIOD_HISTORY | time_period_key | fk_time_period_history2 |
Check Constraints for TIME_PERIOD_SETUP |
|
| Check Constraint Name | Definition |
|---|---|
| cc_tps_enabled | (enabled = 'N' or (enabled = 'Y')) |
Indexes on TIME_PERIOD_SETUP |
|
| Index Name | Column(s) |
|---|---|
| idx_time_period_setup1 | period_name |
| pk_time_period_setup | time_period_key |