redmoonoa.sql

来自「oa 源码」· SQL 代码 · 共 897 行 · 第 1/5 页

SQL
897 行
字号
12345
  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 '',
  `INPUT_VALUE` varchar(100) default NULL,
  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` int(11) default '0',
  `PEOPLE` varchar(50) default NULL,
  `MOSTGRADE` varchar(50) default NULL,
  `IDCARD` varchar(20) default NULL,
  PRIMARY KEY  (`USERNAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
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` int(11) default NULL,
  `OPERATETYPE` varchar(10) default NULL,
  `PEOPLE` varchar(50) default NULL,
  `MOSTGRADE` varchar(50) default NULL,
  `IDCARD` varchar(20) default NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ARCHIVE_USER_HIS_INDEX` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `asset_info` (
  `Id` int(11) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `type` varchar(50) default NULL,
  `number` varchar(11) default NULL,
  `typeId` int(11) default NULL,
12345

redmoonoa.sql - 源码说明

本页面展示了「oa 源码」中的 redmoonoa.sql 源码文件，采用 SQL 编程语言编写，共 897 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与oa相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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