TR
Tables (3)
card_bin_issuer (카드빈_카드사)
- id — bigint — Primary key — 아이디
- created_date — timestamp(6)
- last_modified_date — timestamp(6) — 수정일시
- card_bin_number — varchar(50) — NOT NULL — 카드빈번호
- issuer_reference_id — varchar(50) — NOT NULL — 카드사
payment (결제)
- id — varchar(50) — Primary key — NOT NULL
- id (id2) — bigint — Foreign key → transaction.id
- amount — numeric(10,2)
- created_date — timestamp(6)
- last_modified_date — timestamp(6)
- currency — varchar(50) — NOT NULL
- token_reference_id — varchar(50) — NOT NULL
- user_reference_id — varchar(50) — NOT NULL
- status — enum
transaction
- id — bigint — Primary key
- payment_id — varchar(50)
- created_date — timestamp(6)
- last_modified_date — timestamp(6)
- issuer_reference_id — varchar(50)
- approval_status — enum — NOT NULL