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