결제할인

테이블 (3)

Untitled (payment_discount)

  • id — int — 기본 키 — NOT NULL
  • name (cart_tap_name) — VARCHAR(10) — NOT NULL
  • startDate (cart_tap_icon_url) — VARCHAR(100) — NOT NULL
  • Field4 (cart_tap_info_url) — VARCHAR(100)
  • Field5 (pg_company) — VARCHAR(30) — NOT NULL — KAKAOPAY, INICIS
  • endDate (mall_id) — VARCHAR(30) — NOT NULL — 가맹점 코드 (cid, mid 등)
  • Field3 (status) — VARCHAR(15) — NOT NULL — DEACTIVATE, ACTIVE
  • Field6 (start_at) — DATETIME — NOT NULL
  • Field7 (end_at) — DATETIME — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field2 (modified_at) — DATETIME — NOT NULL

Untitled2 (payment_discount_brand_info)

  • id — int — 기본 키 — NOT NULL
  • id (brand_info) — int — 외래 키 → brand_info.id — NOT NULL
  • id (payment_discount_id) — int — 외래 키 → Untitled.id — NOT NULL
  • Field (create_at) — DATETIME — NOT NULL
  • Field2 (modified_at) — DATETIME — NOT NULL

brand_info

  • id — 기본 키 — NOT NULL
  • Field (name)
  • Field2 (banner)
  • Field3 (kor_url)