登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 55

magicdetective/playground

forked from 帝博软件/playground 
代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
克隆/下载
crm_example.sql 39.58 KB
一键复制 编辑 原始数据 按行查看 历史
mazc 提交于 2023-09-21 11:37 . * 添加crm示例sql，便于体验devtools
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586
INSERT INTO dbt_dictionary (id, parent_id, tenant_id, `type`, item_name, item_name_i18n, item_value, description, extension, sort_id, is_editable, is_deletable, is_deleted, create_time) VALUES('1704389951212695553', '0', '0', 'CUS_POS', '客户联系人职位', NULL, NULL, NULL, NULL, 99, 1, 1, 0, '2023-09-20 15:00:05');

INSERT INTO dbt_dictionary (id, parent_id, tenant_id, `type`, item_name, item_name_i18n, item_value, description, extension, sort_id, is_editable, is_deletable, is_deleted, create_time) VALUES('1704389951233667074', '1704389951212695553', '0', 'CUS_POS', 'IT 负责人', NULL, 'ITLeader', NULL, '{"color":"#00CED1"}', 0, 1, 1, 0, '2023-09-20 15:00:05');

INSERT INTO dbt_dictionary (id, parent_id, tenant_id, `type`, item_name, item_name_i18n, item_value, description, extension, sort_id, is_editable, is_deletable, is_deleted, create_time) VALUES('1704389951237861377', '1704389951212695553', '0', 'CUS_POS', 'CEO', NULL, 'CEO', NULL, '{"color":"#0062FF"}', 1, 1, 1, 0, '2023-09-20 15:00:05');

INSERT INTO dbt_dictionary (id, parent_id, tenant_id, `type`, item_name, item_name_i18n, item_value, description, extension, sort_id, is_editable, is_deletable, is_deleted, create_time) VALUES('1704392357199687681', '0', '0', 'BUS_STATUS', '商机状态', NULL, NULL, NULL, NULL, 99, 1, 1, 0, '2023-09-20 15:09:39');

INSERT INTO dbt_dictionary (id, parent_id, tenant_id, `type`, item_name, item_name_i18n, item_value, description, extension, sort_id, is_editable, is_deletable, is_deleted, create_time) VALUES('1704392357220659202', '1704392357199687681', '0', 'BUS_STATUS', '待跟进', NULL, 'DGJ', NULL, '{"color":"#1E90FF"}', 0, 1, 1, 0, '2023-09-20 15:09:39');

INSERT INTO dbt_dictionary (id, parent_id, tenant_id, `type`, item_name, item_name_i18n, item_value, description, extension, sort_id, is_editable, is_deletable, is_deleted, create_time) VALUES('1704392357224853505', '1704392357199687681', '0', 'BUS_STATUS', '初步协商', NULL, 'CBXS', NULL, '{"color":"#FFD700"}', 1, 1, 1, 0, '2023-09-20 15:09:39');

INSERT INTO dbt_dictionary (id, parent_id, tenant_id, `type`, item_name, item_name_i18n, item_value, description, extension, sort_id, is_editable, is_deletable, is_deleted, create_time) VALUES('1704392357229047810', '1704392357199687681', '0', 'BUS_STATUS', '已报价', NULL, 'YBJ', NULL, '{"color":"#00CED1"}', 2, 1, 1, 0, '2023-09-20 15:09:39');

INSERT INTO dbt_dictionary (id, parent_id, tenant_id, `type`, item_name, item_name_i18n, item_value, description, extension, sort_id, is_editable, is_deletable, is_deleted, create_time) VALUES('1704392357229047811', '1704392357199687681', '0', 'BUS_STATUS', '赢单', NULL, 'YD', NULL, '{"color":"#90EE90"}', 3, 1, 1, 0, '2023-09-20 15:09:39');

