AIBE6 team2
Tables (12)
accessibility_info
- place_id — BIGINT — Foreign key → places.id
- parking — BOOLEAN
- elevator — BOOLEAN
- escalator — BOOLEAN
- route — BOOLEAN
- lift — BOOLEAN
- restroom — BOOLEAN
- wheelchair — BOOLEAN
- stroller — BOOLEAN
- braille_block — BOOLEAN
- braille_guide — BOOLEAN
- audio_guide — BOOLEAN
- sign_guide — BOOLEAN
- nursing_room — BOOLEAN
- diaper_changing — BOOLEAN
- guide_dog — BOOLEAN
- accessible_room — BOOLEAN
- notes — TEXT
- updated_at — TIMESTAMP
categories
- id — SMALLINT
- name — VARCHAR(50) — NOT NULL
- icon — VARCHAR(10)
- has_accessibility — BOOLEAN
favorites
- id — BIGSERIAL
- user_id — UUID — Foreign key → users.id — NOT NULL
- place_id — BIGINT — Foreign key → places.id — NOT NULL
- created_at — TIMESTAMP
- UNIQUE(user_id, — place_id)
- INDEX — idx_favorites_user
- INDEX — idx_favorites_place
places
- id — BIGINT
- category_id — SMALLINT — Foreign key → categories.id — NOT NULL
- region_code — SMALLINT — Foreign key → regions.code
- title — VARCHAR(200) — NOT NULL
- address — TEXT
- address_detail — VARCHAR(200)
- zipcode — VARCHAR(10)
- latitude — DECIMAL(10, 8)
- longitude — DECIMAL(11, 8)
- tel — VARCHAR(50)
- image_url — TEXT
- image_thumbnail_url — TEXT
- homepage_url — TEXT
- overview — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_places_category
- INDEX — idx_places_region
- INDEX — idx_places_title
- INDEX — idx_places_location
regions
- code — SMALLINT
- name — VARCHAR(50) — NOT NULL
- parent_code — SMALLINT
review_helpful
- id — BIGSERIAL
- review_id — BIGINT — Foreign key → reviews.id — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP
- UNIQUE(review_id, — user_id)
- INDEX — idx_review_helpful_review
- INDEX — idx_review_helpful_user
review_images
- id — BIGSERIAL
- review_id — BIGINT — Foreign key → reviews.id — NOT NULL
- image_url — TEXT — NOT NULL
- created_at — TIMESTAMP
- INDEX — idx_review_images_review
reviews
- id — BIGSERIAL
- user_id — UUID — Foreign key → users.id — NOT NULL
- place_id — BIGINT — Foreign key → places.id — NOT NULL
- rating — SMALLINT
- content — TEXT
- accessibility_rating — SMALLINT
- helpful_count — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_reviews_user
- INDEX — idx_reviews_place
- INDEX — idx_reviews_rating
sync_logs
- id — BIGSERIAL
- sync_type — VARCHAR(50) — NOT NULL
- category_id — SMALLINT — Foreign key → categories.id
- total_count — INTEGER
- success_count — INTEGER
- fail_count — INTEGER
- error_message — TEXT
- started_at — TIMESTAMP
- completed_at — TIMESTAMP
- INDEX — idx_sync_logs_type
- INDEX — idx_sync_logs_started
trip_plan_items
- id — BIGSERIAL
- trip_plan_id — BIGINT — Foreign key → trip_plans.id — NOT NULL
- place_id — BIGINT — Foreign key → places.id — NOT NULL
- day_number — SMALLINT — NOT NULL
- order_number — SMALLINT — NOT NULL
- visit_time — TIME
- duration_minutes — INTEGER
- memo — TEXT
- created_at — TIMESTAMP
- INDEX — idx_trip_plan_items_plan
- INDEX — idx_trip_plan_items_place
- INDEX — idx_trip_plan_items_day
trip_plans
- id — BIGSERIAL
- user_id — UUID — Foreign key → users.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- start_date — DATE
- end_date — DATE
- is_public — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_trip_plans_user
- INDEX — idx_trip_plans_dates
users
- id — UUID
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100)
- profile_image_url — TEXT
- disability_type — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP