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