Skip to content

Latest commit

 

History

History
11 lines (10 loc) · 925 Bytes

Patron-Database.md

File metadata and controls

11 lines (10 loc) · 925 Bytes

Patron Tables

Image Explanation
Statistics.Patron.png
Patrons Has a Gender and Barcode for each individual Patron which is marked by an individual patronId. Has one to many relationship to PatronRecords.
PatronRecords Stores multiple time specific PatronRecordId's for each Patron. It also includes an effectiveStartDate and effectiveEndDate of that time period.
StudentMajorRecords Stores data about a students major at a specific time.
StudentRecords Stores Data about a student at a specific time.
StudentResidenceRecords Stores records of a student at a specific time at a specific residence.
StudentResidences Stores Residence Names and their ResidenceCategory(Commuter, OnCampus, OffCampus, AwayFromCampus)