e_ttoa_create_table.sql

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

--*****************************
--CREATE TABLE
--*****************************
--
CREATE TABLE T_PERSON_COMING_MSG (
	MSG_ID FLOAT NOT NULL,
	EMP_ID FLOAT NOT NULL,
	SENDER_ID FLOAT,
	SEND_DATE FLOAT,
	IS_READ FLOAT,
	MSG_TITLE VARCHAR ( 20 ),
	MSG_BODY VARCHAR ( 500 ),
	CONSTRAINT SYS_C005538 PRIMARY KEY (MSG_ID, EMP_ID)
	) 
;
CREATE TABLE T_PRIVILEGE (
	PRIVILEGE_ID NUMERIC ( 11 ) NOT NULL,
	PRIVILEGE_NAME VARCHAR ( 50 ) NOT NULL,
	DESCRIPTION VARCHAR ( 100 ),
	GROUP_NAME VARCHAR ( 20 ),
	TYPE VARCHAR ( 40 ),
	SEQUENCE NUMERIC ( 11 ),
	CONSTRAINT SYS_C005170 PRIMARY KEY (PRIVILEGE_ID)
	) 
;
CREATE TABLE T_TRAINING_ATTANDENCE (
	TRAINNING_ID FLOAT NOT NULL,
	EMP_ID VARCHAR ( 20 ) NOT NULL,
	NOTE VARCHAR ( 20 ),
	CONSTRAINT SYS_C005528 PRIMARY KEY (TRAINNING_ID, EMP_ID)
	) 
;
CREATE TABLE T_EQUIPMENT (
	ID NUMERIC ( 11 ) NOT NULL,
	EQUIPMENT_NAME VARCHAR ( 100 ) NOT NULL,
	CATEGORY_ID NUMERIC ( 11 ) NOT NULL,
	BUY_DEPT_ID NUMERIC ( 11 ) NOT NULL,
	BUY_PERSON_ID NUMERIC ( 11 ),
	USE_DEPT_ID NUMERIC ( 11 ),
	USE_PERSON_ID NUMERIC ( 11 ),
	PURPOSE VARCHAR ( 200 ),
	MODEL VARCHAR ( 200 ),
	EQUIPMENT_CODE VARCHAR ( 100 ),
	CONFIGURE VARCHAR ( 500 ),
	PRICE NUMERIC ( 10, 4 ),
	BUY_DATE DATETIME,
	SUPPLIER VARCHAR ( 200 ),
	PLACE VARCHAR ( 200 ),
	TERM NUMERIC ( 5 ),
	REMARK VARCHAR ( 500 ),
	QUANTITY NUMERIC ( 8 ) NOT NULL,
	REPAIRED NUMERIC ( 1 ) DEFAULT 0  NOT NULL,
	A DATETIME,
	BATCH_ID NUMERIC ( 11 ),
	CONSTRAINT PK_T_EQUIPMENT PRIMARY KEY (ID)
	) 
;
CREATE TABLE T_EMP_X_DUTY (
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	DUTY_ID NUMERIC ( 11 ) NOT NULL,
	ASSIGNMENT_DATE DATETIME,
	ASSIGNER_ID NUMERIC ( 11 ),
	IS_MAIN_DUTY NUMERIC ( 1 ),
	CONSTRAINT SYS_C005197 PRIMARY KEY (EMP_ID, DUTY_ID)
	) 
;
CREATE TABLE T_ADDRESSLIST_EMPLOYE (
	EMPLOYE_ID NUMERIC ( 11 ) NOT NULL,
	COMPANY_ID NUMERIC ( 11 ) NOT NULL,
	EMPLOYE_NAME VARCHAR ( 200 ),
	EMPLOYE_DEPARTMENT VARCHAR ( 200 ),
	EMPLOYE_DUTY VARCHAR ( 200 ),
	EMPLOYE_EXTENSION NUMERIC ( 10 ),
	EMPLOYE_PAGER VARCHAR ( 100 ),
	EMPLOYE_HANDSET VARCHAR ( 100 ),
	EMPLOYE_OFFICE VARCHAR ( 200 ),
	EMPLOYE_EMAIL VARCHAR ( 100 ),
	CONSTRAINT SYS_C005787 PRIMARY KEY (EMPLOYE_ID, COMPANY_ID)
	) 
;
CREATE TABLE T_SALARY_ITEMS (
	EMP_ID VARCHAR ( 20 ) NOT NULL,
	ITEM_ID FLOAT NOT NULL,
	VALUE FLOAT,
	IS_PRINT FLOAT,
	CONSTRAINT SYS_C005519 PRIMARY KEY (EMP_ID, ITEM_ID)
	) 
