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