운동처방

테이블 (28)

agonist (Untitled10)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • name (Field) — varchar(255)

ai_script_exercise (a_script_exercise)

  • id (Key2) — int(11) — 기본 키 — NOT NULL
  • user_id (Key3) — int(11) — 외래 키 → ai_script_week.user_id — NOT NULL
  • ai_script_week_id (Key22) — int(11) — 외래 키 → ai_script_week.ai_script_master_id — NOT NULL
  • exercise_id (Key4) — int(11) — 외래 키 → exercise.id — NOT NULL
  • exercise_name (Field) — varchar(255)
  • goal_count (Field3) — varchar(255)
  • execute_count (Field4) — varchar(255)
  • created_at (Field5) — timestamp
  • updated_at (Field2) — timestamp

ai_script_exercise_set (a_script_exercise_set)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • ai_script_exercise_id (Key2) — int(11) — 외래 키 → ai_script_exercise.id — NOT NULL
  • user_id (Key3) — int(11) — 외래 키 → ai_script_exercise.user_id — NOT NULL
  • set_num (Field2) — int(11)
  • is_default (Field3) — int(11)
  • repeat_count (Field) — int(11)
  • weight (Field4) — int(11)
  • weight_unit (Field6) — int(11)
  • distance (Field5) — string
  • distance_unit (Field7) — int(11)
  • time (Field8) — varchar(255)
  • time_unit (Field9) — int(11)
  • created_at (Field10) — timestamp
  • updated_at (Field11) — timestamp
  • speed (Field12) — float
  • speed_unit (Field13) — int(11)
  • kal (Field14) — float

ai_script_exercise_type (Untitled12)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • exercise_type (Field) — int(11)
  • exercise_day_per_week (Field2) — int(11)

ai_script_master (a_script_master)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • user_id (Key3) — int(11) — 외래 키 → user.id — NOT NULL
  • doctor_script_id (Key2) — int(11) — 외래 키 → doctor_script.id — NOT NULL
  • hospital_id (Key22) — int(11) — 외래 키 → doctor.hospital_id — NOT NULL
  • script_name (Field2) — varchar(255)
  • start_dt (Field) — timestamp
  • end_dt (Field3) — timestamp
  • is_script (Field5) — int(11)
  • exercise_count (Field10) — int(11)
  • created_at (Field6) — timestamp
  • updated_at (Field7) — timestamp

ai_script_week (a_script_week)

  • id (Key4) — int(11) — 기본 키 — NOT NULL
  • user_id (Key3) — int(11) — 외래 키 → ai_script_master.user_id — NOT NULL
  • ai_script_master_id (Key2) — int(11) — 외래 키 → ai_script_master.doctor_script_id — NOT NULL
  • week (Field3) — int(11)
  • start_dt (Field) — date
  • end_dt (Field2) — date
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

chart (Untitled4)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • doctor_id (Key2) — int(11) — 외래 키 → doctor.id — NOT NULL
  • title (Field) — varchar(255)
  • is_use (Field2) — int(11)

chart_question (Untitled5)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • chart_id (Key2) — int(11) — 외래 키 → chart.id — NOT NULL
  • question_no (Key3) — int(11) — 외래 키 → question.id — NOT NULL
  • created_at (Field) — timestamp
  • updated_at (Field2) — timestamp

common_code (Untitled)

  • id (Key) — int(5) — 기본 키 — NOT NULL
  • type (Field) — varchar(255)
  • text (Field2) — varchar(255)
  • value (Field3) — int(11)
  • description (Field4) — varchar(255)
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp

doctor

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • hospital_id (Key2) — int(11) — 외래 키 → hospital.id — NOT NULL
  • login_id (Field) — varchar(255)
  • password (Field4) — varchar(255)
  • name (Field8) — varchar(255)
  • resident_registration_number (Field5) — varchar(255)
  • age (Field6) — int(11)
  • birthday (Field7) — varchar(255)
  • birthday_type (Field9) — int(11)
  • mobile (Field10) — varchar(255)
  • address (Field11) — varchar(255)
  • address_detail (Field12) — varchar(255)
  • note (Field2) — varchar(255)
  • email (Field3) — varchar(255)
  • major (Field13) — varchar(255)
  • created_at (Field14) — timestamp
  • updated_at (Field15) — timestamp

