CampusMap
Tables (3)
Building (Untitled2)
- id (PK) — Int — Primary key — NOT NULL
- name (Field) — String
- lat (Field2) — String
- lng (Field3) — String
- createdAt (Field4) — Date
- updatedAt (Field5) — Date
Floor (Untitled3)
- id (PK) — Int — Primary key — NOT NULL
- building_id (FK) — Int — Foreign key → Building.id — NOT NULL
- name (Field) — String
- Image (Field2) — String
- createdAt (Field3) — Date
- updatedAt (Field4) — Date
User (Untitled)
- id (PK) — Int — Primary key — NOT NULL
- studentId (Field) — String
- name (Field2) — String
- password (Field3) — Stirng
- major (Field4) — Stirng
- idCard (Field5) — Stirng
- verified (Field6) — Boolean
- isManaged (Field7) — Boolean
- createdAt (Field8) — Date
- updatedAt (Field9) — Date