e_ttoa_create_table.sql

非常完整的Java开发的网络办公系统

	) 
;
CREATE TABLE T_DUTY (
	DUTY_ID NUMERIC ( 11 ) NOT NULL,
	DIVISION_ID NUMERIC ( 11 ) NOT NULL,
	DUTY_TITLE VARCHAR ( 200 ),
	DESCRIPTION VARCHAR ( 200 ),
	CHECK_STANDARD VARCHAR ( 200 ),
	DEMAND_SKILL VARCHAR ( 200 ),
	NEED_NUMERIC NUMERIC ( 4 ),
	CURRENT_NUMBER NUMERIC ( 4 ),
	CONSTRAINT SYS_C005183 PRIMARY KEY (DUTY_ID),
	CONSTRAINT T_DUTY_UN01 UNIQUE (DIVISION_ID, DUTY_TITLE)
	) 
;
CREATE TABLE T_DIVISION (
	DIVISION_ID NUMERIC ( 11 ) NOT NULL,
	P_DIVISION_ID NUMERIC ( 11 ),
	DIVISION_NAME VARCHAR ( 80 ) NOT NULL,
	LOCATION VARCHAR ( 60 ),
	TELEPHONE VARCHAR ( 20 ),
	FAX VARCHAR ( 20 ),
	ZIP_CODE VARCHAR ( 6 ),
	PROVINCE VARCHAR ( 20 ),
	CITY VARCHAR ( 20 ),
	MANAGER_ID NUMERIC ( 11 ),
	DIVISION_DUTY VARCHAR ( 200 ),
	EMAIL VARCHAR ( 30 ),
	DIVISION_TYPE VARCHAR ( 20 ),
	CONSTRAINT SYS_C005163 PRIMARY KEY (DIVISION_ID),
	CONSTRAINT T_DIVISION_UN01 UNIQUE (P_DIVISION_ID, DIVISION_NAME)
	) 
;
CREATE TABLE HR_CONTRACT (
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	CONTRACT_TYPE NUMERIC ( 5 ),
	CONTRACT_CURRENCY NUMERIC ( 5 ),
	CONTRACT_STATE NUMERIC ( 5 ),
	CONTRACT_STARTDATE DATETIME,
	CONTRACT_ENDDATE DATETIME,
	CONTRACT_SALARY NUMERIC ( 10, 2 ),
	CONTRACT_POSITION_LEVEL VARCHAR ( 40 ),
	CONTRACT_SALARY_LEVEL VARCHAR ( 40 ),
	CONTRACT_NOTE VARCHAR ( 400 ),
	CONSTRAINT SYS_C005815 PRIMARY KEY (EMP_ID)
	) 
;
CREATE TABLE T_SUBTASK (
	SUB_TASK_ID NUMERIC ( 10 ) NOT NULL,
	STEP_NO NUMERIC ( 5 ) NOT NULL,
	TITLE VARCHAR ( 250 ) NOT NULL,
	DESCRIPTION VARCHAR ( 1500 ),
	BEGIN_DATE DATETIME,
	PLAN_END_DATE DATETIME,
	END_DATE DATETIME,
	WORKFLOW_ID NUMERIC ( 10 ) NOT NULL,
	STATUS_ID NUMERIC ( 2 ) NOT NULL,
	TYPE_ID NUMERIC ( 2 ) NOT NULL,
	NOTE VARCHAR ( 1500 ),
	CONSTRAINT PK_SUBTASKS5 PRIMARY KEY (SUB_TASK_ID)
	) 
;
CREATE TABLE T_ACCIDENT (
	ID FLOAT NOT NULL,
	EMP_ID FLOAT NOT NULL,
	TIME DATETIME,
	SITE VARCHAR ( 1000 ),
	SEVERITY_LEVEL VARCHAR ( 100 ),
	REASON VARCHAR ( 1000 ),
	IS_RESPONSIBLE FLOAT,
	PROCESS_RESULT VARCHAR ( 1000 ),
	NOTE VARCHAR ( 1000 ),
	AUTOMOBILE_ID NUMERIC ( 11 ) NOT NULL,
	CONSTRAINT PK_T_ACCIDENT131 PRIMARY KEY (ID)
	) 
;
CREATE TABLE HR_TRAIN_FEEDBACK (
	TRAIN_ID NUMERIC ( 5 ) NOT NULL,
	EMP_ID NUMERIC ( 11 ),
	TRAIN_SATISFACTION VARCHAR ( 20 ),
	TRAIN_EXPERIENCE VARCHAR ( 2000 ),
	TRAIN_ADVICE VARCHAR ( 2000 ),
	TRAIN_COMMENT VARCHAR ( 2000 )
	) 
