test
Tables (7)
course
- course_id — INTEGER — Primary key — NOT NULL
- course_name — VARCHAR(100) — NOT NULL
- credits — INTEGER
department
- dept_id — INTEGER — Primary key — NOT NULL
- dept_name — VARCHAR(50) — NOT NULL
enrollment
- enroll_id — INTEGER — Primary key — NOT NULL
- student_id — INTEGER — Foreign key → student.student_id — NOT NULL
- section_id — INTEGER — Foreign key → section.section_id — NOT NULL
- score — NUMERIC(3,1)
- enroll_date — DATE
- is_retake — BOOLEAN
- is_forced — BOOLEAN
professor
- prof_id — INTEGER — Primary key — NOT NULL
- prof_name — VARCHAR(50) — NOT NULL
- dept_id — INTEGER — Foreign key → department.dept_id
section
- section_id — INTEGER — Primary key — NOT NULL
- course_id — INTEGER — Foreign key → course.course_id — NOT NULL
- prof_id — INTEGER — Foreign key → professor.prof_id
- year — INTEGER — NOT NULL
- semester — VARCHAR(10) — NOT NULL
- classroom — VARCHAR(50)
student
- student_id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- grade — INTEGER
- email — VARCHAR(100)
- entrance_date — DATE
- dept_id — INTEGER — Foreign key → department.dept_id
student_major
- major_id — INTEGER — Primary key — NOT NULL
- student_id — INTEGER — Foreign key → student.student_id — NOT NULL
- dept_id — INTEGER — Foreign key → department.dept_id — NOT NULL
- major_type — VARCHAR(10) — NOT NULL