Description
Time dimension table
Columns
| Column Name | Description |
|---|---|
time_key |
Surrogate key corresponding to the second of the day. The value -1 indicates a NULL timestamp |
time |
24 Hour format time HH:mm:ss |
hour |
24 Hour format hour of the day HH:00:00 |
hour_int |
24 Hour format integer hour of the day 0-23 |
half_hour |
24 Hour format quarter hour of the day HH:30:00 |
quarter_hour |
24 Hour format quarter hour of the day HH:15:00 |
business_id |
Unique identifier for the business |