INSERT INTO dbt_dictionary (id, parent_id, tenant_id, `type`, item_name, item_name_i18n, item_value, description, extension, sort_id, is_editable, is_deletable, is_deleted, create_time) VALUES('1704392357233242113', '1704392357199687681', '0', 'BUS_STATUS', '丢单', NULL, 'DJ', NULL, '{"color":"#FF8C00"}', 4, 1, 1, 0, '2023-09-20 15:09:39');



INSERT INTO dbtlc_model_category (id, tenant_id, parent_id, app_module, name, code, `level`, sort_id, remark, is_editable, is_deleted, create_time, update_time) VALUES('1704385285905133569', '0', '0', 'model-center', 'CRM', 'CRM', 0, 10, NULL, 1, 0, '2023-09-20 14:41:33', '2023-09-20 14:41:33');



INSERT INTO dbtlc_meta_model (id, tenant_id, category_id, app_module, `key`, label, storage_key, id_key, id_type, extension, features, status, is_editable, is_deleted, create_time, update_time) VALUES('1704386264952156166', '0', '1704385285905133569', 'model-center', 'SaleArea', '销售区域', 'mdl_sale_area', 'id', 'ASSIGN_ID', '{"menuId":"1704668331677663234","menuParentId":"1704464754652844033","menuName":"区域管理"}', 'TREE', 'DRAFT', 1, 0, '2023-09-20 14:45:26', '2023-09-21 09:26:16');

INSERT INTO dbtlc_meta_model (id, tenant_id, category_id, app_module, `key`, label, storage_key, id_key, id_type, extension, features, status, is_editable, is_deleted, create_time, update_time) VALUES('1704386747112566790', '0', '1704385285905133569', 'model-center', 'Sales', '销售员', 'mdl_sales', 'id', 'ASSIGN_ID', '{"menuId":"1704682043184599042","menuParentId":"1704464754652844033","menuName":"销售员管理"}', NULL, 'DRAFT', 1, 0, '2023-09-20 14:47:21', '2023-09-21 10:20:45');

INSERT INTO dbtlc_meta_model (id, tenant_id, category_id, app_module, `key`, label, storage_key, id_key, id_type, extension, features, status, is_editable, is_deleted, create_time, update_time) VALUES('1704388652287078408', '0', '1704385285905133569', 'model-center', 'Customer', '客户', 'mdl_customer', 'id', 'ASSIGN_ID', '{"menuId":"1704682472845266946","menuParentId":"1704464754652844033","menuName":"客户管理"}', NULL, 'DRAFT', 1, 0, '2023-09-20 14:54:55', '2023-09-21 10:22:27');

INSERT INTO dbtlc_meta_model (id, tenant_id, category_id, app_module, `key`, label, storage_key, id_key, id_type, extension, features, status, is_editable, is_deleted, create_time, update_time) VALUES('1704391451179692039', '0', '1704385285905133569', 'model-center', 'Chance', '商机', 'mdl_chance', 'id', 'ASSIGN_ID', '{"menuId":"1704682530454032385","menuParentId":"1704464754652844033","menuName":"商机管理"}', NULL, 'DRAFT', 1, 0, '2023-09-20 15:06:03', '2023-09-21 10:22:41');

INSERT INTO dbtlc_meta_model (id, tenant_id, category_id, app_module, `key`, label, storage_key, id_key, id_type, extension, features, status, is_editable, is_deleted, create_time, update_time) VALUES('1704393451602653190', '0', '1704385285905133569', 'model-center', 'Follow', '跟进记录', 'mdl_follow', 'id', 'ASSIGN_ID', '{"menuId":"1704682602784804865","menuParentId":"1704464754652844033","menuName":"跟进记录"}', NULL, 'DRAFT', 1, 0, '2023-09-20 15:14:00', '2023-09-21 10:22:58');

