Health

Tables (5)

Periods (Period)

  • info id (Id_info) — INT — Foreign key → personal info.info id — NOT NULL
  • login Id (Id_login) — INT — Foreign key → personal info.login Id — NOT NULL — used to identify login information of each user
  • lastBegin_Period (Begin_last) — DATE — the beginning date of the last period
  • lastEnd_Period (lastBegin_Period) — DATE
  • nextBegin_estimate (Next_Begin) — DATE
  • End date this month (Begin_this) — DATE
  • End date this month (End_this) — DATE — NOT NULL — end date of this month

chat history (Chat_his)

  • chat id (Id_chat) — INT — Primary key — NOT NULL
  • login Id (Id_login) — INT — Foreign key → login info.login Id — NOT NULL — used to identify login information of each user
  • chat date (Time_chat) — DATETIME — The time of history chats

login info (Info_Log)

  • login Id (Id_login) — INT — Primary key — NOT NULL — used to identify login information of each user
  • Login_Type (Type_login) — Varchar(1) — used to identify the login type of this user, whether use Google account or Facebook or Microsoft
  • Login_Account (Acc_Log) — varchar(20) — the login account name of the user based on the login_type eg. if log in with a google account, this should be a google…

message_chat (Messag_chat)

  • chat id (Id_chat) — INT — Foreign key → chat history.chat id — NOT NULL
  • login Id (Id_login) — INT — Foreign key → chat history.login Id — NOT NULL — used to identify login information of each user
  • message Time (MessaTime) — Time
  • message content (MessCon) — Varchar(200)

personal info (Info_per)

  • info id (Id_info) — INT — Primary key — NOT NULL
  • login Id (Id_login) — INT — Foreign key → login info.login Id — NOT NULL — used to identify login information of each user
  • BloodSugar (BloodSug) — SMALLINT — NOT NULL — the blood sugar of each user used to be shown on the dashboard
  • HeartRate (Heart_rate) — SMALLINT — the heart rate of each user used to be shown on the dashboard
  • Blood Pressure (Press_blood) — SMALLINT — blood pressure of each user used to be shown on the dashboard
  • Height — SMALLINT — the height of each user used to be shown on the dashboard
  • weight (Weight) — SMALLINT — The weight of each user used to be shown on the dashboard
  • chest_info (Chest_info) — FLOAT — chest of each user used for body measurement
  • waist_info (Waist_info) — FLOAT — the waist of each user used for body measurement
  • Hip (Hip_info) — FLOAT — the hip of each user used for body measurement
  • Field