create table gen_table_column
(
    column_id      bigint                    not null comment '编号'
        primary key,
    table_id       bigint                    null comment '归属表编号',
    column_name    varchar(200)              null comment '列名称',
    column_comment varchar(500)              null comment '列描述',
    column_type    varchar(100)              null comment '列类型',
    java_type      varchar(500)              null comment 'JAVA类型',
    java_field     varchar(200)              null comment 'JAVA字段名',
    is_pk          char                      null comment '是否主键（1是）',
    is_increment   char                      null comment '是否自增（1是）',
    is_required    char                      null comment '是否必填（1是）',
    is_insert      char                      null comment '是否为插入字段（1是）',
    is_edit        char                      null comment '是否编辑字段（1是）',
    is_list        char                      null comment '是否列表字段（1是）',
    is_query       char                      null comment '是否查询字段（1是）',
    query_type     varchar(200) default 'EQ' null comment '查询方式（等于、不等于、大于、小于、范围）',
    html_type      varchar(200)              null comment '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
    dict_type      varchar(200) default ''   null comment '字典类型',
    sort           int                       null comment '排序',
    create_dept    bigint                    null comment '创建部门',
    create_by      bigint                    null comment '创建者',
    create_time    datetime                  null comment '创建时间',
    update_by      bigint                    null comment '更新者',
    update_time    datetime                  null comment '更新时间'
)
    comment '代码生成业务表字段';

INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628342067201, 1970296628019105793, 'id', '', 'bigint', 'Long', 'id', '1', '1', '0', null, '1', '1', null, 'EQ', 'input', '', 1, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628350455810, 1970296628019105793, 'tenant_id', '租户id', 'varchar(255)', 'String', 'tenantId', '0', '0', '0', null, null, null, null, 'EQ', 'input', '', 2, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628350455811, 1970296628019105793, 'name', 'mcp名称', 'varchar(255)', 'String', 'name', '0', '0', '0', '1', '1', '1', '1', 'LIKE', 'input', '', 3, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628354650114, 1970296628019105793, 'introduce', '简介', 'varchar(255)', 'String', 'introduce', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'input', '', 4, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628358844418, 1970296628019105793, 'input_data', '输入', 'text', 'String', 'inputData', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'textarea', '', 5, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628358844419, 1970296628019105793, 'output_data', '输出', 'text', 'String', 'outputData', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'textarea', '', 6, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628358844420, 1970296628019105793, 'url', '请求地址', 'varchar(255)', 'String', 'url', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'input', '', 7, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628363038722, 1970296628019105793, 'sort', '排序规则', 'int', 'Long', 'sort', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'input', '', 8, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628363038723, 1970296628019105793, 'agent_id', '智能体id', 'bigint', 'Long', 'agentId', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'input', '', 9, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628363038724, 1970296628019105793, 'status', '状态：0-正常；1-禁用', 'int', 'Long', 'status', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'radio', '', 10, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628367233025, 1970296628019105793, 'create_dept', '创建部门', 'varchar(255)', 'String', 'createDept', '0', '0', '0', null, null, null, null, 'EQ', 'input', '', 11, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628367233026, 1970296628019105793, 'create_by', '创建人', 'bigint', 'Long', 'createBy', '0', '0', '0', null, null, null, null, 'EQ', 'input', '', 12, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628371427329, 1970296628019105793, 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', '0', null, null, null, null, 'EQ', 'datetime', '', 13, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628371427330, 1970296628019105793, 'update_by', '更新时间', 'bigint', 'Long', 'updateBy', '0', '0', '0', null, null, null, null, 'EQ', 'input', '', 14, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628371427331, 1970296628019105793, 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', '0', null, null, null, null, 'EQ', 'datetime', '', 15, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
INSERT INTO ruoyi.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_dept, create_by, create_time, update_by, update_time) VALUES (1970296628375621633, 1970296628019105793, 'remark', '备注', 'text', 'String', 'remark', '0', '0', '0', '1', '1', '1', null, 'EQ', 'textarea', '', 16, 103, 1, '2025-09-23 09:18:17', 1, '2025-09-23 09:18:17');
