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