all-project/学校历史数据迁移/his_lssj_create.sql

CREATE TABLE `his_lssj` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `tenant_id` BIGINT(20) DEFAULT NULL,
  `deleted` TINYINT(1) NOT NULL DEFAULT 0,
  `create_by` BIGINT(20) DEFAULT NULL,
  `create_time` DATETIME DEFAULT NULL,
  `update_by` BIGINT(20) DEFAULT NULL,
  `update_time` DATETIME DEFAULT NULL,
  `工号` TEXT DEFAULT NULL,
  `姓名` TEXT DEFAULT NULL,
  `部门` TEXT DEFAULT NULL,
  `性别` TEXT DEFAULT NULL,
  `手机号码` TEXT DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;