scenediary

Tables (7)

diaries

  • id — BIGINT
  • trip_day_id — BIGINT — Foreign key → trip_days.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(200)
  • content — TEXT — NOT NULL
  • tone — VARCHAR(50)
  • word_count — INT
  • generated_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • tags — VARCHAR(200)

diary_generations

  • id — BIGINT
  • diary_id — BIGINT — NOT NULL
  • model_used — VARCHAR(100) — NOT NULL
  • prompt_text — TEXT
  • response_text — TEXT
  • input_tokens — INT
  • output_tokens — INT
  • duration_ms — INT
  • status — VARCHAR(20) — NOT NULL
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL

photo_generations

  • id — BIGINT
  • photo_id — BIGINT — NOT NULL
  • model_used — VARCHAR(100) — NOT NULL
  • analysis_text — TEXT
  • analysis_json — JSON
  • input_tokens — INT
  • output_tokens — INT
  • created_at — TIMESTAMP — NOT NULL

photos

  • id — BIGINT
  • trip_day_id — BIGINT — Foreign key → trip_days.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • thumbnail_url — VARCHAR(500)
  • original_filename — VARCHAR(255)
  • file_size_bytes — BIGINT
  • mime_type — VARCHAR(50)
  • width — INT
  • height — INT
  • taken_at — TIMESTAMP
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • location_name — VARCHAR(300)
  • place_id — VARCHAR(200)
  • display_order — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

trip_days

  • id — BIGINT
  • trip_id — BIGINT — Foreign key → trips.id — NOT NULL
  • day_number — INT — NOT NULL
  • date — DATE — NOT NULL
  • location_summary — VARCHAR(200)
  • weather — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

trips

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • destination — VARCHAR(200)
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • cover_photo_id — BIGINT
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

users

  • id — BIGINT
  • device_id — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL — 사용자 (인증 없음, 기기 단위 식별)'; CREATE INDEX idx_users_device_id ON users(device_i