MedicalWallet

Tables (17)

ai_report_source_documents

  • id — UUID — Primary key — NOT NULL
  • report_id — UUID — Foreign key → ai_reports.id — NOT NULL
  • document_id — UUID — Foreign key → medical_documents.id — NOT NULL

ai_reports

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • report_type_id — INTEGER — Foreign key → report_types.id — NOT NULL
  • recommendations — JSONB — NOT NULL
  • analysis_result — JSONB — NOT NULL
  • model_version — VARCHAR(50) — NOT NULL
  • generated_at — TIMESTAMP — NOT NULL

blockchain_records

  • id — UUID — Primary key — NOT NULL
  • document_id — UUID — Foreign key → medical_documents.id
  • report_id — UUID — Foreign key → ai_reports.id
  • chain_name — VARCHAR(100) — NOT NULL
  • transaction_hash — VARCHAR(200) — NOT NULL
  • sha256_hash — VARCHAR(64) — NOT NULL
  • block_number — VARCHAR(100)
  • record_type — VARCHAR(50) — NOT NULL
  • verification_status — VARCHAR(50) — NOT NULL
  • recorded_at — TIMESTAMP — NOT NULL

delegation_document_type_permissions

  • id — UUID — Primary key — NOT NULL
  • delegation_id — UUID — Foreign key → delegations.id — NOT NULL
  • doc_type_id — INTEGER — Foreign key → document_types.id — NOT NULL

delegation_types

  • id — SERIAL — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • label_ko — VARCHAR(100) — NOT NULL

delegations

  • id — UUID — Primary key — NOT NULL
  • delegator_user_id — UUID — Foreign key → users.id — NOT NULL
  • delegate_user_id — UUID — Foreign key → users.id — NOT NULL
  • delegation_type_id — INTEGER — Foreign key → delegation_types.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • granted_at — TIMESTAMP — NOT NULL
  • expires_at — TIMESTAMP
  • revoked_at — TIMESTAMP

document_types

  • id — SERIAL — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • label_ko — VARCHAR(100) — NOT NULL
  • fhir_resource_type — VARCHAR(100) — NOT NULL

institutions

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • address — VARCHAR(300)
  • phone — VARCHAR(20)

medical_document_files

  • id — UUID — Primary key — NOT NULL
  • document_id — UUID — Foreign key → medical_documents.id — NOT NULL
  • storage_type — VARCHAR(20) — NOT NULL
  • path_or_url — TEXT — NOT NULL
  • is_encrypted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

medical_documents

  • id — UUID — Primary key — NOT NULL
  • owner_user_id — UUID — Foreign key → users.id — NOT NULL
  • doc_type_id — INTEGER — Foreign key → document_types.id — NOT NULL
  • institution_id — UUID — Foreign key → institutions.id
  • fhir_data — JSONB — NOT NULL
  • sha256_hash — VARCHAR(64) — NOT NULL
  • issued_at — DATE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

recipient_types

  • id — SERIAL — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • label_ko — VARCHAR(100) — NOT NULL

report_types

  • id — SERIAL — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • label_ko — VARCHAR(100) — NOT NULL

share_token_documents

  • id — UUID — Primary key — NOT NULL
  • share_token_id — UUID — Foreign key → share_tokens.id — NOT NULL
  • document_id — UUID — Foreign key → medical_documents.id — NOT NULL
  • shared_fields — JSONB — NOT NULL

share_tokens

  • id — UUID — Primary key — NOT NULL
  • created_by_user_id — UUID — Foreign key → users.id — NOT NULL
  • recipient_type_id — INTEGER — Foreign key → recipient_types.id — NOT NULL
  • recipient_identifier — VARCHAR(300) — NOT NULL
  • redis_key — VARCHAR(300) — NOT NULL
  • token_value — TEXT — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • used_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

user_dids

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • did_value — VARCHAR(500) — NOT NULL
  • omni_one_token — TEXT
  • verification_method — VARCHAR(100) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • verified_at — TIMESTAMP — NOT NULL
  • expires_at — TIMESTAMP

user_profiles

  • user_id — UUID — Foreign key → users.id — NOT NULL
  • emergency_contact_name — VARCHAR(100)
  • emergency_contact_phone — VARCHAR(20)
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • email — VARCHAR(200)
  • birth_date — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL