grade

Tables (7)

Class

  • classcode — Primary key — NOT NULL
  • gradecode (Key) — Foreign key → Grade.gradecode — NOT NULL
  • Field

Grade

  • gradecode (Key) — Primary key — NOT NULL
  • Field

Subject

  • subjectcode — Primary key — NOT NULL
  • subjectname

Untitled (Member)

  • Key (member_id) — Primary key — NOT NULL
  • Field (member_name)

Untitled (memberdetail)

  • Key (member_id) — Foreign key → Untitled.Key — NOT NULL

classsubject

  • classcode — Foreign key → Class.classcode — NOT NULL
  • gradecode (Key) — Foreign key → Class.gradecode — NOT NULL
  • subjectcode — Foreign key → Subject.subjectcode — NOT NULL
  • regdate
  • Field (regtime)

gradesubject

  • gradecode (Key) — Foreign key → Grade.gradecode — NOT NULL
  • subjectcode — Foreign key → Subject.subjectcode — NOT NULL