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)