logical
Tables (18)
budget_allocation
- allocation_id — INT — Primary key — NOT NULL
- project_id — INT — Foreign key → budget_project.project_id
- category_id — INT — Foreign key → budget_category.category_id
budget_category
- category_id — INT — Primary key — NOT NULL
budget_expense
- expense_id — INT — Primary key — NOT NULL
- allocation_id — INT — Foreign key → budget_allocation.allocation_id
- professor_id — INT — Foreign key → professor.professor_id
- org_type_id — INT — Foreign key → organization_type.org_type_id
budget_project
- project_id — INT — Primary key — NOT NULL
change_log
- log_id — INT — Primary key — NOT NULL
- processed_by — INT — Foreign key → user.user_id
mileage_request
- request_id — INT — Primary key — NOT NULL
- program_id — INT — Foreign key → sw_program.program_id
- student_id — INT — Foreign key → student.student_id
organization_type
- org_type_id — INT — Primary key — NOT NULL
permission
- permission_id — INT — Primary key — NOT NULL
professor
- professor_id — INT — Primary key — NOT NULL
student
- student_id — INT — Foreign key → user.user_id — NOT NULL
student_update_request
- request_id — INT — Primary key — NOT NULL
- student_id — INT — Foreign key → student.student_id
survey
- survey_id — INT — Primary key — NOT NULL
- program_id — INT — Foreign key → sw_program.program_id
survey_response
- response_id — INT — Primary key — NOT NULL
- survey_id — INT — Foreign key → survey.survey_id
- student_id — INT — Foreign key → student.student_id
sw_program
- program_id — INT — Primary key — NOT NULL
topcit_round
- round_id — INT — Primary key — NOT NULL
topcit_score
- score_id — INT — Primary key — NOT NULL
- round_id — INT — Foreign key → topcit_round.round_id
- student_id — INT — Foreign key → student.student_id
user
- user_id — INT — Primary key — NOT NULL
user_permission
- user_id — INT — Foreign key → user.user_id — NOT NULL
- permission_id — INT — Foreign key → permission.permission_id — NOT NULL