온라인 설명회 자동화

테이블 (3)

Copy Of EVENT_MASTER (ONLINE_AUTO)

  • Key (IDX) — INT — 기본 키 — NOT NULL
  • Field (TITLE) — VARCHAR(200)
  • Field2 (PROGRESS) — VARCHAR(4)
  • Field (REG_ID) — VARCHAR(20)
  • Field (REG_DT) — DATETIME
  • Field (MOD_ID) — VARCHAR(20)
  • Field (MOD_DT) — DATETIME
  • Field (EVT_CODE) — INT
  • Field (COUPON_CODE) — VARCHAR(50)
  • Field (IMG) — VARCHAR(100)
  • Field (BACK_COLOR) — VARCHAR(50)
  • Field (ECO) — VARCHAR(50)
  • Field (PRODUCT_URL) — VARCHAR(50)
  • Field (OG_TITLE) — VARCHAR(100)
  • Field (OG_DESCRIPTION) — VARCHAR(500)

EVENT_MASTER

  • Key (EVT_IDX) — INT — 기본 키 — NOT NULL
  • Field (TITLE) — VARCHAR(200)
  • Field2 (PROGRESS) — VARCHAR(4)
  • Field (EVT_START_DT) — DATETIME
  • Field (EVT_END_DT) — DATETIME
  • Field (REG_ID) — VARCHAR(20)
  • Field (REG_DT) — DATETIME
  • Field (MOD_ID) — VARCHAR(20)
  • Field (MOD_DT) — DATETIME
  • Field (DEL_YN) — CHAR(1)
  • Field

Untitled (EVENT_ONLINE_SUB)

  • Key (IDX) — INT — 기본 키 — NOT NULL
  • Key (EVT_IDX) — INT — 외래 키 → EVENT_MASTER.Key — NOT NULL
  • Field2
  • Field3
  • Field4
  • Field5