dinner_vote/db/ddl.sql

create table main.menu
(
    name       text
        constraint menu_pk
            primary key,
    label      text,
    order_num  integer,
    expression text
);

create table main.roll_result
(
    datestr text
        constraint roll_result_pk
            primary key,
    value   text
);

create table main.user_menu
(
    user     text,
    menu     text,
    datestr  text,
    nickname text,
    dislike  text,
    constraint user_menu_pk
        primary key (user, datestr),
    constraint user_menu_uk
        unique (nickname, datestr)
);

create table main.users
(
    nickname text
        constraint users_pk
            primary key
);