e_ttoa_create_table.sql

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

	FAX VARCHAR ( 20 ),
	PAGER VARCHAR ( 20 ),
	MOBILE_PHONE CHAR ( 18 ),
	HOME_TELEPHONE VARCHAR ( 20 ),
	CONTACT_TYPE VARCHAR ( 20 ),
	INTRESTING_DEGREE VARCHAR ( 20 ),
	COME_FROM VARCHAR ( 20 ),
	CONSTRAINT SYS_C005579 PRIMARY KEY (PERSON_ID)
	) 
;
CREATE TABLE T_RETURN_RECORD (
	RETURN_ID NUMERIC ( 11 ) NOT NULL,
	BORROW_ID NUMERIC ( 11 ) NOT NULL,
	BORROWER_ID NUMERIC ( 11 ) NOT NULL,
	RETURN_DATE DATETIME NOT NULL,
	DESCRIPTION VARCHAR ( 1000 ),
	RECEIVER_ID NUMERIC ( 11 ) NOT NULL,
	ARCHIVE_ID NUMERIC ( 11 ) NOT NULL,
	CONSTRAINT PK_T_RETURN_RECORD26 PRIMARY KEY (RETURN_ID)
	) 
;
CREATE TABLE JIVEMESSAGE (
	MESSAGEID FLOAT NOT NULL,
	THREADID FLOAT DEFAULT -1,
	SUBJECT VARCHAR ( 255 ),
	USERID FLOAT NOT NULL,
	BODY TEXT,
	MODIFIEDDATE VARCHAR ( 15 ) NOT NULL,
	CREATIONDATE VARCHAR ( 15 ) NOT NULL,
	APPROVED FLOAT NOT NULL,
	CONSTRAINT SYS_C006100 PRIMARY KEY (MESSAGEID)
	) 
;
CREATE TABLE T_PASS_READ_ARTICAL (
	ARTICAL_ID FLOAT NOT NULL,
	ARTICAL_NAME VARCHAR ( 20 ),
	ARTICAL_SUMMARY VARCHAR ( 20 ),
	ARTICAL_BODY VARCHAR,
	STATUS_ID FLOAT,
	CONSTRAINT SYS_C005551 PRIMARY KEY (ARTICAL_ID)
	) 
;
CREATE TABLE HR_TRAIN (
	TRAIN_ID NUMERIC ( 5 ) NOT NULL,
	TRAIN_NAME VARCHAR ( 200 ),
	DD_TRAIN_ID NUMERIC ( 5 ),
	TRAIN_SUBJECT VARCHAR ( 200 ),
	TRAIN_TYPE VARCHAR ( 40 ),
	TRAIN_STARTDATE DATETIME,
	TRAIN_ENDDATE DATETIME,
	TRAIN_TEACHER VARCHAR ( 200 ),
	TRAIN_ADDRESS VARCHAR ( 200 ),
	TRAIN_NOTE VARCHAR ( 200 ),
	TRAIN_DIVISION VARCHAR ( 200 ),
	CONSTRAINT SYS_C005481 PRIMARY KEY (TRAIN_ID)
	) 
;
CREATE TABLE T_DRIVING_FEE (
	ID FLOAT NOT NULL,
	EMP_ID FLOAT NOT NULL,
	AUTOMOBILE_ID NUMERIC ( 11 ) NOT NULL,
	YEAR FLOAT NOT NULL,
	MONTH FLOAT NOT NULL,
	BASE_ODOMETER FLOAT ( 4 ),
	ODOMETER FLOAT ( 4 ),
	OIL FLOAT ( 4 ),
	OIL_FEE FLOAT ( 4 ),
	DRIVING_FEE FLOAT ( 4 ),
	MAINTAIN_FEE FLOAT ( 4 ),
	NOTE VARCHAR ( 1000 ),
	CONSTRAINT PK_T_DRIVING_FEE133 PRIMARY KEY (ID)
	) 
