AI-Backend/java_compile/src/main/resources/script.sql

create table config
(
    id            int auto_increment
        primary key,
    conf_name     varchar(255) null,
    field_ids     varchar(255) null,
    file_info_id  int          not null,
    model_type_id int          not null,
    user_id       int          not null
);

create table dl_model
(
    id            int auto_increment
        primary key,
    arguments     varchar(255) null,
    model_name    varchar(255) null,
    model_path    varchar(255) null,
    model_type_id int          not null,
    pic_file_id   int          not null,
    res_of_model  varchar(255) null,
    trained       bit          not null
);

create table file_info
(
    id              int auto_increment
        primary key,
    file_struc_info varchar(255) null,
    filename        varchar(255) null,
    folder          varchar(255) null,
    location        varchar(255) null,
    upload_time     datetime(6)  null,
    user_id         int          not null
);

create table func_info
(
    id                 int          not null
        primary key,
    flag_of_con_or_dis int          not null,
    flag_of_type       int          not null,
    func_des           varchar(255) null,
    func_name          varchar(255) null
);

create table header_info
(
    id           int          not null
        primary key,
    alias_name   varchar(255) null,
    con_or_dis   int          not null,
    field_des    varchar(255) null,
    field_name   varchar(255) null,
    field_type   varchar(255) null,
    file_info_id int          not null,
    nulls_ratio  double       not null,
    value_info   varchar(255) null
);

create table hibernate_sequence
(
    next_val bigint null
);

create table layer_argument
(
    id          int          not null
        primary key,
    description varchar(255) null,
    is_discrete bit          not null,
    type        varchar(255) null,
    value       varchar(255) null,
    value_des   tinyblob     null
);

create table model
(
    id            int auto_increment
        primary key,
    arguments     varchar(255) null,
    config_id     int          not null,
    file_info_id  int          not null,
    model_name    varchar(255) null,
    model_path    varchar(255) null,
    model_type_id int          not null,
    res_of_model  varchar(255) null,
    trained       bit          not null
);

create table model_type
(
    id                int          not null
        primary key,
    arguments         varchar(255) null,
    model_des         varchar(255) null,
    model_detail_des  varchar(255) null,
    model_detail_name varchar(255) null,
    model_type_name   varchar(255) null
);

create table model_type_argument
(
    id            int          not null
        primary key,
    default_value varchar(255) null,
    description   varchar(255) null,
    is_discrete   bit          not null,
    name          varchar(255) null,
    type          varchar(255) null,
    value_des     varchar(255) null
);

create table pic_category
(
    id            int auto_increment
        primary key,
    category_name varchar(255) null,
    pic_file_id   int          not null
);

create table pic_file
(
    id        int auto_increment
        primary key,
    file_name varchar(255) null,
    loc       varchar(255) null,
    user_id   int          not null
);

create table pic_info
(
    id          int auto_increment
        primary key,
    category_id int          not null,
    location    varchar(255) null,
    picname     varchar(255) null,
    tag         varchar(255) null,
    upload_time datetime(6)  null
);

create table user
(
    id       int auto_increment
        primary key,
    password varchar(255) null,
    username varchar(255) null
);