e_ttoa_create_table.sql

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

	END_TIME DATETIME NOT NULL,
	CREATOR NUMERIC ( 10 ),
	CREATION_DATE DATETIME,
	CONTACT_WAY VARCHAR ( 1000 ),
	DESCRIPTION VARCHAR ( 4000 ),
	IF_PUT_SUMMARY NUMERIC ( 1 ),
	UPDATE_DATE DATETIME,
	WORKFLOW_ID NUMERIC ( 10 ) NOT NULL,
	STATUS_ID NUMERIC ( 1 ) NOT NULL,
	BOARDROOM_ID NUMERIC ( 10 ) NOT NULL,
	FILE_PATH VARCHAR ( 1000 ),
	CONSTRAINT PK_T_CONFERENCE125 PRIMARY KEY (CONFERENCE_ID)
	) 
;
CREATE TABLE T_MSG_RECEIVER (
	MSG_ID NUMERIC ( 11 ) NOT NULL,
	RECEIVER_ID NUMERIC ( 11 ) NOT NULL,
	CONSTRAINT PK_T_MSG_RECEIVER5 PRIMARY KEY (MSG_ID, RECEIVER_ID)
	) 
;
CREATE TABLE T_WORK_RECORD (
	ID FLOAT NOT NULL,
	EMP_ID FLOAT NOT NULL,
	AUTOMOBILE_ID NUMERIC ( 11 ) NOT NULL,
	BOATER VARCHAR ( 100 ),
	REASON VARCHAR ( 1000 ),
	SITE VARCHAR ( 1000 ),
	BEGIN_TIME DATETIME,
	END_TIME DATETIME,
	SENDER VARCHAR ( 1000 ),
	NOTE VARCHAR ( 1000 ),
	CONSTRAINT PK_T_WORK_RECORD132 PRIMARY KEY (ID)
	) 
;
CREATE TABLE T_TASK (
	TASK_ID NUMERIC ( 11 ) NOT NULL,
	TASK_NAME VARCHAR ( 200 ),
	TASK_CONTENT VARCHAR ( 2000 ),
	START_DATE DATETIME,
	END_DATE DATETIME,
	TASK_IMPORT VARCHAR ( 200 ),
	TASK_VISIBLE NUMERIC ( 1 ),
	COADJUTANT VARCHAR (200),
	CREATOR_ID NUMERIC ( 11 ),
	CREATE_DATE DATETIME,
	CONSTRAINT SYS_C005282 PRIMARY KEY (TASK_ID)
	) 
;
CREATE TABLE T_ARCHIVE (
	ARCHIVE_ID NUMERIC ( 11 ) NOT NULL,
	ARCHIVE_DISPLAY_ID VARCHAR ( 20 ),
	SAVE_ARCHIVE_DATE DATETIME,
	RECEIVER_ID NUMERIC ( 11 ),
	SENDER VARCHAR ( 50 ),
	CREATE_DATE DATETIME,
	ARCHIVE_TITLE VARCHAR ( 2000 ),
	ARCHIVE_KEYWORD VARCHAR ( 2000 ),
	CONTENTS VARCHAR ( 1000 ),
	SAFETY_LEVEL NUMERIC ( 1 ),
	COPY_PERMISSION NUMERIC ( 1 ),
	COPY_NUM NUMERIC ( 5 ),
	PRINT_PERMISSION NUMERIC ( 1 ),
	PRINT_NUM NUMERIC ( 5 ),
	LEND_PERMISSION NUMERIC ( 1 ),
	SEND_TO_VIEW_FLAG NUMERIC ( 1 ),
	LEADER_NOTES VARCHAR ( 2000 ),
	ARCHIVE_TYPE_ID NUMERIC ( 11 ),
	FILE_SOURCE_ID NUMERIC ( 11 ),
	SEQUENCE_ID NUMERIC ( 7 ),
	IS_BORROWED NUMERIC ( 1 ) DEFAULT 0
,
	CONSTRAINT PK_T_ARCHIVES28 PRIMARY KEY (ARCHIVE_ID)
	) 
;
CREATE TABLE T_SUBTASK_TYPE_SPEC (
	TYPE_ID NUMERIC ( 2 ) NOT NULL,
	TYPE_NAME VARCHAR ( 64 ) NOT NULL,
	CONSTRAINT TC_T_WORKFLOW_TYPE_SPEC168 UNIQUE (TYPE_ID),
	CONSTRAINT PK_T_WORKFLOW_TYPE_SPEC20 PRIMARY KEY (TYPE_ID)
	) 
