medicmagic
Tables (12)
user
- id — varchar(20) — Primary key
- name — varchar(20) — NOT NULL
- password — varchar(20) — NOT NULL
- birthday — date — NOT NULL
- age — int(11) — NOT NULL
userBirthControlPills
- id — varchar(20) — Foreign key → user.id
- pillsTime — time — NOT NULL
- pillsDate — date — NOT NULL
- days — int(11) — NOT NULL
userCalendar
- date — date — Primary key
- id — varchar(20) — Foreign key → user.id
- sleepTime — time — NOT NULL
- exerciseTime — time — NOT NULL
- waterIntake — double — NOT NULL
- startDay — date — NOT NULL
- endDay — date — NOT NULL
userExercise (Untitled)
- id — varchar(20) — Foreign key → user.id
- exerciseHour — double — NOT NULL
userHospital (Untitled2)
- id — varchar(20) — Foreign key → user.id
- hospitalDate — date — NOT NULL
- hospitalTime — time — NOT NULL
userMucus (Untitled3)
- date — date — Foreign key → userCalendar.date
- id — varchar(20) — Foreign key → userCalendar.id
- none — tinyint(1) — NOT NULL
- mottled — tinyint(1) — NOT NULL
- sticky — tinyint(1) — NOT NULL
- creamy — tinyint(1) — NOT NULL
- likeEggWhite — tinyint(1) — NOT NULL
- watery — tinyint(1) — NOT NULL
- abnormal — tinyint(1) — NOT NULL
userPhysiology (Untitled4)
- id — varchar(20) — Foreign key → user.id
- startPhysiology — date — NOT NULL
- endPhysiology — date — NOT NULL
- expectedOvulationDate — date — NOT NULL
- expectedPhysiologyDate — date — NOT NULL
userReminderList (Untitled5)
- id — varchar(20) — Foreign key → user.id
- birthControlPills — tinyint(1) — NOT NULL
- physiology — tinyint(1) — NOT NULL
- hospital — tinyint(1) — NOT NULL
- waterIntake — tinyint(1) — NOT NULL
- exerciseTimeGoal — tinyint(1) — NOT NULL
- sleepTimeGoal — tinyint(1) — NOT NULL
userReminderPhysiology (Untitled6)
- id — varchar(20) — Foreign key → user.id
- physiologyTime — time — NOT NULL
userSleep (Untitled7)
- id — varchar(20) — Foreign key → user.id
- sleepGoal — double — NOT NULL
userSymptom (Untitled8)
- date — date — Foreign key → userCalendar.date
- id — varchar(20) — Foreign key → userCalendar.id
- none — tinyint(1) — NOT NULL
- cramps — tinyint(1) — NOT NULL
- breastTenderness — tinyint(1) — NOT NULL
- headache — tinyint(1) — NOT NULL
- acne — tinyint(1) — NOT NULL
- lumbago — tinyint(1) — NOT NULL
- nausea — tinyint(1) — NOT NULL
- fatigue — tinyint(1) — NOT NULL
- abdominalBloating — tinyint(1) — NOT NULL
- desires — tinyint(1) — NOT NULL
- insomnia — tinyint(1) — NOT NULL
- constipation — tinyint(1) — NOT NULL
- diarrhea — tinyint(1) — NOT NULL
userWaterIntake (Untitled9)
- id — varchar(20) — Foreign key → user.id
- cups — double — NOT NULL
- waterTime — time — NOT NULL