결제통합뷰어ERD

결제통합뷰어 ERD

테이블 (8)

car_contract (계약차량)

  • contract_id — bigint(11) — 기본 키 — NOT NULL
  • car_id — int(11)
  • car_class — varchar(40)
  • region — varchar(80)
  • car_number — varchar(40)
  • car_owner_type — varchar(40)
  • created_at — datetime
  • updated_at — datetime

charged (과금)

  • id — bigint(11) — 기본 키 — NOT NULL
  • ref_type — varchar(80)
  • ref_id — bigint(11)
  • src_type — varchar(100)
  • src_id — int(11)
  • orderer_type — varchar(100)
  • orderer_id — int(11)
  • charged_type — varchar(100)
  • charged_sub_type — varchar(100)
  • order_id — int(11)
  • charged_amount — int(11)
  • taxation_amount — int(11)
  • taxxmpt_amount — int(11)
  • vat_amount — int(11)
  • src_created_at — datetime
  • src_updated_at — datetime
  • created_at — datetime
  • updated_at — datetime
  • id (id2) — bigint(11) — 외래 키 → contract.id — NOT NULL

charged_cancel (과금취소)

  • charged_id — bigint(11) — 기본 키 — NOT NULL
  • charged_cancel_at — datetime
  • updated_at — datetime
  • created_at — datetime
  • id (id2) — bigint(11) — 외래 키 → charged.id — NOT NULL

contract (계약)

  • id — bigint(11) — 기본 키 — NOT NULL
  • parent_id — bigint(11)
  • ref_type — varchar(80)
  • ref_id — bigint(11)
  • start_at — datetime
  • end_at — datetime
  • state — varchar(40)
  • contract_created_at — datetime
  • contract_updated_at — datetime
  • created_at — datetime
  • updated_at — datetime
  • contract_id — bigint(11) — 외래 키 → car_contract.contract_id — NOT NULL
  • contract_id (contract_id2) — bigint(11) — 외래 키 → contractor.contract_id — NOT NULL

contractor (계약자정보)

  • contract_id — bigint(11) — 기본 키 — NOT NULL
  • ref_type — varchar(80)
  • ref_id — bigint(11)
  • created_at — datetime
  • updated_at — datetime

payment (결제)

  • id — bigint(11) — 기본 키 — NOT NULL
  • ref_type — bigint(11)
  • ref_id — bigint(11)
  • src_type — varchar(100)
  • src_id — int(11)
  • orderer_type — varchar(100)
  • orderer_id — int(11)
  • payment_type — varchar(100)
  • payment_sub_type — varchar(100)
  • payment_amount — int(11)
  • taxation_amount — int(11)
  • taxxmpt_amount — int(11)
  • vat_amount — int(11)
  • src_created_at — datetime
  • src_updated_at — datetime
  • updated_at — datetime
  • created_at — datetime
  • id (id2) — bigint(11) — 외래 키 → contract.id — NOT NULL

payment_cancel (결제취소)

  • payment_id — bigint(11) — 기본 키 — NOT NULL
  • payment_cancel_at — datetime
  • updated_at — datetime
  • created_at — datetime
  • id (id2) — bigint(11) — 외래 키 → payment.id — NOT NULL

payment_card_transaction (결제카드)

  • payment_id — bigint(11) — 기본 키 — NOT NULL
  • pg_type — varchar(100)
  • franchise_type — varchar(100)
  • transaction_id — varchar(255)
  • approval_number — varchar(100)
  • src_created_at — datetime
  • src_updated_at — datetime
  • created_at — datetime
  • updated_at — datetime
  • id (id2) — bigint(11) — 외래 키 → payment.id — NOT NULL