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
  • regDate
  • regTime

grade

  • gradeCode — Primary key — NOT NULL

gradeSubject

  • gradeCode — Foreign key → grade.gradeCode — NOT NULL
  • subjectCode — Foreign key → subject.subjectCode — NOT NULL

member

  • memberid (memberId) — Primary key — NOT NULL
  • memberName

memberDetail

  • memberid (memberId) — Foreign key → member.memberid — NOT NULL

subject

  • subjectCode — Primary key — NOT NULL
  • subjectName