mvp

Tables (3)

archive

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamptz
  • user_id — uuid
  • place_id — bigint — Foreign key → place.id
  • source_url — text
  • note — text

place

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamptz
  • name — text — NOT NULL
  • address — text — NOT NULL
  • latitude — double precision
  • longitude — double precision
  • photo_url — text
  • dedup_key — text — NOT NULL

profiles

  • id — uuid — Primary key — NOT NULL
  • created_at — timestamptz
  • nickname — text
  • avatar_url — text