DOMAIN_ACCNT_LIST

DROP TABLE IF EXISTS ATTENDANCE.DOMAIN_ACCNT_LIST CASCADE;  
 
CREATE TABLE ATTENDANCE.DOMAIN_ACCNT_LIST  
(  
    DOMAIN_SEQ_ID    NUMERIC NOT NULL,  
    DOMAIN_ACCNT_ID    CHARACTER VARYING(50) NOT NULL,  
    DOMAIN_ACCNT_PSWRD    CHARACTER VARYING(4000),  
    EXCUTE_OS_NM CHARACTER VARYING(100),
    EXCUTE_MACHINE_ID CHARACTER VARYING(50),
    LAST_ATNDNC_DTTM    TIMESTAMP,
    MESRMNT_STRT_TM    NUMERIC(2) DEFAULT 8,  
    MESRMNT_END_TM    NUMERIC(2) DEFAULT 20,  
    MESRMNT_TM_INCLSN_PRBLTY    NUMERIC(3) DEFAULT 95,  
    ATNDNC_STRT_DTTM    TIMESTAMP WITHOUT TIME ZONE,  
    ATNDNC_STTS_CD    CHARACTER VARYING(1),  
    DOMAIN_ACCNT_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_ACCNT_LIST.DOMAIN_SEQ_ID IS '도메인순번아이디';  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_ACCNT_LIST.DOMAIN_ACCNT_ID IS '도메인계정아이디';  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_ACCNT_LIST.DOMAIN_ACCNT_PSWRD IS '도메인계정비밀번호';  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_ACCNT_LIST.EXCUTE_OS_NM IS '동작OS명';  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_ACCNT_LIST.EXCUTE_MACHINE_ID IS '동작머신ID';  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_ACCNT_LIST.LAST_ATNDNC_DTTM IS '마지막출석일자';  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_ACCNT_LIST.MESRMNT_STRT_TM IS '측정시작시간';  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_ACCNT_LIST.MESRMNT_END_TM IS '측정종료시간';  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_ACCNT_LIST.MESRMNT_TM_INCLSN_PRBLTY IS '측정시간포함확률';  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_ACCNT_LIST.ATNDNC_STRT_DTTM IS '출석시작일시';  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_ACCNT_LIST.ATNDNC_STTS_CD IS '출석상태코드';  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_ACCNT_LIST.DOMAIN_ACCNT_DESC IS '도메인계정설명';  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_ACCNT_LIST.USE_YN IS '사용여부';  
COMMENT ON COLUMN ATTENDANCE.DOMAIN_ACCNT_LIST.CRT_DTTM IS '생성일시';  
COMMENT ON TABLE ATTENDANCE.DOMAIN_ACCNT_LIST IS '도메인계정목록';  
  
CREATE UNIQUE INDEX DOMAIN_ACCNT_LIST_PK ON ATTENDANCE.DOMAIN_ACCNT_LIST  
    ( DOMAIN_SEQ_ID,DOMAIN_ACCNT_ID );  
  
ALTER TABLE ATTENDANCE.DOMAIN_ACCNT_LIST  
    ADD CONSTRAINT DOMAIN_ACCNT_LIST_PK PRIMARY KEY  
        USING INDEX DOMAIN_ACCNT_LIST_PK;