create database log_analysis; create table statistics( name varchar(64), value int, primary key (name) ); insert into statistics (name, value) values ('total', 0), ('anomaly', 0), ('not anomaly', 0), ('undefined', 0); create table logs_classes( id serial, name text, description text, primary key (id) ); insert into logs_classes (name, description) values ('unknown', ''); create table anomaly_logs( id serial, class_id int references logs_classes(id), data text, primary key (id) );