모바일중재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)