Grade

Tables (7)

Grade

  • gradecode — Primary key — NOT NULL

class

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

classsubject

  • subjectcode — Foreign key → subject.subjectcode — NOT NULL
  • classcode — Foreign key → class.classcode — NOT NULL
  • gradecode — Foreign key → class.gradecode — NOT NULL
  • regdate
  • regtime

gradesubject

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

member detail

  • member_name (member_id) — lgcns — Foreign key → member_id.member_name — NOT NULL

member_id

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

subject

  • subjectcode — Primary key — NOT NULL
  • subjectname