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