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