create table time_of_day 
(
    id                                 serial  not null,
    time_of_day                        varchar(8),
    hour                               integer,
    minute                             integer,
    second                             integer,
    am_or_pm                           varchar(2),
    day_or_night                       varchar(5),
    constraint primary_key_time_of_day primary key (id)
);