;
CREATE TABLE T_BOARDROOM (
	BOARDROOM_ID               NUMERIC(10) NOT NULL,
    CODE                       VARCHAR(1000) NOT NULL,
    NAME                       VARCHAR(1000) NOT NULL,
    CREATOR                    NUMERIC(10),
    CREATION_DATE              DATETIME,
    MODIFIER                   NUMERIC(10),
    MODIFY_DATE                DATETIME,
    POSITION                   VARCHAR(1000),
    SEAT_AMOUNT                NUMERIC(10),
    ADMINISTRATOR              NUMERIC(10),
    DEVICES                    VARCHAR(2000),
    DESCRIPTION                VARCHAR(2000),
    STATUS_ID                  NUMERIC(1) NOT NULL,
    BOOKED_COUNT               NUMERIC(5),
	CONSTRAINT PK_T_BOARDROOM124 PRIMARY KEY (BOARDROOM_ID)
	) 
;
CREATE TABLE T_WORKFLOW_DISPATCH (
	WORKFLOW_ID NUMERIC ( 10 ) NOT NULL,
	WORKFLOW_TEMPLATE_ID NUMERIC ( 5 ) NOT NULL,
	SAVE_DEPT_ID NUMERIC ( 5 ) NOT NULL,
	ID NUMERIC ( 5 ),
	SECURITY_ID NUMERIC ( 5 ),
	KEYWORD VARCHAR ( 2000 ),
	INSTANCY_ID NUMERIC ( 5 ),
	CONSTRAINT PK_T_WORKFLOW_DISPATCH24 PRIMARY KEY (WORKFLOW_ID),
	CONSTRAINT TC_DISPATCH41 UNIQUE (WORKFLOW_ID)
	) 
;
CREATE TABLE HR_MEMBER_PRIVATE_INFO (
	EMP_ID                     NUMERIC(11) NOT NULL,
    MEMBER_COUNTRY             VARCHAR(40),
    MEMBER_PROVINCE            VARCHAR(40),
    MEMBER_COUNTY              VARCHAR(40),
    MEMBER_STREET              VARCHAR(120),
    MEMBER_POSTCODE            VARCHAR(12),
    MEMBER_BIRTHDATE           DATETIME,
    DD_PARTY_ID                NUMERIC(5),
    MEMBER_IDCARD              VARCHAR(36),
    MEMBER_NATION              VARCHAR(40),
    MEMBER_HOMEPHONE1          VARCHAR(80),
    MEMBER_HOMEPHONE2          VARCHAR(80),
    MEMBER_ORIGNAL             VARCHAR(40),
    MEMBER_PIC                 VARCHAR(100),
    MEMBER_NOTE                VARCHAR(400),
    CONSTRAINT SYS_C005499 PRIMARY KEY (EMP_ID)
   ) 
;
CREATE TABLE HR_SALARY_LIST (
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	SALARY_DATE DATETIME NOT NULL,
	NAME VARCHAR ( 40 ),
	COMPONENT_ID NUMERIC ( 5 ) NOT NULL,
	COUNT NUMERIC ( 8, 2 ),
	CONSTRAINT SYS_C005957 PRIMARY KEY (EMP_ID, SALARY_DATE, COMPONENT_ID)
	) 
;
CREATE TABLE T_OFF_DUTY_LOG (
	EMP_ID VARCHAR ( 20 ) NOT NULL,
	WORK_DATE DATETIME NOT NULL,
	START_TIME DATETIME,
	END_TIME DATETIME,
	CONSTRAINT SYS_C005512 PRIMARY KEY (EMP_ID, WORK_DATE)
	) 
;
CREATE TABLE T_TOPIC_X_MEETING_ROOM (
	E_MEETING_ROOM_ID FLOAT NOT NULL,
	TOPIC_ID FLOAT NOT NULL,
	CONSTRAINT SYS_C005549 PRIMARY KEY (E_MEETING_ROOM_ID, TOPIC_ID)
	) 
;
CREATE TABLE JIVEFORUM (
	FORUMID FLOAT NOT NULL,
	NAME VARCHAR ( 255 ),
	DESCRIPTION VARCHAR ( 2000 ),
	MODIFIEDDATE VARCHAR ( 15 ),
	CREATIONDATE VARCHAR ( 15 ),
	MODERATED FLOAT NOT NULL,
	CONSTRAINT SYS_C006079 PRIMARY KEY (FORUMID)
	) 
