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