Academin Schema
Tables (5)
course
- course_id — SERIAL — Primary key — NOT NULL
- dept_id — INT — Foreign key → department.dept_id — NOT NULL
- prof_id — INT — Foreign key → professor.prof_id
- course_name — VARCHAR(100) — NOT NULL
- credit — INT — NOT NULL
- semester — VARCHAR(7) — NOT NULL
department
- dept_id — SERIAL — Primary key — NOT NULL
- dept_name — VARCHAR(50) — NOT NULL
- office — VARCHAR(30)
enrollment
- enroll_id — SERIAL — Primary key — NOT NULL
- student_id — INT — Foreign key → student.student_id — NOT NULL
- course_id — INT — Foreign key → course.course_id — NOT NULL
- enroll_date — DATE — NOT NULL
- score — NUMERIC(4,1)
professor
- prof_id — SERIAL — Primary key — NOT NULL
- dept_id — INT — Foreign key → department.dept_id — NOT NULL
- prof_name — VARCHAR(30) — NOT NULL
- email — VARCHAR(100)
- hire_date — DATE — NOT NULL
student
- student_id — SERIAL — Primary key — NOT NULL
- dept_id — INT — Foreign key → department.dept_id — NOT NULL
- student_no — CHAR(8) — NOT NULL
- student_name — VARCHAR(30) — NOT NULL
- email — VARCHAR(100)
- grade — INT — NOT NULL
- admission_date — DATE — NOT NULL