semosan
Tables (15)
courses
- id — BIGSERIAL — Primary key — NOT NULL
- mountain_id — BIGINT — Foreign key → mountains.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- difficulty — difficulty_level — NOT NULL
- distance — DECIMAL(5,2) — NOT NULL
- estimated_time — INT — NOT NULL
- is_primary — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
facilities
- id — BIGSERIAL — Primary key — NOT NULL
- mountain_id — BIGINT — Foreign key → mountains.id — NOT NULL
- type — facility_type — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
mountain_images
- id — BIGSERIAL — Primary key — NOT NULL
- mountain_id — BIGINT — Foreign key → mountains.id — NOT NULL
- url — VARCHAR(500) — NOT NULL
- display_order — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
mountain_restaurants
- mountain_id — BIGINT — Foreign key → mountains.id — NOT NULL
- restaurant_id — BIGINT — Foreign key → restaurants.id — NOT NULL
- distance_meters — INT — NOT NULL
mountain_traffic_info
- mountain_id — BIGINT — Foreign key → mountains.id — NOT NULL
- public_transit_info — TEXT
- car_info — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
mountains
- id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- altitude — INT — NOT NULL
- difficulty — difficulty_level — NOT NULL
- sido — VARCHAR(20) — NOT NULL
- sigungu — VARCHAR(30) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- location — GEOGRAPHY(POINT, 4326) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
restaurant_categories
- id — BIGSERIAL — Primary key — NOT NULL
- code — VARCHAR(50) — NOT NULL
- label — VARCHAR(50) — NOT NULL
- display_order — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
restaurant_menus
- id — BIGSERIAL — Primary key — NOT NULL
- restaurant_id — BIGINT — Foreign key → restaurants.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- display_order — INT — NOT NULL
restaurants
- id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- location — GEOGRAPHY(POINT, 4326) — NOT NULL
- category_id — BIGINT — Foreign key → restaurant_categories.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
review_images
- id — BIGSERIAL — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → reviews.id — NOT NULL
- url — VARCHAR(500) — NOT NULL
- display_order — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
review_tag_types
- id — BIGSERIAL — Primary key — NOT NULL
- code — VARCHAR(50) — NOT NULL
- label — VARCHAR(100) — NOT NULL
- display_order — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
review_tags
- review_id — BIGINT — Foreign key → reviews.id — NOT NULL
- tag_type_id — BIGINT — Foreign key → review_tag_types.id — NOT NULL
reviews
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- mountain_id — BIGINT — Foreign key → mountains.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- id — BIGSERIAL — Primary key — NOT NULL
- email — VARCHAR(50)
- name — VARCHAR(30)
- nickname — VARCHAR(10) — NOT NULL
- profile_url — VARCHAR(255)
- device_type — device_type — NOT NULL
- onboarding_status — onboarding_status — NOT NULL
- oauth_id — VARCHAR(255) — NOT NULL
- oauth_provider — oauth_provider — NOT NULL
- refresh_token — VARCHAR(512)
- gender — gender
- age — INT
- weight — DOUBLE
- fcm_token — VARCHAR(255)
- is_deleted — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
weather_forecasts
- id — BIGSERIAL — Primary key — NOT NULL
- sido — VARCHAR(20) — NOT NULL
- sigungu — VARCHAR(30) — NOT NULL
- forecast_date — DATE — NOT NULL
- condition — weather_condition — NOT NULL
- temperature_min — INT
- temperature_max — INT
- precipitation_probability — INT
- sunrise_time — TIME
- sunset_time — TIME
- fetched_at — TIMESTAMP — NOT NULL