dim_daytime

-1 rows


Description

This table contains all times of a day from 00:00:00 to 23:59:59 with the granularity of one second.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
daytime_id int4 10 null

Primary key of this table. Contains values from 1 to 86400.

daytime varchar 256 null

The time formatted to HH:mm:ss (eg 14:26:37).

hour int4 10 null

The numbered hour part of the time.

minute int4 10 null

The numbered minute part of the time.

second int4 10 null

The numbered second part of the time.

last_updated timestamptz 35 null

System column. UTC Timestamp at which entry was calculated (lags behind source system).

Relationships