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