Database

The database layer of this application is assumed as a PostgreSQL server. For the purposes of local development, an image for a compatible PostgreSQL Docker container is provided at the root of the project.

The database schema contains 15 tables in addition to 2 additional tables for use in knex migrations. The schema is as follows

• Announcements
  • id: int, not null, Primary Key
  • title: varchar, not null
  • description: varchar
  • postDate: date
  • expDate: date
• AuditLogs
  • id: int, not null, Primary Key
  • message: text
  • dateTime: zoned timestamp
• Equipment
  • id: int, not null, Primary Key
  • name: varchar
  • addedAt: zoned timestamp
  • inUse: boolean
  • roomID: int
  • archived: boolean
• Holds
  • id: int, not null, Primary Key
• InventoryItem
• InventoryItemLabel
• Label
• ModuleSubmissions
• ModulesForEquipment
• ReservationEvetns
• Reservations
• RoomSwipes
• Rooms
• TrainingModule
• Users
• knex_migrations
• knex_migrations_lock