과제

테이블 (3)

partner

  • id — bigint — 기본 키
  • code — varchar(64) — NOT NULL
  • name — varchar(255) — NOT NULL
  • active — boolean — NOT NULL

partner_fee_policy

  • id — bigint — 기본 키
  • effective_from — timestamp — NOT NULL
  • percentage — decimal(10,6) — NOT NULL
  • fixed_fee — decimal(15,0)
  • partner_id — bigint — 외래 키 → partner.id

payment

  • id — bigint — 기본 키
  • amount — decimal(15,0) — NOT NULL
  • applied_fee_rate — decimal(10,6) — NOT NULL
  • fee_amount — decimal(15,0) — NOT NULL
  • net_amount — decimal(15,0) — NOT NULL
  • card_bin — varchar(8)
  • card_last4 — varchar(4)
  • approval_code — varchar(32) — NOT NULL
  • approved_at — timestamp — NOT NULL
  • status — varchar(20) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • partner_id — bigint — 외래 키 → partner.id