운동처방
테이블 (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