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