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');
