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