Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| TIME_ID | INT | 10 | null |
|
|
Time unique ID (hour+minute). |
|||||
| HOUR | INT | 10 | null |
|
|
Time hour minute. |
|||||
| MINUTE | INT | 10 | null |
|
|
Date month number |
|||||
| PERIOD | VARCHAR | 10 | null |
|
|
Period of a day (morning, afternoon, night). |
|||||
| CREATED_AT | DATETIME | 26 | CURRENT_TIMESTAMP(6) |
|
|
Timestamp value to register a record creation time. |
|||||
| UPDATED_AT | DATETIME | 26 | √ | CURRENT_TIMESTAMP(6) |
|
|
Timestamp value to register a record update time. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | TIME_ID |
| DTW_BST_DIM_TIME_HOUR_MIN_IDX | Must be unique | Asc/Asc | HOUR + MINUTE |
Relationships
Close relationships within degrees of separation
