seecoder-devcloud/web/src/main/resources/sql/bug_list.sql

create table if not exists devcloud.bug_list
(
    id                 int auto_increment
        primary key,
    title              varchar(31)                         null,
    description        text                                null,
    time_to_take mediumtext                          null,
    start_time         timestamp default CURRENT_TIMESTAMP not null,
    end_time           timestamp                           null,
    priority           varchar(10)                         null,
    state              varchar(10)                         null,
    project_id         int                                 null,
    processor_id       int                                 null,
    constraint bug_list_project_id_fk
        foreign key (project_id) references devcloud.project (id),
    constraint bug_list_user_id_fk
        foreign key (processor_id) references devcloud.user (id)
);