Grade

Tables (7)

Grade

  • gradcode — Primary key — NOT NULL

Subject

  • subjectcode — Primary key — NOT NULL
  • subjectname

class (Untitled2)

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

classsubject (Untitled5)

  • classcode — Foreign key → class.classcode — NOT NULL
  • gradcode (gradecode) — Foreign key → class.gradcode — NOT NULL
  • subjectcode — Foreign key → Subject.subjectcode — NOT NULL
  • regdate
  • regtime

gradesubject

  • gradecode — Primary key — NOT NULL
  • subjectcode (Key2) — Foreign key → Subject.subjectcode — NOT NULL
  • gradcode — Foreign key → Grade.gradcode — NOT NULL

member

  • member_id — Primary key — NOT NULL
  • member_name

memberdetail

  • member_id — Primary key — NOT NULL
  • member_id (member_id2) — Foreign key → member.member_id — NOT NULL