haha
Tables (11)
cgms_authkey (auth_key)
- id — Long — Primary key — NOT NULL
- code — varchar
- state — varchar
- created_at — timestamp
- active_token — varchar
- refresh_token — varchar
- userid — long
- update_at — timestamp
cgms_data
- id — Long — Primary key — NOT NULL
- cgms_sensor_id — long — Foreign key → cgms_sensor.id — NOT NULL
- seq_number — long
- event_at — timestamp
- initial_value — int
- value — int
- trend_rate — float
- trend — int
- min_max_flag — int
cgms_sensor
- id — Long — Primary key — NOT NULL
- auth_key_id — Long — Foreign key → cgms_authkey.id — NOT NULL
- serial_number — varchar
- userid — long
- last_data_update_at — timestamp
- start_at — timestamp
- ended_at — timestamp
diet
- id — Long — Primary key — NOT NULL
- meal_time — varchar
- menu — varchar
- amount — varchar
- user_id — long
- create_at — timestamp
- update_at — timestamp
health_goal
- id — Long — Primary key — NOT NULL
- user_id — long
- contants — varchar
- frequency — int
- alarm_rate — int
- message — varchar
- update_at — timestamp
- created_at — timestamp
health_goal_check
- id — Long — Primary key — NOT NULL
- health_goal_id — Long — Foreign key → health_goal.id — NOT NULL
- day — varchar
- create_at — timestamp
- update_at — timestamp
- user_id — long
medication
- id — Long — Primary key — NOT NULL
- user_id — long
- name — varchar
- create_at — timestamp
- update_at — timestamp
- description — varchar
medication_answer
- id — Long — Primary key — NOT NULL
- medication_intake_id — long — Foreign key → medication_intakes.id — NOT NULL
- medication_taken — tinyint
- event_at — timestamp
- create_at — timestamp
- update_at — timestamp
medication_intakes
- id — Long — Primary key — NOT NULL
- medication_id (medication_idq) — Long — Foreign key → medication.id — NOT NULL
- user_id — long
- intake_timing — varchar
- event_date — varchar
- create_at — timestamp
- update_at — timestamp
reminder
- id — Long — Primary key — NOT NULL
- user_id — long
- title — varchar
- contents — varchar
- push_time — timestamp
- event_at — timestamp
- created_at — timestamp
- updated_at — timestamp
video_check
- id — Long — Primary key — NOT NULL
- user_id — long
- process_time — time
- create_at — timestamp
- update_at — timestamp
- video_info_id — long