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