diary

Tables (6)

diary_generations

  • id — int8 — Primary key — NOT NULL
  • trip_day_id (id2) — int8 — Foreign key → trip_days.id — NOT NULL
  • model_used — varchar(100) — NOT NULL
  • prompt_text — text
  • response_text — text
  • input_tokens — int4
  • output_tokens — int4
  • duration_ms — int4
  • status — varchar(20) — NOT NULL
  • error_message — text
  • created_at — timestamp — NOT NULL

photo_generations

  • id — int8 — Primary key — NOT NULL
  • photo_id (id2) — int8 — Foreign key → photos.id — NOT NULL
  • model_used — varchar(100) — NOT NULL
  • analysis_text — text
  • analysis_json — jsonb
  • input_tokens — int4
  • output_tokens — int4
  • status — varchar(20) — NOT NULL
  • created_at — timestamp — NOT NULL
  • place_type — varchar(40)
  • indoor_outdoor — varchar(20)
  • landmark_guess — varchar(200)
  • landmark_confidence — numeric(4, 3)
  • people_type — varchar(40)
  • people_importance — varchar(40)
  • time_hint — varchar(40)
  • time_confidence — numeric(4, 3)
  • total_tokens — int4

photos

  • id — int8 — Primary key — NOT NULL
  • user_id (id3) — int8 — Foreign key → users.id — NOT NULL
  • trip_day_id (id2) — int8 — Foreign key → trip_days.id — NOT NULL
  • file_url — varchar(500) — NOT NULL
  • thumbnail_url — varchar(500)
  • original_filename — varchar(255)
  • file_size_bytes — int8
  • mime_type — varchar(50)
  • width — int4
  • height — int4
  • latitude — numeric(10, 7)
  • longitude — numeric(10, 7)
  • location_name — varchar(300)
  • place_id — varchar(200)
  • tz — varchar(40)
  • taken_at_utc — timestamptz
  • content_hash — varchar(64)
  • exif — jsonb
  • display_order — int4 — NOT NULL
  • created_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • country_name — varchar(120)
  • city_name — varchar(120)

trip_days

  • id — int8 — Primary key — NOT NULL
  • trip_id (id2) — int8 — Foreign key → trips.id — NOT NULL
  • day_number — int4 — NOT NULL
  • date — date — NOT NULL
  • location_summary — varchar(200)
  • weather — varchar(50)
  • representative_lat — numeric(10, 7)
  • representative_lon — numeric(10, 7)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • subtitle — varchar(200)
  • emotion — varchar(50)
  • represent_image — int8
  • content — text
  • word_count — int4
  • generated_at — timestamp

trips

  • id — int8 — Primary key — NOT NULL
  • user_id (id2) — int8 — Foreign key → users.id — NOT NULL
  • title — varchar(200) — NOT NULL
  • destination — varchar(200)
  • start_date — date — NOT NULL
  • end_date — date — NOT NULL
  • cover_photo_id — int8
  • status — varchar(20) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • flag — varchar(50)

users

  • id — int8 — Primary key — NOT NULL
  • user_uuid — varchar(100) — NOT NULL
  • nickname — varchar(50)
  • profile_image_url — varchar(500)
  • writing_persona — varchar(50)
  • dark_mode — bool — NOT NULL
  • push_enabled — bool — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • travel_style_analysis — varchar(500)
  • travel_style_analysis_requested_at — timestamp