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)