docs/init_sql.sql

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 接口文件
-- ----------------------------
CREATE TABLE `magic_api_file` (
  `file_path` varchar(512) NOT NULL COMMENT '文件地址',
  `file_content` mediumtext COMMENT '文件内容',
  PRIMARY KEY (`file_path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT '接口文件'

-- ----------------------------
-- 接口文件备份
-- ----------------------------
CREATE TABLE `magic_backup_record` (
  `id` varchar(32) NOT NULL COMMENT '原对象ID',
  `create_date` bigint(13) NOT NULL COMMENT '备份时间',
  `tag` varchar(32) DEFAULT NULL COMMENT '标签',
  `type` varchar(32) DEFAULT NULL COMMENT '类型',
  `name` varchar(64) DEFAULT NULL COMMENT '原名称',
  `content` blob COMMENT '备份内容',
  `create_by` varchar(64) DEFAULT NULL COMMENT '操作人',
  PRIMARY KEY (`id`,`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT '接口文件备份'

-- ----------------------------
-- 年级表
-- ----------------------------
DROP TABLE IF EXISTS `base_grade`;
CREATE TABLE `base_grade`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '年级名称',
  `title` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '年份',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '年级表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 专业表
-- ----------------------------
DROP TABLE IF EXISTS `base_major`;
CREATE TABLE `base_major`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '专业名称',
  `code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '专业代码',
  `study_year` decimal(6, 1) NOT NULL COMMENT '修业年限(0.5的整数倍)',
  `key_major` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '重点专业(xjr_dictionary_item[key_major])',
  `feature_major` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '特色专业(xjr_dictionary_item[feature_major])',
  `approve_set_date` date NULL DEFAULT NULL COMMENT '批准设置日期',
  `first_recruit_student_date` date NULL DEFAULT NULL COMMENT '首次招生日期(年月)',
  `status` int NULL DEFAULT NULL COMMENT '专业状态(1:正常、2:停招、3:撤销)',
  `leader_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '专业带头人',
  `director_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '专业负责人',
  `office_start_date` date NULL DEFAULT NULL COMMENT '任职日期开始',
  `office_end_date` date NULL DEFAULT NULL COMMENT '任职日期结束',
  `is_full_time` int NULL DEFAULT NULL COMMENT '是否全日制',
  `major_gradation_id` bigint NOT NULL COMMENT '办学层次(base_major_gradation)',
  `major_categor_id` bigint NOT NULL COMMENT '专业分类(base_major_categor)',
  `department_id` bigint NOT NULL COMMENT '所属机构(xjr_department)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '专业表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 专业分类表
-- ----------------------------
DROP TABLE IF EXISTS `base_major_categor`;
CREATE TABLE `base_major_categor`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '专业分类名称',
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '专业分类代码',
  `remark` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  `major_gradation_id` bigint NOT NULL COMMENT '办学层次(base_major_gradation)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '专业分类表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 办学层次表
-- ----------------------------
DROP TABLE IF EXISTS `base_major_gradation`;
CREATE TABLE `base_major_gradation`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '层次名称',
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '层次代码',
  `school_level` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属职业教育层次(xjr_dictionary_item[school_level])',
  `remark` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '办学层次表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 专业方向表
-- ----------------------------
DROP TABLE IF EXISTS `base_major_set`;
CREATE TABLE `base_major_set`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '专业方向名称',
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '专业方向代码',
  `short_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '专业方向简称',
  `skill_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上报专业技能方向名称',
  `remark` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '专业方向说明',
  `major_gradation_id` bigint NOT NULL COMMENT '办学层次(base_major_gradation)',
  `major_categor_id` bigint NOT NULL COMMENT '专业分类(base_major_categor)',
  `department_id` bigint NOT NULL COMMENT '所属机构(xjr_department)',
  `major_id` bigint NOT NULL COMMENT '专业(base_major)',
  `study_year` decimal(6, 1) NOT NULL COMMENT '适用学制(base_major)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '专业方向表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 办学层次表
-- ----------------------------
DROP TABLE IF EXISTS `base_school_level`;
CREATE TABLE `base_school_level`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '层次名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '办学层次表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 学期表
-- ----------------------------
DROP TABLE IF EXISTS `base_semester`;
CREATE TABLE `base_semester`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '学期名称',
  `start_date` date NULL DEFAULT NULL COMMENT '学期开始日期',
  `end_date` date NULL DEFAULT NULL COMMENT '学期结束日期',
  `teaching_start` date NULL DEFAULT NULL COMMENT '教学开始日期',
  `teaching_end` date NULL DEFAULT NULL COMMENT '教学结束日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '学期表' ROW_FORMAT = Dynamic;


-- ----------------------------
-- 课程学科
-- ----------------------------
DROP TABLE IF EXISTS `base_course_subject`;
CREATE TABLE `base_course_subject`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程学科名称',
  `code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程学科代码',
  `remark` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '课程学科' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 教职工基本信息表
-- ----------------------------
DROP TABLE IF EXISTS `base_teacher`;
CREATE TABLE `base_teacher`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
	`user_id` bigint not null COMMENT '用户ID(xjr_user)',
  -- `job_number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '工号',
  -- `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '姓名',
  `as_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '别名',
  `en_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '英文姓名',
  `py_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姓名拼音',
  `former_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '曾用名',
  -- `gender` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别(xjr_dictionary_item[gender])',
  `job_state` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '在职状态(xjr_dictionary_item[job_state])',
  `credential_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '证件类型(xjr_dictionary_item[credential_type])',
  `credential_number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '证件号码',
  `day_of_birth` date NULL DEFAULT NULL COMMENT '出生日期',
  `birth_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '生日类型(xjr_dictionary_item[date_type])',
  `nation` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '民族(xjr_dictionary_item[nation])',
  `blood_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '血型(xjr_dictionary_item[blood_type])',
  `health` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '健康状况(xjr_dictionary_item[health])',
  `marital_state` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '婚姻状况(xjr_dictionary_item[marital_state])',
  `political_state` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '政治面貌(xjr_dictionary_item[political_state])',
  `nationality` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '国籍地区(xjr_dictionary_item[nationality])',
  `chinese_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '港澳台侨外(xjr_dictionary_item[chinese_type])',
  `house_hold_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '户口类别(xjr_dictionary_item[house_hold_type])',
  `provinces` bigint NULL DEFAULT NULL COMMENT '省(xjr_area)',
  `city` bigint NULL DEFAULT NULL COMMENT '市(xjr_area)',
  `district` bigint NULL DEFAULT NULL COMMENT '区/县(xjr_area)',
  `house_hold_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '户籍地址',
  `start_work_time` date NULL DEFAULT NULL COMMENT '参加工作年月',
  `join_time` date NULL DEFAULT NULL COMMENT '来校年月',
  `is_organized` smallint NULL DEFAULT NULL COMMENT '是否在编',
  `employ_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '聘用类型(xjr_dictionary_item[employ_type])',
  `employ_way` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '聘用方式(xjr_dictionary_item[employ_type])上级聘用类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '教职工基本信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 教职工聘用信息表 未定
-- ----------------------------
DROP TABLE IF EXISTS `base_teacher_employ`;
CREATE TABLE `base_teacher_employ`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
	`user_id` bigint not null COMMENT '用户ID(xjr_user)',
	`type` int NULL COMMENT '岗位类型 (1:校内主岗 2:校内兼职岗位 3:事业制单位主岗)',
  `job_category` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '校内主岗位类别(xjr_dictionary_item[school_job_type])',
  `job_post` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '校内主岗位(xjr_dictionary_item[school_job_type])上级校内主岗位类别',
  `job_level` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '岗位等级(xjr_dictionary_item[school_job_level])',
  `job_level_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '岗位等级类型(xjr_dictionary_item[school_job_level_type])',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '教职工聘用信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 教职工联系信息表
-- ----------------------------
DROP TABLE IF EXISTS `base_teacher_contact`;
CREATE TABLE `base_teacher_contact`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
	`user_id` bigint not null COMMENT '用户ID(xjr_user)',
	-- `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '手机号',
  `office_tel` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '办公室电话',
  `office_address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '办公室地址',
  -- `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '邮箱',
  `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '现住地址',
  `qq_msn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT 'QQ&MSN',
  `wechat` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '微信号',
  `microblog` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '微博地址',
  `zip_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '住址邮编',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '教职工联系信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 教职工专任信息表
-- ----------------------------
DROP TABLE IF EXISTS `base_teacher_regular`;
CREATE TABLE `base_teacher_regular`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
	`user_id` bigint not null COMMENT '用户ID(xjr_user)',
	`certificate_Type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教师资格证种类(xjr_dictionary_item[certificate_Type])',
	`belong_org` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属系统(xjr_dictionary_item[belong_org])',
	`mandarin_level` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '普通话等级(xjr_dictionary_item[mandarin_level])',
  `start_teach_time` date NULL COMMENT '从教起始年月',
  `teaching_status` json NULL DEFAULT NULL COMMENT '任课状况(xjr_dictionary_item[teaching_status])多选',
  `major_categor_id` bigint NULL COMMENT '任教学科类别(base_major_categor)',
  `is_double_teacher` int NULL COMMENT '是否双师型教师',
  `course_subject_id` bigint NULL COMMENT '任教学科(base_course_subject)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '教职工专任信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 教职工学历学位表
-- ----------------------------
DROP TABLE IF EXISTS `base_teacher_education`;
CREATE TABLE `base_teacher_education`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
	`user_id` bigint not null COMMENT '用户ID(xjr_user)',
	`specialty` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '所学专业',
  `education` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '最高学历(xjr_dictionary_item[education])',
	`education_college` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '获得最高学历的院校',
  `degree` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '最高学位(xjr_dictionary_item[degree])',
	`degree_college` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '获得最高学位的院校',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '教职工学历学位表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 教职工家庭基本信息表
-- ----------------------------
DROP TABLE IF EXISTS `base_teacher_family`;
CREATE TABLE `base_teacher_family`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
	`user_id` bigint not null COMMENT '用户ID(xjr_user)',
  `zip_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '家庭邮编',
  `telephone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '家庭电话',
  `contact` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '联系人姓名',
  `population` int NULL COMMENT '家庭人口',
  `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '家庭住址',
  `finance` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '家庭经济情况',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '教职工家庭基本信息表' ROW_FORMAT = Dynamic;


-- ----------------------------
-- 教职工家庭成员表
-- ----------------------------
DROP TABLE IF EXISTS `base_teacher_family_member`;
CREATE TABLE `base_teacher_family_member`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
	`user_id` bigint not null COMMENT '用户ID(xjr_user)',
  `relationship` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '与本人关系(xjr_dictionary_item[relationship])',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '姓名',
  `gender` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别(xjr_dictionary_item[gender])',
  `is_guardian` int NULL COMMENT '是否为监护人',
  `day_of_birth` date NULL DEFAULT NULL COMMENT '出生日期',
  `political_state` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '政治面貌(xjr_dictionary_item[political_state])',
  `occupation` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '职业',
  `work_unit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '工作单位',
	`mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '联系电话',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '教职工家庭成员表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 学生毕业中学表
-- ----------------------------
DROP TABLE IF EXISTS `base_graduate_school`;
CREATE TABLE `base_graduate_school`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '学校名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '学生毕业中学表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 学生基本信息表
-- ----------------------------
DROP TABLE IF EXISTS `base_student`;
CREATE TABLE `base_student`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
	`user_id` bigint not null COMMENT '用户(xjr_user)',
  `student_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '学号',
  -- `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '姓名',
  `as_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '别名',
  `en_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '英文姓名',
  `py_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姓名拼音',
  `former_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '曾用名',
  -- `gender` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别(xjr_dictionary_item[gender])',
  `credential_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '证件类型(xjr_dictionary_item[credential_type])',
  `credential_number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '证件号码',
  `day_of_birth` date NULL DEFAULT NULL COMMENT '出生日期',
  `birth_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '生日类型(xjr_dictionary_item[date_type])',
  `nation` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '民族(xjr_dictionary_item[nation])',
  `blood_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '血型(xjr_dictionary_item[blood_type])',
  `health` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '健康状况(xjr_dictionary_item[health])',
  `marital_state` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '婚姻状况(xjr_dictionary_item[marital_state])',
  `political_state` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '政治面貌(xjr_dictionary_item[political_state])',
  `religion` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '信仰宗教(xjr_dictionary_item[religion])',
  `nationality` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '国籍地区(xjr_dictionary_item[nationality])',
  `chinese_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '港澳台侨外(xjr_dictionary_item[chinese_type])',
  `provinces` bigint NULL DEFAULT NULL COMMENT '籍贯 省(xjr_area)',
  `city` bigint NULL DEFAULT NULL COMMENT '籍贯 市(xjr_area)',
  `district` bigint NULL DEFAULT NULL COMMENT '籍贯 区/县(xjr_area)',
  `house_hold_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '户口类别(xjr_dictionary_item[house_hold_type])',
  `house_provinces` bigint NULL DEFAULT NULL COMMENT '户口所在地 省(xjr_area)',
  `house_city` bigint NULL DEFAULT NULL COMMENT '户口所在地 市(xjr_area)',
  `house_district` bigint NULL DEFAULT NULL COMMENT '户口所在地 区/县(xjr_area)',
  `house_hold_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '户口所在详细地址',
  `belongs_police` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '所属派出所',
  `birth_provinces` bigint NULL DEFAULT NULL COMMENT '出生地 省(xjr_area)',
  `birth_city` bigint NULL DEFAULT NULL COMMENT '出生地 市(xjr_area)',
  `birth_district` bigint NULL DEFAULT NULL COMMENT '出生地 区/县(xjr_area)',
  `graduate_school_id` bigint null  COMMENT '生源地(base_graduate_school)',
  `residence_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学生居住地类型(xjr_dictionary_item[residence_type])',
  `is_migrate_children` smallint NULL DEFAULT NULL COMMENT '是否随迁子女',
  `train_interval` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '乘火车区间',
  `is_floating_population` smallint NULL DEFAULT NULL COMMENT '是否流动人口',
  `height` decimal(6, 1) NULL DEFAULT NULL COMMENT '身高（cm）',
  `weight` decimal(6, 1) NULL DEFAULT NULL COMMENT '体重（kg）',
  `vision` decimal(6, 1) NULL DEFAULT NULL COMMENT '视力',
  `specialty` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '特长',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '学生基本信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 学生学籍信息表
-- ----------------------------
DROP TABLE IF EXISTS `base_student_school_roll`;
CREATE TABLE `base_student_school_roll`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
	`user_id` bigint not null COMMENT '用户ID(xjr_user)',
  `roll_number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '学籍号',
  `archives_number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '学生档案编号',
  `enrollment_date` date NULL DEFAULT NULL COMMENT '入学年月',
  `enrollment_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '入学方式(xjr_dictionary_item[enrollment_type])',
  `grade_id` bigint NOT NULL COMMENT '入学年级(base_grade)',
  `enroll_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '入学招生类型(xjr_dictionary_item[enroll_type])',
  `major_set_id` bigint NOT NULL COMMENT '在读专业方向(base_major_set)',
  `study_year` decimal(6, 1) NOT NULL COMMENT '学制(base_major_set)',
  `class_id` bigint NOT NULL COMMENT '班级(base_class)',
  `student_source` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学生来源(xjr_dictionary_item[student_type])',
  `student_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学生类别(xjr_dictionary_item[student_type])',
  `archives_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学籍状态(xjr_dictionary_item[archives_status])',
  `stduy_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '就读方式(xjr_dictionary_item[stduy_status])',
  `learn_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学习形式(xjr_dictionary_item[learn_status])',
  `choose_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分流状态(xjr_dictionary_item[choose_status])',
  `foster_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分段培养方式(xjr_dictionary_item[foster_type])',
  `recruit_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '招生方式(xjr_dictionary_item[recruit_type])',
  `recruit_target` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '招生对象(xjr_dictionary_item[recruit_target])',
  `highest_education` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '入学前最高学历(xjr_dictionary_item[education])',
  `graduated_university` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '毕业学校',
  `graduated_score` decimal(6, 1) NULL COMMENT '毕业成绩',
  `examinee_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '考生号',
  `ticket_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '准考证号',
  `admission_scores` decimal(6, 1) NULL DEFAULT 0 COMMENT '入学总分',
  `remark` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '学生学籍信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 学生资助信息表
-- ----------------------------
DROP TABLE IF EXISTS `base_student_subsidize`;
CREATE TABLE `base_student_subsidize`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
	`user_id` bigint not null COMMENT '用户ID(xjr_user)',
  `is_indemnify` smallint NULL DEFAULT NULL COMMENT '是否低保',
  `is_stipend` smallint NULL DEFAULT NULL COMMENT '是否享受国家助学金',
  `stipend_stand` decimal(6, 1) NULL DEFAULT 0 COMMENT '助学金发放标准（元）',
  `stipend_number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学生资助卡号',
  `is_free` smallint NULL DEFAULT NULL COMMENT '是否免学费',
  `is_filing_card` smallint NULL DEFAULT NULL COMMENT '是否建档立卡',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '学生资助信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 学生联系信息表
-- ----------------------------
DROP TABLE IF EXISTS `base_student_contact`;
CREATE TABLE `base_student_contact`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
	`user_id` bigint not null COMMENT '用户ID(xjr_user)',
	-- `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '手机号',
  -- `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '邮箱',
  `qq_msn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT 'QQ&MSN',
  `wechat` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '微信号',
  `user_page` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '个人主页',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '学生联系信息表' ROW_FORMAT = Dynamic;


-- ----------------------------
-- 学生家庭基本信息表
-- ----------------------------
DROP TABLE IF EXISTS `base_student_family`;
CREATE TABLE `base_student_family`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
	`user_id` bigint not null COMMENT '用户ID(xjr_user)',
  `zip_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '家庭邮编',
  `telephone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '家庭电话',
  `contact` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '联系人姓名',
  `population` int NULL COMMENT '家庭人口',
  `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '家庭住址',
  `income_source` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '家庭主要收入来源',
  `income_number` decimal(6, 1) NULL DEFAULT 0 COMMENT '家庭月收入金额',
  `railway_station` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '离家最近火车站',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '学生家庭基本信息表' ROW_FORMAT = Dynamic;


-- ----------------------------
-- 学生家庭成员表
-- ----------------------------
DROP TABLE IF EXISTS `base_student_family_member`;
CREATE TABLE `base_student_family_member`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
	`user_id` bigint not null COMMENT '用户ID(xjr_user)',
  `relationship` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '与本人关系(xjr_dictionary_item[relationship])',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '姓名',
  `gender` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别(xjr_dictionary_item[gender])',
  `day_of_birth` date NULL DEFAULT NULL COMMENT '出生日期',
  `birth_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '生日类型(xjr_dictionary_item[date_type])',
  `nation` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '民族(xjr_dictionary_item[nation])',
  `work_unit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '工作单位',
  `occupation` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '从事的工作(职业)',
  `position` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '职务',
	`mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '联系电话',
  `is_guardian` smallint NULL COMMENT '是否为监护人',
  `credential_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '证件类型(xjr_dictionary_item[credential_type])',
  `credential_number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '证件号码',
  `political_state` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '政治面貌(xjr_dictionary_item[political_state])',
  `health` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '健康状况(xjr_dictionary_item[health])',
  `house_provinces` bigint NULL DEFAULT NULL COMMENT '户口所在地 省(xjr_area)',
  `house_city` bigint NULL DEFAULT NULL COMMENT '户口所在地 市(xjr_area)',
  `house_district` bigint NULL DEFAULT NULL COMMENT '户口所在地 区/县(xjr_area)',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '邮箱',
  `wechat` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '微信号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '学生家庭成员表' ROW_FORMAT = Dynamic;


-- ----------------------------
-- 教学办公楼表
-- ----------------------------
DROP TABLE IF EXISTS `base_office_build`;
CREATE TABLE `base_office_build`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '楼栋名称',
  `org_id` bigint NOT NULL COMMENT '所属校区(xjr_department)第一级',
  `floor_total` int NOT NULL COMMENT '楼层数',
  `build_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '楼栋类型(xjr_dictionary_item[build_type])',
  `status` int NOT NULL COMMENT '状态（1:可用 0:停用）',
  `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '地址',
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL COMMENT '描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '教学办公楼表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 教室表
-- ----------------------------
DROP TABLE IF EXISTS `base_classroom`;
CREATE TABLE `base_classroom`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '教室名称',
  `office_build_id` bigint NOT NULL COMMENT '楼栋(base_office_build)',
  `floor_num` int NOT NULL COMMENT '楼层',
  `purpose` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教室用途(xjr_dictionary_item[purpose])',
  `classroom_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教室类型(xjr_dictionary_item[classroom_type])',
  `org_id` bigint NOT NULL COMMENT '组织机构(xjr_department)',
  `square` decimal(6, 1) DEFAULT NULL COMMENT '面积（平米）',
  `capacity` decimal(6, 1) DEFAULT NULL COMMENT '容量（人数）',
  `status` int NOT NULL COMMENT '状态（1:可用 0:停用）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '教室表' ROW_FORMAT = Dynamic;


-- ----------------------------
-- 班级表
-- ----------------------------
DROP TABLE IF EXISTS `base_class`;
CREATE TABLE `base_class`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '班级名称',
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '班级代码',
  `grade_id` bigint NOT NULL COMMENT '所属年级(base_grade)',
  `enroll_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '招生类型(xjr_dictionary_item[enroll_type])',
  `org_id` bigint NOT NULL COMMENT '组织机构(xjr_department)',
  `is_order_class` int DEFAULT NULL COMMENT '是否订单班',
  `classroom_id` bigint DEFAULT NULL COMMENT '固定教室(base_classroom)',
  `teacher_id` bigint DEFAULT NULL COMMENT '班主任(xjr_user)',
  `is_graduate` int DEFAULT NULL COMMENT '在读状态(1: 在读 2: 毕业)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '班级表' ROW_FORMAT = Dynamic;


-- ----------------------------
-- 班级专业方向表
-- ----------------------------
DROP TABLE IF EXISTS `base_class_major_set`;
CREATE TABLE `base_class_major_set`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `class_id` bigint NOT NULL COMMENT '班级(base_class_major_set)',
  `major_set_id` bigint NOT NULL COMMENT '专业方向(base_major_set)',
  `plan_total_student` int DEFAULT NULL COMMENT '计划人数',
  `total_student` int DEFAULT NULL COMMENT '班级人数',
  `boy_num` int DEFAULT NULL COMMENT '男生人数',
  `girl_num` int DEFAULT NULL COMMENT '女生人数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '班级专业方向表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 车辆管理
-- ----------------------------
DROP TABLE IF EXISTS `base_car_management`;
CREATE TABLE `base_car_management`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `user_id` bigint COMMENT '用户(xjr_user)',
  `car_no` varchar(9) not null COMMENT '车牌号码',
  `c_name` varchar(20) COMMENT '姓名',
  `c_id` varchar(18) COMMENT '身份证号',
  `c_phone` varchar(50) COMMENT '联系电话',
  `c_address` varchar(50) COMMENT '住址',
  `c_type` int not null default 1 COMMENT '车牌类型 1=民用 2=军队 3=警用 4=武警',
  `c_fee_type` int not null default 1 COMMENT '收费类型 1=月卡 2=临时车 3=免费车 4=储值卡',
  `sync_status` tinyint(4) unsigned default 1 not null COMMENT '数据同步状态 1=未同步 2=已同步 3=同步失败',
  `status` tinyint(4) unsigned default 1 not null COMMENT '状态 1=启用 2=禁用',
  `c_sync_id` int default 0 not null COMMENT '数据同步编号',
  `c_start_time` datetime not null COMMENT '开始时间',
  `c_end_time` datetime not null COMMENT '结束时间',
  PRIMARY KEY (`id`) USING BTREE,
  unique key `only`(`car_no`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆管理' ROW_FORMAT = Dynamic;


-- ----------------------------
-- 车辆进出记录
-- ----------------------------
DROP TABLE IF EXISTS `base_car_park_records`;
CREATE TABLE `base_car_park_records`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `base_car_management_id` bigint COMMENT '车辆编号(base_car_management)',
  `car_no` varchar(9) not null COMMENT '车牌号码',
  `in_time` datetime not null COMMENT '进场时间',
  `out_time` datetime COMMENT '出场时间',
  `status` tinyint(4) unsigned default 1 not null COMMENT '状态 1=进 2=出',
  `in_passing` tinyint(4) unsigned default 0 not null COMMENT '进类型 0=识别过车  1=人工处置',
  `out_passing` tinyint(4) unsigned default 0 not null COMMENT '出类型 0=识别过车  1=人工处置',
  `remark` varchar(500) COMMENT '备注',
  `c_sync_id` int default 0 not null COMMENT '数据同步编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆进出记录' ROW_FORMAT = Dynamic;


-- ----------------------------
-- 人脸管理
-- ----------------------------
DROP TABLE IF EXISTS `base_face_management`;
CREATE TABLE `base_face_management`  (
  `id` bigint NOT NULL COMMENT '主键',
  `create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_date` date NULL DEFAULT NULL COMMENT '创建时间',
  `modify_user_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  `delete_mark` int NOT NULL COMMENT '删除标记',
  `enabled_mark` int NOT NULL COMMENT '有效标志',
  `user_id` bigint COMMENT '用户(xjr_user)',
  `face_code` varchar(50) not null default '' COMMENT '人脸编码',
  `name` varchar(50) not null default '' COMMENT '姓名',
  `sex` varchar(10) not null default '' COMMENT '性别 男, 女',
  `idno` varchar(20) not null default '' COMMENT '身份证号',
  `people_start_date` datetime COMMENT '名单有效期开始时间',
  `people_end_date` datetime COMMENT '名单有效期结束时间',
  `icno` varchar(20) not null default '' COMMENT ' ic卡号（10位10进制）',
  `register_base64` mediumblob COMMENT '图片的base64字符串',
  `verify_status` tinyint(4) unsigned default 1 not null COMMENT '验证状态 1=未验证 2=通过 3=失败',
  `verify_error_msg` varchar(200) not null default '' COMMENT '验证失败说明',
  `sync_status` tinyint(4) unsigned default 1 not null COMMENT '数据同步状态 1=未同步 2=已同步 3=同步失败',
  `status` tinyint(4) unsigned default 1 not null COMMENT '状态 1=启用 2=禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '人脸管理' ROW_FORMAT = Dynamic;


-- ----------------------------
-- 人脸识别记录
-- ----------------------------
DROP TABLE IF EXISTS `base_face_identify_records`;
CREATE TABLE `base_face_identify_records`  (
  `id` bigint NOT NULL COMMENT '主键',
  `mac_addr` varchar(100) COMMENT '设备唯一标识码',
  `verify_time` datetime COMMENT '比对时间 yyyy -MM - dd HH:mm:ss',
  `device_name` varchar(100) COMMENT '设备名称',
  `location` varchar(100) COMMENT '安装位置',
  `inout_direction` tinyint(4) unsigned COMMENT '出入 0=出口 1=入口',
  `face_code` varchar(50) not null default '' COMMENT '人脸编码',
  `name` varchar(50) COMMENT '姓名',
  `temperature` varchar(50) COMMENT '体温',
  `face_base64` text COMMENT '比对抓拍照片 base64位字符串',
  `result_status` tinyint(4) unsigned COMMENT '比对结果 1=比对成功 0=比对失败',
  `identify_type` tinyint(4) unsigned COMMENT '识别方式（比对类型）：0人脸识别， 1 黑名单识别（预留字段），2人证比对， 3 IC卡识别',
  `face_identify_sync_id` int default 0 not null COMMENT '数据同步编号',
  PRIMARY KEY (`id`) USING BTREE,
  unique index index_no(face_identify_sync_id)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '人脸识别记录' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;