56,679
社区成员
发帖
与我相关
我的任务
分享
/*
SQLyog Community Edition?MySQL GUI v6?2
MySQL ?5??4瑀c琧ommunity : Database ?hrm_db
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=*/;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS?FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE?SQL_MODE=NO_AUTO_VALUE_ON_ZERO */;
create database if not exists `hrm_db`;
USE `hrm_db`;
/*Table structure for table `branch` */
DROP TABLE IF EXISTS `branch`;
CREATE TABLE `branch` ?
`br_id` int?1?NOT NULL AUTO_INCREMENT COMMENT ????????
`br_name` varchar?00?NOT NULL COMMENT ?????
`br_memo` text COMMENT ?????
PRIMARY KEY br_id`?
?ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `branch` */
/*Table structure for table `engageinforelease` */
DROP TABLE IF EXISTS `engageinforelease`;
CREATE TABLE `engageinforelease` ?
`eir_id` int?1?NOT NULL AUTO_INCREMENT COMMENT ??????
`eir_title` varchar?00?DEFAULT NULL COMMENT ???????
`eir_start_date` date DEFAULT NULL COMMENT ?????
`eir_stop_date` date DEFAULT NULL COMMENT ?????
`eir_count` int?1?DEFAULT NULL COMMENT ?????
`eir_job_name` varchar?00?DEFAULT NULL COMMENT ?????
`eir_condition` text COMMENT ????????
`user_add_name` varchar?00?DEFAULT NULL COMMENT ??????
`eir_add_date` datetime DEFAULT NULL COMMENT ?????
`user_edit_name` varchar?00?DEFAULT NULL COMMENT ??????
`eir_edit_date` datetime DEFAULT NULL COMMENT ?????
`user_check_name` varchar?00?DEFAULT COMMENT ??????
`eir_check_date` datetime DEFAULT NULL COMMENT ?????
`eir_state` varchar?00?DEFAULT NULL COMMENT ???
`eir_memo` text COMMENT ???
PRIMARY KEY eir_id`?
?ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
`br_id` int?1?NOT NULL AUTO_INCREMENT COMMENT ????????