Database File Format - gorectk5/TA-App GitHub Wiki

Update this when you add new columns or tables

Accounts:
Username,Password,Clearance

Username: Unique string
Password: string
Clearance:Supervisor=1,Admin=2,Professor=3,TA=4

Courses:
CourseIDInt,CourseName,Professor

CourseIDInt: Unique integer

CourseName: string “CS337”

Professor: Professor username from Accounts

Labs:
LabIDInt,CourseIDInt,TA

LabIDInt: Unique integer

CourseIDInt: unique integer should exist in Courses

TA: TA username should exist in Accounts