kyvc core erd

Tables (7)

credential_status

  • issuer_account — VARCHAR(128) — Primary key — NOT NULL
  • holder_account — VARCHAR(128) — Primary key — NOT NULL
  • credential_type — VARCHAR(160) — Primary key — NOT NULL
  • flags — INT — NOT NULL
  • expiration — BIGINT
  • uri — TEXT
  • updated_at — VARCHAR(32) — NOT NULL

did_documents

  • did — VARCHAR(255)
  • document_json — LONGTEXT — NOT NULL
  • updated_at — VARCHAR(32) — NOT NULL

issued_credentials

  • credential_id — VARCHAR(255)
  • issuer_did — VARCHAR(255) — NOT NULL
  • issuer_account — VARCHAR(128) — NOT NULL
  • holder_did — VARCHAR(255) — NOT NULL
  • holder_account — VARCHAR(128) — NOT NULL
  • credential_type — VARCHAR(160) — NOT NULL
  • vc_core_hash — VARCHAR(128) — NOT NULL
  • vc_json — LONGTEXT — NOT NULL
  • created_at — VARCHAR(32) — NOT NULL
  • revoked_at — VARCHAR(32)
  • INDEX — idx_issued_credentials_status

provider_selection_history

  • id — BIGINT — NOT NULL
  • category — VARCHAR(32) — Foreign key → provider_selections.category — NOT NULL
  • previous_provider — VARCHAR(128)
  • previous_profile — VARCHAR(128)
  • new_provider — VARCHAR(128) — NOT NULL
  • new_profile — VARCHAR(128) — NOT NULL
  • changed_by — VARCHAR(255)
  • changed_at — VARCHAR(32) — NOT NULL
  • INDEX — idx_provider_selection_history_category_time

provider_selections

  • category — VARCHAR(32)
  • provider — VARCHAR(128) — NOT NULL
  • profile — VARCHAR(128) — NOT NULL
  • active — TINYINT(1) — NOT NULL
  • updated_by — VARCHAR(255)
  • updated_at — VARCHAR(32) — NOT NULL

verification_challenges

  • challenge — VARCHAR(255)
  • domain — VARCHAR(255) — NOT NULL
  • expires_at — VARCHAR(32) — NOT NULL
  • used_at — VARCHAR(32)
  • created_at — VARCHAR(32) — NOT NULL
  • presentation_definition_json — LONGTEXT

verification_logs

  • id — BIGINT — NOT NULL
  • subject_id — VARCHAR(255)
  • ok — TINYINT(1) — NOT NULL
  • errors_json — LONGTEXT — NOT NULL
  • details_json — LONGTEXT — NOT NULL
  • verified_at — VARCHAR(32) — NOT NULL