📄 redmoonoa.sql

📁 oa 源代码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
12 3 4 5 下一页
SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 /*!32312 IF NOT EXISTS*/ `redmoonoa`;
USE `redmoonoa`;
CREATE TABLE `account` (
  `name` varchar(20) NOT NULL default '',
  `userName` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`name`),
  KEY `Index_userName` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `address` (
  `ID` bigint(20) NOT NULL default '0',
  `PERSON` varchar(20) NOT NULL default '',
  `JOB` varchar(20) default NULL,
  `TEL` varchar(50) default NULL,
  `POSTALCODE` varchar(10) default NULL,
  `EMAIL` varchar(100) default NULL,
  `MOBILE` varchar(20) default NULL,
  `INTRODUCTION` varchar(200) default NULL,
  `ADDRESS` varchar(50) default NULL,
  `USERNAME` varchar(20) NOT NULL default '',
  `ADDDATE` datetime default NULL,
  `TYPE` bigint(20) default NULL,
  `FIRSTNAME` varchar(50) default NULL,
  `FAMILYNAME` varchar(50) default NULL,
  `MIDDLENAME` varchar(50) default NULL,
  `NICKNAME` varchar(50) default NULL,
  `STREET` varchar(50) default NULL,
  `CITY` varchar(50) default NULL,
  `PROVINCE` varchar(50) default NULL,
  `COUNTRY` varchar(50) default NULL,
  `FAX` varchar(50) default NULL,
  `COMPANYSTREET` varchar(50) default NULL,
  `COMPANYCITY` varchar(50) default NULL,
  `COMPANYPOSTCODE` varchar(50) default NULL,
  `COMPANYPROVICE` varchar(50) default NULL,
  `COMPANYCOUNTRY` varchar(50) default NULL,
  `OPERATIONWEB` varchar(50) default NULL,
  `OPERATIONPHONE` varchar(50) default NULL,
  `OPERATIONFAX` varchar(50) default NULL,
  `BEEPPAGER` varchar(50) default NULL,
  `COMPANY` varchar(50) default NULL,
  `DEPARTMENT` varchar(50) default NULL,
  `WEB` varchar(50) default NULL,
  `TYPEID` int(11) default NULL,
  `MSN` varchar(100) default NULL,
  `QQ` varchar(20) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `address_type` (
  `ID` bigint(20) NOT NULL default '0',
  `NAME` varchar(50) default NULL,
  `USER_NAME` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_assess` (
  `ID` bigint(20) NOT NULL default '0',
  `USERNAME` varchar(50) NOT NULL default '',
  `ASSESSYEAR` varchar(50) default NULL,
  `INFO` varchar(50) default NULL,
  `MYDATE` datetime default NULL,
  `RESULT` varchar(50) default NULL,
  `REMARK` varchar(50) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_assess_his` (
  `ID` bigint(20) NOT NULL default '0',
  `USERNAME` varchar(50) NOT NULL default '',
  `ASSESSYEAR` varchar(50) default NULL,
  `INFO` varchar(50) default NULL,
  `MYDATE` datetime default NULL,
  `RESULT` varchar(50) default NULL,
  `REMARK` varchar(50) 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_duty` (
  `ID` bigint(20) NOT NULL default '0',
  `USERNAME` varchar(50) NOT NULL default '',
  `INFO` varchar(50) default NULL,
  `FILENUMBER` varchar(50) default NULL,
  `MYDATE` datetime default NULL,
  `DUTY` varchar(50) default NULL,
  `DEPOSAL` varchar(50) default NULL,
  `REMARK` varchar(250) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `archive_duty` (`ID`,`USERNAME`,`INFO`,`FILENUMBER`,`MYDATE`,`DUTY`,`DEPOSAL`,`REMARK`) VALUES (100,'11624617811255930823','sdfg','sdfg','2006-11-20 00:00:00','dsfg','','sdfgsdfg');
CREATE TABLE `archive_duty_his` (
  `ID` bigint(20) NOT NULL default '0',
  `USERNAME` varchar(50) NOT NULL default '',
  `INFO` varchar(50) default NULL,
  `FILENUMBER` varchar(50) default NULL,
  `MYDATE` datetime default NULL,
  `DUTY` varchar(50) default NULL,
  `DEPOSAL` varchar(50) default NULL,
  `REMARK` varchar(250) default NULL,
  `OPERATOR` varchar(20) default NULL,
  `ADDDATE` datetime default NULL,
  `OPERATETYPE` varchar(10) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `archive_duty_his` (`ID`,`USERNAME`,`INFO`,`FILENUMBER`,`MYDATE`,`DUTY`,`DEPOSAL`,`REMARK`,`OPERATOR`,`ADDDATE`,`OPERATETYPE`) VALUES (100,'11624617811255930823','sdfg','sdfg','2006-11-20 00:00:00','dsfg','','sdfgsdfg','admin','2006-11-02 18:08:55','创建');
CREATE TABLE `archive_family` (
  `ID` bigint(20) NOT NULL default '0',
  `APPELLATION` varchar(20) default NULL,
  `NAME` varchar(20) default NULL,
  `AGE` bigint(20) default NULL,
  `POLITIC` varchar(20) default NULL,
  `UNIT` varchar(100) default NULL,
  `REMARK` varchar(250) default NULL,
  `USERNAME` varchar(20) default NULL,
  `ADDRESS` varchar(200) default NULL,
  `PHONE` varchar(20) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_family_his` (
  `ID` bigint(20) NOT NULL default '0',
  `APPELLATION` varchar(20) default NULL,
  `NAME` varchar(20) default NULL,
  `AGE` bigint(20) default NULL,
  `POLITIC` varchar(20) default NULL,
  `UNIT` varchar(100) default NULL,
  `REMARK` varchar(250) default NULL,
  `USERNAME` varchar(20) default NULL,
  `ADDRESS` varchar(200) default NULL,
  `PHONE` 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_field` (
  `ID` int(11) NOT NULL default '0',
  `FIELD_NAME` varchar(50) NOT NULL default '',
  `FIELD_CODE` varchar(50) NOT NULL default '',
  `TABLE_SHORT_CODE` varchar(50) NOT NULL default '',
  `FIELD_TYPE` varchar(50) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `archive_field` (`ID`,`FIELD_NAME`,`FIELD_CODE`,`TABLE_SHORT_CODE`,`FIELD_TYPE`) VALUES (16,'毕业院校','COLLEGE','AST','0'),(17,'毕业院校简称','SCOLLEGE','AST','0'),(18,'专业','SPECIALTY','AST','0'),(19,'专业简称','SSPECIALTY','AST','0'),(20,'是否在职','ISJOB','AST','1'),(21,'开始时间','BEGINDATE','AST','2'),(22,'结束时间','ENDDATE','AST','2'),(23,'学位','DEGREE','AST','1'),(24,'单位名称','COMPANY','ARES','0'),(25,'担任何种工作','JOB','ARES','0'),(26,'开始时间','BEGINDATE','ARES','2'),(27,'结束时间','ENDDATE','ARES','2'),(28,'离职原因','LEAVEREASON','ARES','0'),(29,'称谓','APPELLATION','AFA','1'),(30,'姓名','NAME','AFA','0'),(31,'年龄','AGE','AFA','0'),(32,'政治面貌','POLITIC','AFA','1'),(33,'工作单位','UNIT','AFA','0'),(34,'联系地址','ADDRESS','AFA','0'),(35,'联系电话','PHONE','AFA','0'),(36,'专业技术职务','PROFESSION','APR','1'),(37,'获取时间','MYDATE','APR','2'),(38,'证书编号','NUMBER','APR','0'),(39,'专长','SPECIAL','APR','0');
INSERT INTO `archive_field` (`ID`,`FIELD_NAME`,`FIELD_CODE`,`TABLE_SHORT_CODE`,`FIELD_TYPE`) VALUES (40,'证书名称','NAME','APR','0'),(41,'考核年度','ASSESSYEAR','AAS','0'),(42,'考核情况','INFO','AAS','0'),(43,'审批时间','MYDATE','AAS','2'),(44,'考核结果','RESULT','AAS','1'),(45,'何时','MYDATE','ARE','2'),(46,'何地','PLACE','ARE','0'),(47,'何种奖励','REWARDS','ARE','0'),(48,'主要事迹','REASON','ARE','0'),(49,'任免情况','INFO','ADU','0'),(50,'任职','duty','ADU','0'),(51,'免职','deposal','ADU','0'),(52,'任免时间','MYDATE','ADU','2'),(53,'任免文号','FILENUMBER','ADU','0'),(1,'真实姓名','REALNAME','AUS','0'),(2,'性别','SEX','AUS','1'),(3,'出生日期','BIRTHDAY','AUS','2'),(4,'籍贯','NATION','AUS','0'),(5,'出生地','BORN','AUS','0'),(6,'入党时间','JPARTYDATE','AUS','2'),(7,'参加工作时间','JWORKDATE','AUS','2'),(8,'健康状况','HEALTHSTATE','AUS','1'),(9,'文化程度','CULTURE','AUS','1'),(10,'后备干部级别','INSUPPORTCADRELEVEL','AUS','1'),(11,'定为后备干部的时间','INSUPPORTCADREDATE','AUS','2');
INSERT INTO `archive_field` (`ID`,`FIELD_NAME`,`FIELD_CODE`,`TABLE_SHORT_CODE`,`FIELD_TYPE`) VALUES (12,'政治面貌','POLITY','AUS','1'),(13,'其它党派加入时间','JOINCLANDATE','AUS','2'),(14,'编制情况','TYPEOFWORK','AUS','1'),(15,'学历','GRADE','AST','1'),(54,'编号','ACCOUNT','AUS','0'),(55,'在职情况','INACTIVESERVICE','AUS','1'),(56,'加入本单位时间','JDEPARTMENTDATE','AUS','2'),(57,'干部来源','CADRESSOURCE','AUS','1'),(58,'过渡时间','TRANSITIONDATE','AUS','2');
CREATE TABLE `archive_privilege` (
  `ID` int(11) NOT NULL default '0',
  `USERNAME` varchar(20) NOT NULL default '',
  `QUERY_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_profession` (
  `ID` bigint(20) NOT NULL default '0',
  `PROFESSION` varchar(50) default NULL,
  `MYDATE` datetime default NULL,
  `SPECIAL` varchar(50) default NULL,
  `REMARK` varchar(250) default NULL,
  `USERNAME` varchar(50) NOT NULL default '',
  `NAME` varchar(50) default NULL,
  `CNUM` varchar(50) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_profession_his` (
  `ID` bigint(20) NOT NULL default '0',
  `PROFESSION` varchar(50) default NULL,
  `MYDATE` datetime default NULL,
  `SPECIAL` varchar(50) default NULL,
  `REMARK` varchar(250) default NULL,
  `USERNAME` varchar(50) NOT NULL default '',
  `NAME` varchar(50) default NULL,
  `CNUM` varchar(50) default NULL,
  `OPERATOR` varchar(20) default NULL,
12 3 4 5 下一页
⌨️ 快捷键说明

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