CREATE TABLE MAIL_TEMPLATE 
(
	TEMPLATE_ID          CHAR (3) NOT NULL PRIMARY KEY,
	TEMPLATE_DIR         VARCHAR2 (500) NOT NULL,
	TEMPLATE_FILENAME    VARCHAR2 (200) NOT NULL,
	MAIL_SUBJECT         VARCHAR2 (1000) NOT NULL,
	DATA_MODEL_TYPE      CHAR (1) NOT NULL,
	USE_FLAG             CHAR (1) DEFAULT 'Y' NOT NULL,
	CREATED_BY           VARCHAR2 (200),
	CREATION_DATE        DATE,
	UPDATED_BY           VARCHAR2 (200),
	UPDATED_DATE         DATE
) ;

COMMENT ON COLUMN MAIL_TEMPLATE.TEMPLATE_ID IS '템플릿 아이디';
COMMENT ON COLUMN MAIL_TEMPLATE.TEMPLATE_DIR IS '템플릿 경로';
COMMENT ON COLUMN MAIL_TEMPLATE.TEMPLATE_FILENAME IS '템플릿 파일명';
COMMENT ON COLUMN MAIL_TEMPLATE.MAIL_SUBJECT IS '메일 제목';
COMMENT ON COLUMN MAIL_TEMPLATE.DATA_MODEL_TYPE IS '데이터 모델 종류(J:JSON,X:XML,P:PARAMETER)';
COMMENT ON COLUMN MAIL_TEMPLATE.USE_FLAG IS '사용 유무(Y/N)';
COMMENT ON COLUMN MAIL_TEMPLATE.CREATED_BY IS '생성자';
COMMENT ON COLUMN MAIL_TEMPLATE.CREATION_DATE IS '생성일';
COMMENT ON COLUMN MAIL_TEMPLATE.UPDATED_BY IS '수정자';
COMMENT ON COLUMN MAIL_TEMPLATE.UPDATED_DATE IS '수정일';
COMMENT ON TABLE MAIL_TEMPLATE IS '메일 템플릿';



CREATE TABLE MAIL 
(
	MAIL_NO              NUMBER NOT NULL PRIMARY KEY,
	TEMPLATE_ID          CHAR (3) NOT NULL,
	STATUS_CODE          CHAR (2) NOT NULL,
	TO_ADDRESS           VARCHAR2 (200) NOT NULL,
	TO_NAME              VARCHAR2 (100),
	FROM_ADDRESS         VARCHAR2 (200) NOT NULL,
	FROM_NAME            VARCHAR2 (100),
	SUBJECT_DATA         VARCHAR2 (200),
	COTENT_DATA          VARCHAR2 (4000),
	SENT_BY              VARCHAR2 (200),
	SENT_DATE            DATE,
	CREATED_BY           VARCHAR2 (200),
	CREATION_DATE        DATE,
	UPDATED_BY           VARCHAR2 (200),
	UPDATED_DATE         DATE
) ;

COMMENT ON COLUMN MAIL.MAIL_NO IS '메일 번호';
COMMENT ON COLUMN MAIL.TEMPLATE_ID IS '템플릿 아이디';
COMMENT ON COLUMN MAIL.STATUS_CODE IS '상태 코드';
COMMENT ON COLUMN MAIL.TO_ADDRESS IS '받은이 주소';
COMMENT ON COLUMN MAIL.TO_NAME IS '받는이 이름';
COMMENT ON COLUMN MAIL.FROM_ADDRESS IS '보내는이 주소';
COMMENT ON COLUMN MAIL.FROM_NAME IS '보내는이 이름';
COMMENT ON COLUMN MAIL.SUBJECT_DATA IS '제목 데이터';
COMMENT ON COLUMN MAIL.COTENT_DATA IS '본문 데이터';
COMMENT ON COLUMN MAIL.SENT_BY IS '발송자';
COMMENT ON COLUMN MAIL.SENT_DATE IS '발송일';
COMMENT ON COLUMN MAIL.CREATED_BY IS '생성자';
COMMENT ON COLUMN MAIL.CREATION_DATE IS '생성일';
COMMENT ON COLUMN MAIL.UPDATED_BY IS '수정자';
COMMENT ON COLUMN MAIL.UPDATED_DATE IS '수정일';
COMMENT ON TABLE MAIL IS '메일';