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