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