;
CREATE TABLE JIVEGROUPPERM (
	FORUMID FLOAT NOT NULL,
	GROUPID FLOAT NOT NULL,
	PERMISSION FLOAT NOT NULL,
	CONSTRAINT SYS_C006090 PRIMARY KEY (FORUMID, GROUPID, PERMISSION)
	) 
;
CREATE TABLE T_LEAVE_WORD (
	LEAVE_WORD_ID NUMERIC ( 11 ) NOT NULL,
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	MSG_TITLE VARCHAR ( 200 ),
	MSG_BODY VARCHAR ( 3000 ),
	WRITE_DATE DATETIME NOT NULL,
	END_DATE DATETIME,
	CONSTRAINT PK_T_LEAVE_WORD1 PRIMARY KEY (LEAVE_WORD_ID)
	) 
;
CREATE TABLE T_SAFETY_DRIVING (
	ID FLOAT NOT NULL,
	SAFETY_EXAMINATION VARCHAR ( 1000 ),
	BONUS FLOAT,
	NOTE VARCHAR ( 1000 ),
	CONSTRAINT PK_T_SAFTY_DRIVING1 PRIMARY KEY (ID)
	) 
;
CREATE TABLE T_SUBTASK_TEMPLATE (
	SUBTASK_ID NUMERIC ( 10 ) NOT NULL,
	STEP_NO NUMERIC ( 4 ) NOT NULL,
	TITLE VARCHAR ( 2000 ),
	DESCRIPTION VARCHAR ( 4000 ),
	WORKFLOW_ID NUMERIC ( 10 ) NOT NULL,
	TYPE_ID NUMERIC ( 2 ) NOT NULL,
	CONSTRAINT PK_T_SUBTASK_TEMPLATE22 PRIMARY KEY (SUBTASK_ID)
	) 
;
CREATE TABLE T_CONTACT_PERSON_NOTES (
	NOTE_ID FLOAT NOT NULL,
	PERSON_ID FLOAT,
	NOTE_SUMMARY VARCHAR ( 20 ),
	NOTE_DESCRIPTION VARCHAR ( 20 ),
	CONSTRAINT SYS_C005583 PRIMARY KEY (NOTE_ID)
	) 
;
CREATE TABLE T_WORKFLOW_TEMPLATE (
	WORKFLOW_ID NUMERIC ( 10 ) NOT NULL,
	CREATOR NUMERIC ( 10 ),
	CREATION_DATE DATETIME,
	TITLE VARCHAR ( 2000 ),
	DESCRIPTION VARCHAR ( 3000 ),
	FILE_PATH VARCHAR ( 1000 ),
	TYPE_ID NUMERIC ( 10 ) NOT NULL,
	MODIFIER NUMERIC ( 10 ),
	MODIFIED_DATE DATETIME,
	WORKFLOW_TYPE_ID NUMERIC ( 10 ),
	CONSTRAINT PK_T_WORKFLOW4 PRIMARY KEY (WORKFLOW_ID)
	) 
;
CREATE TABLE HR_MEMBER_INNER_RESUME (
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	INNER_ID NUMERIC ( 11 ) NOT NULL,
	INNER_DEVISION_NAME VARCHAR ( 80 ),
	INNER_STARTDATE DATETIME,
	INNER_ENDDATE DATETIME,
	INNER_DUTY VARCHAR ( 80 ),
	INNER_ACHIEVEMENT VARCHAR ( 400 ),
	CONSTRAINT SYS_C005487 PRIMARY KEY (EMP_ID, INNER_ID)
	) 
;
CREATE TABLE T_EMPLOYEE_X_GROUP (
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	GROUP_ID NUMERIC ( 11 ) NOT NULL,
	CONSTRAINT PK_T_EMPLOYEE_X_GROUP1 PRIMARY KEY (EMP_ID, GROUP_ID)
	) 
;
CREATE TABLE T_AUTOMOBILE_MAINTAIN (
	ID NUMERIC ( 11 ) NOT NULL,
	AUTOMOBILE_ID NUMERIC ( 11 ) NOT NULL,
	BEGIN_TIME DATETIME NOT NULL,
	END_TIME DATETIME NOT NULL,
	SENDER VARCHAR ( 256 ),
	REPAIRER VARCHAR ( 256 ) NOT NULL,
	REASON VARCHAR ( 2048 ),
	COST NUMERIC ( 11, 2 ) NOT NULL,
	CONSTRAINT PK_T_AUTOMOBILE_MAINTAIN124 PRIMARY KEY (ID)
	) 
