모바일중재AI

테이블 (18)

cgm_zone_bucket

  • bucket_id — BIGINT
  • cgm_id — BIGINT — NOT NULL
  • zone — VARCHAR(30) — NOT NULL
  • percent — DECIMAL(6,3) — NOT NULL

codebook_prepost_pair

  • pair_id — BIGINT
  • codebook_version_id — BIGINT — NOT NULL
  • pre_variable_name — VARCHAR(200) — NOT NULL
  • post_variable_name — VARCHAR(200) — NOT NULL
  • pair_group — VARCHAR(100)
  • compare_flag — VARCHAR(50)

codebook_variable

  • var_id — BIGINT
  • codebook_version_id — BIGINT — NOT NULL
  • variable_name — VARCHAR(200) — NOT NULL
  • unit — VARCHAR(50)
  • value_type — VARCHAR(50)
  • description — TEXT
  • data_file_no — VARCHAR(50)
  • section — VARCHAR(100)
  • notes — TEXT

consult_message

  • consult_message_id — BIGINT
  • session_id — BIGINT — NOT NULL
  • role — VARCHAR(30) — NOT NULL
  • content — TEXT
  • created_at — DATETIME
  • meta — TEXT

intervention_message

  • message_id — BIGINT
  • enrollment_id — BIGINT — NOT NULL
  • week_no — INT
  • category — VARCHAR(30)
  • channel — VARCHAR(50)
  • status — VARCHAR(30)
  • draft_content — TEXT
  • final_content — TEXT
  • generated_at — DATETIME
  • approved_at — DATETIME
  • sent_at — DATETIME
  • hitl_reviewer_id — BIGINT
  • error_message — TEXT

intervention_profile

  • profile_id — BIGINT
  • enrollment_id — BIGINT — NOT NULL
  • risk_level — VARCHAR(50)
  • segment_tag — VARCHAR(100)
  • last_evaluated_at — DATETIME

lifelog_alcohol

  • id — BIGINT
  • enrollment_id — BIGINT — NOT NULL
  • drank_at — DATETIME — NOT NULL
  • drink_count — INT
  • drink_amount — VARCHAR(200)
  • source — VARCHAR(100)

lifelog_bodycomp

  • id — BIGINT
  • enrollment_id — BIGINT — NOT NULL
  • measured_at — DATETIME — NOT NULL
  • skeletal_muscle_kg — DECIMAL(7,2)
  • body_fat_percent — DECIMAL(5,2)
  • source — VARCHAR(100)

lifelog_meal

  • meal_id — BIGINT
  • enrollment_id — BIGINT — NOT NULL
  • eaten_at — DATETIME — NOT NULL
  • menu_text — TEXT
  • source — VARCHAR(100)

lifelog_nutrition

  • nutrition_id — BIGINT
  • meal_id — BIGINT — NOT NULL
  • total_kcal — DECIMAL(10,2)
  • carbs_g — DECIMAL(10,2)
  • sugar_g — DECIMAL(10,2)
  • protein_g — DECIMAL(10,2)
  • fat_g — DECIMAL(10,2)
  • sodium_mg — DECIMAL(10,2)
  • raw_json — TEXT

lifelog_steps

  • id — BIGINT
  • enrollment_id — BIGINT — NOT NULL
  • measured_at — DATETIME — NOT NULL
  • steps — INT
  • distance_m — DECIMAL(10,2)
  • calories — DECIMAL(10,2)
  • source — VARCHAR(100)

lifelog_weight

  • id — BIGINT
  • enrollment_id — BIGINT — NOT NULL
  • measured_at — DATETIME — NOT NULL
  • weight_kg — DECIMAL(7,2) — NOT NULL
  • source — VARCHAR(100)

participant_medication

  • med_id — BIGINT
  • participant_id — BIGINT — NOT NULL
  • medication_name — VARCHAR(200) — NOT NULL
  • dose — VARCHAR(200)
  • frequency — VARCHAR(200)
  • start_date — DATE
  • end_date — DATE
  • note — TEXT

program

  • program_id — BIGINT
  • name — VARCHAR(200) — NOT NULL
  • duration_weeks — INT
  • description — TEXT

raw_ingest_record

  • ingest_record_id — BIGINT
  • ingest_file_id — BIGINT — NOT NULL
  • enrollment_id — BIGINT
  • row_no — INT
  • payload — TEXT
  • created_at — DATETIME

survey_answer

  • survey_answer_id — BIGINT
  • survey_response_id — BIGINT — NOT NULL
  • question_id — BIGINT — NOT NULL
  • answer_value — TEXT
  • answer_text — TEXT

survey_question

  • question_id — BIGINT
  • survey_form_id — BIGINT — NOT NULL
  • question_code — VARCHAR(100) — NOT NULL
  • question_text — TEXT
  • answer_type — VARCHAR(30)
  • unit — VARCHAR(50)

survey_response

  • survey_response_id — BIGINT
  • enrollment_id — BIGINT — NOT NULL
  • survey_form_id — BIGINT — NOT NULL
  • phase — VARCHAR(10) — NOT NULL
  • responded_at — DATETIME
  • total_score — DECIMAL(10,2)