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