ATNDNC_LOG

DROP TABLE IF EXISTS ATTENDANCE.ATNDNC_LOG CASCADE;  
  
CREATE TABLE ATTENDANCE.ATNDNC_LOG  
(  
    DOMAIN_SEQ_ID    NUMERIC NOT NULL,  
    DOMAIN_ACCNT_ID    CHARACTER VARYING(50) NOT NULL,  
    EXCUTE_OS_NM CHARACTER VARYING(100),
    EXCUTE_MACHINE_ID CHARACTER VARYING(50),
    ATNDNC_DT    CHARACTER VARYING(8) NOT NULL,  
    LOG_SEQ_ID    NUMERIC NOT NULL,  
    LOG_MSG    CHARACTER VARYING(4000),  
    LOG_DTTM    TIMESTAMP WITHOUT TIME ZONE DEFAULT (NOW() AT TIME ZONE 'ASIA/SEOUL')  
);  
  
COMMENT ON COLUMN ATTENDANCE.ATNDNC_LOG.DOMAIN_SEQ_ID IS '도메인순번아이디';  
COMMENT ON COLUMN ATTENDANCE.ATNDNC_LOG.DOMAIN_ACCNT_ID IS '도메인계정아이디';  
COMMENT ON COLUMN ATTENDANCE.ATNDNC_LOG.EXCUTE_OS_NM IS '동작OS명';  
COMMENT ON COLUMN ATTENDANCE.ATNDNC_LOG.EXCUTE_MACHINE_ID IS '동작머신ID'; 
COMMENT ON COLUMN ATTENDANCE.ATNDNC_LOG.ATNDNC_DT IS '출석일자';  
COMMENT ON COLUMN ATTENDANCE.ATNDNC_LOG.LOG_SEQ_ID IS '로그순번아이디';  
COMMENT ON COLUMN ATTENDANCE.ATNDNC_LOG.LOG_MSG IS '로그메시지';  
COMMENT ON COLUMN ATTENDANCE.ATNDNC_LOG.LOG_DTTM IS '로그일시';  
COMMENT ON TABLE ATTENDANCE.ATNDNC_LOG IS '출석로그';  
  
CREATE UNIQUE INDEX ATNDNC_LOG_PK ON ATTENDANCE.ATNDNC_LOG  
    ( DOMAIN_SEQ_ID,DOMAIN_ACCNT_ID,ATNDNC_DT,LOG_SEQ_ID );  
  
ALTER TABLE ATTENDANCE.ATNDNC_LOG  
    ADD CONSTRAINT ATNDNC_LOG_PK PRIMARY KEY  
        USING INDEX ATNDNC_LOG_PK;