colorchips
Tables (13)
activitiy_guide
- activity_title — varchar(30) — Primary key — NOT NULL
- activity_mov — varchar(500)
activity
- activity_no — int — Primary key — NOT NULL
- activity_title — varchar(30)
- activity_image — text
- is_favorite — bool
- tag — varchar(10)
- per_time — int
- time — int
- equipment — varchar(20)
- set_no — int — NOT NULL
activity_daily_routine
- set_no — int — Primary key — NOT NULL
- set_title — varchar(10)
- weekly_no — int — NOT NULL
- dailty_no — int — NOT NULL
activity_record
- activity_date — date — Primary key — NOT NULL
activity_routine
- plan_no — int — Primary key — NOT NULL
- plan_name — varchar(20)
- duration — int
- goal_weight — float
activity_set
- count — int
- weight — int
- activity_no — int — NOT NULL
activity_weekly_routine
- weekly_no — int — Primary key — NOT NULL
- plan_no — int — NOT NULL
alarm
- no — int — Primary key — NOT NULL
- mon — varchar(6)
- tue — varchar(6)
- wed — varchar(6)
- thur — varchar(6)
- fri — varchar(6)
- sat — varchar(6)
- sun — varchar(6)
- permit — bool
daily
- dailty_no — int — Primary key — NOT NULL
- daily_date — date
- is_done — bool
- total_time — varchar(20)
- burned_ — calories`
grade
- grade — varchar(10) — Primary key — NOT NULL
- low — varchar(10)
- middle — varchar(10)
- high — varchar(10)
- uuid — varchar(50) — NOT NULL
inbody
- no — int — Primary key — NOT NULL
- height — float
- weight — float
- body_date — date
- bmr — float
- bodyfat — float
- bmi — float
- uuid — varchar(50) — NOT NULL
meal
- no — int — Primary key — NOT NULL
- meal_date — date
- brunch_image — text
- brunch_memo — text
- lunch_image — text
- lunch_memo — text
- dinner_image — text
- dinner_memo — text
member
- uuid — varchar(50) — Primary key — NOT NULL
- nick — varchar(10)
- birth — int
- gender — varchar(6)
- fhp — int
- pelvic_imbalance — int
- shoulder_imbalance — int