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