附件脚本供参考
CREATE TABLE ATTACHMENT ( ID NUMBER NOT NULL, CLASS NUMBER, SUBCLASS NUMBER, ATTACHMENT_NUMBER VARCHAR2(150) NOT NULL, OBJVERSION NUMBER, DELETE_FLAG NUMBER, LATEST_VSN NUMBER, DESCRIPTION VARCHAR2(4000), CHECKOUT_USER NUMBER, CHECKOUT_DATE DATE, CHECKOUT_FOLDER VARCHAR2(3000), FLAGS VARCHAR2(32), LAST_MOD DATE, CREATE_DATE DATE, BASEATTACH_ID NUMBER, ATTACHMENTTYPE NUMBER, COMPONENT_TYPE NUMBER, DEFAULT_CHANGE NUMBER DEFAULT 0, REDLINE_USER NUMBER, ROUTED_DATE DATE, CONSTRAINT ATTACHMENT_PK PRIMARY KEY ( ID ) )
CREATE TABLE ATTACH_REDLINE ( ID NUMBER, USER_ID NUMBER, NAME VARCHAR2(240), DESCRIPTION VARCHAR2(400), CREATE_DATE DATE, MODIFY_DATE DATE, VERSION NUMBER, USER_SESSION VARCHAR2(120), CHG_ID NUMBER, ITEM_ID NUMBER, ATTACH_ID NUMBER, ATTACH_VER NUMBER, FILE_ID NUMBER )
CREATE TABLE FOLDER ( ID NUMBER NOT NULL, NAME VARCHAR2 (190), DESCRIPTION VARCHAR2 (510), OWNER NUMBER, IS_PUBLIC NUMBER, ORDERED NUMBER, OBJVERSION NUMBER DEFAULT 0, CREATED DATE DEFAULT SYSDATE NOT NULL, LAST_UPD DATE DEFAULT SYSDATE NOT NULL, CONSTRAINT FOLDER_PK PRIMARY KEY ( ID ) )
CREATE TABLE FOLDERING ( FOLDERID NUMBER NOT NULL, OBJECTID NUMBER NOT NULL, CLASSID NUMBER NOT NULL, ORDERING NUMBER, USER_ORDER NUMBER, OBJ_UDF_NAME VARCHAR2(3129), CREATED DATE DEFAULT SYSDATE NOT NULL, LAST_UPD DATE DEFAULT SYSDATE NOT NULL,
CREATE TABLE FILES ( ID NUMBER NOT NULL, FILE_SIZE NUMBER, FILE_TYPE VARCHAR2(450), FILENAME VARCHAR2(4000), PAGE NUMBER, FLAGS VARCHAR2(32), UUID VARCHAR2(128), CONTENT_URL VARCHAR2(1024), FILE_FORMAT VARCHAR2(10), CONTENT_URL_TEMPLATE VARCHAR2(1024), CATEGORY NUMBER, CREATED DATE DEFAULT SYSDATE NOT NULL, LAST_UPD DATE DEFAULT SYSDATE NOT NULL, CONSTRAINT FILES_PK PRIMARY KEY ( ID ) )
CONSTRAINT FOLDERING_PK PRIMARY KEY (FOLDERID, OBJECTID, CLASSID) )
CREATE TABLE FOLDER_STRUCTURE ( ID NUMBER, PID NUMBER, P_VER_ID NUMBER, CID NUMBER, C_VER_ID NUMBER, FIND_NUMBER NUMBER, QUANTITY NUMBER, FLAGS VARCHAR2(32), FILENAME VARCHAR2(1333 BYTE), IDENTIFIER VARCHAR2(150), COMPONENT VARCHAR2(150), REFERENCE VARCHAR2(150), CONFIGURATION VARCHAR2(150), CREATED DATE DEFAULT SYSDATE NOT NULL, LAST_UPD DATE DEFAULT SYSDATE NOT NULL, CONSTRAINT FOLDER_STRUCTURE_PK PRIMARY KEY ( ID ) )
CREATE TABLE VERSION ( ID NUMBER, ATTACH_ID NUMBER, VERSION_NUM NUMBER, FLAGS VARCHAR2(32), CREATE_DATE DATE, LIFECYCLEPHASE NUMBER, CHECKIN_USER NUMBER, LAST_UPD DATE DEFAULT SYSDATE NOT NULL, LABEL VARCHAR2(150), REVISION VARCHAR2(150), VER_DATE DATE, APPROVAL_STATUS NUMBER(1), ITEM_CHANGE_STATUS VARCHAR2(10), FOLDER_REVISION VARCHAR2(150 BYTE), CHANGE NUMBER DEFAULT 0, INCORPORATED NUMBER(1,0) DEFAULT 0, CHANGESEQ VARCHAR2(20), CONSTRAINT VERSION_PK PRIMARY KEY (ID) )
CREATE TABLE FILE_INFO ( FILE_ID NUMBER NOT NULL, FILE_TYPE VARCHAR2(450), CHECKSUM_VALUE NUMBER, FILE_PATH VARCHAR2(4000), LOCATIONS VARCHAR2(4000), EIFS_FILEPATH VARCHAR2(4000), IFS_FILEPATH VARCHAR2(4000), HFS_FILEPATH VARCHAR2(4000), CREATED DATE DEFAULT SYSDATE NOT NULL, LAST_UPD DATE DEFAULT SYSDATE NOT NULL, CONSTRAINT PK_CHECKSUM PRIMARY KEY (FILE_ID) )
CREATE TABLE VAULT ( IFS_URL VARCHAR2(512), TYPE VARCHAR2(32), BASE_STORAGE_DIR VARCHAR2(1024), PURGE_DIR VARCHAR2(1024), CATEGORY VARCHAR2(32), DESCRIPTION VARCHAR2(4000), CREATED DATE DEFAULT SYSDATE NOT NULL, LAST_UPD DATE DEFAULT SYSDATE NOT NULL )