결제할인
테이블 (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)