;
CREATE TABLE T_EMP_X_DUTY_REMOVE_LOG (
	REMOVAL_DATE DATETIME NOT NULL,
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	DUTY_ID NUMERIC ( 11 ) NOT NULL,
	REMOVER_NO NUMERIC ( 11 ),
	ASSIGNMENT_DATE DATETIME,
	ASSIGNER_NO NUMERIC ( 11 ),
	CONSTRAINT SYS_C005535 PRIMARY KEY (REMOVAL_DATE, EMP_ID, DUTY_ID)
	) 
;
CREATE TABLE T_CATEGORY (
	CATEGORY_ID  NUMERIC(11) NOT NULL,
	PARENT_ID NUMERIC(11) DEFAULT -1,
	ISLEAF FLOAT NOT NULL,
	CATEGORY_NAME VARCHAR ( 40 ) NOT NULL,
	CREATOR_ID FLOAT,
	CREATE_DATE DATETIME,
	CONSTRAINT SYS_C005882 PRIMARY KEY (CATEGORY_ID)
	) 
;
CREATE TABLE T_PASS_READ_SENT_BOX (
	ARTICAL_ID FLOAT NOT NULL,
	EMP_NO FLOAT,
	IS_SENT FLOAT,
	SEND_DATE DATETIME,
	CONSTRAINT SYS_C005555 PRIMARY KEY (ARTICAL_ID)
	) 
;
CREATE TABLE T_DOCUMENTATION (
	DOCUMENT_ID FLOAT NOT NULL,
	PERSON_ID FLOAT NOT NULL,
	DOCUMENT_NAME VARCHAR ( 20 ),
	DOCUMENT_LINK VARCHAR ( 20 ),
	DOCUMENT_SUMMARY VARCHAR ( 20 ),
	CREATOR_NO FLOAT,
	CONSTRAINT SYS_C005586 PRIMARY KEY (DOCUMENT_ID)
	) 
;
CREATE TABLE T_SUBTASK_X_FILE (
	FILE_ID NUMERIC ( 10 ),
	ID NUMERIC ( 10 ),
	CONSTRAINT PK_T_EXECUTOR_TEMPLATE_X_FI16 PRIMARY KEY (FILE_ID, ID)
	) 
;
CREATE TABLE T_EQUIPMENT_ALLOWED_EMP (
	EQUIPMENT_ID VARCHAR ( 20 ) NOT NULL,
	EMP_NO FLOAT,
	PRIVILEGE VARCHAR ( 20 ),
	CONSTRAINT SYS_C005568 PRIMARY KEY (EQUIPMENT_ID)
	) 
;
CREATE TABLE T_EQUIPMENT_APPOINTMENT (
	EQUIPMENT_ID VARCHAR ( 20 ) NOT NULL,
	APPOINT_DATE VARCHAR ( 20 ) NOT NULL,
	START_DATE DATETIME,
	END_DATE DATETIME,
	APPOINT_EMP_NO FLOAT,
	CONSTRAINT SYS_C005573 PRIMARY KEY (EQUIPMENT_ID, APPOINT_DATE)
	) 
;
CREATE TABLE T_DOC_RECEIVED_TYPE (
	ID NUMERIC ( 2 ) NOT NULL,
	NAME VARCHAR ( 64 ) NOT NULL,
	CONSTRAINT PK_T_DOC_RECEIVED_TYPE19 PRIMARY KEY (ID)
	) 
;
CREATE TABLE T_ADDRESSLIST (
	COMPANY_ID NUMERIC ( 11 ) NOT NULL,
	COMPANY_NAME VARCHAR ( 200 ),
	COMPANY_ADDRESS VARCHAR ( 200 ),
	COMPANY_ZIP NUMERIC ( 10 ),
	COMPANY_TELEPHONE VARCHAR ( 100 ),
	COMPANY_FAX VARCHAR ( 100 ),
	CONSTRAINT SYS_C005288 PRIMARY KEY (COMPANY_ID)
	) 
;
CREATE TABLE T_PUBLICATION (
	PUBLICATION_ID NUMERIC ( 11 ) NOT NULL,
	PUBLICATION_NAME VARCHAR ( 200 ),
	PUBLICATION_DEPARTMENT VARCHAR ( 200 ),
	ATTACHMENT_URL VARCHAR ( 100 ),
	PUBLISH_DATE DATETIME,
	CONSTRAINT SYS_C005298 PRIMARY KEY (PUBLICATION_ID)
	) 
