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