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