;
CREATE TABLE T_CONFERENCE_X_FILES (
	ID NUMERIC ( 10 ) NOT NULL,
	FILE_ID NUMERIC ( 5 ) NOT NULL,
	CONSTRAINT PK_T_CONFERENCE_X_FILES134 PRIMARY KEY (ID, FILE_ID)
	) 
;
CREATE TABLE T_CONFERENCE_STATUS (
	STATUS_ID NUMERIC ( 1 ) NOT NULL,
	STATUS_NAME VARCHAR ( 100 ) NOT NULL,
	DESCRIPTION VARCHAR ( 1000 ),
	CONSTRAINT PK_T_CONFERENCE_STATUS130 PRIMARY KEY (STATUS_ID)
	) 
;
CREATE TABLE T_EXECUTOR_TEMPLATE (
	ID NUMERIC ( 10 ) NOT NULL,
	EMPLOYEE_ID NUMERIC ( 10 ) NOT NULL,
	NOTES VARCHAR ( 800 ),
	SUBTASK_ID NUMERIC ( 10 ) NOT NULL,
	CONSTRAINT PK_T_EXECUTOR_TEMPATE23 PRIMARY KEY (ID)
	) 
;
CREATE TABLE T_WORKFLOW_STATUS_SPEC (
	STATUS_ID NUMERIC ( 10 ) NOT NULL,
	STATUS_NAME VARCHAR ( 64 ) NOT NULL,
	CONSTRAINT PK_T_WORKFLOW_STATUS_SPEC19 PRIMARY KEY (STATUS_ID),
	CONSTRAINT TC_T_WORKFLOW_STATUS_SPEC167 UNIQUE (STATUS_ID)
	) 
;
CREATE TABLE T_DOCRECEIVED_X_FILE (
	FILE_ID NUMERIC ( 10 ),
	ID NUMERIC ( 10 ),
	CONSTRAINT PK_T_DOCRECEIVED_X_FILE22 PRIMARY KEY (FILE_ID, ID)
	) 
;
CREATE TABLE T_WORKFLOW_TEMPLATE_X_FILE (
	ID NUMERIC ( 10 ),
	FILE_ID NUMERIC ( 10 ),
	CONSTRAINT PK_T_WORKFLOW_TEMPLATE_X_FI18 PRIMARY KEY (ID, FILE_ID)
	) 
;
CREATE TABLE T_WORKFLOW (
	WORKFLOW_ID NUMERIC ( 10 ) NOT NULL,
	CREATOR_ID NUMERIC ( 10 ),
	CREATE_DATE DATETIME,
	TITLE VARCHAR ( 1000 ) NOT NULL,
	DESCRIPTION VARCHAR ( 4000 ),
	FILE_PATH VARCHAR ( 100 ),
	STATUS_ID NUMERIC ( 10 ) NOT NULL,
	TYPE_ID NUMERIC ( 10 ) NOT NULL,
	CONSTRAINT PK_T_WORKFLOW24 PRIMARY KEY (WORKFLOW_ID)
	) 
;
CREATE TABLE HR_MEMBER_EDUCATIONAL_INFO (
	MEMBER_SCHOOL_ID NUMERIC ( 11 ) NOT NULL,
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	MEMBER_SCHOOL VARCHAR ( 80 ),
	DD_EDULEVEL_ID NUMERIC ( 5 ),
	MEMBER_SUBJECT VARCHAR ( 80 ),
	MEMBER_STARTDATE DATETIME,
	MEMBER_ENDDATE DATETIME,
	MEMBER_EDU_SPECIAL VARCHAR ( 200 ),
	CONSTRAINT SYS_C005502 PRIMARY KEY (MEMBER_SCHOOL_ID, EMP_ID)
	) 
;
CREATE TABLE T_EXECUTOR (
	EXEC_ID NUMERIC ( 10 ) NOT NULL,
	EMPLOYEE_ID NUMERIC ( 10 ) NOT NULL,
	BEGIN_DATE DATETIME,
	END_DATE DATETIME,
	NOTES VARCHAR ( 100 ),
	SUB_TASK_ID NUMERIC ( 10 ) NOT NULL,
	STATUS_ID NUMERIC ( 10 ) NOT NULL,
	CONSTRAINT PK_EXECUTOR6 PRIMARY KEY (EXEC_ID)
	) 
