Hoops

Tables (7)

QRModel (Untitled7)

  • id (Key) — Int — Primary key — NOT NULL
  • qr (Field) — String
  • activate (Field2) — Boolean
  • createdAt (Field3) — DateTime
  • updatedAt (Field4) — DateTime

Reservation (Untitled2)

  • id (Key) — Int — Primary key — NOT NULL
  • uid (Key2) — Int — Foreign key → User.id — NOT NULL
  • roomId (Key3) — Int — Foreign key → Room.id — NOT NULL
  • reserveNum (Field) — String
  • createdAt (Field2) — DateTime
  • updatedAt (Field3) — DateTime

Room (Untitled4)

  • id (Key) — Int — Primary key — NOT NULL
  • major (Field) — ENUM
  • roomNumber (Field2) — Int
  • description (Field3) — String
  • open (Field4) — String
  • closed (Field5) — String
  • createdAt (Field6) — DateTine
  • updatedAt (Field7) — DateTime

Schedule (Untitled3)

  • id (Key) — Int — Primary key — NOT NULL
  • reservationId (Key2) — Int — Foreign key → Reservation.id — NOT NULL
  • year (Field) — String
  • month (Field2) — String
  • date (Field3) — String
  • start (Field8) — String
  • finish (Field9) — String
  • class (Field10) — String
  • isReserved (Field4) — Boolean
  • userId (Field7) — Int
  • createdAt (Field5) — DateTime
  • updatedAt (Field6) — DateTime

Schedule_Room (Untitled5)

  • id (Key) — Int — Primary key — NOT NULL
  • schedueId (Key2) — Int — Foreign key → Schedule.id — NOT NULL
  • roomId (Key3) — Int — Foreign key → Room.id — NOT NULL

User (Untitled)

  • id (Key) — Int — Primary key — NOT NULL
  • studentId (Field) — String
  • name (Field2) — String
  • password (Field3) — String
  • idCard (Field4) — String
  • major (Field5) — ENUM
  • email (Field6) — String
  • campus (Field7) — ENUM
  • isValid (Field8) — Boolean
  • isManaged (Field9) — Boolean
  • createdAt (Field10) — DateTime
  • updatedAt (Field11) — DateTime

members_groups (Untitled6)

  • id (Key3) — Int — Primary key — NOT NULL
  • member (Key) — Int — Foreign key → User.id — NOT NULL
  • group (Key2) — Int — Foreign key → Reservation.id — NOT NULL
  • id (Key32) — Int — Foreign key → Reservation.roomId — NOT NULL