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