SkyEye人事薪酬-培训计划 - MySQL数据库表结构设计

-- 数据库大全：SkyEye人事薪酬-培训计划
-- 来源：YesApi.cn
CREATE TABLE `yesapi_hr_train_plan` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `train_name` varchar(200) NOT NULL COMMENT '培训名称',
    `train_type` varchar(50) NOT NULL COMMENT '培训类型',
    `train_start` date NOT NULL COMMENT '开始日期',
    `train_end` date NOT NULL COMMENT '结束日期',
    `train_hours` int(11) NOT NULL COMMENT '培训课时',
    `train_teacher` varchar(100) NOT NULL COMMENT '讲师',
    `train_staff_ids` text NOT NULL COMMENT '参训人员',
    `train_content` text NOT NULL COMMENT '培训内容',
    `train_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
    `train_id` varchar(64) NOT NULL COMMENT '培训ID',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'SkyEye人事薪酬-培训计划';