doctor_script (h_script)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • user_id (Key2) — int(11) — 외래 키 → user.id — NOT NULL
  • doctor_id (Key3) — int(11) — 외래 키 → doctor.id — NOT NULL
  • script (Field) — varchar(255)
  • weight (Field3) — float
  • disease (Field4) — varchar(255)
  • low_blood_pressure (Field5) — int(11)
  • high_blood_pressure (Field6) — int(11)
  • heart_rate (Field7) — int(11)
  • skeletal_muscle_mass (Field8) — float
  • fat_mass (Field9) — float
  • fat_rate (Field10) — float
  • symptom (Field11) — varchar(255)
  • memo (Field12) — varchar(255)
  • is_smoking (Field13) — int(11)
  • is_drinking (Field14) — int(11)
  • bmi (Field15) — float
  • hct (Field16) — float
  • rbc (Field17) — float
  • wbc (Field18) — float
  • platelet (Field19) — float
  • hba1c (Field20) — float
  • glu (Field21) — float
  • fbs (Field22) — float
  • ld_col (Field23) — float
  • hd_col (Field24) — float
  • is_heart_disease (Field25) — int
  • is_peripheral_vascular_disease (Field26) — int
  • is_lung_disease (Field27) — int
  • is_cerebrovascular_disease (Field28) — int
  • is_asthma (Field29) — int
  • is_kidney_disease (Field30) — int
  • is_liver_disease (Field31) — int
  • is_musculoskeletal_disease (Field32) — int
  • is_obesity (Field33) — int
  • is_high_blood_pressure (Field34) — int
  • is_diabetes (Field35) — int
  • is_tuberculosis (Field36) — int
  • is_hepatitis (Field37) — int
  • is_thyroid_disease (Field38) — int
  • is_cancer (Field39) — int
  • is_itch (Field40) — int
  • created_at (Field41) — timestamp
  • updated_at (Field42) — timestamp

exercise

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • user_id (Key2) — int(11) — 외래 키 → user.id — NOT NULL
  • name (Field) — varchar(255)
  • exercise_title (Field2) — varchar(255)
  • exercise_type (Field3) — int(11)
  • measure_type (Field4) — int(11)
  • is_default (Field5) — int(11)
  • created_at (Field6) — timestamp
  • updated_at (Field7) — timestamp

exercise_agonist (Untitled11)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • exercise_id (Key2) — int(11) — 외래 키 → exercise.id — NOT NULL
  • agonist_id (Key3) — int(11) — 외래 키 → agonist.id — NOT NULL

exercise_result (result)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • ai_script_exercise_set_id (Key22) — int(11) — 외래 키 → ai_script_exercise_set.ai_script_exercise_id — NOT NULL
  • user_id (Key3) — int(11) — 외래 키 → ai_script_exercise_set.user_id — NOT NULL
  • result_value (Field2) — int(11)
  • kcal (Field5) — varchar(255)
  • exercise_time (Field4) — int(11)
  • created_at (Field6) — timestamp
  • updated_at (Field) — timestamp

faq

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • title (Field) — varchar(255)
  • content (Field2) — varchar(255)
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

fitness

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • name (Field) — varchar(255)
  • address (Field2) — varchar(255)
  • latitude (Field3) — varchar(255)
  • longitude (Field4) — varchar(255)
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp

fitness_machine

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • exercise_id (Key2) — int(11) — 외래 키 → exercise.id — NOT NULL
  • fitness_id (Key3) — int(11) — 외래 키 → fitness.id — NOT NULL
  • name (Field) — varchar(255)
  • created_at (Field2) — timestamp
  • updated_at (Field3) — timestamp

