[TABLE]1.1 SENDMAIL

ALTER TABLE AAA.SENDMAIL
 DROP PRIMARY KEY CASCADE;

DROP TABLE AAA.SENDMAIL CASCADE CONSTRAINTS;

CREATE TABLE AAA.SENDMAIL
(
  SEQ          NUMBER(15)                       NOT NULL,
  SYSTEM_NAME  VARCHAR2(30 BYTE)                NOT NULL,
  FROM_EMAIL   VARCHAR2(60 BYTE)                NOT NULL,
  TO_EMAIL     VARCHAR2(60 BYTE)                NOT NULL,
  SUBJECT      VARCHAR2(100 BYTE)               NOT NULL,
  MESSAGE      VARCHAR2(4000 BYTE),
  SEND_FLAG    NUMBER(2)                        DEFAULT -1,
  CREATE_TIME  VARCHAR2(20 BYTE)                DEFAULT (TO_CHAR(SYSDATE, 'yyyymmddhh24miss')) NOT NULL,
  CREATE_USER  VARCHAR2(20 BYTE),
  SEND_TIME    VARCHAR2(20 BYTE),
  ERROR_MSG    VARCHAR2(1000 BYTE),
  FILE_ID      NUMBER(15)
)
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
NOCACHE
NOPARALLEL
MONITORING;

COMMENT ON COLUMN AAA.SENDMAIL.SEQ IS 'PK(SEQ_SENDMAIL 사용)';

COMMENT ON COLUMN AAA.SENDMAIL.SYSTEM_NAME IS 'SYSTEM_NAME';

COMMENT ON COLUMN AAA.SENDMAIL.FROM_EMAIL IS '보내는 사람 Email주소';

COMMENT ON COLUMN AAA.SENDMAIL.TO_EMAIL IS '받는 사람 Email주소';

COMMENT ON COLUMN AAA.SENDMAIL.SUBJECT IS '제목';

COMMENT ON COLUMN AAA.SENDMAIL.MESSAGE IS '메일메시지';

COMMENT ON COLUMN AAA.SENDMAIL.SEND_FLAG IS '전송여부( 기본 : -1, 전송 : 0, ERROR : 1 )';

COMMENT ON COLUMN AAA.SENDMAIL.CREATE_TIME IS '메일전송데이터 생성시간';

COMMENT ON COLUMN AAA.SENDMAIL.CREATE_USER IS '생성사용자';

COMMENT ON COLUMN AAA.SENDMAIL.SEND_TIME IS '전송시간';

COMMENT ON COLUMN AAA.SENDMAIL.ERROR_MSG IS '전송에러메시지';

COMMENT ON COLUMN AAA.SENDMAIL.FILE_ID IS '첨부파일ID(SEQ_FILESTORAGE 사용)';

CREATE INDEX AAA.SENDMAIL_IDX1 ON AAA.SENDMAIL
(SEND_FLAG)
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;

CREATE UNIQUE INDEX AAA.PK_SENDMAIL ON AAA.SENDMAIL
(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.SENDMAIL ADD (
  CONSTRAINT PK_SENDMAIL
 PRIMARY KEY
 (SEQ)
    USING INDEX
    TABLESPACE AAA_TBS
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                NEXT             1M
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
               ));