단축 URL
테이블 (5)
SU_FOBIDDEN_DOMAIN (차단된 도메인)
- FORBIDDEN_DOMAIN_OID — VARCHAR2(11) — 기본 키 — NOT NULL
- FORBIDDEN_DOMAIN — VARCHAR2(2048)
- TITLE — VARCHAR2(255)
- DESCR — VARCHAR2(4000)
- FORBIDDEN_TYPE_FLAG — CHAR(1)
- USE_YN — CHAR(1)
- INPUT_USER — VARCHAR2(11)
- INPUT_DATE — DATE
- CUSTOM_FIELD1 — VARCHAR2(255)
- CUSTOM_FIELD2 — VARCHAR2(255)
- CUSTOM_FIELD3 — VARCHAR2(255)
SU_SHORT_URL (단축 URL)
- SHORT_URL_OID — VARCHAR2(11) — 기본 키 — NOT NULL
- ORIGIN_URL — VARCHAR2(2048)
- SHORT_URL — VARCHAR2(12)
- CLASSIFY_CATEGORY_OID — VARCHAR2(11) — 외래 키 → TB_CATEGORY.OID — NOT NULL
- TITLE — VARCHAR2(255)
- DESCR — VARCHAR2(4000)
- MAIN_IMAGE_URL — VARCHAR2(2048)
- EXPIRE_DATE — DATE
- PWD — VARCHAR2(255)
- OPEN_YN — CHAR(1)
- AUTO_YN — CHAR(1)
- VISIT_CNT — NUMBER
- INPUT_USER — VARCHAR2(11)
- INPUT_DATE — DATE
- MOD_USER — VARCHAR2(11)
- MOD_DATE — DATE
- CUSTOM_FIELD1 — VARCHAR2(255)
- CUSTOM_FIELD2 — VARCHAR2(255)
- CUSTOM_FIELD3 — VARCHAR2(255)
SU_SHORT_URL_VISIT_AUDIT (단축 URL 방문 이력)
- SHORT_URL_VISIT_AUDIT_OID — VARCHAR2(11) — 기본 키 — NOT NULL
- SHORT_URL_OID — VARCHAR2(11) — 외래 키 → SU_SHORT_URL.SHORT_URL_OID — NOT NULL
- VISIT_YEAR — VARCHAR2(4)
- VISIT_MONTH — VARCHAR2(2)
- VISIT_WEEK — VARCHAR2(1)
- VISIT_DAY — VARCHAR2(2)
- USER_IP — VARCHAR2(20)
- USER_DEVICE_TYPE_FLAG — CHAR(1)
- USER_OS_FLAG — CHAR(1)
- USER_BROWSER — VARCHAR2(30)
- USER_OS — VARCHAR2(30)
- USER_RESOLUTION — VARCHAR2(15)
- USER_BROWSER_MAJOR_VERSION — VARCHAR2(15)
- USER_BROWSER_FULL_VERSION — VARCHAR2(15)
- USER_OS_VERSION — VARCHAR2(15)
- USER_COUNTRY — VARCHAR2(255)
- USER_CITY — VARCHAR2(255)
- USER_REGION — VARCHAR2(255)
- USER_DISTRICT — VARCHAR2(255)
- LOCATION — VARCHAR2(50)
- INPUT_USER — VARCHAR2(11)
- INPUT_DATE — DATE
- CUSTOM_FIELD1 — VARCHAR2(255)
- CUSTOM_FIELD2 — VARCHAR2(255)
- CUSTOM_FIELD3 — VARCHAR2(255)
SU_SHORT_URL_VISIT_STATS (단축 URL 방문 통계)
- SHORT_URL_VISIT_STATS_OID — VARCHAR2(11) — 기본 키 — NOT NULL
- SHORT_URL_OID — VARCHAR2(11) — 외래 키 → SU_SHORT_URL.SHORT_URL_OID — NOT NULL
- STATS_YEAR — VARCHAR2(4)
- STATS_MONTH — VARCHAR2(2)
- STATS_WEEK — VARCHAR2(1)
- STATS_DAY — VARCHAR2(2)
- STATS_HOUR — VARCHAR2(2)
- INPUT_DATE — DATE
- CUSTOM_FIELD1 — VARCHAR2(255)
- CUSTOM_FIELD2 — VARCHAR2(255)
- CUSTOM_FIELD3 — VARCHAR2(255)
TB_CATEGORY (분류)
- OID — VARCHAR2(11) — 기본 키 — NOT NULL