;
CREATE TABLE T_E_MEETING_MESSAGE (
	MESSAGE_ID VARCHAR ( 20 ) NOT NULL,
	TOPIC_ID FLOAT,
	E_MEETING_ROOM_ID FLOAT,
	MESSAGE_SUMMARY VARCHAR ( 20 ),
	MESSAGE_BODY VARCHAR ( 1000 ),
	SENDER_NO FLOAT,
	REPLY_ID FLOAT,
	CONSTRAINT SYS_C005546 PRIMARY KEY (MESSAGE_ID)
	) 
;
CREATE TABLE T_ADDRESSLIST_BOOK (
	CONTACT_ID NUMERIC ( 11 ) NOT NULL,
	EMP_ID NUMERIC ( 11 ) NOT NULL,
	NAME VARCHAR ( 50 ),
	NICK_NAME VARCHAR ( 50 ),
	BIRTHDAY DATETIME,
	GENDER NUMERIC ( 1 ),
	EMAIL_ADDRESS VARCHAR ( 100 ),
	ANOTHER_EMAIL VARCHAR ( 100 ),
	PERSONAL_URL VARCHAR ( 100 ),
	OICQ_NUM VARCHAR ( 50 ),
	PAGER_NUM VARCHAR ( 100 ),
	MOBILE_NUM VARCHAR ( 100 ),
	HOME_ADDRESS VARCHAR ( 500 ),
	HOME_PC VARCHAR ( 24 ),
	HOME_TELE_NUM VARCHAR ( 100 ),
	UNIT VARCHAR ( 100 ),
	POSITION VARCHAR ( 50 ),
	UNIT_ADDRESS VARCHAR ( 500 ),
	UNIT_TELE_NUM VARCHAR ( 100 ),
	UNIT_PC VARCHAR ( 24 ),
	UNIT_FAX_NUM VARCHAR ( 100 ),
	NOTES VARCHAR ( 2000 ),
	CONSTRAINT PK_T_ADDRESSLIST_BOOK124 PRIMARY KEY (CONTACT_ID)
	) 
;
CREATE TABLE T_EQUIPMENT_GROUP (
	GROUP_ID FLOAT NOT NULL,
	GROUP_NAME VARCHAR ( 20 ),
	GROUP_DESCRIPTION VARCHAR ( 20 ),
	CONSTRAINT SYS_C005566 PRIMARY KEY (GROUP_ID)
	) 
;
CREATE TABLE T_MSG_ATTACHMENT (
	FILE_ID NUMERIC(11) NULL ,
	FILE_LOCATION VARCHAR (800)  NULL ,
	COUNTER NUMERIC(11) NULL 
) 
;

CREATE TABLE T_MSG_X_REC_ATTACHMENT (
	FILE_ID NUMERIC(11) NULL ,
	MSG_ID NUMERIC(11) NULL ,
	EMP_ID NUMERIC(11) NULL 
) 
;

CREATE TABLE T_MSG_X_SEND_ATTACHMENT (
	MSG_ID  NUMERIC(11) NOT NULL ,
	FILE_ID NUMERIC(11) NOT NULL 
) 
;

CREATE TABLE T_DIV_ATT_TIME(
	DIVISION_ID  NUMERIC(11) NOT NULL,
	ON_DUTY_HOUR  NUMERIC(11) ,
	ON_DUTY_MINUTE  NUMERIC(11) ,
	OFF_DUTY_HOUR  NUMERIC(11) ,
	OFF_DUTY_MINUTE  NUMERIC(11) 
)
;

CREATE TABLE T_DIV_ATT_MODE(
	ON_DUTY_MODE VARCHAR(100) ,
	OFF_DUTY_MODE VARCHAR(100)
)
;