;
CREATE TABLE T_PROJECT_CHANGE (
	PROJECT_ID FLOAT NOT NULL,
	PERSON_ID FLOAT,
	PROJECT_NAME VARCHAR ( 20 ),
	TOTAL_PRICE VARCHAR ( 20 ),
	COMPANY_ID FLOAT,
	STATUS VARCHAR ( 20 ),
	RESULT VARCHAR ( 20 ),
	REASON VARCHAR ( 20 ),
	DESCRIPTION VARCHAR ( 20 ),
	PLAYER VARCHAR ( 20 ),
	PARTNER VARCHAR ( 20 ),
	CHANGE VARCHAR ( 20 ),
	CREATOR_NO FLOAT,
	CONSTRAINT SYS_C005588 PRIMARY KEY (PROJECT_ID)
	) 
;
CREATE TABLE T_BUDGET (
	COMPONENT_ID NUMERIC ( 11 ) NOT NULL,
	COMPONENT_NAME VARCHAR ( 60 ),
	COMPONENT_STATUS NUMERIC ( 1 ) DEFAULT (1),
	COMPONENT_DESCRIPTION VARCHAR ( 500 ),
	CONSTRAINT BUDGET_COMPONENT_ID UNIQUE (COMPONENT_ID)
	) 
;
CREATE TABLE T_DEPT_MSG (
	DEPT_MSG_ID FLOAT NOT NULL,
	MSG_TITLE VARCHAR ( 20 ),
	MSG_BODY FLOAT,
	DEPT_ID FLOAT,
	CREATE_DATE DATETIME,
	CREATOR_ID VARCHAR ( 20 ),
	CONSTRAINT SYS_C005540 PRIMARY KEY (DEPT_MSG_ID)
	) 
;
CREATE TABLE T_PERSON_SENT_MSG (
	MSG_ID VARCHAR ( 20 ) NOT NULL,
	EMP_ID VARCHAR ( 20 ),
	IS_SENT FLOAT,
	MSG_TITLE VARCHAR ( 20 ),
	MSG_BODY VARCHAR ( 500 ),
	CONSTRAINT SYS_C005590 PRIMARY KEY (MSG_ID)
	) 
;
CREATE TABLE T_FILE (
	FILE_ID NUMERIC ( 10 ) NOT NULL,
	FILE_NAME VARCHAR ( 600 ),
	TITLE VARCHAR ( 300 ),
	DESCRIPTION VARCHAR ( 300 ),
	SENDER_ID NUMERIC ( 10 ),
	SEND_DATE DATETIME,
	CONSTRAINT SYS_C006351 PRIMARY KEY (FILE_ID)
	) 
;
CREATE TABLE T_DIRECTORIES (
	DIRECTORY_ID NUMERIC ( 11 ) NOT NULL,
	DIRECTORY_NAME VARCHAR ( 255 ) NOT NULL,
	SUPER_DIRECTORY_ID NUMERIC ( 11 ),
	OWNER_ID NUMERIC ( 11 ),
	IS_LEAF NUMERIC ( 1 ) DEFAULT 0,
	CREATE_DATE DATETIME,
	WRITE_CONTROL NUMERIC ( 1 ) DEFAULT 0,
	READ_CONTROL NUMERIC ( 1 ) DEFAULT 0,
	TYPE NUMERIC ( 1 ) DEFAULT 0,
	CONSTRAINT UK_T_DIRECTORIES6 UNIQUE (DIRECTORY_NAME, SUPER_DIRECTORY_ID),
	CONSTRAINT PK_T_DIRECTORIES12 PRIMARY KEY (DIRECTORY_ID)
	) 
;
CREATE TABLE JIVETHREAD (
	THREADID FLOAT NOT NULL,
	FORUMID FLOAT NOT NULL,
	ROOTMESSAGEID FLOAT NOT NULL,
	CREATIONDATE VARCHAR ( 15 ) NOT NULL,
	MODIFIEDDATE VARCHAR ( 15 ) NOT NULL,
	APPROVED FLOAT NOT NULL,
	CONSTRAINT SYS_C006114 PRIMARY KEY (THREADID)
	) 
;
CREATE TABLE T_PERSON_MSG (
	PERSON_MSG_ID FLOAT NOT NULL,
	MSG_TITLE VARCHAR ( 20 ),
	MSG_BODY VARCHAR ( 20 ),
	WRITE_DATE CHAR ( 18 ),
	CONSTRAINT SYS_C005594 PRIMARY KEY (PERSON_MSG_ID)
	) 
