TIME_PERIOD |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| time_period_key | decimal (15,0) | TIME_PERIOD_SETUP | fk_time_period1 | |
| begin_date | datetime | |||
| end_date | datetime | |||
| period_number | int | |||
References made to TIME_PERIOD |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| PERSON_TIME | time_period_key | fk_person_time4 |
| PERSON_TIME | begin_date | fk_person_time4 |
Indexes on TIME_PERIOD |
|
| Index Name | Column(s) |
|---|---|
| pk_time_period | time_period_key, begin_date |