zsjz-ai/sql/plat.sql

drop table if exists bank_card_issuer_info;
create table bank_card_issuer_info
(
    bank_bin  TEXT not null primary key,
    bank_name TEXT,
    card_type TEXT,
    flag      INTEGER
);

drop table if exists case_info;
create table case_info
(
    -- 主键由应用侧雪花算法生成，不使用自增
    id          BIGINT not null primary key,
    name        TEXT,
    pwd         TEXT,
    type        TEXT,
    remark      TEXT,
    db          TEXT,
    db_Path     TEXT,
    init        INTEGER,
    create_time DATE
);

drop table if exists phone_isp;
create table phone_isp
(
    paragraph TEXT not null primary key,
    province  TEXT,
    city      TEXT,
    isp       TEXT
);

drop table if exists system_info;
create table system_info
(
    machinecode      TEXT,
    client_no        TEXT,
    unit             TEXT,
    phone            TEXT,
    active_date_time DATE,
    authdatetime     DATE,
    overdatetime     DATE
);

drop table if exists table_field;
create table table_field
(
    id             INTEGER           not null primary key,
    table_id       INTEGER           not null,
    field_name_cn  TEXT,
    field_name_en  TEXT,
    field_type     TEXT,
    required       INTEGER default 0 not null,
    field_len      INTEGER default 0 not null,
    matched        INTEGER,
    direction_conf TEXT,
    field_sort     INTEGER
);

drop table if exists table_info;
create table table_info
(
    id            INTEGER not null primary key,
    main_id       INTEGER,
    table_name_cn TEXT,
    table_name_en TEXT,
    headers       TEXT,
    classify      TEXT,
    func_regex    TEXT,
    line_no       INTEGER default 0,
    has_inner     INTEGER default 0,
    create_time   DATE
);

DROP TABLE IF EXISTS `chat_message`;
CREATE TABLE `chat_message`
(
    `id`         INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `session_id` TEXT,
    `content`    TEXT,
    `role`       TEXT,
    `model_name` TEXT
);

DROP TABLE IF EXISTS `chat_session`;
CREATE TABLE `chat_session`
(
    `id`              TEXT,
    `case_id`         INTEGER,
    `session_title`   TEXT,
    `session_content` TEXT,
    `conversation_id` TEXT
);

DROP TABLE IF EXISTS `chat_model`;
CREATE TABLE `chat_model`
(
    `id`              INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `category`        TEXT,
    `model_name`      TEXT,
    `provider_code`   TEXT,
    `model_describe`  TEXT,
    `model_dimension` INTEGER,
    `api_host`        TEXT,
    `api_key`         TEXT
);

DROP TABLE IF EXISTS `chat_provider`;
CREATE TABLE `chat_provider`
(
    `id`            INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `provider_name` TEXT,
    `provider_code` TEXT,
    `provider_icon` TEXT,
    `provider_desc` TEXT,
    `api_host`      TEXT
);


DROP TABLE IF EXISTS `knowledge_attach`;
CREATE TABLE `knowledge_attach`
(
    `id`           INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `knowledge_id` INTEGER,
    `oss_id`       INTEGER,
    `doc_id`       TEXT,
    `name`         TEXT,
    `type`         TEXT
);

DROP TABLE IF EXISTS `knowledge_fragment`;
CREATE TABLE `knowledge_fragment`
(
    `id`      INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `idx`     INTEGER,
    `doc_id`  TEXT,
    `content` TEXT
);

DROP TABLE IF EXISTS `knowledge_info`;
CREATE TABLE `knowledge_info`
(
    `id`              INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `name`            TEXT,
    `share`           INTEGER,
    `description`     TEXT,
    `separator`       TEXT,
    `overlap_char`    INTEGER,
    `retrieve_limit`  INTEGER,
    `text_block_size` INTEGER,
    `vector_model`    TEXT,
    `embedding_model` TEXT
);