skala_db
Tables (5)
course
- id — SERIAL — Primary key — NOT NULL
- course_code — VARCHAR(6) — NOT NULL
- course_name — VARCHAR(30) — NOT NULL
- credit — INTEGER — NOT NULL
- dept_id — INTEGER — Foreign key → department.id — NOT NULL
- prof_id — INTEGER — Foreign key → professor.id
- created_at — TIMESTAMP — NOT NULL
department
- id — SERIAL — Primary key — NOT NULL
- dept_code — VARCHAR(6) — NOT NULL
- dept_name — VARCHAR(30) — NOT NULL
- location — VARCHAR(30)
- created_at — TIMESTAMP — NOT NULL
enrollment
- student_id — INTEGER — Foreign key → student.id — NOT NULL
- course_id — INTEGER — Foreign key → course.id — NOT NULL
- enrollment_date — DATE — NOT NULL
- grade — VARCHAR(2)
professor
- id — SERIAL — Primary key — NOT NULL
- prof_no — VARCHAR(6) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- email — VARCHAR(100)
- dept_id — INTEGER — Foreign key → department.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
student
- id — SERIAL — Primary key — NOT NULL
- student_no — VARCHAR(8) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- email — VARCHAR(100)
- admission_year — INTEGER — NOT NULL
- dept_id — INTEGER — Foreign key → department.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL