DIO_Final
Tables (46)
ai_jobs
- ai_job_id — BIGINT — Primary key — NOT NULL
- job_type — VARCHAR(30) — NOT NULL
- source_media_file_id — UUID — Foreign key → media_files.media_file_id — NOT NULL
- result_media_file_id — UUID — Foreign key → media_files.media_file_id
- status — VARCHAR(20) — NOT NULL
- error_code — VARCHAR(50)
- error_message — VARCHAR(500)
- requested_at — TIMESTAMPTZ(6) — NOT NULL
- started_at — TIMESTAMPTZ(6)
- completed_at — TIMESTAMPTZ(6)
block_warning_dismissals
- blocker_user_id — BIGINT — Foreign key → user_blocks.blocker_user_id — NOT NULL
- blocked_user_id — BIGINT — Foreign key → user_blocks.blocked_user_id — NOT NULL
- diary_id — UUID — Foreign key → diaries.diary_id — NOT NULL
canvas_elements
- element_id — UUID — Primary key — NOT NULL
- page_id — UUID — Foreign key → pages.page_id — NOT NULL
- element_type — VARCHAR(20) — NOT NULL
- group_id — UUID
- name — VARCHAR(100)
- sort_key — DECIMAL(20,10) — NOT NULL
- x — DECIMAL(12,3) — NOT NULL
- y — DECIMAL(12,3) — NOT NULL
- width — DECIMAL(12,3) — NOT NULL
- height — DECIMAL(12,3) — NOT NULL
- rotation — DECIMAL(7,3) — NOT NULL
- opacity — DECIMAL(4,3) — NOT NULL
- is_locked — BOOLEAN — NOT NULL
- is_hidden — BOOLEAN — NOT NULL
- media_file_id — UUID — Foreign key → media_files.media_file_id
- properties_json — JSONB
- created_by — BIGINT — Foreign key → users.user_id
- version — BIGINT — NOT NULL
- created_at — TIMESTAMPTZ(6) — NOT NULL
- updated_at — TIMESTAMPTZ(6) — NOT NULL
- deleted_at — TIMESTAMPTZ(6)
canvas_history_operations
- operation_id — BIGINT — Primary key — NOT NULL
- page_id — UUID — Foreign key → pages.page_id — NOT NULL
- actor_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- client_operation_id — UUID — NOT NULL
- operation_type — VARCHAR(20) — NOT NULL
- snapshot_format — VARCHAR(30) — NOT NULL
- before_state_json — JSONB — NOT NULL
- after_state_json — JSONB — NOT NULL
- status — VARCHAR(20) — NOT NULL
- undone_at — TIMESTAMPTZ(6)
- created_at — TIMESTAMPTZ(6) — NOT NULL
diaries
- diary_id — UUID — Primary key — NOT NULL
- owner_user_id — BIGINT — Foreign key → users.user_id
- owner_device_id — VARCHAR(64)
- title — VARCHAR(100) — NOT NULL
- cover_color — CHAR(7) — NOT NULL
- cover_style — VARCHAR(30) — NOT NULL
- visibility — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ(6) — NOT NULL
- updated_at — TIMESTAMPTZ(6) — NOT NULL
- deleted_at — TIMESTAMPTZ(6)
- version — BIGINT — NOT NULL
- cover_json — TEXT
- paper_appearance_json — TEXT
- template_config_json — TEXT
diary_creation_receipts
- key_hash — CHAR(64) — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- request_hash — CHAR(64) — NOT NULL
- diary_id — UUID — Foreign key → diaries.diary_id
- response_body — JSONB
- created_at — TIMESTAMPTZ(6) — NOT NULL
- completed_at — TIMESTAMPTZ(6)
diary_handwriting_fonts
- diary_id — UUID — Foreign key → diaries.diary_id — NOT NULL
- font_media_file_id — UUID — Foreign key → media_files.media_file_id — NOT NULL
- granted_by_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- is_enabled — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ(6) — NOT NULL
- disabled_at — TIMESTAMPTZ(6)
diary_invites
- invite_id — BIGINT — Primary key — NOT NULL
- diary_id — UUID — Foreign key → diaries.diary_id — NOT NULL
- inviter_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- invitee_user_id — BIGINT — Foreign key → users.user_id
- invite_type — VARCHAR(20) — NOT NULL
- token_hash — BYTEA — NOT NULL
- role — VARCHAR(20) — NOT NULL
- max_uses — INT
- use_count — INT — NOT NULL
- expires_at — TIMESTAMPTZ(6) — NOT NULL
- revoked_at — TIMESTAMPTZ(6)
- created_at — TIMESTAMPTZ(6) — NOT NULL
- retention_until — TIMESTAMPTZ(6) — NOT NULL
diary_media_library
- diary_id — UUID — Foreign key → diaries.diary_id — NOT NULL
- media_file_id — UUID — Foreign key → media_files.media_file_id — NOT NULL
- added_by_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- library_category — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ(6) — NOT NULL
diary_members
- diary_id — UUID — Foreign key → diaries.diary_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- member_color — CHAR(7) — NOT NULL
- is_favorite — BOOLEAN — NOT NULL
- last_opened_page_id — UUID — Foreign key → pages.page_id
- last_opened_at — TIMESTAMPTZ(6)
- joined_at — TIMESTAMPTZ(6) — NOT NULL
- left_at — TIMESTAMPTZ(6)
- member_nickname — VARCHAR(30)
- member_profile_photo_id — UUID — Foreign key → media_files.media_file_id
diary_purge_receipts
- diary_id — UUID — Primary key — NOT NULL
- owner_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- completed_at — TIMESTAMPTZ(6) — NOT NULL
element_strokes
- element_id — UUID — Foreign key → canvas_elements.element_id — NOT NULL
- tool — VARCHAR(20) — NOT NULL
- pen_kind — VARCHAR(20)
- color — CHAR(7) — NOT NULL
- stroke_width — DECIMAL(8,3) — NOT NULL
- line_cap — VARCHAR(10) — NOT NULL
- base_width — DECIMAL(12,3) — NOT NULL
- base_height — DECIMAL(12,3) — NOT NULL
- point_format — VARCHAR(30) — NOT NULL
- points — JSONB — NOT NULL
invitation_notification_receipts
- event_id — UUID — Primary key — NOT NULL
- recipient_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- invite_id — BIGINT — NOT NULL
- event_occurred_at — TIMESTAMPTZ(6) — NOT NULL
- outcome — VARCHAR(30) — NOT NULL
- notification_id — BIGINT — Foreign key → notifications.notification_id
- processed_at — TIMESTAMPTZ(6) — NOT NULL
media_files
- media_file_id — UUID — Primary key — NOT NULL
- owner_user_id — BIGINT — Foreign key → users.user_id
- owner_device_id — VARCHAR(64)
- media_type — VARCHAR(20) — NOT NULL
- source_type — VARCHAR(20) — NOT NULL
- source_media_file_id — UUID — Foreign key → media_files.media_file_id
- library_category — VARCHAR(20) — NOT NULL
- storage_key — VARCHAR(500) — NOT NULL
- original_filename — VARCHAR(255)
- mime_type — VARCHAR(100) — NOT NULL
- file_size — BIGINT — NOT NULL
- width — INT
- height — INT
- checksum_sha256 — CHAR(64)
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ(6) — NOT NULL
- deleted_at — TIMESTAMPTZ(6)
media_storage_deletion_queue
- deletion_id — UUID — Primary key — NOT NULL
- media_file_id — UUID — NOT NULL
- storage_key — VARCHAR(500) — NOT NULL
- queued_at — TIMESTAMPTZ(6) — NOT NULL
- attempt_count — INT — NOT NULL
- last_attempt_at — TIMESTAMPTZ(6)
- last_error — VARCHAR(1000)
- next_attempt_at — TIMESTAMPTZ(6) — NOT NULL
notification_read_watermark_items
- notification_id — BIGINT — Foreign key → notifications.notification_id — NOT NULL
- watermark_id — UUID — Foreign key → notification_read_watermarks.watermark_id — NOT NULL
notification_read_watermarks
- watermark_id — UUID — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- created_at — TIMESTAMPTZ(6) — NOT NULL
- expires_at — TIMESTAMPTZ(6) — NOT NULL
- applied_at — TIMESTAMPTZ(6)
notifications
- notification_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- actor_user_id — BIGINT — Foreign key → users.user_id
- diary_id — UUID — Foreign key → diaries.diary_id
- page_id — UUID — Foreign key → pages.page_id
- notification_type — VARCHAR(50) — NOT NULL
- payload_json — JSONB
- read_at — TIMESTAMPTZ(6)
- deleted_at — TIMESTAMPTZ(6)
- created_at — TIMESTAMPTZ(6) — NOT NULL
page_template_v27_backups
- page_id — UUID — Primary key — NOT NULL
- previous_template_id — BIGINT
- previous_template_config — JSONB
- previous_version — BIGINT — NOT NULL
- previous_updated_at — TIMESTAMPTZ(6) — NOT NULL
- backed_up_at — TIMESTAMPTZ(6) — NOT NULL
page_template_v35_links
- page_id — UUID — Primary key — NOT NULL
- linked_template_id — BIGINT — NOT NULL
- previous_version — BIGINT — NOT NULL
- previous_updated_at — TIMESTAMPTZ(6) — NOT NULL
- linked_at — TIMESTAMPTZ(6) — NOT NULL
page_templates
- template_id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(100) — NOT NULL
- template_version — VARCHAR(30) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(30) — NOT NULL
- orientation — VARCHAR(20) — NOT NULL
- canvas_width — DECIMAL(10,2) — NOT NULL
- canvas_height — DECIMAL(10,2) — NOT NULL
- default_config — JSONB
- display_order — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ(6) — NOT NULL
- updated_at — TIMESTAMPTZ(6) — NOT NULL
pages
- page_id — UUID — Primary key — NOT NULL
- diary_id — UUID — Foreign key → diaries.diary_id — NOT NULL
- template_id — BIGINT — Foreign key → page_templates.template_id
- template_config — JSONB
- title — VARCHAR(100)
- sort_key — DECIMAL(20,10) — NOT NULL
- canvas_width — DECIMAL(10,2) — NOT NULL
- canvas_height — DECIMAL(10,2) — NOT NULL
- grid_visible — BOOLEAN — NOT NULL
- grid_color — CHAR(7)
- version — BIGINT — NOT NULL
- created_at — TIMESTAMPTZ(6) — NOT NULL
- updated_at — TIMESTAMPTZ(6) — NOT NULL
- deleted_at — TIMESTAMPTZ(6)
password_reset_verifications
- email — VARCHAR(255) — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- code_hash — CHAR(64) — NOT NULL
- sent_at — TIMESTAMPTZ(6) — NOT NULL
- expires_at — TIMESTAMPTZ(6) — NOT NULL
- failed_attempts — INT — NOT NULL
- token_hash — CHAR(64)
- token_expires_at — TIMESTAMPTZ(6)
- consumed_at — TIMESTAMPTZ(6)
push_deliveries
- binding_version — BIGINT — Primary key — NOT NULL
- installation_id — UUID — Foreign key → push_installations.installation_id — NOT NULL
- outbox_id — UUID — Foreign key → push_outbox.outbox_id — NOT NULL
- token_version — BIGINT — NOT NULL
- status — VARCHAR(24) — NOT NULL
- attempt_count — INT — NOT NULL
- next_attempt_at — TIMESTAMPTZ(6)
- lease_until — TIMESTAMPTZ(6)
- lease_id — UUID
- provider_ticket_id — VARCHAR(255)
- result_code — VARCHAR(128)
- accepted_at — TIMESTAMPTZ(6)
- terminal_at — TIMESTAMPTZ(6)
push_installations
- installation_id — UUID — Primary key — NOT NULL
- environment — VARCHAR(32) — NOT NULL
- app_id — VARCHAR(160) — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- session_id — UUID — NOT NULL
- credential_hash — BYTEA — NOT NULL
- provider — VARCHAR(16) — NOT NULL
- platform — VARCHAR(16) — NOT NULL
- token_ciphertext — BYTEA
- token_key_id — VARCHAR(64)
- token_cipher_format — SMALLINT
- token_hash — BYTEA
- permission — VARCHAR(16) — NOT NULL
- enabled — BOOLEAN — NOT NULL
- binding_version — BIGINT — NOT NULL
- token_version — BIGINT — NOT NULL
- created_at — TIMESTAMPTZ(6) — NOT NULL
- updated_at — TIMESTAMPTZ(6) — NOT NULL
- disabled_at — TIMESTAMPTZ(6)
push_mutation_requests
- session_id — UUID — Primary key — NOT NULL
- installation_id — UUID — Primary key — NOT NULL
- request_id — UUID — Primary key — NOT NULL
- request_hash — BYTEA — NOT NULL
- operation — VARCHAR(16) — NOT NULL
- binding_version — BIGINT — NOT NULL
- token_version — BIGINT — NOT NULL
- result_provider — VARCHAR(16) — NOT NULL
- result_platform — VARCHAR(16) — NOT NULL
- result_permission — VARCHAR(16) — NOT NULL
- result_enabled — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ(6) — NOT NULL
push_outbox
- outbox_id — UUID — Primary key — NOT NULL
- event_key — VARCHAR(255) — NOT NULL
- notification_id — BIGINT — Foreign key → notifications.notification_id
- recipient_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- event_type — VARCHAR(64) — NOT NULL
- reference_id — VARCHAR(255)
- status — VARCHAR(24) — NOT NULL
- created_at — TIMESTAMPTZ(6) — NOT NULL
- expires_at — TIMESTAMPTZ(6) — NOT NULL
- environment — VARCHAR(32)
- app_id — VARCHAR(160)
- terminal_at — TIMESTAMPTZ(6)
push_registration_requests
- session_id — UUID — Primary key — NOT NULL
- installation_id — UUID — Primary key — NOT NULL
- request_id — UUID — Primary key — NOT NULL
- request_hash — BYTEA — NOT NULL
- encrypted_response — BYTEA
- response_key_id — VARCHAR(64)
- response_cipher_format — SMALLINT
- expires_at — TIMESTAMPTZ(6) — NOT NULL
- created_at — TIMESTAMPTZ(6) — NOT NULL
refresh_token_history
- token_hash — CHAR(64) — Primary key — NOT NULL
- token_id — BIGINT — Foreign key → refresh_tokens.token_id — NOT NULL
- rotated_at — TIMESTAMPTZ(6) — NOT NULL
refresh_tokens
- token_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- token_hash — CHAR(64) — NOT NULL
- device_name — VARCHAR(100)
- expires_at — TIMESTAMPTZ(6) — NOT NULL
- revoked_at — TIMESTAMPTZ(6)
- created_at — TIMESTAMPTZ(6) — NOT NULL
- session_id — UUID — NOT NULL
signup_email_verifications
- email — VARCHAR(255) — Primary key — NOT NULL
- code_hash — CHAR(64) — NOT NULL
- sent_at — TIMESTAMPTZ(6) — NOT NULL
- expires_at — TIMESTAMPTZ(6) — NOT NULL
- failed_attempts — INT — NOT NULL
- token_hash — CHAR(64)
- token_expires_at — TIMESTAMPTZ(6)
- consumed_at — TIMESTAMPTZ(6)
signup_profile_photos
- photo_id — UUID — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- image_bytes — BYTEA
- created_at — TIMESTAMPTZ(6) — NOT NULL
- storage_provider — VARCHAR(10)
- storage_key — VARCHAR(200)
- storage_bucket — VARCHAR(255)
user_auth_accounts
- auth_account_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_subject — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- linked_at — TIMESTAMPTZ(6) — NOT NULL
user_blocks
- blocked_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- blocker_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- created_at — TIMESTAMPTZ(6) — NOT NULL
user_cover_libraries
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- version — BIGINT — NOT NULL
- document_json — TEXT — NOT NULL
- updated_at — TIMESTAMPTZ(6) — NOT NULL
user_cover_library_media
- media_file_id — UUID — Foreign key → media_files.media_file_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
user_palettes
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- version — BIGINT — NOT NULL
- document_json — TEXT — NOT NULL
- updated_at — TIMESTAMPTZ(6) — NOT NULL
user_paper_libraries
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- version — BIGINT — NOT NULL
- document_json — TEXT — NOT NULL
- updated_at — TIMESTAMPTZ(6) — NOT NULL
user_paper_library_media
- media_file_id — UUID — Foreign key → media_files.media_file_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
user_reports
- report_id — BIGINT — Primary key — NOT NULL
- reporter_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- reported_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- diary_id — UUID — NOT NULL
- client_request_id — UUID — NOT NULL
- request_hash — VARCHAR(64) — NOT NULL
- reason_code — VARCHAR(40) — NOT NULL
- description — VARCHAR(1000)
- evidence_json — JSONB — NOT NULL
- status — VARCHAR(20) — NOT NULL
- action_type — VARCHAR(30)
- action_expires_at — TIMESTAMPTZ(6)
- resolution_note — TEXT
- handled_by — VARCHAR(100)
- created_at — TIMESTAMPTZ(6) — NOT NULL
- updated_at — TIMESTAMPTZ(6) — NOT NULL
- resolved_at — TIMESTAMPTZ(6)
- notification_status — VARCHAR(20) — NOT NULL
- notification_attempts — INT — NOT NULL
- notification_next_attempt_at — TIMESTAMPTZ(6)
- history_json — JSONB — NOT NULL
user_sticker_libraries
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- version — BIGINT — NOT NULL
- document_json — TEXT — NOT NULL
- updated_at — TIMESTAMPTZ(6) — NOT NULL
user_sticker_library_media
- media_file_id — UUID — Foreign key → media_files.media_file_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
user_tape_libraries
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- version — BIGINT — NOT NULL
- document_json — TEXT — NOT NULL
- updated_at — TIMESTAMPTZ(6) — NOT NULL
user_tape_library_media
- media_file_id — UUID — Foreign key → media_files.media_file_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
user_terms_agreements
- terms_type — VARCHAR(20) — Primary key — NOT NULL
- terms_version — VARCHAR(20) — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- agreed — BOOLEAN — NOT NULL
- agreed_at — TIMESTAMPTZ(6) — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- nickname — VARCHAR(30) — NOT NULL
- profile_img — CHAR(7) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- last_login_at — TIMESTAMPTZ(6)
- created_at — TIMESTAMPTZ(6) — NOT NULL
- updated_at — TIMESTAMPTZ(6) — NOT NULL
- deleted_at — TIMESTAMPTZ(6)
- nickname_key — VARCHAR(30) — NOT NULL
- profile_color — CHAR(7) — NOT NULL