| 123456789101112131415161718192021222324252627282930 |
- create table sys_tenant
- (
- id bigint not null comment 'id'
- primary key,
- tenant_id varchar(20) not null comment '租户编号',
- contact_user_name varchar(20) null comment '联系人',
- contact_phone varchar(20) null comment '联系电话',
- company_name varchar(30) null comment '企业名称',
- license_number varchar(30) null comment '统一社会信用代码',
- address varchar(200) null comment '地址',
- intro varchar(200) null comment '企业简介',
- domain varchar(200) null comment '域名',
- remark varchar(200) null comment '备注',
- package_id bigint null comment '租户套餐编号',
- expire_time datetime null comment '过期时间',
- account_count int default -1 null comment '用户数量（-1不限制）',
- status char default '0' null comment '租户状态（0正常 1停用）',
- del_flag char default '0' null comment '删除标志（0代表存在 1代表删除）',
- 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.sys_tenant (id, tenant_id, contact_user_name, contact_phone, company_name, license_number, address, intro, domain, remark, package_id, expire_time, account_count, status, del_flag, create_dept, create_by, create_time, update_by, update_time) VALUES (1, '000000', '管理组', '15888888888', '医梦科技有限公司', null, null, '多租户通用后台管理管理系统', null, null, null, null, -1, '0', '0', 103, 1, '2025-08-23 21:51:22', null, null);
- INSERT INTO ruoyi.sys_tenant (id, tenant_id, contact_user_name, contact_phone, company_name, license_number, address, intro, domain, remark, package_id, expire_time, account_count, status, del_flag, create_dept, create_by, create_time, update_by, update_time) VALUES (1959256835757731841, '889144', '王康', '15596825802', '医梦AI', '', '', '', '', '', 1959256708301221890, null, -1, '0', '0', 103, 1, '2025-08-23 22:10:06', 1, '2025-08-23 22:15:36');
- INSERT INTO ruoyi.sys_tenant (id, tenant_id, contact_user_name, contact_phone, company_name, license_number, address, intro, domain, remark, package_id, expire_time, account_count, status, del_flag, create_dept, create_by, create_time, update_by, update_time) VALUES (1959976407455010817, '841063', 'wangkang', '15596825802', '医梦 2', '', '', '', '', '', 1959256708301221890, null, 0, '0', '0', 103, 1, '2025-08-25 21:49:25', 1, '2025-08-25 21:49:25');
- INSERT INTO ruoyi.sys_tenant (id, tenant_id, contact_user_name, contact_phone, company_name, license_number, address, intro, domain, remark, package_id, expire_time, account_count, status, del_flag, create_dept, create_by, create_time, update_by, update_time) VALUES (1960316477454225410, '938163', 'wangkang', '15599999999', '医梦 3', '', '', '', '', '', 1959256708301221890, null, -1, '0', '0', 103, 1, '2025-08-26 20:20:44', 1, '2025-08-26 20:27:15');
|
