dailyhealth

Tables (8)

biz_hour

  • id — int — Primary key
  • gym_id (Field) — int — NOT NULL
  • type — varchar(10) — 평일, 토요일. 공휴일 등
  • start_time — varchar(10)
  • end_time — varchar(10)
  • update_at — timestamp
  • create_at — timestamp

group_purchase (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • member_id (Field2)
  • price_id (Field) — varchar(50)
  • group_code (Field3)
  • update_at (Field4) — timestamp
  • create_at (Field5) — timestamp

gym

  • id — int — Primary key — NOT NULL
  • name — varchar(100)
  • address — varchar(200)
  • homepage — varchar(100)
  • phone — varchar(100)
  • gps_x — varchar(50)
  • gps_y — varchar(50)
  • subway_title — varchar(10)
  • subway_line — varchar(10)
  • subway_walktime — varchar(5) — 지하철역에서 걸어서 걸리는 시간
  • create_at — timestamp
  • update_at — timestamp
  • type — varchar(50) — 헬스장, PT, 필라테스

image

  • id — int — Primary key
  • gym_id — int
  • url — varchar(200)
  • order — int
  • create_at — timestamp
  • update_at — int

member

  • id (Key) — int — Primary key — NOT NULL
  • type (Field7) — varchar(50) — gym, user
  • gym_id (Field10) — int
  • nickname (Field9) — varchar(100)
  • email (Field) — varchar(100)
  • password (Field2) — varchar(100)
  • kakao_id (Field3) — varchar(100)
  • phone (Field4) — varchar(100)
  • create_at (Field5) — timestamp
  • update_at (Field8) — timestamp
  • last_login_at (Field6) — timestamp

options

  • id — int — Primary key
  • gym_id — int
  • type — varchar(10) — 와이파이, 화장실, 주차장 등
  • order — int — 노출 순서
  • update_at — timestamp
  • create_at — timestamp

price

  • id — int — Primary key
  • gym_id — int
  • workout_type (Key) — varchar(500) — NOT NULL — health, pt, pilates
  • period_type — varchar(10) — day, month
  • period — int — 기간
  • price_type (Field2) — varchar(100) — 정상가, 공동구매가
  • price — int
  • discount_price — int
  • order (Field) — int — 순서
  • update_at — timestamp
  • create_at — timestamp

price_suggest

  • id — int — Primary key
  • gym_id — int
  • period — int
  • period_type — varchar(10) — DAY, MONTH
  • price — int
  • create_at — timestamp
  • update_at — timestamp