meeat/meeat.procrusql

table meet
column meet id serial primary key
column meet title text not null
column meet key text unique
column meet active boolean default true

table date
column date id serial primary key
column date date date not null
column date display text
column date meet int references meet not null

table time
column time id serial primary key
column time time time not null
column time display text
column time meet int references meet not null

table place
column place id serial primary key
column place name text not null
column place meet int references meet not null

table bod
column bod id serial primary key
column bod email text not null unique
column bod short text
column bod key text unique
column bod keychange timestamptz default now()

table date_vote
column date_vote date int not null references date
column date_vote bod int not null references bod
column date_vote preference float4

table time_vote
column time_vote time int not null references time
column time_vote bod int not null references bod
column time_vote preference float4

table place_vote
column place_vote place int not null references place
column place_vote bod int not null references bod
column place_vote preference float4

table news
column news id serial primary key
column news meet int references meet not null
column news ts timestamptz not null default now()
column news content text not null