activity

Tables (9)

Resorts (스키장)

  • 스키장 식별자 (resort_id) — Primary key — NOT NULL
  • 스키장 이름 (name)
  • 홈페이지 주소 (homepage_url)
  • 주소 (location_address)
  • 연락처 (contact_number)
  • 개장일 (start_date)
  • 폐장일 (end_date)

events (Untitled4)

  • Key (event_id) — Primary key — NOT NULL
  • Field (event_type)
  • Field2 (start_date)
  • Field (end_date)
  • Field (discount_type)
  • Field (discount_value)
  • Field (use_start_date)
  • Field (use_end_date)

product_events (Untitled3)

  • Key (event_id) — Foreign key → events.Key — NOT NULL
  • product_id — Foreign key → products.product_id — NOT NULL
  • Field

product_price_options (Untitled2)

  • option_id — Primary key — NOT NULL
  • day_type (Field2)
  • person_type (Field3)
  • price (Field4)
  • product_id — Foreign key → products.product_id — NOT NULL

product_usage_periods (Untitled)

    products (Untitled5)

    • product_id — Primary key — NOT NULL
    • 상품명 (product_name)
    • 상품설명 (description)
    • 상품타입 (product_type)
    • 상품사용 시간 (duration_hours)
    • 상품 시작일자 (start_date)
    • 상품 종료일자 (end_date)

    rental_gear (렌탈 장비 정보)

    • 렌탈 장비 식별자 (rental_gear_id) — Primary key — NOT NULL
    • 장비 이름 (name)
    • 액티비티 종류 (category)

    resort_level (스키장 회원 등급)

    • 스키장 회원 등급 식별자 (resort_level_id)

    users (Untitled6)

    • Key (user_id) — Primary key — NOT NULL
    • Field (name)
    • Field2 (birth_date)
    • Field3 (phone)
    • Field (member_type)
    • (has_season_pass)
    • Field (created_at)
    • Field (is_deleted)
    • Field (updated_at)