;
CREATE TABLE HR_DEV_TRAIN (
	TRAIN_ID NUMERIC ( 5 ) NOT NULL,
	DIVISION_ID NUMERIC ( 11 ),
	DEP_TRAIN_DESCRIPTION VARCHAR ( 20 ),
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	EMP_NAME VARCHAR ( 20 ),
	CONSTRAINT HR_DEV_TRAIN_PK PRIMARY KEY (TRAIN_ID, EMP_ID)
	) 
;
CREATE TABLE HR_MEMBER_SALARY (
	COMPONENT_ID NUMERIC ( 5 ) NOT NULL,
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	COMPONENT_COUNT NUMERIC ( 8, 2 ),
	COMPONENT_TYPE FLOAT,
	CONSTRAINT SYS_C005951 PRIMARY KEY (COMPONENT_ID, EMP_ID)
	) 
;
CREATE TABLE T_TRAINNING_PROJECT (
	TRAINNING_ID FLOAT NOT NULL,
	TRAIN_TITLE VARCHAR ( 20 ),
	TRAIN_SUMMARY VARCHAR ( 20 ),
	TRAIN_DESCRIPTION VARCHAR ( 20 ),
	DEPT_NO FLOAT,
	START_DATE DATETIME,
	END_DATE DATETIME,
	CONSTRAINT SYS_C005525 PRIMARY KEY (TRAINNING_ID)
	) 
;
CREATE TABLE T_AUTOMOBILE_TYPE (
	TYPE_ID NUMERIC ( 5 ) NOT NULL,
	TYPE_NAME VARCHAR ( 256 ) NOT NULL,
	CONSTRAINT PK_T_AUTOMOBILE_TYPE129 PRIMARY KEY (TYPE_ID)
	) 
;
CREATE TABLE T_WORKFLOW_INSTANCY_TYPE (
	ID NUMERIC ( 5 ) NOT NULL,
	NAME VARCHAR ( 64 ) NOT NULL,
	CONSTRAINT PK_T_WORKFLOW_INSTANCY_TYPE21 PRIMARY KEY (ID)
	) 
;
CREATE TABLE HR_DD (
	DD_ID NUMERIC ( 5 ) NOT NULL,
	DD_TYPE_ID FLOAT,
	DD_NAME VARCHAR ( 60 ),
	DD_STATE FLOAT,
	DD_DESCRIPTION VARCHAR ( 120 ),
	CONSTRAINT SYS_C005479 PRIMARY KEY (DD_ID)
	) 
;
CREATE TABLE T_DOC_RECEIVED (
	ID NUMERIC ( 10 ) NOT NULL,
	NO VARCHAR ( 128 ) NOT NULL,
	TITLE VARCHAR ( 256 ) NOT NULL,
	RECEIVED_DATE DATETIME,
	FILE_NUMBER NUMERIC ( 5 ),
	PAGES NUMERIC ( 5 ),
	CONTENT VARCHAR ( 800 ),
	REMARK VARCHAR ( 800 ),
	CREATOR_ID NUMERIC ( 10 ),
	CREATE_DATE DATETIME,
	COME_FROM VARCHAR ( 400 ),
	TYPE_ID NUMERIC ( 2 ) NOT NULL,
	SECURITY_ID NUMERIC ( 5 ) NOT NULL,
	KEYWORD VARCHAR ( 2000 ),
	CONSTRAINT PK_T_DOC_RECEIVED24 PRIMARY KEY (ID)	
	) 
;
CREATE TABLE JIVEGROUP (
	GROUPID FLOAT NOT NULL,
	NAME VARCHAR ( 50 ) NOT NULL,
	DESCRIPTION VARCHAR ( 255 ),
	CONSTRAINT SYS_C006086 PRIMARY KEY (GROUPID)
	) 
;
CREATE TABLE HR_MEMBER_RESUME_INFO (
	MEMBER_COR_ID NUMERIC ( 11 ) NOT NULL,
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	MEMBER_COR_NAME VARCHAR ( 80 ),
	MEMBER_STARTDATE DATETIME,
	MEMBER_ENDDATE DATETIME,
	MEMBER_DEP_NAME VARCHAR ( 80 ),
	MEMBER_DUTY_NAME VARCHAR ( 40 ),
	MEMBER_ACHIEVEMENT VARCHAR ( 400 ),
	MEMBER_RESUME_TYPE FLOAT,
	CONSTRAINT SYS_C005497 PRIMARY KEY (MEMBER_COR_ID, EMP_ID)
	) 
