Issuer

Tables (9)

Certificate VC (certificate_vc)

  • id — BIGINT — Primary key — NOT NULL — id
  • vc — text — NOT NULL — vc
  • create at (created_at) — TIMESTAMP — NOT NULL — create at
  • update at (updated_at) — TIMESTAMP — update at

E2E (e2e)

  • id — BIGINT — Primary key — NOT NULL — id
  • session key (session_key) — VARCHAR(300) — NOT NULL — session key
  • nonce — VARCHAR(100) — NOT NULL — nonce
  • curve — VARCHAR(20) — NOT NULL — curve
  • cipher — VARCHAR(20) — NOT NULL — cipher
  • 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

Revoke VC list (revoke_vc)

  • id — BIGINT — Primary key — NOT NULL — id
  • Issuer Nonce (nonce) — VARCHAR(100) — NOT NULL — Issuer Nonce
  • VC ID (vc_id) — VARCHAR(40) — NOT NULL — VC ID
  • revoke status (status) — VARCHAR(20) — revoke 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

User info management (user)

  • id — BIGINT — Primary key — NOT NULL — id
  • pii — VARCHER(100) — pii
  • user data (data) — TEXT — NOT NULL — user data
  • did — VARCHAR(200) — did
  • created date (created_at) — TIMESTAMP — NOT NULL — created date
  • updated date (updated_at) — TIMESTAMP — updated date

VC (vc)

  • id — BIGINT — Primary key — NOT NULL — id
  • Issued date (issued_at) — TIMESTAMP — NOT NULL — Issued date
  • holder DID (did) — VARCHAR(200) — NOT NULL — holder DID
  • VC ID (vc_id) — VARCHAR(40) — NOT NULL — VC ID
  • transaction ID (tx_id) — VARCHAR(40) — NOT NULL — transaction ID
  • expiration date (expired_at) — TIMESTAMP — NOT NULL — expiration date
  • VC plain id (vc_plan_id) — VARCHAR(20) — NOT NULL — VC plain id
  • created date (created_at) — TIMESTAMP — NOT NULL — created date
  • updated date (updated_at) — TIMESTAMP — updated date
  • User key (user_id) — BIGINT — Foreign key → User info management.id — NOT NULL — User key

VC Offer (vc_offer)

  • id — BIGINT — Primary key — NOT NULL — id
  • offer id (offer_id) — VARCHAR(40) — NOT NULL — offer id
  • offer type (offer_type) — VARCHAR(50) — NOT NULL — offer type
  • VC plan id (vc_plan_id) — VARCHAR(20) — NOT NULL — VC plan id
  • Issuer DID (did) — VARCHAR(200) — NOT NULL — Issuer DID
  • offer valid until (valid_until) — TIMESTAMP — offer valid until
  • 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 — transaction key

VC Profile (vc_profile)

  • id — BIGINT — Primary key — NOT NULL — id
  • profile id (profile_id) — VARCHAR(40) — NOT NULL — profile id
  • holder DID (did) — VARCHAR(200) — NOT NULL — holder DID
  • Issuer Nonce (nonce) — VARCHAR(100) — NOT NULL — Issuer Nonce
  • 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
  • user key (user_id) — BIGINT — Foreign key → User info management.id — user key

sub_transaction management (sub_transaction)

  • id — BIGINT — Primary key — NOT NULL — id
  • step — INTEGER — 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
  • status — VARCHAR(50) — NOT NULL — status
  • VC plan id (vc_plan_id) — VARCHAR(20) — VC plan id
  • reference ID (ref_id) — VARCHAR(20) — reference ID
  • expiration date (expired_at) — TIMESTAMP — expiration date
  • created date (created_at) — TIMESTAMP — NOT NULL — created date
  • updated date (updated_at) — TIMESTAMP — updated date