[TABLE]1.2 FILESTORAGE

ALTER TABLE AAA.FILESTORAGE
 DROP PRIMARY KEY CASCADE;

DROP TABLE AAA.FILESTORAGE CASCADE CONSTRAINTS;

CREATE TABLE AAA.FILESTORAGE
(
  SYSTEM_NAME   VARCHAR2(50 BYTE),
  FILE_ID       NUMBER(15)                      NOT NULL,
  FILE_SEQ      NUMBER(2)                       NOT NULL,
  CNT           NUMBER(1),
  FILE_ATTCH    BLOB                            DEFAULT empty_blob(),
  FILE_NAME     VARCHAR2(300 BYTE),
  FILE_SIZE     VARCHAR2(100 BYTE),
  REGIST_DATE   VARCHAR2(14 BYTE),
  USER_ID       VARCHAR2(25 BYTE),
  USER_COMMENT  VARCHAR2(650 BYTE)
)
TABLESPACE AAA_TBS
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING
NOCOMPRESS
LOB (FILE_ATTCH) STORE AS
      ( TABLESPACE  AAA_TBS
        ENABLE      STORAGE IN ROW
        CHUNK       8192
        RETENTION
        NOCACHE
        INDEX       (
          TABLESPACE AAA_TBS
          STORAGE    (
                      INITIAL          64K
                      NEXT             1
                      MINEXTENTS       1
                      MAXEXTENTS       UNLIMITED
                      PCTINCREASE      0
                      BUFFER_POOL      DEFAULT
                     ))
        STORAGE    (
                    INITIAL          64K
                    NEXT             1M
                    MINEXTENTS       1
                    MAXEXTENTS       UNLIMITED
                    PCTINCREASE      0
                    BUFFER_POOL      DEFAULT
                   )
      )
NOCACHE
NOPARALLEL
MONITORING;

COMMENT ON COLUMN AAA.FILESTORAGE.SYSTEM_NAME IS '사용 System 명.';

COMMENT ON COLUMN AAA.FILESTORAGE.FILE_ID IS 'File ID';

COMMENT ON COLUMN AAA.FILESTORAGE.FILE_SEQ IS 'File Seq';

COMMENT ON COLUMN AAA.FILESTORAGE.CNT IS 'File Cnt';

COMMENT ON COLUMN AAA.FILESTORAGE.FILE_ATTCH IS 'File';

COMMENT ON COLUMN AAA.FILESTORAGE.FILE_NAME IS 'File Name';

COMMENT ON COLUMN AAA.FILESTORAGE.FILE_SIZE IS 'File Size';

COMMENT ON COLUMN AAA.FILESTORAGE.REGIST_DATE IS '등록시간';

COMMENT ON COLUMN AAA.FILESTORAGE.USER_ID IS '사용';

COMMENT ON COLUMN AAA.FILESTORAGE.USER_COMMENT IS 'Comment';

CREATE UNIQUE INDEX AAA.PK_FILESTORAGE ON AAA.FILESTORAGE
(FILE_ID, FILE_SEQ)
LOGGING
TABLESPACE AAA_TBS
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;

ALTER TABLE AAA.FILESTORAGE ADD (
  CONSTRAINT PK_FILESTORAGE
 PRIMARY KEY
 (FILE_ID, FILE_SEQ)
    USING INDEX
    TABLESPACE AAA_TBS
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                NEXT             1M
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
               ));