sadasd

Tables (6)

grade

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → join_detail.Key — NOT NULL
  • Key (join_id2) — Foreign key → join_detail.Key — NOT NULL
  • student_id (student_id2) — Foreign key → join_detail.student_id — NOT NULL
  • Key (subject_id2) — Foreign key → join_detail.Key — NOT NULL
  • Key (professor_id2) — Foreign key → join_detail.Key — NOT NULL
  • Field
  • Field2
  • Field3

join

  • Key (join_id) — Primary key — NOT NULL
  • student_id (student_id2) — Foreign key → student.student_id — NOT NULL
  • Key (subject_id2) — Foreign key → subject.Key — NOT NULL
  • Key (professor_id2) — Foreign key → subject.Key — NOT NULL
  • Field (student_id)
  • Field2 (subject_id)

join_detail

  • Key — Primary key — NOT NULL
  • Key (join_id2) — Foreign key → join.Key — NOT NULL
  • student_id (student_id2) — Foreign key → join.student_id — NOT NULL
  • Key (subject_id2) — Foreign key → join.Key — NOT NULL
  • Key (professor_id2) — Foreign key → join.Key — NOT NULL
  • Field (join_detail_id)
  • Field2 (join_id)

professor

  • Key (professor_id) — Primary key — NOT NULL
  • Field (professor_name)
  • Field (subject)

student

  • student_id — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

subject

  • Key (subject_id) — Primary key — NOT NULL
  • Key (professor_id2) — Foreign key → professor.Key — NOT NULL
  • Field (subject_name)
  • Field2 (professor_id)
  • Field3