📄 redmoonoa.sql

📁 oa 源代码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
  `ADDDATE` datetime default NULL,
  `OPERATETYPE` varchar(10) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_query` (
  `ID` int(11) NOT NULL default '0',
  `TABLE_CODE` varchar(200) NOT NULL default '',
  `SHOW_FIELD_CODE` text NOT NULL,
  `ORDER_FIELD_CODE` varchar(200) default NULL,
  `QUERY_NAME` varchar(200) NOT NULL default '',
  `DEPT_CODE` text NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_query_condition` (
  `ID` int(11) NOT NULL default '0',
  `QUERY_ID` int(11) NOT NULL default '0',
  `CONDITION_FIELD_CODE` text NOT NULL,
  `CONDITION_SIGN` varchar(10) NOT NULL default '',
  `CONDITION_VALUE` text NOT NULL,
  `CONDITION_TYPE` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_resume` (
  `ID` bigint(20) NOT NULL default '0',
  `COMPANY` varchar(100) default NULL,
  `JOB` varchar(50) default NULL,
  `BEGINDATE` datetime default NULL,
  `ENDDATE` datetime default NULL,
  `LEAVEREASON` varchar(100) default NULL,
  `REMARK` varchar(250) default NULL,
  `USERNAME` varchar(20) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_resume_his` (
  `ID` bigint(20) NOT NULL default '0',
  `COMPANY` varchar(100) default NULL,
  `JOB` varchar(50) default NULL,
  `BEGINDATE` datetime default NULL,
  `ENDDATE` datetime default NULL,
  `LEAVEREASON` varchar(100) default NULL,
  `REMARK` varchar(250) default NULL,
  `USERNAME` varchar(20) default NULL,
  `OPERATOR` varchar(20) default NULL,
  `ADDDATE` datetime default NULL,
  `OPERATETYPE` varchar(10) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_rewards` (
  `ID` bigint(20) NOT NULL default '0',
  `MYDATE` datetime default NULL,
  `PLACE` varchar(50) default NULL,
  `REWARDS` varchar(50) default NULL,
  `REASON` varchar(50) default NULL,
  `REMARK` varchar(250) default NULL,
  `USERNAME` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_rewards_his` (
  `ID` bigint(20) NOT NULL default '0',
  `MYDATE` datetime default NULL,
  `PLACE` varchar(50) default NULL,
  `REWARDS` varchar(50) default NULL,
  `REASON` varchar(50) default NULL,
  `REMARK` varchar(250) default NULL,
  `USERNAME` varchar(50) NOT NULL default '',
  `OPERATOR` varchar(20) default NULL,
  `ADDDATE` datetime default NULL,
  `OPERATETYPE` varchar(10) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_studyinfo` (
  `ID` bigint(20) NOT NULL default '0',
  `GRADE` varchar(50) default NULL,
  `COLLEGE` varchar(150) default NULL,
  `SCOLLEGE` varchar(50) default NULL,
  `ISJOB` varchar(10) default NULL,
  `REMARK` varchar(250) default NULL,
  `SPECIALTY` varchar(50) default NULL,
  `SSPECIALTY` varchar(50) default NULL,
  `BEGINDATE` datetime default NULL,
  `ENDDATE` datetime default NULL,
  `DEGREE` varchar(50) default NULL,
  `USERNAME` varchar(20) default NULL,
  `ISMOSTGRADE` char(1) default NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ARCHIVE_STUDYINFO_INDEX` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_studyinfo_his` (
  `ID` bigint(20) NOT NULL default '0',
  `GRADE` varchar(50) default NULL,
  `COLLEGE` varchar(150) default NULL,
  `SCOLLEGE` varchar(50) default NULL,
  `ISJOB` varchar(10) default NULL,
  `REMARK` varchar(250) default NULL,
  `SPECIALTY` varchar(50) default NULL,
  `SSPECIALTY` varchar(50) default NULL,
  `BEGINDATE` datetime default NULL,
  `ENDDATE` datetime default NULL,
  `DEGREE` varchar(50) default NULL,
  `USERNAME` varchar(20) default NULL,
  `OPERATOR` varchar(20) default NULL,
  `ADDDATE` datetime default NULL,
  `OPERATETYPE` varchar(10) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_table` (
  `TABLE_SHORT_CODE` varchar(50) NOT NULL default '',
  `TABLE_CODE` varchar(50) NOT NULL default '',
  `TABLE_DESCRIPTION` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`TABLE_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `archive_table` (`TABLE_SHORT_CODE`,`TABLE_CODE`,`TABLE_DESCRIPTION`) VALUES ('AAS','ARCHIVE_ASSESS','考核'),('ADU','ARCHIVE_DUTY','任免'),('AFA','ARCHIVE_FAMILY','家庭'),('APR','ARCHIVE_PROFESSION','专业技能'),('ARES','ARCHIVE_RESUME','履历'),('ARE','ARCHIVE_REWARDS','奖励'),('AST','ARCHIVE_STUDYINFO','教育'),('AUS','ARCHIVE_USER','用户');
CREATE TABLE `archive_user` (
  `USERNAME` varchar(20) NOT NULL default '',
  `SEX` varchar(10) default 'NULL',
  `BIRTHDAY` datetime default NULL,
  `NATION` varchar(50) default 'NULL',
  `BORN` varchar(250) default 'NULL',
  `JPARTYDATE` datetime default NULL,
  `JWORKDATE` datetime default NULL,
  `HEALTHSTATE` varchar(50) default 'NULL',
  `REMARK` varchar(250) default 'NULL',
  `CULTURE` varchar(20) default 'NULL',
  `INSUPPORTCADRELEVEL` varchar(50) default 'NULL',
  `INSUPPORTCADREDATE` datetime default NULL,
  `POLITY` varchar(20) default 'NULL',
  `JOINCLANDATE` datetime default NULL,
  `TYPEOFWORK` varchar(50) default 'NULL',
  `REALNAME` varchar(20) default 'NULL',
  `IMAGE` varchar(250) default 'NULL',
  `JDEPARTMENTDATE` datetime default NULL,
  `INACTIVESERVICE` varchar(20) default 'NULL',
  `CADRESSOURCE` varchar(20) default 'NULL',
  `TRANSITIONDATE` datetime default NULL,
  `DEPTCODE` varchar(50) default 'NULL',
  `ACCOUNT` varchar(20) default 'NULL\\n',
  `PEOPLE` varchar(50) default NULL,
  `MOSTGRADE` varchar(50) default NULL,
  PRIMARY KEY  (`USERNAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `archive_user` (`USERNAME`,`SEX`,`BIRTHDAY`,`NATION`,`BORN`,`JPARTYDATE`,`JWORKDATE`,`HEALTHSTATE`,`REMARK`,`CULTURE`,`INSUPPORTCADRELEVEL`,`INSUPPORTCADREDATE`,`POLITY`,`JOINCLANDATE`,`TYPEOFWORK`,`REALNAME`,`IMAGE`,`JDEPARTMENTDATE`,`INACTIVESERVICE`,`CADRESSOURCE`,`TRANSITIONDATE`,`DEPTCODE`,`ACCOUNT`,`PEOPLE`,`MOSTGRADE`) VALUES ('11605225628431810865','男',NULL,'dd','dd',NULL,NULL,'亚健康','','小学','科长',NULL,'团员',NULL,'行政','dd','',NULL,'','招考',NULL,'2deputyzjl','dd',NULL,NULL),('11624617811255930823','男',NULL,'asdf','sadf',NULL,NULL,'','sadfsafd','小学','科长',NULL,'团员',NULL,'行政','sdfasdf','',NULL,'','招考',NULL,'2deputyzjl','0',NULL,'专科');
CREATE TABLE `archive_user_his` (
  `USERNAME` varchar(20) NOT NULL default '',
  `SEX` varchar(10) default NULL,
  `BIRTHDAY` datetime default NULL,
  `NATION` varchar(50) default NULL,
  `BORN` varchar(250) default NULL,
  `JPARTYDATE` datetime default NULL,
  `JWORKDATE` datetime default NULL,
  `HEALTHSTATE` varchar(50) default NULL,
  `REMARK` varchar(250) default NULL,
  `CULTURE` varchar(20) default NULL,
  `INSUPPORTCADRELEVEL` varchar(50) default NULL,
  `INSUPPORTCADREDATE` datetime default NULL,
  `POLITY` varchar(20) default NULL,
  `JOINCLANDATE` datetime default NULL,
  `TYPEOFWORK` varchar(50) default NULL,
  `REALNAME` varchar(20) default NULL,
  `IMAGE` varchar(250) default NULL,
  `JDEPARTMENTDATE` datetime default NULL,
  `INACTIVESERVICE` varchar(20) default NULL,
  `OPERATOR` varchar(20) NOT NULL default '',
  `ADDDATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `ID` int(11) NOT NULL default '0',
  `CADRESSOURCE` varchar(20) default NULL,
  `TRANSITIONDATE` datetime default NULL,
  `DEPTCODE` varchar(50) default NULL,
  `ACCOUNT` varchar(20) default NULL,
  `OPERATETYPE` varchar(10) default NULL,
  `PEOPLE` varchar(50) default NULL,
  `MOSTGRADE` varchar(50) default NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ARCHIVE_USER_HIS_INDEX` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `archive_user_his` (`USERNAME`,`SEX`,`BIRTHDAY`,`NATION`,`BORN`,`JPARTYDATE`,`JWORKDATE`,`HEALTHSTATE`,`REMARK`,`CULTURE`,`INSUPPORTCADRELEVEL`,`INSUPPORTCADREDATE`,`POLITY`,`JOINCLANDATE`,`TYPEOFWORK`,`REALNAME`,`IMAGE`,`JDEPARTMENTDATE`,`INACTIVESERVICE`,`OPERATOR`,`ADDDATE`,`ID`,`CADRESSOURCE`,`TRANSITIONDATE`,`DEPTCODE`,`ACCOUNT`,`OPERATETYPE`,`PEOPLE`,`MOSTGRADE`) VALUES ('11605225628431810865','男',NULL,'dd','dd',NULL,NULL,'亚健康','','小学','科长',NULL,'团员',NULL,'行政','dd',NULL,NULL,'','admin','2006-10-11 07:22:50',0,'招考',NULL,'2deputyzjl','dd','创建',NULL,NULL),('11624617811255930823','男',NULL,'asdf','sadf',NULL,NULL,'','sadfsafd','小学','科长',NULL,'团员',NULL,'行政','sdfasdf',NULL,NULL,'','admin','2006-11-02 18:07:50',100,'招考',NULL,'2deputyzjl','0','创建',NULL,'专科'),('11624617811255930823','男',NULL,'asdf','sadf',NULL,NULL,'','sadfsafd','小学','科长',NULL,'团员',NULL,'行政','sdfasdf',NULL,NULL,'','admin','2006-11-02 18:08:42',101,'招考',NULL,'2deputyzjl','0','修改',NULL,'专科');
CREATE TABLE `asset_info` (
  `Id` int(11) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `type` varchar(50) default NULL,
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -