university_db
Tables (5)
courses
- course_id — SERIAL — Primary key — NOT NULL
- course_code — VARCHAR(20) — NOT NULL
- course_name — VARCHAR(100) — NOT NULL
- department_id — INTEGER — Foreign key → departments.department_id — NOT NULL
- credits — INTEGER — NOT NULL
- capacity — INTEGER — NOT NULL
- academic_year — INTEGER — NOT NULL
- semester — INTEGER — NOT NULL
departments
- department_id — SERIAL — Primary key — NOT NULL
- department_code — VARCHAR(10) — NOT NULL
- department_name — VARCHAR(100) — NOT NULL
- office_phone — VARCHAR(20)
enrollments
- enrollment_id — SERIAL — Primary key — NOT NULL
- student_id — INTEGER — Foreign key → students.student_id — NOT NULL
- course_id — INTEGER — Foreign key → courses.course_id — NOT NULL
- enrolled_at — DATE — NOT NULL
- status — VARCHAR(20) — NOT NULL
- score — NUMERIC(5, 2)
professors
- professor_id — SERIAL — Primary key — NOT NULL
- employee_no — VARCHAR(20) — NOT NULL
- professor_name — VARCHAR(50) — NOT NULL
- department_id — INTEGER — Foreign key → departments.department_id — NOT NULL
- email — VARCHAR(100)
- hire_date — DATE — NOT NULL
students
- student_id — SERIAL — Primary key — NOT NULL
- student_no — VARCHAR(20) — NOT NULL
- student_name — VARCHAR(50) — NOT NULL
- department_id — INTEGER — Foreign key → departments.department_id — NOT NULL
- grade — INTEGER — NOT NULL
- birth_date — DATE — NOT NULL
- email — VARCHAR(100)
- phone — VARCHAR(20)
- admission_date — DATE — NOT NULL