Kinoko_prototype

Tables (4)

CultureMedium (Untitled)

  • Key — Primary key — NOT NULL
  • Temperature (Field2)
  • Humidity (Field3)
  • TotalNumOfMushroom (Field)
  • CurrentNumOfMushroom (Field5)
  • SavedTime (Field6) — Timestamp
  • ProgramKey (Key2) — Foreign key → Program.ProgramKey — NOT NULL

Hardware (?)

  • MachinePinNum (Key) — Primary key — NOT NULL
  • MachinePassword (Field2)
  • MachineName (Field)
  • UserKey (Key2) — int — Foreign key → User.UserKey — NOT NULL

Program (Untitled3)

  • ProgramKey (Key2) — Primary key — NOT NULL
  • ProgramName (Field) — NOT NULL
  • DueDate (Field5) — Timestamp — NOT NULL
  • UserKey (Key) — int — Foreign key → User.UserKey — NOT NULL
  • WaterCycle (Field2)
  • SunlightOn (Field3) — boolean — NOT NULL

User (Untitled2)

  • UserKey (Key) — int — Primary key — NOT NULL
  • UserId (Field)
  • UserPassword (Field2)
  • UserName (Field3)
  • UserEmail (Field4)