This table contains various attributes related to time, providing detailed temporal information within a day. Each row represents a minute of a clock.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
time_id (PK) |
SMALLINT | PK | Unique identifier for a specific time. | Yes |
minute_of_day |
SMALLINT | Minute number within the day (0-1439). | Yes | |
minute_of_hour |
SMALLINT | Minute number within the hour (0-59). | No | |
hour_of_day |
SMALLINT | Hour number within the day (0-23, 24-hour format). | Yes | |
hour_of_half_day |
SMALLINT | Hour number within the half-day (1-12). | No | |
clock_hour_of_day |
SMALLINT | Clock hour within the day (1-24). | No | |
clock_hour_of_halfday |
SMALLINT | Clock hour within the half-day (1-12). | No | |
halfday_of_day |
SMALLINT | Indicator for AM/PM (for example, 0 for AM, 1 for PM). | No | |
halfday_of_day_display_name |
VARCHAR | Display name for half-day (for example, "AM", "PM"). | No | |
time_display_name_24hr |
VARCHAR | User-friendly display name for time in 24-hour format (for example, "14:30"). | No | |
time_display_name_12hr |
VARCHAR | User-friendly display name for time in 12-hour format (for example, "11:22 PM"). | No |