;
CREATE TABLE T_CONTRACT (
	CONTRACT_ID FLOAT NOT NULL,
	EMP_ID VARCHAR ( 20 ),
	STATUS VARCHAR ( 20 ),
	CONTRACT_NAME VARCHAR ( 20 ),
	CONTRACT_TYPE CHAR ( 18 ),
	SIGN_DATE DATETIME,
	ABORT_DATE DATETIME,
	CONTRACT_CONTENT VARCHAR ( 4000 ),
	CONSTRAINT SYS_C005514 PRIMARY KEY (CONTRACT_ID)
	) 
;
CREATE TABLE T_SALARY_ITEMS_SPEC (
	ITEM_ID FLOAT NOT NULL,
	ITEM_NAME FLOAT,
	CONSTRAINT SYS_C005516 PRIMARY KEY (ITEM_ID)
	) 
;
CREATE TABLE T_WORKFLOW_X_FILE (
	ID NUMERIC ( 10 ),
	FILE_ID NUMERIC ( 10 ),
	CONSTRAINT PK_T_WORKFLOW_X_FILE11 PRIMARY KEY (ID, FILE_ID)
	) 
;
CREATE TABLE T_ATTENDANCE_LOG (
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	WORK_DATE DATETIME NOT NULL,
	CHECK_IN_TIME DATETIME,
	CHECK_OFF_TIME DATETIME,
	CHECK_IN_NOTES VARCHAR ( 500 ),
	CHECK_OFF_NOTES VARCHAR ( 500 ),
	LATE_COUNT NUMERIC ( 4 ),
	EARLY_LEAVE_COUNT NUMERIC ( 4 ),
	CONSTRAINT SYS_C005250 PRIMARY KEY (EMP_ID, WORK_DATE)
	) 
;
CREATE TABLE T_REGULATION (
	REGULATION_ID NUMERIC ( 11 ) NOT NULL,
	REGULATION_NAME VARCHAR ( 200 ),
	REGULATION_DEPARTMENT VARCHAR ( 200 ),
	ATTACHMENT_URL VARCHAR ( 100 ),
	PUBLISH_DATE DATETIME,
	CONSTRAINT SYS_C005294 PRIMARY KEY (REGULATION_ID)
	) 
;
CREATE TABLE T_EQUIPMENT_ALLOWED_DEPT (
	EQUIPMENT_ID VARCHAR ( 20 ) NOT NULL,
	DEPT_NO FLOAT,
	TYPE VARCHAR ( 20 ),
	PRIVILEGE VARCHAR ( 20 ),
	CONSTRAINT SYS_C005570 PRIMARY KEY (EQUIPMENT_ID)
	) 
;
CREATE TABLE T_EMP_X_PRIVILEGE (
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	PRIVILEGE_ID NUMERIC ( 11 ) NOT NULL,
	ASSIGNER_ID NUMERIC ( 11 ),
	ASSIGN_DATE DATETIME,
	DIVISION_ID NUMERIC ( 11 ) NOT NULL,
	CONSTRAINT SYS_C005177 PRIMARY KEY (EMP_ID, PRIVILEGE_ID, DIVISION_ID)
	) 
;
CREATE TABLE T_DIRECTORIES_PERMISSION (
	DIRECTORY_ID NUMERIC ( 11 ) NOT NULL,
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	PERMISSION NUMERIC ( 1 ) NOT NULL,
	ASSIGNER_ID NUMERIC ( 11 ),
	ASSIGN_DATE DATETIME,
	CONSTRAINT PK_T_DIRECTORIES_PERMISSION16 PRIMARY KEY (DIRECTORY_ID, EMP_ID, PERMISSION)
	) 
;
CREATE TABLE T_DIVISION_TYPE (
	DIVISION_TYPE VARCHAR ( 20 ) NOT NULL,
	DESCRIPTION VARCHAR ( 20 ),
	CONSTRAINT SYS_C005280 PRIMARY KEY (DIVISION_TYPE)
	) 
;
CREATE TABLE T_DISCUSSION_TOPIC (
	TOPIC_ID FLOAT NOT NULL,
	TOPIC_NAME VARCHAR ( 20 ),
	TOPIC_DESCRIPTION VARCHAR ( 1000 ),
	CREATOR_NO FLOAT,
	START_DATE DATETIME,
	CONSTRAINT SYS_C005544 PRIMARY KEY (TOPIC_ID)
	) 
;
CREATE TABLE T_CONFERENCE (
	CONFERENCE_ID NUMERIC ( 10 ) NOT NULL,
	SUBJECT VARCHAR ( 100 ) NOT NULL,
	START_TIME DATETIME NOT NULL,