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