과제
테이블 (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