ACT_LIST

DROP TABLE IF EXISTS ATTENDANCE.ACT_LIST CASCADE;  
  
CREATE TABLE ATTENDANCE.ACT_LIST  
(  
    DOMAIN_SEQ_ID    NUMERIC NOT NULL,  
    ACT_ORD    NUMERIC(2) NOT NULL,  
    ACT_TYP_CD    CHARACTER VARYING(10),  
    ACT_DTL    JSON,  
    RETRY_YN    CHARACTER VARYING(1),  
    CRT_DTTM    TIMESTAMP WITHOUT TIME ZONE DEFAULT (NOW() AT TIME ZONE 'ASIA/SEOUL')  
);  
  
COMMENT ON COLUMN ATTENDANCE.ACT_LIST.DOMAIN_SEQ_ID IS '도메인순번아이디';  
  
COMMENT ON COLUMN ATTENDANCE.ACT_LIST.ACT_ORD IS '행동순서';  
  
COMMENT ON COLUMN ATTENDANCE.ACT_LIST.ACT_TYP_CD IS '행동유형코드';  
  
COMMENT ON COLUMN ATTENDANCE.ACT_LIST.ACT_DTL IS '행동상세';  
  
COMMENT ON COLUMN ATTENDANCE.ACT_LIST.RETRY_YN IS '재시도여부';  
  
COMMENT ON COLUMN ATTENDANCE.ACT_LIST.CRT_DTTM IS '생성일시';  
  
COMMENT ON TABLE ATTENDANCE.ACT_LIST IS '행동목록';  
  
CREATE UNIQUE INDEX ACT_LIST_PK ON ATTENDANCE.ACT_LIST  
    ( DOMAIN_SEQ_ID,ACT_ORD );  
  
ALTER TABLE ATTENDANCE.ACT_LIST  
    ADD CONSTRAINT ACT_LIST_PK PRIMARY KEY  
        USING INDEX ACT_LIST_PK;