웰니스: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