;
CREATE TABLE T_PECCANCY (
	ID FLOAT NOT NULL,
	EMP_ID FLOAT NOT NULL,
	TIME DATETIME,
	SITE VARCHAR ( 1000 ),
	SEVERITY_LEVEL VARCHAR ( 100 ),
	REASON VARCHAR ( 1000 ),
	PUNISHMENT VARCHAR ( 1000 ),
	NOTE VARCHAR ( 1000 ),
	AUTOMOBILE_ID NUMERIC ( 11 ) NOT NULL,
	CONSTRAINT PK_T_PECCANCY130 PRIMARY KEY (ID)
	) 
;
CREATE TABLE JIVEMESSAGETREE (
	PARENTID FLOAT NOT NULL,
	CHILDID FLOAT NOT NULL,
	CONSTRAINT SYS_C006103 PRIMARY KEY (PARENTID, CHILDID)
	) 
;
CREATE TABLE T_CONTACT_COMPANY (
	COMPANY_ID FLOAT NOT NULL,
	COMPANY_NAME CHAR ( 18 ),
	ADDRESS VARCHAR,
	ZIP_CODE VARCHAR,
	COUNTRY VARCHAR ( 20 ),
	PROVINCE VARCHAR ( 20 ),
	CITY VARCHAR ( 20 ),
	WWW_URL VARCHAR ( 20 ),
	DESCRIPTION VARCHAR ( 20 ),
	BANK_NO VARCHAR ( 20 ),
	TAX_NO CHAR ( 18 ),
	CONSTRAINT SYS_C005577 PRIMARY KEY (COMPANY_ID)
	) 
;
CREATE TABLE T_SALARY_ITEMS_LOG (
	SALARY_DATE VARCHAR ( 20 ) NOT NULL,
	ITEM_ID FLOAT NOT NULL,
	EMP_ID VARCHAR ( 20 ) NOT NULL,
	VALUE FLOAT,
	IS_PRINT FLOAT,
	CONSTRAINT SYS_C005523 PRIMARY KEY (SALARY_DATE, ITEM_ID, EMP_ID)
	) 
;
CREATE TABLE T_EMP_CHECK (
	EMP_ID VARCHAR ( 20 ) NOT NULL,
	CHECK_DATE DATETIME NOT NULL,
	PERFORMANCE_VALUE FLOAT,
	CONSTRAINT SYS_C005531 PRIMARY KEY (EMP_ID, CHECK_DATE)
	) 
;
CREATE TABLE T_WORKFLOW_SECURITY_TYPE (
	ID NUMERIC ( 5 ) NOT NULL,
	NAME VARCHAR ( 64 ) NOT NULL,
	CONSTRAINT PK_SECURITY_TYPE20 PRIMARY KEY (ID)
	) 
;
CREATE TABLE T_EQUIPMENT_REPAIR_RECORD (
	EQUIPMENT_ID NUMERIC ( 11 ) NOT NULL,
	ID NUMERIC ( 11 ) NOT NULL,
	TIME DATETIME NOT NULL,
	USE_DEPT_ID NUMERIC ( 11 ) NOT NULL,
	USE_PERSON_ID NUMERIC ( 11 ),
	REPAIRER VARCHAR ( 200 ),
	REPAIR_REASON VARCHAR ( 200 ),
	EXPENSE NUMERIC ( 10, 2 ),
	RESULT VARCHAR ( 200 ),
	CONSTRAINT PK_T_EQUIPMENT_REPAIR_RECOR3 PRIMARY KEY (EQUIPMENT_ID, ID)
	) 
;
CREATE TABLE T_SALARY_LOG (
	SALARY_DATE VARCHAR ( 20 ) NOT NULL,
	EMP_ID VARCHAR ( 20 ) NOT NULL,
	SALARY FLOAT,
	ISSUE_DATE DATETIME,
	CONSTRAINT SYS_C005509 PRIMARY KEY (SALARY_DATE, EMP_ID)
	) 
;
CREATE TABLE T_MSG_RECEIVERS (
	MSG_ID VARCHAR ( 20 ) NOT NULL,
	EMP_ID VARCHAR ( 20 ),
	CONSTRAINT SYS_C005592 PRIMARY KEY (MSG_ID)
	) 
;
CREATE TABLE T_EQUIPMENT_PERSON_CONF (
	EMP_NO FLOAT NOT NULL,
	APPOINT_TIME_ZONE FLOAT,
	EQUIPMENT_GROUP_ROW_NUM FLOAT,
	DISPLAY_POSITION FLOAT,
	CONSTRAINT SYS_C005575 PRIMARY KEY (EMP_NO)
	) 
