| | |
| | | -- ---------------------------- |
| | | -- 公司课时变更记录表 |
| | | -- ---------------------------- |
| | | drop table if exists `train_exam`.`ex_company_period`; |
| | | CREATE TABLE `train_exam`.`ex_company_period` ( |
| | | `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键' , |
| | | `company_id` bigint NOT NULL COMMENT '公司id', |
| | | `phase_id` bigint NULL COMMENT '批次id', |
| | | `origin` varchar(50) NOT NULL COMMENT '变动来源', |
| | | `modify_period` int NOT NULL COMMENT '变动情况(增减课时)', |
| | | `remain_period` int NOT NULL COMMENT '变动后剩余(分)', |
| | | `modify_period` bigint(20) NOT NULL COMMENT '变动情况(增减课时)秒', |
| | | `remain_period` bigint(20) NOT NULL COMMENT '变动后剩余(秒)', |
| | | `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| | | `create_by` varchar(50) NULL DEFAULT NULL COMMENT '创建人', |
| | | `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', |