Hawk
Tables (3)
CCC_OUTER_AD (재직자AD인증)
- CONNECT_ID (Key) — VARCHAR2(100) — Primary key — NOT NULL
- EMP_NO (Key2) — VARCHAR2(20) — Primary key — NOT NULL
- AD_SEQ (Key3) — NUMBER — Primary key — NOT NULL
- REQ_DATE (Key4) — DATE — Primary key — NOT NULL
- CONNECT_ID (Key5) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.CONNECT_ID — NOT NULL
- SESSION_ID (Key22) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.SESSION_ID — NOT NULL
- USER_AGENT (Key32) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.USER_AGENT — NOT NULL
- CONNECT_TYPE (Key42) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.CONNECT_TYPE — NOT NULL
- CONNECT_BROWSER (Key52) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.CONNECT_BROWSER — NOT NULL
- CONNECT_OS (Key6) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.CONNECT_OS — NOT NULL
- CONNECT_DATE (Key7) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.CONNECT_DATE — NOT NULL
CCC_OUTER_OTP (휴직자.퇴직자OTP인증)
- CONNECT_ID (Key) — VARCHAR2(100) — Primary key — NOT NULL
- EMP_NO (Key2) — VARCHAR2(20) — Primary key — NOT NULL
- AD_SEQ (Key3) — NUMBER — Primary key — NOT NULL
- REQ_DATE (Key4) — DATE — Primary key — NOT NULL
- CONNECT_ID (Key5) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.CONNECT_ID — NOT NULL
- SESSION_ID (Key22) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.SESSION_ID — NOT NULL
- USER_AGENT (Key32) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.USER_AGENT — NOT NULL
- CONNECT_TYPE (Key42) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.CONNECT_TYPE — NOT NULL
- CONNECT_BROWSER (Key52) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.CONNECT_BROWSER — NOT NULL
- CONNECT_OS (Key6) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.CONNECT_OS — NOT NULL
- CONNECT_DATE (Key7) — VARCHAR2(100) — Foreign key → CCC_OUTER_USERAGENT.CONNECT_DATE — NOT NULL
CCC_OUTER_USERAGENT (CCC사외 WEB접속 헤더정보)
- CONNECT_ID (Key) — VARCHAR2(100) — Primary key — NOT NULL
- SESSION_ID (Key2) — VARCHAR2(100) — Primary key — NOT NULL
- USER_AGENT (Key3) — VARCHAR2(100) — Primary key — NOT NULL
- CONNECT_TYPE (Key4) — VARCHAR2(100) — Primary key — NOT NULL
- CONNECT_BROWSER (Key5) — VARCHAR2(100) — Primary key — NOT NULL
- CONNECT_OS (Key6) — VARCHAR2(100) — Primary key — NOT NULL
- CONNECT_DATE (Key7) — VARCHAR2(100) — Primary key — NOT NULL