0811_skala
Tables (6)
attendances
- attendance_id — INTEGER — Primary key — NOT NULL
- enrollment_id — INTEGER — Foreign key → enrollments.enrollment_id
- attendance_date — DATE
- status — BOOLEAN
courses
- course_id — INTEGER — Primary key — NOT NULL
- name — VARCHAR
- start_date — DATE
- end_date — DATE
- professor_id — INTEGER — Foreign key → professors.professor_id
enrollments
- enrollment_id — INTEGER — Primary key — NOT NULL
- student_id — INTEGER — Foreign key → students.student_id
- course_id — INTEGER — Foreign key → courses.course_id
- enrollment_date — TIMESTAMP
major
- major_id — INTEGER — Primary key — NOT NULL
- major_name — VARCHAR
professors
- professor_id — INTEGER — Primary key — NOT NULL
- professor_no — VARCHAR
- major_id — INTEGER — Foreign key → major.major_id
- name — VARCHAR
students
- student_id — INTEGER — Primary key — NOT NULL
- student_no — VARCHAR
- major_id — INTEGER — Foreign key → major.major_id
- name — VARCHAR
- grade — INTEGER
- is_enrolled — BOOLEAN