결제통합뷰어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