Hoops DB

Tables (3)

Reservation (Untitled2)

  • id (Key) — Int — Primary key — NOT NULL
  • userId (Key2) — Int — Foreign key → User.id — NOT NULL
  • date (Field) — String
  • start (Field2) — String
  • finish (Field3) — String
  • space (Field4) — String
  • createAt (Field5) — Date
  • updatedAt (Field6) — Date

Studyroom (Untitled3)

  • id (Key) — Int — Primary key — NOT NULL
  • isReservation (Field) — Boolean
  • roomNumber (Field2) — String
  • roomPassword (Field3) — String

User (Untitled)

  • id (Key) — Int — Primary key — NOT NULL
  • studentID (Field) — String
  • name (Field2) — String
  • major (Field3) — String
  • isValid (Field5) — Boolean
  • campus (Field4) — Enum
  • terminatedTime (Field7) — String
  • activateTime (Field6) — String
  • updatedAt (Field9) — Date
  • createdAt (Field8) — Date