create table inventories
(
    asset_id       bigint primary key references hosts (id) on update cascade on delete cascade,
    name           text,
    os             text,
    kernel         text,
    kernel_version text,
    os_version     text,
    cpu_cores      integer,
    cpu_name       text,
    cpu_vendor     text,
    uptime         bigint,
    arch           text,
    host_uuid      text,
    collected_at   timestamptz not null default now()
);
