Verifier

Tables (7)

Certificate VC (certificate_vc)

  • id — BIGINT — Primary key — NOT NULL — id
  • certificatge VC contents (json) (vc) — text — NOT NULL — certificatge VC contents (json)
  • created date (created_at) — TIMESTAMP — NOT NULL — created date
  • updated date (updated_at) — TIMESTAMP — updated date

ECDH Transaction Management (e2e)

  • id — BIGINT — Primary key — NOT NULL — id
  • session key (session_key) — VARCHAR(100) — NOT NULL — session key
  • nonce — VARCHAR(100) — NOT NULL — nonce
  • curve — VARCHAR(20) — NOT NULL — curve
  • cipher type (cipher) — VARCHAR(20) — NOT NULL — cipher type
  • padding type (padding) — VARCHAR(20) — NOT NULL — padding
  • created date (created_at) — TIMESTAMP — NOT NULL — created date
  • updated date (updated_at) — TIMESTAMP — updated date
  • transaction key (transaction_id) — BIGINT — Foreign key → Transaction Management.id — NOT NULL — transaction key

Sub-Transaction Management (sub_transaction)

  • id — BIGINT — Primary key — NOT NULL — id
  • step — TINYINT — NOT NULL — step
  • transaction type (type) — VARCHAR(50) — NOT NULL — transaction type
  • status — VARCHAR(50) — NOT NULL — status
  • created date (created_at) — TIMESTAMP — NOT NULL — created date
  • updated date (updated_at) — TIMESTAMP — updated date
  • transaction key (transaction_id) — BIGINT — Foreign key → Transaction Management.id — NOT NULL — transaction key

Transaction Management (transaction)

  • id — BIGINT — Primary key — NOT NULL — id
  • transaction id (tx_id) — VARCHAR(40) — NOT NULL — transaction id
  • transaction type (type) — VARCHAR(50) — NOT NULL — transaction type
  • transaction status (status) — VARCHAR(50) — NOT NULL — transaction status
  • expiration date (expired_at) — TIMESTAMP — NOT NULL — expiration date
  • created date (created_at) — TIMESTAMP — NOT NULL — created date
  • updated date (updated_at) — TIMESTAMP — updated date

VP Offer Management (vp_offer)

  • id — BIGINT — Primary key — NOT NULL — id
  • Offer id (offer_id) — VARCHAR(40) — NOT NULL — Offer id
  • service id (service) — VARCHAR(40) — NOT NULL — service id
  • device — VARCHAR(40) — NOT NULL — device
  • payload — LONGTEXT — NOT NULL — payload
  • offer valid until (valid_until) — TIMESTAMP — offer valid until
  • passcode — VARCHAR(64)
  • vp policy id (vp_policy_id) — VARCHAR(40) — NOT NULL — vp policy id
  • created date (created_at) — TIMESTAMP — NOT NULL — created date
  • updated date (updated_at) — TIMESTAMP — updated date
  • transaction Key (transaction_id) — BIGINT — Foreign key → Transaction Management.id — NOT NULL — transaction Key

VP Profile Management (vp_profile)

  • id — BIGINT — Primary key — NOT NULL — id
  • Profile ID (profile_id) — VARCHAR(40) — NOT NULL — vp profile id
  • vp_profile — LONGTEXT — NOT NULL — vp profile
  • created date (created_at) — TIMESTAMP — NOT NULL — created date
  • updated date (updated_at) — TIMESTAMP — updated date
  • transaction key (transaction_id) — BIGINT — Foreign key → Transaction Management.id — NOT NULL — transaction key

VP Submit Management (vp_submit)

  • id — BIGINT — Primary key — NOT NULL — id
  • vp — LONGTEXT — NOT NULL — verfiable presentation
  • 생성일시 (created_at) — TIMESTAMP — NOT NULL — created date
  • 수정일시 (updated_at) — TIMESTAMP — updated date
  • 거래관리 Key (transaction_id) — BIGINT — Foreign key → Transaction Management.id — NOT NULL — transaction key