hospital

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • name (Field) — varchar(255)
  • created_at (Field2) — timestamp
  • updated_at (Field3) — timestamp

notice

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • user_id (Key2) — int(11) — 외래 키 → user.id — NOT NULL
  • title (Field) — varchar(255)
  • content (Field2) — varchar(255)
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

notification

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • user_id (Key2) — int(11) — 외래 키 → user.id — NOT NULL
  • title (Field) — varchar(255)
  • content (Field2) — varchar(255)
  • status (Field3) — int(11)
  • type (Field4) — varchar(255)
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp

qna (Untitled8)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • user_id (Key2) — int(11) — 외래 키 → user.id — NOT NULL
  • type (Field) — enum
  • title (Field2) — varchar(255)
  • question (Field3) — text
  • answer (Field4) — text
  • answerYN (Field5) — enum
  • answered_at (Field6) — timestamp
  • created_at (Field7) — timestamp
  • updated_at (Field8) — timestamp

question (Untitled2)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • doctor_id (Key2) — int(11) — 외래 키 → doctor.id — NOT NULL
  • type (Field) — int(11)
  • title (Field2) — varchar(255)
  • is_use (Field3) — int(11)
  • is_single_selection (Field4) — int(11)
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp

question_example (Untitled3)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • question_id (Key2) — int(11) — 외래 키 → question.id — NOT NULL
  • content (Field) — varchar(255)
  • order_no (Field2) — int(11)
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

user

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • hospital_id (Field19) — int(11)
  • name (Field) — varchar(255)
  • gender (Field3) — varchar(255)
  • mobile (Field2) — varchar(255)
  • blood_type (Field14) — int(11)
  • resident_registration_number (Field17) — varchar(255)
  • birthday (Field5) — varchar(255)
  • birthday_type (Field18) — int(11)
  • email (Field20) — varchar(255)
  • age (Field4) — int(11)
  • height (Field6) — float
  • weight (Field21) — int(11)
  • memo (Field22) — varchar(255)
  • uuid (Field23) — varchar(255)
  • firebase_token (Field8) — varchar(255)
  • is_agree_location (Field9) — int(11)
  • is_agree_exer (Field10) — int(11)
  • is_agree_result (Field11) — int(11)
  • is_agree_noti (Field12) — int(11)
  • address (Field15) — varchar(255)
  • address_detail (Field16) — varchar(255)
  • benchpress_1rm (Field24) — float
  • legpress_1rm (Field25) — float
  • profile_path (Field26) — varchar(255)
  • profile_name (Field27) — varchar(255)
  • profile_thumb_path (Field28) — varchar(255)
  • profile_thumb_name (Field29) — varchar(255)
  • created_at (Field7) — timestamp
  • updated_at (Field13) — timestamp

user_chart (Untitled6)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • user_id (Key2) — int(11) — 외래 키 → user.id — NOT NULL
  • hospital_id (Key3) — int(11) — 외래 키 → hospital.id — NOT NULL
  • chart_name (Field2) — varchar(255)
  • attending_physician_opinion (Field3) — varchar(255)
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

user_chart_answer (Untitled9)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • user_chart_question_id (Key2) — int(11) — 외래 키 → user_chart_question.id — NOT NULL
  • subjective_answer (Field) — varchar(255)
  • example_no (Field2) — int(11)
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

user_chart_question (Untitled7)

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • user_chart_id (Key2) — int(11) — 외래 키 → user_chart.id — NOT NULL
  • question (Field) — varchar(255)
  • answer (Field2) — varchar(255)
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

user_status

  • id (Key) — int(11) — 기본 키 — NOT NULL
  • heart_rate (Field) — smallint(6)
  • low_blood_pressure (Field2) — smallint(6)
  • high_blood_pressure (Field6) — smallint(6)
  • bmi (Field3) — smallint(6)
  • first_create_dt (Field4) — date
  • last_update_dt (Field5) — date