;
CREATE TABLE T_EMPLOYEE_GROUP (
	GROUP_ID NUMERIC ( 11 ) NOT NULL,
	GROUP_NAME VARCHAR ( 200 ),
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	CONSTRAINT PK_T_EMPLOYEE_GROUP1 PRIMARY KEY (GROUP_ID)
	) 
;
CREATE TABLE T_ARCHIVE_TYPE_SPEC (
	ARCHIVE_TYPE_ID NUMERIC ( 11 ) NOT NULL,
	ARCHIVE_TYPE_SPEC VARCHAR ( 1000 ) NOT NULL,
	CONSTRAINT PK_T_ARCHIVE_TYPE_SPEC24 PRIMARY KEY (ARCHIVE_TYPE_ID)
	) 
;
CREATE TABLE T_DIRECTORY (
	DIRECTORY_ID NUMERIC ( 11 ) NOT NULL,
	DIRECTORY_NAME VARCHAR ( 200 ),
	DIRECTORY_DEPARTMENT VARCHAR ( 200 ),
	ATTACHMENT_URL VARCHAR ( 100 ),
	PUBLISH_DATE DATETIME,
	CONSTRAINT SYS_C005296 PRIMARY KEY (DIRECTORY_ID)
	) 
;
CREATE TABLE T_CONTACT_TASK (
	TASK_ID FLOAT NOT NULL,
	PERSON_ID FLOAT,
	TASK_NAME VARCHAR ( 20 ),
	TASK_DESCRIPTION VARCHAR ( 20 ),
	TASK_STATUS VARCHAR ( 20 ),
	CREATOR_NO VARCHAR ( 20 ),
	CONSTRAINT SYS_C005581 PRIMARY KEY (TASK_ID)
	) 
;
CREATE TABLE T_AUTOMOBILE (
	AUTOMOBILE_ID NUMERIC ( 11 ) NOT NULL,
	CAR_CERT_NO VARCHAR ( 256 ) NOT NULL,
	PRICE NUMERIC ( 11, 2 ) NOT NULL,
	PURCHASE_DATE DATETIME NOT NULL,
	ENGINE_NO VARCHAR ( 256 ) NOT NULL,
	FRAME_NO VARCHAR ( 256 ) NOT NULL,
	PRODUCER VARCHAR ( 256 ) NOT NULL,
	BRAND VARCHAR ( 256 ) NOT NULL,
	CAR_TYPE VARCHAR ( 256 ) NOT NULL,
	CAR_DOOR_NUM NUMERIC ( 5 ),
	PASSENGER_NUM NUMERIC ( 5 ) NOT NULL,
	CAB_CAPACITY NUMERIC ( 5 ) NOT NULL,
	CHECK_DATE DATETIME NOT NULL,
	COLOR VARCHAR ( 512 ) NOT NULL,
	DEPARTMENT NUMERIC ( 11 ),
	DECORATION VARCHAR ( 512 ),
	PURPOSE VARCHAR ( 512 ),
	ISBOOKING NUMERIC ( 5 ) NOT NULL,
	LENGTH NUMERIC ( 11, 2 ),
	WIDTH NUMERIC ( 11, 2 ),
	HEIGHT NUMERIC ( 11, 2 ),
	WHEELBASE NUMERIC ( 11, 2 ),
	TREAD NUMERIC ( 11, 2 ),
	MIN_FLOOR NUMERIC ( 11, 2 ),
	TANK_CUBAGE NUMERIC ( 11, 2 ),
	WEIGHT NUMERIC ( 11, 2 ),
	TOTAL_WEIGHT NUMERIC ( 11, 2 ),
	MIN_RADIUS NUMERIC ( 11, 2 ),
	JOURNEY VARCHAR ( 512 ),
	EXHAUST FLOAT,
	ACCELERATE FLOAT,
	POWER VARCHAR ( 50 ),
	TURN VARCHAR ( 512 ),
	ENGINE_TYPE VARCHAR ( 512 ),
	TYPE_ID NUMERIC ( 5 ) NOT NULL,
	CONSTRAINT PK_T_AUTOMOBILE127 PRIMARY KEY (AUTOMOBILE_ID)
	) 
;
CREATE TABLE T_PASS_READ_INBOX (
	ARTICAL_ID FLOAT NOT NULL,
	EMP_NO FLOAT,
	IS_READ FLOAT,
	RECE_DATE DATETIME,
	CONSTRAINT SYS_C005553 PRIMARY KEY (ARTICAL_ID)
	) 