;
CREATE TABLE T_DRIVER (
	EMP_ID FLOAT NOT NULL,
	LICENCE_NO VARCHAR ( 100 ) NOT NULL,
	TYPE_PERMITED VARCHAR ( 100 ),
	ADDRESS_ISSUED VARCHAR ( 1000 ),
	TIME_ISSUED DATETIME,
	NEXT_TIME DATETIME,
	NOTE VARCHAR ( 1000 ),
	CONSTRAINT PK_T_DRIVER129 PRIMARY KEY (EMP_ID)
	) 
;
CREATE TABLE T_EXECUTOR_STATUS_SPEC (
	STATUS_ID NUMERIC ( 10 ) NOT NULL,
	STATUS_NAME VARCHAR ( 64 ) NOT NULL,
	CONSTRAINT TC_T_EXECUTOR_STATUS_SPEC169 UNIQUE (STATUS_ID),
	CONSTRAINT PK_T_EXECUTOR_STATUS_SPEC21 PRIMARY KEY (STATUS_ID)
	) 
;
CREATE TABLE T_BULLETIN (
	BULLETIN_ID NUMERIC ( 11 ) NOT NULL,
	BULLETIN_TITLE VARCHAR ( 200 ) NOT NULL,
	BULLETIN_BODY VARCHAR ( 3000 ),
	DEPT_ID NUMERIC ( 11 ) NOT NULL,
	CREATE_DATE DATETIME NOT NULL,
	CREATOR_ID NUMERIC ( 11 ) NOT NULL,
	END_DATE DATETIME,
	IS_SCROLL_TEXT  NUMERIC (11) NULL ,
	IS_SET_TO_SCROLL  NUMERIC (18, 0) NULL, 
	CONSTRAINT PK_T_BULLETIN0 PRIMARY KEY (BULLETIN_ID)
	) 
;
CREATE TABLE T_WORKFLOW_TYPE_SPEC (
	TYPE_ID NUMERIC ( 10 ) NOT NULL,
	TYPE_NAME VARCHAR ( 100 ) NOT NULL,
	CONSTRAINT PK_T_WORKFLOW_TYPE_SPEC24 PRIMARY KEY (TYPE_ID)
	) 
;
CREATE TABLE JIVEMESSAGEPROP (
	MESSAGEID FLOAT NOT NULL,
	NAME VARCHAR ( 50 ) NOT NULL,
	PROPVALUE VARCHAR ( 255 ) NOT NULL,
	CONSTRAINT SYS_C006107 PRIMARY KEY (MESSAGEID, NAME)
	) 
;
CREATE TABLE T_BUDGET_LIST (
	MONTH VARCHAR ( 8 ) NOT NULL,
	DIVISION_ID NUMERIC ( 11 ) NOT NULL,
	COMPONENT_ID NUMERIC ( 11 ) NOT NULL,
	BUDGET NUMERIC ( 15, 2 ),
	ACTUAL NUMERIC ( 15, 2 ),
	BALANCE NUMERIC ( 15, 2 ),
	DESCRIPTION VARCHAR ( 500 ),
	STATUS NUMERIC ( 1 ) DEFAULT 0
	) 
;
CREATE TABLE T_EQUIPMENT_USE_RECORD (
	EQUIPMENT_ID NUMERIC ( 11 ) NOT NULL,
	ID NUMERIC ( 11 ) NOT NULL,
	START_TIME DATETIME NOT NULL,
	END_TIME DATETIME,
	USE_DEPT_ID NUMERIC ( 11 ) NOT NULL,
	USE_PERSON_ID NUMERIC ( 11 ),
	CONSTRAINT PK_T_EQUIPMENT_USE_RECORD2 PRIMARY KEY (EQUIPMENT_ID, ID)
	) 
;
CREATE TABLE T_BOARDROOM_STATUS (
	STATUS_ID NUMERIC ( 1 ) NOT NULL,
	STATUS_NAME VARCHAR ( 100 ) NOT NULL,
	DESCRIPTION VARCHAR ( 1000 ) NOT NULL,
	CONSTRAINT PK_T_BORDROOM_STATUS131 PRIMARY KEY (STATUS_ID)
	) 
;
CREATE TABLE T_E_MEETING_ROOM (
	E_MEETING_ROOM_ID FLOAT NOT NULL,
	E_MEETING_ROOM_NAME CHAR ( 18 ),
	CREATOR_NO FLOAT,
	ATTRIBUTE VARCHAR ( 20 ),
	CONSTRAINT SYS_C005542 PRIMARY KEY (E_MEETING_ROOM_ID)
	) 
