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)