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)