Skip to content

A mock recreation of the UC Merced housing database for CSE111: Databases.

Notifications You must be signed in to change notification settings

Hinoden/UCM-Housing-Database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

52 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

UC Merced/Fall2024/CSE111-Project

By Jeffrey Peng and Kristina Wong

Operating using Flask

To run: python server.py

DB Tables and columns:

  • assets

  • building

    • buildingId
    • name
    • numRoom
  • canAccess

    • approved
    • formID
    • employeeID
  • canUnlock

    • accessDateTime
    • reason
    • buildingID
    • employeeID
  • contact

    • contactDateTime
    • reason
    • studentID
    • employeeID
  • employee

    • employeeID
    • name
    • email
  • housingForm

    • formID
    • status
    • accommodations
    • surveyID
  • profileSurvey

    • surveyID
    • prefRoomType
    • cleanliness
    • prefRoomGen
  • room

    • roomID
    • roomType
    • occupied
    • buildingID
  • student

    • studentID
    • name
    • gender
    • year
    • email
    • buildingID
    • roomID

About

A mock recreation of the UC Merced housing database for CSE111: Databases.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published