freeway

Tables (10)

bookmarks

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid
  • place_id — text — Foreign key → places.content_id
  • created_at — timestamp

places

  • content_id — text — Primary key — NOT NULL
  • content_type — text
  • title — text
  • address — text
  • addr2 — text
  • tel — text
  • lat — real
  • lng — real
  • image_url — text
  • image_url2 — text
  • parking — text
  • publictransport — text
  • route — text
  • ticketoffice — text
  • promotion — text
  • wheelchair — text
  • exit — text
  • elevator — text
  • restroom — text
  • auditorium — text
  • room — text
  • handicapetc — text
  • braileblock — text
  • helpdog — text
  • guidehuman — text
  • audioguide — text
  • bigprint — text
  • brailepromotion — text
  • guidesystem — text
  • blindhandicapetc — text
  • signguide — text
  • videoguide — text
  • hearingroom — text
  • hearinghandicapetc — text
  • stroller — text
  • lactationroom — text
  • babysparechair — text
  • infantsfamilyetc — text
  • created_at — timestamp

post

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid
  • title — text — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp

post_comments

  • id — uuid — Primary key — NOT NULL
  • post_id — uuid — Foreign key → post.id
  • user_id — uuid
  • content — text — NOT NULL
  • created_at — timestamp

post_images

  • id — uuid — Primary key — NOT NULL
  • post_id — uuid — Foreign key → post.id
  • user_id — uuid
  • image_url — text — NOT NULL
  • created_at — timestamp

post_likes

  • id — uuid — Primary key — NOT NULL
  • post_id — uuid — Foreign key → post.id
  • user_id — uuid
  • created_at — timestamp

review_comments

  • id — uuid — Primary key — NOT NULL
  • review_id — uuid — Foreign key → reviews.id
  • user_id — uuid
  • content — text — NOT NULL
  • created_at — timestamp

review_images

  • id — uuid — Primary key — NOT NULL
  • review_id — uuid — Foreign key → reviews.id
  • user_id — uuid
  • image_url — text — NOT NULL
  • created_at — timestamp

review_likes

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid
  • review_id — uuid — Foreign key → reviews.id
  • created_at — timestamp

reviews

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid
  • place_id — text — Foreign key → places.content_id
  • content — text — NOT NULL
  • score_entrance — integer
  • score_interior — integer
  • score_facility — integer
  • created_at — timestamp