ALTER TABLE T_TRAINING_ATTANDENCE ADD  CONSTRAINT SYS_C005614 FOREIGN KEY (TRAINNING_ID) REFERENCES T_TRAINNING_PROJECT (TRAINNING_ID)
;
ALTER TABLE T_EQUIPMENT ADD CONSTRAINT T_EQUIPMENT_FK_C_I FOREIGN KEY (CATEGORY_ID) REFERENCES T_CATEGORY (CATEGORY_ID)
;
ALTER TABLE T_EMP_X_DUTY ADD CONSTRAINT SYS_C005198 FOREIGN KEY (DUTY_ID) REFERENCES T_DUTY (DUTY_ID)
;
ALTER TABLE T_ADDRESSLIST_EMPLOYE ADD CONSTRAINT SYS_C005788 FOREIGN KEY (COMPANY_ID) REFERENCES T_ADDRESSLIST (COMPANY_ID)
;
ALTER TABLE T_SALARY_ITEMS ADD CONSTRAINT SYS_C005611 FOREIGN KEY (EMP_ID) REFERENCES T_SALARY_TEMPLATE (EMP_ID)
;
ALTER TABLE T_SALARY_ITEMS ADD CONSTRAINT SYS_C005610 FOREIGN KEY (ITEM_ID) REFERENCES T_SALARY_ITEMS_SPEC (ITEM_ID)
;
ALTER TABLE T_CATEGORY ADD CONSTRAINT T_CATEGORY_FK FOREIGN KEY (PARENT_ID) REFERENCES T_CATEGORY (CATEGORY_ID)
;
ALTER TABLE T_PASS_READ_SENT_BOX ADD CONSTRAINT SYS_C005621 FOREIGN KEY (ARTICAL_ID) REFERENCES T_PASS_READ_ARTICAL (ARTICAL_ID)
;
ALTER TABLE T_DOCUMENTATION ADD CONSTRAINT SYS_C005629 FOREIGN KEY (PERSON_ID) REFERENCES T_CONTACT_PERSON (PERSON_ID)
;
ALTER TABLE T_SUBTASK_X_FILE ADD CONSTRAINT SYS_C006353 FOREIGN KEY (FILE_ID) REFERENCES T_FILE (FILE_ID)
;
ALTER TABLE T_SUBTASK_X_FILE ADD CONSTRAINT SYS_C06364 FOREIGN KEY (ID) REFERENCES T_SUBTASK (SUB_TASK_ID)
;
ALTER TABLE T_CONTACT_TASK ADD CONSTRAINT SYS_C005627 FOREIGN KEY (PERSON_ID) REFERENCES T_CONTACT_PERSON (PERSON_ID)
;
ALTER TABLE T_AUTOMOBILE ADD CONSTRAINT FK_T_AUTOMOBILE109 FOREIGN KEY (TYPE_ID) REFERENCES T_AUTOMOBILE_TYPE (TYPE_ID)
;
ALTER TABLE T_PASS_READ_INBOX ADD CONSTRAINT SYS_C005620 FOREIGN KEY (ARTICAL_ID) REFERENCES T_PASS_READ_ARTICAL (ARTICAL_ID)
;
ALTER TABLE T_PASS_READ_LOG ADD CONSTRAINT SYS_C005625 FOREIGN KEY (ARTICAL_ID) REFERENCES T_PASS_READ_ARTICAL (ARTICAL_ID)
;
ALTER TABLE T_DRIVER_X_AUTOMOBILE ADD CONSTRAINT FK_T_DRIVER_X_AUTOMOBILE4 FOREIGN KEY (EMP_ID) REFERENCES T_DRIVER (EMP_ID)
;
ALTER TABLE T_DRIVER_X_AUTOMOBILE ADD CONSTRAINT FK_T_DRIVER_X_AUTOMOBILE5 FOREIGN KEY (AUTOMOBILE_ID) REFERENCES T_AUTOMOBILE (AUTOMOBILE_ID)
;
ALTER TABLE T_AUTOMOBILE_BOOKING ADD CONSTRAINT FK_T_AUTOMOBILE_BOOKING103 FOREIGN KEY (AUTOMOBILE_ID) REFERENCES T_AUTOMOBILE (AUTOMOBILE_ID)
;
ALTER TABLE T_AUTOMOBILE_BOOKING ADD CONSTRAINT FK_T_AUTOMOBILE_BOOKING1 FOREIGN KEY (STATUS_ID) REFERENCES T_AUTOMOBILE_BOOKING_STATUS (STATUS_ID)
;
ALTER TABLE T_PASS_READ_RECYLE_BOX ADD CONSTRAINT SYS_C005624 FOREIGN KEY (ARTICAL_ID) REFERENCES T_PASS_READ_ARTICAL (ARTICAL_ID)
;
ALTER TABLE HR_FORMAL ADD CONSTRAINT SYS_C005828 FOREIGN KEY (EMP_ID) REFERENCES T_EMP (EMP_ID)
;
ALTER TABLE T_EMP ADD CONSTRAINT SYS_C005812 FOREIGN KEY (EMP_ID) REFERENCES T_EMP (EMP_ID)
--;
--ALTER TABLE T_EMP ADD CONSTRAINT SYS_C005813 FOREIGN KEY (DIVISION_ID) REFERENCES T_DIVISION (DIVISION_ID)
;
ALTER TABLE T_CONTACT_X_GROUP ADD CONSTRAINT FK_T_X_CONTACT_GROUP102 FOREIGN KEY (CONTACT_ID) REFERENCES T_ADDRESSLIST_BOOK (CONTACT_ID)
;
ALTER TABLE T_CONTACT_X_GROUP ADD CONSTRAINT FK_T_X_CONTACT_GROUP103 FOREIGN KEY (GROUP_ID) REFERENCES T_ADDRESSLIST_GROUP (GROUP_ID)
;
ALTER TABLE T_DUTY_X_PRIVILEGE ADD CONSTRAINT SYS_C005189 FOREIGN KEY (DUTY_ID) REFERENCES T_DUTY (DUTY_ID)
;
ALTER TABLE T_DUTY_X_PRIVILEGE ADD CONSTRAINT SYS_C005188 FOREIGN KEY (PRIVILEGE_ID) REFERENCES T_PRIVILEGE (PRIVILEGE_ID)
;
ALTER TABLE T_PASS_READ_OVER_BOX ADD CONSTRAINT SYS_C005623 FOREIGN KEY (ARTICAL_ID) REFERENCES T_PASS_READ_ARTICAL (ARTICAL_ID)
;
ALTER TABLE T_TASK_ATTACHMENT ADD CONSTRAINT SYS_C005286 FOREIGN KEY (TASK_ID) REFERENCES T_TASK (TASK_ID)
;
ALTER TABLE T_DUTY ADD CONSTRAINT SYS_C005184 FOREIGN KEY (DIVISION_ID) REFERENCES T_DIVISION (DIVISION_ID)
;
ALTER TABLE T_DIVISION ADD CONSTRAINT SYS_C005595 FOREIGN KEY (DIVISION_ID) REFERENCES T_DIVISION (DIVISION_ID)
;
ALTER TABLE T_DIVISION ADD CONSTRAINT SYS_C005164 FOREIGN KEY (P_DIVISION_ID) REFERENCES T_DIVISION (DIVISION_ID)
;
ALTER TABLE HR_CONTRACT ADD CONSTRAINT SYS_C005817 FOREIGN KEY (EMP_ID) REFERENCES T_EMP (EMP_ID)
;
ALTER TABLE HR_CONTRACT ADD CONSTRAINT SYS_C005816 FOREIGN KEY (CONTRACT_CURRENCY) REFERENCES HR_DD (DD_ID)
;
ALTER TABLE T_SUBTASK ADD CONSTRAINT FK_T_SUBTASK30 FOREIGN KEY (TYPE_ID) REFERENCES T_SUBTASK_TYPE_SPEC (TYPE_ID)
;
ALTER TABLE T_SUBTASK ADD CONSTRAINT FK_SUBTASKS0 FOREIGN KEY (WORKFLOW_ID) REFERENCES T_WORKFLOW (WORKFLOW_ID)
;
ALTER TABLE T_SUBTASK ADD CONSTRAINT FK_T_SUBTASK25 FOREIGN KEY (STATUS_ID) REFERENCES T_SUBTASK_STATUS_SPEC (STATUS_ID)
;
ALTER TABLE T_ACCIDENT ADD CONSTRAINT FK_T_ACCIDENT105 FOREIGN KEY (EMP_ID) REFERENCES T_DRIVER (EMP_ID)
;
ALTER TABLE T_ACCIDENT ADD CONSTRAINT FK_T_ACCIDENT3 FOREIGN KEY (AUTOMOBILE_ID) REFERENCES T_AUTOMOBILE (AUTOMOBILE_ID)
;
ALTER TABLE T_SAFETY_DRIVING ADD CONSTRAINT FK_T_SAFTY_DRIVING1 FOREIGN KEY (ID) REFERENCES T_DRIVING_FEE (ID)
;
ALTER TABLE T_SUBTASK_TEMPLATE ADD CONSTRAINT FK_T_SUBTASK_TEMPLATE32 FOREIGN KEY (WORKFLOW_ID) REFERENCES T_WORKFLOW_TEMPLATE (WORKFLOW_ID)
;
ALTER TABLE T_SUBTASK_TEMPLATE ADD CONSTRAINT FK_T_SUBTASK_TEMPLATE36 FOREIGN KEY (TYPE_ID) REFERENCES T_SUBTASK_TYPE_SPEC (TYPE_ID)
;
ALTER TABLE T_CONTACT_PERSON_NOTES ADD CONSTRAINT SYS_C005628 FOREIGN KEY (PERSON_ID) REFERENCES T_CONTACT_PERSON (PERSON_ID)
;
ALTER TABLE T_WORKFLOW_TEMPLATE ADD CONSTRAINT FK_T_WORKFLOW_TEMPLATE33 FOREIGN KEY (TYPE_ID) REFERENCES T_WORKFLOW_TEMPLATE_TYPE_SPEC (TYPE_ID)
;
ALTER TABLE T_EMPLOYEE_X_GROUP ADD CONSTRAINT FK_T_EMPLOYEE_X_GROUP102 FOREIGN KEY (GROUP_ID) REFERENCES T_EMPLOYEE_GROUP (GROUP_ID)
;
ALTER TABLE T_AUTOMOBILE_MAINTAIN ADD CONSTRAINT FK_T_AUTOMOBILE_MAINTAIN102 FOREIGN KEY (AUTOMOBILE_ID) REFERENCES T_AUTOMOBILE (AUTOMOBILE_ID)
;
ALTER TABLE T_CONFERENCE_X_FILES ADD CONSTRAINT FK_T_CONFERENCE_X_FILES117 FOREIGN KEY (ID) REFERENCES T_CONFERENCE (CONFERENCE_ID)
;
ALTER TABLE T_EXECUTOR_TEMPLATE ADD CONSTRAINT FK_T_EXECUTOR_TEMPATE31 FOREIGN KEY (SUBTASK_ID) REFERENCES T_SUBTASK_TEMPLATE (SUBTASK_ID)
;
ALTER TABLE T_DOCRECEIVED_X_FILE ADD CONSTRAINT SYS_C006352 FOREIGN KEY (FILE_ID) REFERENCES T_FILE (FILE_ID)
;
ALTER TABLE T_DOCRECEIVED_X_FILE ADD CONSTRAINT SYS_C006367 FOREIGN KEY (ID) REFERENCES T_DOC_RECEIVED (ID)
;
ALTER TABLE T_WORKFLOW_TEMPLATE_X_FILE ADD CONSTRAINT SYS_C006354 FOREIGN KEY (FILE_ID) REFERENCES T_FILE (FILE_ID)
;
ALTER TABLE T_WORKFLOW ADD CONSTRAINT FK_T_WORKFLOW27 FOREIGN KEY (STATUS_ID) REFERENCES T_WORKFLOW_STATUS_SPEC (STATUS_ID)
;
ALTER TABLE T_WORKFLOW ADD CONSTRAINT FK_T_WORKFLOW35 FOREIGN KEY (TYPE_ID) REFERENCES T_WORKFLOW_TYPE_SPEC (TYPE_ID)
;
ALTER TABLE HR_MEMBER_EDUCATIONAL_INFO ADD CONSTRAINT SYS_C005607 FOREIGN KEY (DD_EDULEVEL_ID) REFERENCES HR_DD (DD_ID)
;
ALTER TABLE T_EXECUTOR ADD CONSTRAINT FK_T_EXECUTOR24 FOREIGN KEY (STATUS_ID) REFERENCES T_EXECUTOR_STATUS_SPEC (STATUS_ID)
;
ALTER TABLE T_EXECUTOR ADD CONSTRAINT FK_EXECUTOR1 FOREIGN KEY (SUB_TASK_ID) REFERENCES T_SUBTASK (SUB_TASK_ID)
;
ALTER TABLE HR_DEV_TRAIN ADD CONSTRAINT SYS_C005598 FOREIGN KEY (TRAIN_ID) REFERENCES HR_TRAIN (TRAIN_ID)
;
ALTER TABLE HR_MEMBER_SALARY ADD CONSTRAINT SYS_C005953 FOREIGN KEY (COMPONENT_ID) REFERENCES HR_SALARY_COMPONENT (COMPONENT_ID)
;
ALTER TABLE HR_MEMBER_SALARY ADD CONSTRAINT SYS_C005952 FOREIGN KEY (EMP_ID) REFERENCES T_EMP (EMP_ID)
;
ALTER TABLE T_DOC_RECEIVED ADD CONSTRAINT FK_T_DOC_RECEIVED23 FOREIGN KEY (TYPE_ID) REFERENCES T_DOC_RECEIVED_TYPE (ID)
;
ALTER TABLE T_DOC_RECEIVED ADD CONSTRAINT FK_T_DOC_RECEIVED26 FOREIGN KEY (SECURITY_ID) REFERENCES T_WORKFLOW_SECURITY_TYPE (ID)
;
ALTER TABLE T_WORKFLOW_X_FILE ADD CONSTRAINT SYS_C006366 FOREIGN KEY (ID) REFERENCES T_WORKFLOW (WORKFLOW_ID)
;
ALTER TABLE T_WORKFLOW_X_FILE ADD CONSTRAINT SYS_C006355 FOREIGN KEY (FILE_ID) REFERENCES T_FILE (FILE_ID)
;
ALTER TABLE T_EMP_X_PRIVILEGE ADD CONSTRAINT SYS_C005178 FOREIGN KEY (PRIVILEGE_ID) REFERENCES T_PRIVILEGE (PRIVILEGE_ID)
;
ALTER TABLE T_DIRECTORIES_PERMISSION ADD CONSTRAINT FK_T_DIRECTORIES_PERMISSION9 FOREIGN KEY (DIRECTORY_ID) REFERENCES T_DIRECTORIES (DIRECTORY_ID)
;
ALTER TABLE T_CONFERENCE ADD CONSTRAINT FK_T_CONFERENCE112 FOREIGN KEY (STATUS_ID) REFERENCES T_CONFERENCE_STATUS (STATUS_ID)
;
ALTER TABLE T_MSG_RECEIVER ADD CONSTRAINT FK_T_MSG_RECEIVER3 FOREIGN KEY (MSG_ID) REFERENCES T_SENT_MESSAGE (MSG_ID)
;
ALTER TABLE T_WORK_RECORD ADD CONSTRAINT FK_T_WORK_RECORD107 FOREIGN KEY (AUTOMOBILE_ID) REFERENCES T_AUTOMOBILE (AUTOMOBILE_ID)
;
ALTER TABLE T_WORK_RECORD ADD CONSTRAINT FK_T_WORK_RECORD106 FOREIGN KEY (EMP_ID) REFERENCES T_DRIVER (EMP_ID)
;
ALTER TABLE T_PROJECT_CHANGE ADD CONSTRAINT SYS_C005630 FOREIGN KEY (PERSON_ID) REFERENCES T_CONTACT_PERSON (PERSON_ID)
;
ALTER TABLE T_DIRECTORIES ADD CONSTRAINT FK_T_DIRECTORIES5 FOREIGN KEY (SUPER_DIRECTORY_ID) REFERENCES T_DIRECTORIES (DIRECTORY_ID)
;
ALTER TABLE T_PECCANCY ADD CONSTRAINT FK_T_PECCANCY2 FOREIGN KEY (AUTOMOBILE_ID) REFERENCES T_AUTOMOBILE (AUTOMOBILE_ID)
;
ALTER TABLE T_PECCANCY ADD CONSTRAINT FK_T_PECCANCY104 FOREIGN KEY (EMP_ID) REFERENCES T_DRIVER (EMP_ID)
;
ALTER TABLE T_SALARY_ITEMS_LOG ADD CONSTRAINT SYS_C005613 FOREIGN KEY (SALARY_DATE, EMP_ID) REFERENCES T_SALARY_LOG (SALARY_DATE, EMP_ID)
;
ALTER TABLE T_SALARY_ITEMS_LOG ADD CONSTRAINT SYS_C05612 FOREIGN KEY (ITEM_ID) REFERENCES T_SALARY_ITEMS_SPEC (ITEM_ID)
;
ALTER TABLE T_SALARY_LOG ADD CONSTRAINT SYS_C005609 FOREIGN KEY (EMP_ID) REFERENCES T_SALARY_TEMPLATE (EMP_ID)
;
ALTER TABLE T_MSG_RECEIVERS ADD CONSTRAINT SYS_C005631 FOREIGN KEY (MSG_ID) REFERENCES T_PERSON_SENT_MSG (MSG_ID)
;
ALTER TABLE T_BUDGET_LIST ADD CONSTRAINT T_BUDGET_DIVISIONID FOREIGN KEY (DIVISION_ID) REFERENCES T_DIVISION (DIVISION_ID)
;
ALTER TABLE T_FILES ADD CONSTRAINT FK_T_FILES4 FOREIGN KEY (DIRECTORY_ID) REFERENCES T_DIRECTORIES (DIRECTORY_ID)
;
ALTER TABLE T_PASS_READ_PASSING_BOX ADD CONSTRAINT SYS_C005622 FOREIGN KEY (ARTICAL_ID) REFERENCES T_PASS_READ_ARTICAL (ARTICAL_ID)
;
ALTER TABLE T_CONTACT_PERSON ADD CONSTRAINT SYS_C005626 FOREIGN KEY (COMPANY_ID) REFERENCES T_CONTACT_COMPANY (COMPANY_ID)
;
ALTER TABLE HR_TRAIN ADD CONSTRAINT SYS_C005596 FOREIGN KEY (DD_TRAIN_ID) REFERENCES HR_DD (DD_ID)
;
ALTER TABLE T_DRIVING_FEE ADD CONSTRAINT FK_T_DRIVING_FEE106 FOREIGN KEY (AUTOMOBILE_ID) REFERENCES T_AUTOMOBILE (AUTOMOBILE_ID)
;
ALTER TABLE T_DRIVING_FEE ADD CONSTRAINT FK_T_DRIVING_FEE105 FOREIGN KEY (EMP_ID) REFERENCES T_DRIVER (EMP_ID)
;
ALTER TABLE T_BOARDROOM ADD CONSTRAINT FK_T_BOARDROOM113 FOREIGN KEY (STATUS_ID) REFERENCES T_BOARDROOM_STATUS (STATUS_ID)
;
ALTER TABLE T_WORKFLOW_DISPATCH ADD CONSTRAINT FK_DISPATCH9 FOREIGN KEY (WORKFLOW_ID) REFERENCES T_WORKFLOW (WORKFLOW_ID)
;
ALTER TABLE HR_MEMBER_PRIVATE_INFO ADD CONSTRAINT SYS_C005605 FOREIGN KEY (DD_PARTY_ID) REFERENCES HR_DD (DD_ID)
;
ALTER TABLE HR_SALARY_LIST ADD CONSTRAINT SYS_C005958 FOREIGN KEY (EMP_ID) REFERENCES T_EMP (EMP_ID)
;
ALTER TABLE T_TOPIC_X_MEETING_ROOM ADD CONSTRAINT SYS_C005619 FOREIGN KEY (E_MEETING_ROOM_ID) REFERENCES T_E_MEETING_ROOM (E_MEETING_ROOM_ID)
;
ALTER TABLE T_TOPIC_X_MEETING_ROOM ADD CONSTRAINT SYS_C005618 FOREIGN KEY (TOPIC_ID) REFERENCES T_DISCUSSION_TOPIC (TOPIC_ID)
;
ALTER TABLE T_E_MEETING_MESSAGE ADD CONSTRAINT SYS_C005615 FOREIGN KEY (MESSAGE_ID) REFERENCES T_E_MEETING_MESSAGE (MESSAGE_ID)
;
ALTER TABLE T_E_MEETING_MESSAGE ADD CONSTRAINT SYS_C005617 FOREIGN KEY (E_MEETING_ROOM_ID) REFERENCES T_E_MEETING_ROOM (E_MEETING_ROOM_ID)
;
ALTER TABLE T_E_MEETING_MESSAGE ADD CONSTRAINT SYS_C005616 FOREIGN KEY (TOPIC_ID) REFERENCES T_DISCUSSION_TOPIC (TOPIC_ID)
;