웰니스:RebornFit
테이블 (20)
Certification
- userToken — varchar(200) — 외래 키 → User.userToken — NOT NULL
- refreshToken — text
- idx — varchar(100)
Disease_type
- diseaseCode — varchar(50) — 기본 키 — NOT NULL
- mainCategory — varchar(50) — NOT NULL
- middleCategory — varchar(50) — NOT NULL
- subCategory — varchar(50) — NOT NULL
- diseaseName — varchar(256) — NOT NULL
- diseaseExplain — varchar(50)
Evaluate
- idx — int — 기본 키 — NOT NULL
- userToken — varchar(200) — 외래 키 → User.userToken — NOT NULL
- rLogNum — int — 외래 키 → Routine_log.rLogNum — NOT NULL
- exerciseToken — varchar(128) — 외래 키 → Exercise.exerciseToken
- first — int
- second — int
- third — int
- rating — double
- fifth — varchar(20)
Exercise
- exerciseToken — varchar(128) — 기본 키 — NOT NULL
- exerciseName — varchar(128)
- exercise — varchar(256)
- exerciseType — varchar(50) — NOT NULL
- exerciseSet — int
- exerciseExplain — varchar(50)
- difficulty — varchar(100)
- repeat — int
- exerciseTime — varchar(100)
- holdingTime — varchar(100)
- restTimeS — varchar(100)
- restTimeR — varchar(100)
- staticVAS — varchar(100)
- dynamicVAS — varchar(100)
Exercise_bookmark
- idx — int — 기본 키 — NOT NULL
- userToken — varchar(200) — 외래 키 → User.userToken — NOT NULL
- exerciseToken — varchar(128) — 외래 키 → Exercise.exerciseToken — NOT NULL
- createdAt — timestamp — NOT NULL
Exercise_exCriteria_D
- exerciseToken — varchar(128) — 외래 키 → Exercise.exerciseToken — NOT NULL
- exDiseaseCode — varchar(50) — NOT NULL
Exercise_exCriteria_P
- exerciseToken — varchar(128) — 외래 키 → Exercise.exerciseToken — NOT NULL
- exPainCode — varchar(50) — NOT NULL
Exercise_inCriteria_D
- exerciseToken — varchar(128) — 외래 키 → Exercise.exerciseToken — NOT NULL
- inDiseaseCode — varchar(50) — NOT NULL
Exercise_inCriteria_P
- exerciseToken — varchar(128) — 외래 키 → Exercise.exerciseToken — NOT NULL
- inAreaCode — varchar(50) — NOT NULL
Inquiry
- inquiryToken — int — 기본 키 — NOT NULL
- isAlliance — tinyint(1) — NOT NULL
- userToken — varchar(200) — 외래 키 → User.userToken — NOT NULL
- content — text
- answer — text
- isAnswer — tinyint(1) — NOT NULL
- badUserToken — varchar(20)
- createdAt — timestamp — NOT NULL
Notice
- idx — int — 기본 키 — NOT NULL
- title — text
- content — text
- createdAt — timestamp — NOT NULL
Pain
- painCode — varchar(128) — NOT NULL
- painType — varchar(128) — NOT NULL
- Field — varchar(255)
- Field2 — varchar(255)
- areaCode — varchar(50) — 외래 키 → PainArea.areaCode — NOT NULL
PainArea
- areaCode — varchar(50) — 기본 키 — NOT NULL
- mainCategory — varchar(50) — NOT NULL
- middleCategory — varchar(50) — NOT NULL
- subCategory — varchar(50) — NOT NULL
Pain_status
- userToken — varchar(200) — 외래 키 → User.userToken — NOT NULL
- purpose — varchar(20) — NOT NULL
- diseaseCode — varchar(50)
- painSpot — varchar(128)
- static — int — NOT NULL
- dynamic — int — NOT NULL
- createdAt — timestamp — NOT NULL
Play_log
- logNum — int — 기본 키 — NOT NULL
- playTime — varchar(100) — NOT NULL
- userToken — varchar(200) — 외래 키 → User.userToken — NOT NULL
- rLogNum — int — NOT NULL
Routine
- routineToken — varchar(200) — 기본 키 — NOT NULL
- title — varchar(20) — NOT NULL
- totalTime — varchar(200) — NOT NULL
- recomand — tinyint(1) — NOT NULL
Routine_bookmark
- idx — int — 기본 키 — NOT NULL
- userToken — varchar(200) — 외래 키 → User.userToken — NOT NULL
- rLogNum — int — 외래 키 → Routine_log.rLogNum — NOT NULL
- createdAt — timestamp — NOT NULL
Routine_log
- rLogNum — int — 기본 키 — NOT NULL
- routineToken — varchar(200) — 외래 키 → Routine.routineToken — NOT NULL
- userToken — varchar(200) — 외래 키 → User.userToken — NOT NULL
- createdAt — timestamp — NOT NULL
User
- userToken — varchar(200) — 기본 키 — NOT NULL
- userType — varchar(10) — NOT NULL
- email — varchar(50) — NOT NULL
- name — varchar(20)
- profileImg — varchar(100)
- weight — int
- height — int
- gender — varchar(10)
- birth — varchar(20)
- level — varchar(20)
- agree — tinyint(1)
- diseaseCode — varchar(50)
- pastCode — varchar(50)
- createdAt — timestamp — NOT NULL
r_v
- routineToken — varchar(200) — 외래 키 → Routine.routineToken — NOT NULL
- exerciseToken — varchar(128) — 외래 키 → Exercise.exerciseToken — NOT NULL
- createdAt — timestamp — NOT NULL