Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| daytime_id | int4 | 10 | null |
|
|
Primary key representing seconds in a day (1-86400) |
||
| daytime | varchar | 256 | √ | null |
|
|
Time in HH:MM:SS format |
|
| hour | int4 | 10 | √ | null |
|
|
Hour component (0-23) |
|
| minute | int4 | 10 | √ | null |
|
|
Minute component (0-59) |
|
| second | int4 | 10 | √ | null |
|
|
Second component (0-59) |
|
| last_updated | timestamp | 29,6 | √ | null |
|
|
System column. UTC Timestamp at which entry was calculated (lags shortly behind source system). |
Relationships
Close relationships within degrees of separation
