univ

Tables (8)

colleges

  • id — SERIAL — Primary key — NOT NULL
  • code — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

course_offerings

  • id — SERIAL — Primary key — NOT NULL
  • course_id — INTEGER — Foreign key → courses.id — NOT NULL
  • professor_id — INTEGER — Foreign key → professors.id
  • semester — VARCHAR(10) — NOT NULL

courses

  • id — SERIAL — Primary key — NOT NULL
  • code — VARCHAR(20) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • credits — SMALLINT — NOT NULL
  • major_id — INTEGER — Foreign key → majors.id
  • created_at — TIMESTAMP — NOT NULL

enrollments

  • student_id — INTEGER — Foreign key → students.id — NOT NULL
  • offering_id — INTEGER — Foreign key → course_offerings.id — NOT NULL
  • score — NUMERIC(5,2)
  • enrolled_at — DATE — NOT NULL

majors

  • id — SERIAL — Primary key — NOT NULL
  • college_id — INTEGER — Foreign key → colleges.id — NOT NULL
  • code — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • program_years — SMALLINT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • closed_at — DATE
  • created_at — TIMESTAMP — NOT NULL

professors

  • id — SERIAL — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(200)
  • major_id — INTEGER — Foreign key → majors.id
  • is_active — BOOLEAN — NOT NULL
  • retired_at — DATE
  • created_at — TIMESTAMP — NOT NULL

student_additional_majors

  • student_id — INTEGER — Foreign key → students.id — NOT NULL
  • major_id — INTEGER — Foreign key → majors.id — NOT NULL
  • major_type — VARCHAR(10) — NOT NULL

students

  • id — SERIAL — Primary key — NOT NULL
  • student_no — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(200)
  • gender — CHAR(1)
  • birth_date — DATE
  • major_id — INTEGER — Foreign key → majors.id — NOT NULL
  • completed_semesters — SMALLINT — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • leave_semesters — SMALLINT — NOT NULL
  • phone — VARCHAR(20)
  • admitted_at — DATE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL