TIME_PERIOD_HISTORY |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| person_key | decimal (15,0) | PERSON | fk_time_period_history1 | |
| time_period_key | decimal (15,0) | TIME_PERIOD_SETUP | fk_time_period_history2 | |
| begin_date | datetime | |||
| end_date | datetime | YES | ||
Indexes on TIME_PERIOD_HISTORY |
|
| Index Name | Column(s) |
|---|---|
| pk_time_period_history | person_key, time_period_key, begin_date |