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

  • member _id (member_id) — Primary key — NOT NULL
  • member_name

MemberDetail

  • member _id (member_id) — Foreign key → Member.member _id — NOT NULL

Subject

  • subjectcode — Primary key — NOT NULL
  • subjectname