OperationalService/script/1.1.2/schema/4.create_camera_status_offline_log.sql

create table if not exists camera_status_offline_log
(
    id        serial      not null,
    camera_id integer     not null,
    status    varchar(32) not null,
    time      timestamp   not null,
    constraint camera_status_offline_log_pk
        primary key (id)
);

create unique index if not exists camera_status_offline_log_id_uindex
    on camera_status_offline_log (id);