ILS

Tables (12)

DEVICE (ILS_DEVICE)

  • DUID — varchar(50) — Primary key — NOT NULL
  • DOMAIN — varchar(50)
  • REG_DTM — timestamp

DEVICE_HTX (ILS_DEVICE_HTX)

  • DUID — varchar(50) — Foreign key → DEVICE.DUID — NOT NULL
  • HT_TIN — varchar(50) — Foreign key → HTX.HT_TIN — NOT NULL — 홈택스TIN' primary ke

DEVICE_REF (ILS_DEVICE_REF)

  • DUID — varchar(50) — Foreign key → DEVICE.DUID — NOT NULL
  • RUID — varchar(50) — Foreign key → REF.RUID — NOT NULL — 레퍼러일련번호' primary ke

EVENT (ILS_DEVICE_EVENT)

  • REG_DTM — timestamp — Primary key — NOT NULL
  • EVENT — varchar(5) — Foreign key → EVENT_INF.EVENT — NOT NULL — 이벤트 코드' primary ke
  • DUID — varchar(50) — Foreign key → DEVICE.DUID — NOT NULL
  • IP_ADDR — varchar(100)
  • DOMAIN — varchar(50)
  • PAGE_URL — varchar(200)
  • REFERRER — varchar(2000)
  • OS — varchar(100)
  • OS_VER — varchar(30)
  • BROWSER — varchar(100)
  • BROWSER_VER — varchar(30)
  • DEV — varchar(100)
  • DEV_BRND — varchar(100)
  • USER_AGENT — text

EVENT_ATTR (ILS_DEVICE_EVENT_ATTR)

  • EVENT — varchar(5) — Primary key — NOT NULL
  • DUID — varchar(50) — Primary key — NOT NULL
  • NAME — VARCHAR(50) — Primary key
  • REG_DTM — timestamp — Foreign key → EVENT.REG_DTM — NOT NULL
  • VALUE — VARCHAR(1000)

EVENT_INF (ILS_EVENT_INF)

  • EVENT — varchar(5) — Primary key — NOT NULL — 이벤트 코드' primary ke
  • EVENT_NM — varchar(200) — NOT NULL — 이벤트 이름
  • UPD_USER — varchar(100) — 최종수정자
  • REG_DTM — timestamp — NOT NULL — 등록일시
  • UPD_DTM — timestamp — 수정일시

HTX (ILS_HTX_CORP)

  • HT_TIN — varchar(50) — Primary key — NOT NULL — 홈택스TIN' primary ke
  • TOT_CORP_CNT — int(3) — NOT NULL — 전체사업장개수
  • NML_CORP_CNT — int(3) — NOT NULL — 정상사업장개수
  • END_CORP_CNT — int(3) — NOT NULL — 폐업사업장개수
  • REG_DTM — timestamp — NOT NULL — 등록일자
  • UPD_DTM — timestamp — NOT NULL — 수정일자

ILS_DEVICE_EVENT_POSTBACK

  • POSTBACK_UUID — varchar(50) — Primary key — NOT NULL — 포스트백일련번호
  • EVENT — varchar(5) — Foreign key → EVENT_INF.EVENT — NOT NULL — 이벤트 코드' primary ke
  • DUID — varchar(50) — Foreign key → DEVICE.DUID — NOT NULL
  • POSTBACK_CORP — varchar(30) — NOT NULL — 포스트백업체
  • POSTBACK_KEY — varchar(50) — NOT NULL — 포스트백키
  • POSTBACK_URL — varchar(300) — 포스트백URL
  • REQ_PARAM — text — req 파라미터정보
  • RES — text — res 정보
  • ERR_YN — char — NOT NULL — 오류여부
  • TRACE — text — 오류TRACE
  • REG_DTM — timestamp — NOT NULL — 등록일시

REF (ILS_REF)

  • RUID — varchar(50) — Primary key — NOT NULL — 레퍼러일련번호' primary ke
  • REFERRER — varchar(2000) — NOT NULL — 레퍼러

REF_ATTR (ILS_REF_ATTR)

  • KEY — varchar(50) — Primary key — NOT NULL — 레퍼러 파라미터 키
  • RUID — varchar(50) — Foreign key → REF.RUID — NOT NULL — 레퍼러일련번호' primary ke
  • VALUE — varchar(100) — 레퍼러 파라미터 값

SERVICE

  • SERVICE_CD — VARCHAR(50) — Primary key — NOT NULL
  • SERVICE_NM — VARCHAR(200)
  • MAX_DEPTH — INT

VIEW

  • VIEW_ID — VARCHAR(1000) — Primary key — NOT NULL
  • SERVICE_CD — VARCHAR(50) — Foreign key → SERVICE.SERVICE_CD — NOT NULL
  • VIEW_NM — VARCHAR(1000)
  • DEPTH — INT