DOMAIN_LIST

DROP TABLE IF EXISTS ATTENDANCE.DOMAIN_LIST CASCADE;  
  
CREATE TABLE ATTENDANCE.DOMAIN_LIST  
(  
    DOMAIN_SEQ_ID    NUMERIC NOT NULL,  
    DOMAIN_NM    CHARACTER VARYING(100),  
    DOMAIN_ADDRS    CHARACTER VARYING(200),  
    DOMAIN_DESC    CHARACTER VARYING(4000),  
    USE_YN    CHARACTER VARYING(1) DEFAULT 'Y',  
    CRT_DTTM    TIMESTAMP WITHOUT TIME ZONE DEFAULT (NOW() AT TIME ZONE 'ASIA/SEOUL')  
);  
  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_LIST.DOMAIN_SEQ_ID IS '도메인순번아이디';  
  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_LIST.DOMAIN_NM IS '도메인명';  
  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_LIST.DOMAIN_ADDRS IS '도메인주소';  
  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_LIST.DOMAIN_DESC IS '도메인설명';  
  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_LIST.USE_YN IS '사용여부';  
  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_LIST.CRT_DTTM IS '생성일시';  
  
COMMENT ON TABLE ATTENDANCE.DOMAIN_LIST IS '도메인목록';  
  
CREATE UNIQUE INDEX DOMAIN_LIST_PK ON ATTENDANCE.DOMAIN_LIST  
    ( DOMAIN_SEQ_ID );  
  
ALTER TABLE ATTENDANCE.DOMAIN_LIST  
    ADD CONSTRAINT DOMAIN_LIST_PK PRIMARY KEY  
        USING INDEX DOMAIN_LIST_PK;  
  
CREATE SEQUENCE ATTENDANCE.DOMAIN_LIST_ATTENDANCE_DOMAIN_SEQ_ID_SEQ;  
  
ALTER SEQUENCE ATTENDANCE.DOMAIN_LIST_ATTENDANCE_DOMAIN_SEQ_ID_SEQ OWNER TO LMS;  
  
ALTER SEQUENCE ATTENDANCE.DOMAIN_LIST_ATTENDANCE_DOMAIN_SEQ_ID_SEQ OWNED BY ATTENDANCE.DOMAIN_LIST.DOMAIN_SEQ_ID;