INSERT INTO dbtlc_meta_model (id, tenant_id, category_id, app_module, `key`, label, storage_key, id_key, id_type, extension, features, status, is_editable, is_deleted, create_time, update_time) VALUES('1704441659640569863', '0', '1704385285905133569', 'model-center', 'Contract', '合同', 'mdl_contract', 'id', 'ASSIGN_ID', '{"menuId":"1704682649891033089","menuParentId":"1704464754652844033","menuName":"合同管理"}', NULL, 'DRAFT', 1, 0, '2023-09-20 18:25:33', '2023-09-21 10:23:09');



INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386264947961857', '0', '1704386264952156166', 'id', '唯一标识', 'id', 'TXT_SHORT', 32, 1, 0, NULL, NULL, NULL, NULL, 1, NULL, 0, '2023-09-20 14:45:26', '2023-09-20 14:45:26');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386264947961858', '0', '1704386264952156166', 'name', '名称', 'name', 'TXT_SHORT', 50, 1, 0, NULL, NULL, NULL, NULL, 11, '{"comparison":"LIKE"}', 0, '2023-09-20 14:45:26', '2023-09-20 14:45:26');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386264947961859', '0', '1704386264952156166', 'parentId', '上级', 'parent_id', 'REL_FIELD', 32, 0, 0, '0', 'many_one', '1704386264952156166', '1704386264947961858', 2, '{"relType":"many_one","appModule":"model-center","modelId":"1704386264952156166","modelKey":"SaleArea","treeModel":true,"fieldId":"1704386264947961858","fieldKey":"name"}', 0, '2023-09-20 14:45:26', '2023-09-20 14:46:50');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386264947961860', '0', '1704386264952156166', 'parentIdsPath', '上级id路径', 'parent_ids_path', 'TXT_SHORT', 500, 0, 0, NULL, NULL, NULL, NULL, 3, NULL, 0, '2023-09-20 14:45:26', '2023-09-20 14:45:26');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386264952156161', '0', '1704386264952156166', 'createBy', '创建人', 'create_by', 'USER', 32, 0, 0, NULL, NULL, NULL, NULL, 996, '{"relType":"many_one","appModule":"model-center","modelId":"1591260224109547520","modelKey":"User","treeModel":false,"fieldId":"1591262799303151618","fieldKey":"realname"}', 0, '2023-09-20 14:45:26', '2023-09-20 14:45:26');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386264952156162', '0', '1704386264952156166', 'createTime', '创建时间', 'create_time', 'DATETIME', 0, 0, 0, NULL, NULL, NULL, NULL, 997, NULL, 0, '2023-09-20 14:45:26', '2023-09-20 14:45:26');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386264952156163', '0', '1704386264952156166', 'updateBy', '更新人', 'update_by', 'USER', 32, 0, 0, NULL, NULL, NULL, NULL, 998, '{"relType":"many_one","appModule":"model-center","modelId":"1591260224109547520","modelKey":"User","treeModel":false,"fieldId":"1591262799303151618","fieldKey":"realname"}', 0, '2023-09-20 14:45:26', '2023-09-20 14:45:26');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386264952156164', '0', '1704386264952156166', 'updateTime', '更新时间', 'update_time', 'DATETIME', 0, 0, 0, NULL, NULL, NULL, NULL, 999, NULL, 0, '2023-09-20 14:45:26', '2023-09-20 14:45:26');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386264952156165', '0', '1704386264952156166', 'deleted', '是否删除', 'is_deleted', 'BOOLEAN', 0, 1, 0, '0', NULL, NULL, NULL, 995, NULL, 0, '2023-09-20 14:45:26', '2023-09-20 14:45:26');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386616434831362', '0', '1704386264952156166', 'remark', '备注', 'remark', 'TXT_SHORT', 200, 0, 0, NULL, NULL, NULL, NULL, 12, '{"comparison":"LIKE"}', 0, '2023-09-20 14:46:50', '2023-09-20 14:46:50');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386747108372481', '0', '1704386747112566790', 'id', '唯一标识', 'id', 'TXT_SHORT', 32, 1, 0, NULL, NULL, NULL, NULL, 1, NULL, 0, '2023-09-20 14:47:21', '2023-09-20 14:47:21');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386747108372482', '0', '1704386747112566790', 'createBy', '创建人', 'create_by', 'USER', 32, 0, 0, NULL, NULL, NULL, NULL, 996, '{"relType":"many_one","appModule":"model-center","modelId":"1591260224109547520","modelKey":"User","treeModel":false,"fieldId":"1591262799303151618","fieldKey":"realname"}', 0, '2023-09-20 14:47:21', '2023-09-20 14:47:21');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386747112566786', '0', '1704386747112566790', 'createTime', '创建时间', 'create_time', 'DATETIME', 0, 0, 0, NULL, NULL, NULL, NULL, 997, NULL, 0, '2023-09-20 14:47:21', '2023-09-20 14:47:21');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386747112566787', '0', '1704386747112566790', 'updateBy', '更新人', 'update_by', 'USER', 32, 0, 0, NULL, NULL, NULL, NULL, 998, '{"relType":"many_one","appModule":"model-center","modelId":"1591260224109547520","modelKey":"User","treeModel":false,"fieldId":"1591262799303151618","fieldKey":"realname"}', 0, '2023-09-20 14:47:21', '2023-09-20 14:47:21');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386747112566788', '0', '1704386747112566790', 'updateTime', '更新时间', 'update_time', 'DATETIME', 0, 0, 0, NULL, NULL, NULL, NULL, 999, NULL, 0, '2023-09-20 14:47:21', '2023-09-20 14:47:21');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704386747112566789', '0', '1704386747112566790', 'deleted', '是否删除', 'is_deleted', 'BOOLEAN', 0, 1, 0, '0', NULL, NULL, NULL, 995, NULL, 0, '2023-09-20 14:47:21', '2023-09-20 14:47:21');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704387086368845825', '0', '1704386747112566790', 'realname', '姓名', 'realname', 'TXT_SHORT', 100, 0, 0, NULL, NULL, NULL, NULL, 11, '{"comparison":"LIKE"}', 0, '2023-09-20 14:48:42', '2023-09-20 14:48:42');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704387086368845826', '0', '1704386747112566790', 'area', '负责区域', 'area', 'REL_FIELD', 32, 0, 0, NULL, 'many_one', '1704386264952156166', '1704386264947961858', 12, '{"relType":"many_one","appModule":"model-center","modelId":"1704386264952156166","modelKey":"SaleArea","treeModel":true,"fieldId":"1704386264947961858","fieldKey":"name"}', 0, '2023-09-20 14:48:42', '2023-09-20 14:48:42');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704388652287078402', '0', '1704388652287078408', 'id', '唯一标识', 'id', 'TXT_SHORT', 32, 1, 0, NULL, NULL, NULL, NULL, 1, NULL, 0, '2023-09-20 14:54:55', '2023-09-20 14:54:55');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704388652287078403', '0', '1704388652287078408', 'createBy', '创建人', 'create_by', 'USER', 32, 0, 0, NULL, NULL, NULL, NULL, 996, '{"relType":"many_one","appModule":"model-center","modelId":"1591260224109547520","modelKey":"User","treeModel":false,"fieldId":"1591262799303151618","fieldKey":"realname"}', 0, '2023-09-20 14:54:55', '2023-09-20 14:54:55');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704388652287078404', '0', '1704388652287078408', 'createTime', '创建时间', 'create_time', 'DATETIME', 0, 0, 0, NULL, NULL, NULL, NULL, 997, NULL, 0, '2023-09-20 14:54:55', '2023-09-20 14:54:55');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704388652287078405', '0', '1704388652287078408', 'updateBy', '更新人', 'update_by', 'USER', 32, 0, 0, NULL, NULL, NULL, NULL, 998, '{"relType":"many_one","appModule":"model-center","modelId":"1591260224109547520","modelKey":"User","treeModel":false,"fieldId":"1591262799303151618","fieldKey":"realname"}', 0, '2023-09-20 14:54:55', '2023-09-20 14:54:55');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704388652287078406', '0', '1704388652287078408', 'updateTime', '更新时间', 'update_time', 'DATETIME', 0, 0, 0, NULL, NULL, NULL, NULL, 999, NULL, 0, '2023-09-20 14:54:55', '2023-09-20 14:54:55');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704388652287078407', '0', '1704388652287078408', 'deleted', '是否删除', 'is_deleted', 'BOOLEAN', 0, 1, 0, '0', NULL, NULL, NULL, 995, NULL, 0, '2023-09-20 14:54:55', '2023-09-20 14:54:55');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704390170876784643', '0', '1704388652287078408', 'name', '名称', 'name', 'TXT_SHORT', 100, 0, 0, NULL, NULL, NULL, NULL, 11, '{"comparison":"LIKE"}', 0, '2023-09-20 15:00:57', '2023-09-20 15:04:47');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704390170876784644', '0', '1704388652287078408', 'address', '地址', 'address', 'TXT_SHORT', 100, 0, 0, NULL, NULL, NULL, NULL, 12, '{"comparison":"LIKE"}', 0, '2023-09-20 15:00:57', '2023-09-20 15:04:47');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704390170876784645', '0', '1704388652287078408', 'contactPerson', '联系人', 'contact_person', 'TXT_SHORT', 100, 0, 0, NULL, NULL, NULL, NULL, 13, '{"comparison":"LIKE"}', 0, '2023-09-20 15:00:57', '2023-09-20 15:04:47');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704390170876784646', '0', '1704388652287078408', 'phone', '联系电话', 'phone', 'TXT_SHORT', 100, 0, 0, NULL, NULL, NULL, NULL, 14, '{"comparison":"LIKE"}', 0, '2023-09-20 15:00:57', '2023-09-20 15:04:47');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704390170876784647', '0', '1704388652287078408', 'position', '联系人职位', 'position', 'REL_DICT', 20, 0, 0, NULL, NULL, NULL, NULL, 15, '{"dictType":"CUS_POS"}', 0, '2023-09-20 15:00:57', '2023-09-20 15:04:47');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704390170876784648', '0', '1704388652287078408', 'sales', '销售员', 'sales', 'REL_FIELD', 32, 0, 0, NULL, 'many_one', '1704386747112566790', '1704387086368845825', 16, '{"relType":"many_one","appModule":"model-center","modelId":"1704386747112566790","modelKey":"Sales","treeModel":false,"fieldId":"1704387086368845825","fieldKey":"realname"}', 0, '2023-09-20 15:00:57', '2023-09-20 15:04:47');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704391451179692033', '0', '1704391451179692039', 'id', '唯一标识', 'id', 'TXT_SHORT', 32, 1, 0, NULL, NULL, NULL, NULL, 1, NULL, 0, '2023-09-20 15:06:03', '2023-09-20 15:06:03');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704391451179692034', '0', '1704391451179692039', 'createBy', '创建人', 'create_by', 'USER', 32, 0, 0, NULL, NULL, NULL, NULL, 996, '{"relType":"many_one","appModule":"model-center","modelId":"1591260224109547520","modelKey":"User","treeModel":false,"fieldId":"1591262799303151618","fieldKey":"realname"}', 0, '2023-09-20 15:06:03', '2023-09-20 15:06:03');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704391451179692035', '0', '1704391451179692039', 'createTime', '创建时间', 'create_time', 'DATETIME', 0, 0, 0, NULL, NULL, NULL, NULL, 997, NULL, 0, '2023-09-20 15:06:03', '2023-09-20 15:06:03');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704391451179692036', '0', '1704391451179692039', 'updateBy', '更新人', 'update_by', 'USER', 32, 0, 0, NULL, NULL, NULL, NULL, 998, '{"relType":"many_one","appModule":"model-center","modelId":"1591260224109547520","modelKey":"User","treeModel":false,"fieldId":"1591262799303151618","fieldKey":"realname"}', 0, '2023-09-20 15:06:03', '2023-09-20 15:06:03');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704391451179692037', '0', '1704391451179692039', 'updateTime', '更新时间', 'update_time', 'DATETIME', 0, 0, 0, NULL, NULL, NULL, NULL, 999, NULL, 0, '2023-09-20 15:06:03', '2023-09-20 15:06:03');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704391451179692038', '0', '1704391451179692039', 'deleted', '是否删除', 'is_deleted', 'BOOLEAN', 0, 1, 0, '0', NULL, NULL, NULL, 995, NULL, 0, '2023-09-20 15:06:03', '2023-09-20 15:06:03');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704392736066973697', '0', '1704391451179692039', 'title', '机会名称', 'title', 'TXT_SHORT', 100, 0, 0, NULL, NULL, NULL, NULL, 11, '{"comparison":"LIKE"}', 0, '2023-09-20 15:11:09', '2023-09-20 15:11:09');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704392736066973698', '0', '1704391451179692039', 'customer', '客户', 'customer', 'REL_FIELD', 32, 0, 0, NULL, 'many_one', '1704388652287078408', '1704390170876784643', 12, '{"relType":"many_one","appModule":"model-center","modelId":"1704388652287078408","modelKey":"Customer","treeModel":false,"fieldId":"1704390170876784643","fieldKey":"name"}', 0, '2023-09-20 15:11:09', '2023-09-20 15:11:09');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704392736066973699', '0', '1704391451179692039', 'description', '机会描述', 'description', 'TXT_SHORT', 500, 0, 0, NULL, NULL, NULL, NULL, 13, '{"comparison":"LIKE"}', 0, '2023-09-20 15:11:09', '2023-09-20 15:11:09');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704392736066973700', '0', '1704391451179692039', 'status', '商机状态', 'status', 'REL_DICT', 20, 0, 0, NULL, NULL, NULL, NULL, 14, '{"dictType":"BUS_STATUS"}', 0, '2023-09-20 15:11:09', '2023-09-20 15:11:09');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704392736066973701', '0', '1704391451179692039', 'area', '销售区域', 'area', 'REL_FIELD', 32, 0, 0, NULL, 'many_one', '1704386264952156166', '1704386264947961858', 15, '{"relType":"many_one","appModule":"model-center","modelId":"1704386264952156166","modelKey":"SaleArea","treeModel":true,"fieldId":"1704386264947961858","fieldKey":"name"}', 0, '2023-09-20 15:11:09', '2023-09-20 15:11:09');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704392736066973702', '0', '1704391451179692039', 'sales', '跟进销售员', 'sales', 'REL_FIELD', 32, 0, 0, NULL, 'many_one', '1704386747112566790', '1704387086368845825', 16, '{"relType":"many_one","appModule":"model-center","modelId":"1704386747112566790","modelKey":"Sales","treeModel":false,"fieldId":"1704387086368845825","fieldKey":"realname"}', 0, '2023-09-20 15:11:09', '2023-09-20 15:11:09');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704392736066973703', '0', '1704391451179692039', 'remark', '备注', 'remark', 'TXT_LONG', 1000, 0, 0, NULL, NULL, NULL, NULL, 17, '{"comparison":"LIKE"}', 0, '2023-09-20 15:11:09', '2023-09-20 15:11:09');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704393451598458881', '0', '1704393451602653190', 'id', '唯一标识', 'id', 'TXT_SHORT', 32, 1, 0, NULL, NULL, NULL, NULL, 1, NULL, 0, '2023-09-20 15:14:00', '2023-09-20 15:14:00');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704393451602653185', '0', '1704393451602653190', 'createBy', '创建人', 'create_by', 'USER', 32, 0, 0, NULL, NULL, NULL, NULL, 996, '{"relType":"many_one","appModule":"model-center","modelId":"1591260224109547520","modelKey":"User","treeModel":false,"fieldId":"1591262799303151618","fieldKey":"realname"}', 0, '2023-09-20 15:14:00', '2023-09-20 15:14:00');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704393451602653186', '0', '1704393451602653190', 'createTime', '创建时间', 'create_time', 'DATETIME', 0, 0, 0, NULL, NULL, NULL, NULL, 997, NULL, 0, '2023-09-20 15:14:00', '2023-09-20 15:14:00');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704393451602653187', '0', '1704393451602653190', 'updateBy', '更新人', 'update_by', 'USER', 32, 0, 0, NULL, NULL, NULL, NULL, 998, '{"relType":"many_one","appModule":"model-center","modelId":"1591260224109547520","modelKey":"User","treeModel":false,"fieldId":"1591262799303151618","fieldKey":"realname"}', 0, '2023-09-20 15:14:00', '2023-09-20 15:14:00');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704393451602653188', '0', '1704393451602653190', 'updateTime', '更新时间', 'update_time', 'DATETIME', 0, 0, 0, NULL, NULL, NULL, NULL, 999, NULL, 0, '2023-09-20 15:14:00', '2023-09-20 15:14:00');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704393451602653189', '0', '1704393451602653190', 'deleted', '是否删除', 'is_deleted', 'BOOLEAN', 0, 1, 0, '0', NULL, NULL, NULL, 995, NULL, 0, '2023-09-20 15:14:00', '2023-09-20 15:14:00');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704394408805740545', '0', '1704393451602653190', 'chance', '商机名称', 'chance', 'REL_FIELD', 32, 0, 0, NULL, 'many_one', '1704391451179692039', '1704392736066973697', 11, '{"relType":"many_one","appModule":"model-center","modelId":"1704391451179692039","modelKey":"Chance","treeModel":false,"fieldId":"1704392736066973697","fieldKey":"title"}', 0, '2023-09-20 15:17:48', '2023-09-20 15:17:48');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704394408805740546', '0', '1704393451602653190', 'customer', '客户', 'customer', 'REL_REFER', 0, 0, 0, NULL, NULL, NULL, '1704392736066973698', 12, '{"relationFieldKey":"chance","referenceFieldId":"1704392736066973698"}', 0, '2023-09-20 15:17:48', '2023-09-20 15:17:48');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704394408805740547', '0', '1704393451602653190', 'content', '跟进内容', 'content', 'TXT_SHORT', 200, 0, 0, NULL, NULL, NULL, NULL, 13, '{"comparison":"LIKE"}', 0, '2023-09-20 15:17:48', '2023-09-20 15:17:48');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704394408805740548', '0', '1704393451602653190', 'sales', '跟进人', 'sales', 'REL_FIELD', 32, 0, 0, NULL, 'many_one', '1704386747112566790', '1704387086368845825', 14, '{"relType":"many_one","appModule":"model-center","modelId":"1704386747112566790","modelKey":"Sales","treeModel":false,"fieldId":"1704387086368845825","fieldKey":"realname"}', 0, '2023-09-20 15:17:48', '2023-09-20 15:17:48');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704394408805740549', '0', '1704393451602653190', 'followDate', '跟进日期', 'follow_date', 'DATE', 0, 0, 0, NULL, NULL, NULL, NULL, 15, '{}', 0, '2023-09-20 15:17:48', '2023-09-20 15:17:48');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704394408805740550', '0', '1704393451602653190', 'remark', '备注', 'remark', 'TXT_SHORT', 500, 0, 0, NULL, NULL, NULL, NULL, 16, '{"comparison":"LIKE"}', 0, '2023-09-20 15:17:48', '2023-09-20 15:17:48');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704441659627986946', '0', '1704441659640569863', 'id', '唯一标识', 'id', 'TXT_SHORT', 32, 1, 0, NULL, NULL, NULL, NULL, 1, NULL, 0, '2023-09-20 18:25:33', '2023-09-20 18:25:33');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704441659640569858', '0', '1704441659640569863', 'createBy', '创建人', 'create_by', 'USER', 32, 0, 0, NULL, NULL, NULL, NULL, 996, '{"relType":"many_one","appModule":"model-center","modelId":"1591260224109547520","modelKey":"User","treeModel":false,"fieldId":"1591262799303151618","fieldKey":"realname"}', 0, '2023-09-20 18:25:33', '2023-09-20 18:25:33');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704441659640569859', '0', '1704441659640569863', 'createTime', '创建时间', 'create_time', 'DATETIME', 0, 0, 0, NULL, NULL, NULL, NULL, 997, NULL, 0, '2023-09-20 18:25:33', '2023-09-20 18:25:33');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704441659640569860', '0', '1704441659640569863', 'updateBy', '更新人', 'update_by', 'USER', 32, 0, 0, NULL, NULL, NULL, NULL, 998, '{"relType":"many_one","appModule":"model-center","modelId":"1591260224109547520","modelKey":"User","treeModel":false,"fieldId":"1591262799303151618","fieldKey":"realname"}', 0, '2023-09-20 18:25:33', '2023-09-20 18:25:33');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704441659640569861', '0', '1704441659640569863', 'updateTime', '更新时间', 'update_time', 'DATETIME', 0, 0, 0, NULL, NULL, NULL, NULL, 999, NULL, 0, '2023-09-20 18:25:33', '2023-09-20 18:25:33');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704441659640569862', '0', '1704441659640569863', 'deleted', '是否删除', 'is_deleted', 'BOOLEAN', 0, 1, 0, '0', NULL, NULL, NULL, 995, NULL, 0, '2023-09-20 18:25:33', '2023-09-20 18:25:33');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704442111153201154', '0', '1704441659640569863', 'sn', '编号', 'sn', 'TXT_SHORT', 100, 0, 0, NULL, NULL, NULL, NULL, 11, '{"comparison":"LIKE"}', 0, '2023-09-20 18:27:21', '2023-09-20 18:27:21');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704442111153201155', '0', '1704441659640569863', 'customer', '客户', 'customer', 'REL_FIELD', 32, 0, 0, NULL, 'many_one', '1704388652287078408', '1704390170876784643', 12, '{"relType":"many_one","appModule":"model-center","modelId":"1704388652287078408","modelKey":"Customer","treeModel":false,"fieldId":"1704390170876784643","fieldKey":"name"}', 0, '2023-09-20 18:27:21', '2023-09-20 18:27:21');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704442111153201156', '0', '1704441659640569863', 'title', '标题', 'title', 'TXT_SHORT', 100, 0, 0, NULL, NULL, NULL, NULL, 13, '{"comparison":"LIKE"}', 0, '2023-09-20 18:27:21', '2023-09-20 18:27:21');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704442111153201157', '0', '1704441659640569863', 'amount', '金额', 'amount', 'NUM_INTEGER', 20, 0, 0, NULL, NULL, NULL, NULL, 14, '{}', 0, '2023-09-20 18:27:21', '2023-09-20 18:27:21');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704442111153201158', '0', '1704441659640569863', 'remark', '备注', 'remark', 'TXT_SHORT', 500, 0, 0, NULL, NULL, NULL, NULL, 16, '{"comparison":"LIKE"}', 0, '2023-09-20 18:27:21', '2023-09-20 21:27:09');

INSERT INTO dbtlc_meta_field (id, tenant_id, model_id, `key`, label, storage_key, data_type, data_length, is_required, is_unique, default_val, rel_type, rel_model_id, rel_label_field_id, sort_id, extension, is_deleted, create_time, update_time) VALUES('1704487359090843650', '0', '1704441659640569863', 'attachment', '附件', 'attachment', 'UPLOAD_FILE', 500, 0, 0, NULL, NULL, NULL, NULL, 15, '{}', 0, '2023-09-20 21:27:09', '2023-09-20 21:27:09');
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/magicdetective/playground.git
[email protected]:magicdetective/playground.git
magicdetective
playground
playground
master-v3
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部