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