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