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