skala_db

Tables (5)

course

  • course_id — varchar(10) — Primary key — NOT NULL
  • course_name — varchar(20) — NOT NULL
  • credit — int — NOT NULL
  • dept_id — varchar(10) — Foreign key → department.dept_id — NOT NULL
  • prof_id — varchar(10) — Foreign key → professor.prof_id — NOT NULL

department

  • dept_id — varchar(10) — Primary key — NOT NULL
  • dept_name — varchar(20) — NOT NULL
  • head_prof_id — varchar(10)

enrollment

  • enrollment_id — varchar(10) — Primary key — NOT NULL
  • student_id — varchar(10) — Foreign key → student.student_id — NOT NULL
  • course_id — varchar(10) — Foreign key → course.course_id — NOT NULL
  • apply_date — date
  • status — varchar(10)
  • score — int

professor

  • prof_id — varchar(10) — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL
  • birth_date — date
  • phone — varchar(20) — NOT NULL
  • email — varchar(100) — NOT NULL
  • dept_id — varchar(10) — Foreign key → department.dept_id — NOT NULL

student

  • student_id — varchar(10) — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL
  • birth_date — date
  • phone — varchar(20) — NOT NULL
  • email — varchar(100) — NOT NULL
  • dept_id — varchar(10) — Foreign key → department.dept_id — NOT NULL
  • advisor_id — varchar(10) — Foreign key → professor.prof_id — NOT NULL
  • admission_date — date
  • status — varchar(10)