Grade

Tables (7)

Class

  • classcode — Primary key — NOT NULL
  • gradecode — Foreign key → Grade.gradecode — NOT NULL

ClassSubject

  • classcode — Foreign key → Class.classcode — NOT NULL
  • gradecode — Foreign key → Class.gradecode — NOT NULL
  • subjectcode — Foreign key → subject.subjectcode — NOT NULL
  • date
  • time

Grade

  • gradecode — Primary key — NOT NULL

gradesubject

  • gradecode — Foreign key → Grade.gradecode — NOT NULL
  • subjectcode — Foreign key → subject.subjectcode — NOT NULL

member

  • memberID — Primary key — NOT NULL
  • name

memberDetail

  • memberID — Foreign key → member.memberID — NOT NULL

subject

  • subjectcode — Primary key — NOT NULL
  • subjectname