;
CREATE TABLE T_RECEIVED_MESSAGE (
	MSG_ID NUMERIC ( 11 ) NOT NULL,
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	SENDER_ID NUMERIC ( 11 ) NOT NULL,
	SEND_DATE DATETIME NOT NULL,
	IS_READ NUMERIC ( 1 ) DEFAULT 0  NOT NULL,
	MSG_TITLE VARCHAR ( 200 ) NOT NULL,
	MSG_BODY VARCHAR ( 3000 ),
	CONSTRAINT PK_T_RECEIVER_MESSAGE6 PRIMARY KEY (MSG_ID, EMP_ID)
	) 
;
CREATE TABLE T_WORKFLOW_TEMPLATE_TYPE_SPEC (
	TYPE_ID NUMERIC ( 10 ) NOT NULL,
	NAME VARCHAR ( 20 ) NOT NULL,
	DESCRIPTION VARCHAR ( 100 ),
	CONSTRAINT PK_T_WORKFLOW_TYPE25 PRIMARY KEY (TYPE_ID)
	) 
;
CREATE TABLE JIVEUSERPERM (
	FORUMID FLOAT NOT NULL,
	USERID FLOAT NOT NULL,
	PERMISSION FLOAT NOT NULL,
	CONSTRAINT SYS_C006125 PRIMARY KEY (FORUMID, USERID, PERMISSION)
	) 
;
CREATE TABLE T_PASS_READ_LOG (
	ARTICAL_ID FLOAT NOT NULL,
	READ_DATE DATETIME NOT NULL,
	EMP_NO FLOAT,
	OPERATION VARCHAR ( 20 ),
	CONSTRAINT SYS_C005564 PRIMARY KEY (ARTICAL_ID, READ_DATE)
	) 
;
CREATE TABLE T_DRIVER_X_AUTOMOBILE (
	EMP_ID FLOAT NOT NULL,
	AUTOMOBILE_ID NUMERIC ( 11 ) NOT NULL,
	CONSTRAINT PK_T_DRIVER_X_AUTOMOBILE2 PRIMARY KEY (EMP_ID, AUTOMOBILE_ID)
	) 
;
CREATE TABLE T_SUBTASK_STATUS_SPEC (
	STATUS_ID NUMERIC ( 2 ) NOT NULL,
	STATUS_NAME VARCHAR ( 64 ) NOT NULL,
	CONSTRAINT PK_T_SUBTASK_STATUS_SPEC22 PRIMARY KEY (STATUS_ID),
	CONSTRAINT TC_T_SUBTASK_STATUS_SPEC170 UNIQUE (STATUS_ID)
	) 
;
CREATE TABLE T_AUTOMOBILE_BOOKING (
	AUTOMOBILE_ID NUMERIC ( 11 ) NOT NULL,
	BEGIN_TIME DATETIME NOT NULL,
	END_TIME DATETIME NOT NULL,
	HASDRIVER NUMERIC ( 5 ) NOT NULL,
	REASON VARCHAR ( 2000 ) NOT NULL,
	ROUTE VARCHAR ( 1500) NOT NULL,
	NOTE VARCHAR ( 2000 ),
	USER_ID NUMERIC ( 11 ),
	ID NUMERIC ( 11 ) NOT NULL,
	STATUS_ID NUMERIC ( 5 ) NOT NULL,
	DISAPPROVE VARCHAR ( 2000 ),
	CONSTRAINT PK_T_AUTOMOBILE_BOOKING128 PRIMARY KEY (ID)
	) 
;
CREATE TABLE T_PASS_READ_RECYLE_BOX (
	ARTICAL_ID FLOAT NOT NULL,
	EMP_NO FLOAT,
	REMOVE_DATE DATETIME,
	CONSTRAINT SYS_C005561 PRIMARY KEY (ARTICAL_ID)
	) 
;
CREATE TABLE HR_FORMAL (
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	OWN_ADVICE VARCHAR ( 800 ),
	MANAGER_ADVICE VARCHAR ( 800 ),
	CEO_ADVICE VARCHAR ( 800 ),
	HR_ADVICE VARCHAR ( 800 ),
	CREATEDATE DATETIME,
	CONSTRAINT SYS_C005827 PRIMARY KEY (EMP_ID)
	) 
;

CREATE TABLE T_ARCHIVE_ATTACHMENT (
	FILE_ID NUMERIC ( 11 ) NOT NULL,
	FILE_NAME VARCHAR ( 255 ),
	FILE_TITLE VARCHAR ( 1000 ) NOT NULL,
	FILE_SUMMARY VARCHAR ( 500 ),
	SEND_DATE DATETIME NOT NULL,
	OTHERS VARCHAR ( 1000 ),
	ARCHIVE_ID NUMERIC ( 11 ) NOT NULL,
	CONSTRAINT PK_T_ARCHIVE_ATTACHMENT27 PRIMARY KEY (FILE_ID)
	) 
