Home Explore Help
Sign In
WangKang
/
emoon-backend
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: package-refactoring-org-dromara-to-com-emoon
Branches Tags
emoon-backend
/
script
/
sql
/
mysql-bak-2025-09-26
/
gen_table_column.sql

gen_table_column.sql 10 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445 
  1. create table gen_table_column
    2. 

  2. (
    3. 

  3.     column_id      bigint                    not null comment '编号'
    4. 

  4.         primary key,
    5. 

  5.     table_id       bigint                    null comment '归属表编号',
    6. 

  6.     column_name    varchar(200)              null comment '列名称',
    7. 

  7.     column_comment varchar(500)              null comment '列描述',
    8. 

  8.     column_type    varchar(100)              null comment '列类型',
    9. 

  9.     java_type      varchar(500)              null comment 'JAVA类型',
    10. 

  10.     java_field     varchar(200)              null comment 'JAVA字段名',
    11. 

  11.     is_pk          char                      null comment '是否主键（1是）',
    12. 

  12.     is_increment   char                      null comment '是否自增（1是）',
    13. 

  13.     is_required    char                      null comment '是否必填（1是）',
    14. 

  14.     is_insert      char                      null comment '是否为插入字段（1是）',
    15. 

  15.     is_edit        char                      null comment '是否编辑字段（1是）',
    16. 

  16.     is_list        char                      null comment '是否列表字段（1是）',
    17. 

  17.     is_query       char                      null comment '是否查询字段（1是）',
    18. 

  18.     query_type     varchar(200) default 'EQ' null comment '查询方式（等于、不等于、大于、小于、范围）',
    19. 

  19.     html_type      varchar(200)              null comment '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
    20. 

  20.     dict_type      varchar(200) default ''   null comment '字典类型',
    21. 

  21.     sort           int                       null comment '排序',
    22. 

  22.     create_dept    bigint                    null comment '创建部门',
    23. 

  23.     create_by      bigint                    null comment '创建者',
    24. 

  24.     create_time    datetime                  null comment '创建时间',
    25. 

  25.     update_by      bigint                    null comment '更新者',
    26. 

  26.     update_time    datetime                  null comment '更新时间'
    27. 

  27. )
    28. 

  28.     comment '代码生成业务表字段';
    29. 

  29. 

  30. 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');
    31. 

  31. 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');
    32. 

  32. 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');
    33. 

  33. 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');
    34. 

  34. 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');
    35. 

  35. 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');
    36. 

  36. 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');
    37. 

  37. 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');
    38. 

  38. 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');
    39. 

  39. 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');
    40. 

  40. 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');
    41. 

  41. 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');
    42. 

  42. 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');
    43. 

  43. 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');
    44. 

  44. 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');
    45. 

  45. 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');
    46.