TAS
Tables (11)
Entity Information (entity)
- id — BIGINT — Primary key — NOT NULL
- entity did (did) — VARCHAR(200) — NOT NULL — entity did
- entity name (name) — VARCHAR(200) — NOT NULL — entity name
- entity role (role) — VARCHAR(30) — NOT NULL — entity role
- entity status (status) — VARCHAR(50) — NOT NULL — entity status
- entity server URL (server_url) — VARCHAR(2000) — NOT NULL — entity server URL
- entity's certificate VC URL (certificate_url) — VARCHAR(2000) — entity's certificate VC URL
- created date (created_at) — TIMESTAMP — NOT NULL — created date
- updated date (updated_at) — TIMESTAMP — updated date
App Information (app)
- id — BIGINT — Primary key — NOT NULL — entity table key
- app ID (app_id) — VARCHAR(20) — NOT NULL — app ID
- push token (push_token) — VARCHAR(255) — push token
- app status (status) — VARCHAR(50) — NOT NULL — app status
- created date (created_at) — TIMESTAMP — NOT NULL — created date
- updated date (updated_at) — TIMESTAMP — updated date
- user table key (user_id) — BIGINT — Foreign key → User Information.id — NOT NULL — user table key
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
DID Offer Transaction Management (did_offer)
- id — BIGINT — Primary key — NOT NULL — id
- did offer id (offier_id) — VARCHAR(40) — NOT NULL — did offer id
- did offer type (type) — VARCHAR(50) — NOT NULL — did offer type
- user did (did) — VARCHAR(200) — NOT NULL — user did
- did offer expiration date (valid_until) — TIMESTAMP — did offer expiration date
- created date (created_at) — TIMESTAMP — NOT NULL — created date
- updated date (updated_at) — TIMESTAMP — updated date
- transaction management table key (transaction_id) — BIGINT — Foreign key → Transaction Management.id — transaction management table key
ECDH Transaction Management (ecdh)
- id — BIGINT — Primary key — NOT NULL — id
- client did (client_did) — VARCHAR(200) — NOT NULL — client did
- session key (session_key) — VARCHAR(100) — NOT NULL — session key
- nonce — VARCHAR(100) — NOT NULL — nonce
- cipher type (cipher) — VARCHAR(20) — NOT NULL — cipher type
- padding type (padding) — VARCHAR(20) — NOT NULL — padding type
- created date (created_at) — TIMESTAMP — NOT NULL — created date
- updated date (updated_at) — TIMESTAMP — updated date
- transaction management table key (transaction_id) — BIGINT — Foreign key → Transaction Management.id — NOT NULL — transaction management table key
Sub-Transaction Management (sub_transaction)
- id — BIGINT — Primary key — NOT NULL — id
- sub transaction step (step) — SMALLINT — NOT NULL — sub transaction step
- sub transaction type (type) — VARCHAR(50) — NOT NULL — sub transaction type
- sub transaction status (status) — VARCHAR(50) — NOT NULL — sub transaction status
- created date (created_at) — TIMESTAMP — NOT NULL — created date
- updated date (updated_at) — TIMESTAMP — updated date
- transaction table key (transaction_id) — BIGINT — Foreign key → Transaction Management.id — NOT NULL — transaction table key
TAS Information (tas)
- id — BIGINT — Primary key — NOT NULL — id
- tas did (did) — VARCHAR(200) — NOT NULL — tas did
- tas name (name) — VARCHAR(200) — NOT NULL — tas name
- tas status (status) — VARCHAR(50) — NOT NULL — tas status
- tas server URL (server_url) — VARCHAR(2000) — NOT NULL — tas server URL
- tas's certificate VC URL (certificate_url) — VARCHAR(2000) — tas's certificate VC URL
- created date (created_at) — TIMESTAMP — NOT NULL — created date
- updated date (updated_at) — TIMESTAMP — updated date
Token Management (token)
- id — BIGINT — Primary key — NOT NULL — id
- token purpose (purpose) — VARCHAR(50) — NOT NULL — token purpose
- token — VARCHAR(200) — NOT NULL — token
- app id (app_id) — VARCHAR(20) — NOT NULL — app id
- wallet id (wallet_id) — VARCHAR(200) — NOT NULL — wallet id
- token expiration date (expired_at) — TIMESTAMP — NOT NULL — wallet id
- created date (created_at) — TIMESTAMP — NOT NULL — created date
- updated date (updated_at) — TIMESTAMP — updated date
- transaction management table key (transaction_id) — BIGINT — Foreign key → Transaction Management.id — NOT NULL — transaction management table 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
- transaction target did (did) — VARCHAR(200) — transaction target did
- DID Auth nonce (auth_nonce) — VARCHAR(100) — DID Auth nonce
- certificate VC ID (certificate_id) — VARCHAR(50) — certificate VC ID
- external server transaction id (external_tx_id) — VARCHAR(40) — external server transaction id
- external server did (external_did) — VARCHAR(200) — external server did
- user pii (pii) — VARCHAR(100) — user pii
- 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
User Information (user)
- id — BIGINT — Primary key — NOT NULL — id
- user did (did) — VARCHAR(200) — NOT NULL — did
- usser status (status) — VARCHAR(50) — NOT NULL — user status
- user pii (pii) — VARCHAR(100) — NOT NULL — pii
- created date (created_at) — TIMESTAMP — NOT NULL — created date
- updated date (updated_at) — TIMESTAMP — updated date
Wallet Information (wallet)
- id — BIGINT — Primary key — NOT NULL — id
- wallet ID (wallet_id) — VARCHAR(200) — NOT NULL — wallet ID
- wallet did (did) — VARCHAR(200) — NOT NULL — wallet did
- wallet status (status) — VARCHAR(50) — NOT NULL — wallet status
- wallet registeration date (registered_at) — TIMESTAMP — NOT NULL — wallet registeration date
- wallet termination date (cancelled_at) — TIMESTAMP — wallet termination date
- created date (created_at) — TIMESTAMP — NOT NULL — created date
- updated date (updated_at) — TIMESTAMP — updated date
- user table key (user_id) — BIGINT — Foreign key → User Information.id — user table key
- entity table key (entity_id) — BIGINT — Foreign key → Entity Information.id — NOT NULL — entity table key