My Trip Diary
Tables (8)
countries
- iso_code — TEXT — NOT NULL
- name — TEXT — NOT NULL
- currency_code — TEXT
- flag_emoji — TEXT
expenses
- id — TEXT — NOT NULL
- trip_id — TEXT — Foreign key → trips.id — NOT NULL
- amount — REAL — NOT NULL
- currency — TEXT
- category — TEXT — NOT NULL
- memo — TEXT
- expense_date — INTEGER — NOT NULL
- created_at — INTEGER — NOT NULL
- deleted_at — INTEGER
locations
- id — TEXT — NOT NULL
- trip_id — TEXT — Foreign key → trips.id — NOT NULL
- latitude — REAL — NOT NULL
- longitude — REAL — NOT NULL
- accuracy — REAL
- created_at — INTEGER — NOT NULL
- deleted_at — INTEGER
photo_clusters
- id — TEXT — NOT NULL
- trip_id — TEXT — Foreign key → trips.id — NOT NULL
- location_name — TEXT
- country_code — TEXT — Foreign key → countries.iso_code
- timezone_offset — INTEGER — NOT NULL
- representative_latitude — REAL — NOT NULL
- representative_longitude — REAL — NOT NULL
- cluster_memo — TEXT
- created_at — INTEGER — NOT NULL
- deleted_at — INTEGER
photos
- id — TEXT — NOT NULL
- trip_id — TEXT — Foreign key → trips.id — NOT NULL
- cluster_id — TEXT — Foreign key → photo_clusters.id
- asset_id — TEXT — NOT NULL
- uri — TEXT — NOT NULL
- latitude — REAL
- longitude — REAL
- accuracy — REAL
- created_at — INTEGER — NOT NULL
- status — TEXT
- is_favorite — INTEGER
- reviewed_at — INTEGER
- deleted_at — INTEGER
trip_diaries
- id — TEXT — NOT NULL
- trip_id — TEXT — Foreign key → trips.id — NOT NULL
- diary_date — TEXT — NOT NULL
- content — TEXT — NOT NULL
- mood — TEXT
- weather — TEXT
- created_at — INTEGER — NOT NULL
- updated_at — INTEGER — NOT NULL
- deleted_at — INTEGER
- UNIQUE(trip_id, — diary_date)
- CHECK — (mood IN ('🤩', '😊', '😶', '😴', '😥'))
- CHECK — (weather IN ('☀️', '☁️', '🌧️', '❄️', '🌬️'))
trips
- id — TEXT — NOT NULL
- name — TEXT — NOT NULL
- start_date — INTEGER — NOT NULL
- end_date — INTEGER — NOT NULL
- is_active — INTEGER
- cover_photo_id — TEXT
- created_at — INTEGER — NOT NULL
- updated_at — INTEGER — NOT NULL
- deleted_at — INTEGER
- CHECK — (is_active IN (0, 1))
visit_countries
- id — TEXT — NOT NULL
- trip_id — TEXT — Foreign key → trips.id — NOT NULL
- country_code — TEXT — Foreign key → countries.iso_code — NOT NULL
- entered_at — INTEGER — NOT NULL
- created_at — INTEGER — NOT NULL
- UNIQUE(trip_id, — country_code)