;
CREATE TABLE JIVEUSERPROP (
	USERID FLOAT NOT NULL,
	NAME VARCHAR ( 30 ) NOT NULL,
	PROPVALUE VARCHAR ( 255 ) NOT NULL,
	CONSTRAINT SYS_C006129 PRIMARY KEY (USERID, NAME)
	) 
;
CREATE TABLE JIVEGROUPUSER (
	GROUPID FLOAT NOT NULL,
	USERID FLOAT NOT NULL,
	ADMINISTRATOR FLOAT NOT NULL,
	CONSTRAINT SYS_C006094 PRIMARY KEY (GROUPID, USERID)
	) 
;
CREATE TABLE T_FILES (
	DIRECTORY_ID NUMERIC ( 11 ) NOT NULL,
	LOCATION VARCHAR ( 250 ),
	FILE_BODY BINARY,
	STORAGE_TYPE NUMERIC ( 1 ) DEFAULT 0,
	CONSTRAINT TC_35 PRIMARY KEY (DIRECTORY_ID)
	) 
;
CREATE TABLE T_AUTOMOBILE_BOOKING_STATUS (
	STATUS_ID NUMERIC ( 5 ) NOT NULL,
	STATUS_NAME VARCHAR ( 256 ) NOT NULL,
	CONSTRAINT PK_T_AUTOMOBILE_BOOKING_STA127 PRIMARY KEY (STATUS_ID)
	) 
;
CREATE TABLE T_PROJECT (
	WORKFLOW_ID NUMERIC ( 10 ) NOT NULL,
	PLAN_BEGIN_DATE DATETIME,
	PLAN_END_DATE DATETIME,
	CONSTRAINT PK_T_PROJECT25 PRIMARY KEY (WORKFLOW_ID),
	CONSTRAINT TC_PROJECT40 UNIQUE (WORKFLOW_ID)
	) 
;
CREATE TABLE T_SALARY_TEMPLATE (
	EMP_ID VARCHAR ( 20 ) NOT NULL,
	TOTAL_SALARY FLOAT,
	CONSTRAINT SYS_C005506 PRIMARY KEY (EMP_ID)
	) 
;
CREATE TABLE JIVEFILTER (
	FILTEROBJECT BINARY ,
	FORUMID FLOAT NOT NULL,
	FILTERINDEX FLOAT NOT NULL,
	CONSTRAINT SYS_C006076 PRIMARY KEY (FORUMID, FILTERINDEX)
	) 
;
CREATE TABLE JIVEUSER (
	USERID                 INT NOT NULL,
    NAME                       VARCHAR(80),
    USERNAME                   VARCHAR(80) NOT NULL,
    PASSWORDHASH               VARCHAR(32) NOT NULL,
    EMAIL                      VARCHAR(30) NOT NULL,
    EMAILVISIBLE               INT NOT NULL,
    NAMEVISIBLE                INT NOT NULL,
	CONSTRAINT SYS_C006121 PRIMARY KEY (USERID)
	) 
;
CREATE TABLE T_PASS_READ_PASSING_BOX (
	ARTICAL_ID FLOAT NOT NULL,
	EMP_NO FLOAT,
	CONSTRAINT SYS_C005557 PRIMARY KEY (ARTICAL_ID)
	) 
;
CREATE TABLE T_BORROW_RECORD (
	BORROW_ID NUMERIC ( 11 ) NOT NULL,
	BORROWER_ID NUMERIC ( 11 ) NOT NULL,
	BORROW_DATE DATETIME NOT NULL,
	RETURN_DATE DATETIME NOT NULL,
	ARCHIVE_ID NUMERIC ( 11 ) NOT NULL,
	BORROW_FLAG NUMERIC ( 1 ) DEFAULT 0,
	CONSTRAINT PK_T_BORROW_RECORD25 PRIMARY KEY (BORROW_ID)
	) 
;
CREATE TABLE T_CONTACT_PERSON (
	PERSON_ID FLOAT NOT NULL,
	COMPANY_ID FLOAT,
	PERSON_NAME CHAR ( 18 ),
	TITLE VARCHAR ( 20 ),
	DEPT_NAME VARCHAR ( 20 ),
	CALL_NAME VARCHAR ( 20 ),
	EMAIL VARCHAR ( 20 ),
	TELEPHONE VARCHAR ( 20 ),