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