;
CREATE TABLE T_EMP (
    EMP_ID                     NUMERIC(11) NOT NULL,
    TITLE                      VARCHAR(120),
    NAME                       VARCHAR(80),
    USERNAME                   VARCHAR(80),
    DIVISION_ID                NUMERIC(11),
    OFFICE_TELEPHONE           VARCHAR(80),
    HOME_FAX                   VARCHAR(80),
    MOBILE_PHONE               VARCHAR(80),
    EMAIL                      VARCHAR(80),
    MANAGER_ID                 NUMERIC(11),
    ASSISTANT_ID               NUMERIC(11),
    NOTE                       VARCHAR(400),
    PASSWORD                   VARCHAR(32) DEFAULT '1111',
    SEX                        INT DEFAULT '1',
    DISMISSION                 INT DEFAULT 0,
    HOME_PHONE                 VARCHAR(80),
    CONSTRAINT SYS_C005811 PRIMARY KEY (EMP_ID),
    CONSTRAINT T_EMP_UNIQUE_USERNAME UNIQUE (USERNAME)
) 
;
CREATE TABLE T_SENT_MESSAGE (
	MSG_ID NUMERIC ( 11 ) NOT NULL,
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	IS_SENT NUMERIC ( 1 ) DEFAULT 0 ,
	MSG_TITLE VARCHAR ( 300 ) NOT NULL,
	MSG_BODY VARCHAR ( 3000 ),
	SENT_DATE DATETIME NOT NULL,
	CONSTRAINT PK_T_SEND_MESSAGE2 PRIMARY KEY (MSG_ID)
	) 
;
CREATE TABLE JIVEFORUMPROP (
	FORUMID FLOAT NOT NULL,
	NAME VARCHAR ( 30 ) NOT NULL,
	PROPVALUE VARCHAR ( 255 ) NOT NULL,
	CONSTRAINT SYS_C006083 PRIMARY KEY (FORUMID, NAME)
	) 
;
CREATE TABLE T_CONTACT_X_GROUP (
	CONTACT_ID NUMERIC ( 11 ) NOT NULL,
	GROUP_ID NUMERIC ( 11 ) NOT NULL,
	CONSTRAINT PK_T_X_CONTACT_GROUP125 PRIMARY KEY (CONTACT_ID, GROUP_ID)
	) 
;
CREATE TABLE T_DUTY_X_PRIVILEGE (
	DUTY_ID NUMERIC ( 11 ) NOT NULL,
	PRIVILEGE_ID NUMERIC ( 11 ) NOT NULL,
	ASSIGNMENT_DATE DATETIME,
	ASSIGNER_NO NUMERIC ( 11 ),
	CONSTRAINT SYS_C005187 PRIMARY KEY (DUTY_ID, PRIVILEGE_ID)
	) 
;
CREATE TABLE T_ADDRESSLIST_GROUP (
	GROUP_ID NUMERIC ( 11 ) NOT NULL,
	GROUP_NAME VARCHAR ( 200 ),
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	CONSTRAINT PK_T_ADDRESSLIST_GROUP123 PRIMARY KEY (GROUP_ID)
	) 
;
CREATE TABLE HR_SALARY_COMPONENT (
	COMPONENT_ID NUMERIC ( 5 ) NOT NULL,
	COMPONENT_NAME VARCHAR ( 80 ),
	COMPONENT_TYPE FLOAT,
	COMPONENT_STATE FLOAT,
	COMPONENT_CALCTYPE FLOAT,
	COMPONENT_CALCNUM FLOAT ,
	COMPONENT_DESCRIPTION VARCHAR ( 60 ),
	CONSTRAINT SYS_C005888 PRIMARY KEY (COMPONENT_ID)
	) 
;
CREATE TABLE T_PASS_READ_OVER_BOX (
	ARTICAL_ID FLOAT NOT NULL,
	EMP_NO FLOAT,
	CONSTRAINT SYS_C005559 PRIMARY KEY (ARTICAL_ID)
	) 
;
CREATE TABLE T_TASK_ATTACHMENT (
	ATTACHMENT_ID NUMERIC ( 11 ) NOT NULL,
	TASK_ID NUMERIC ( 11 ) NOT NULL,
	URL VARCHAR ( 100 ),
	CONSTRAINT SYS_C005285 PRIMARY KEY (ATTACHMENT_ID, TASK_ID)