Grade

Tables (7)

Calss (Class)

  • ClassCode — Primary key — NOT NULL
  • GradeCode (GradeCode2) — Foreign key → Grade.GradeCode — NOT NULL

ClassSubject

  • ClassCode — Foreign key → Calss.ClassCode — NOT NULL
  • GradeCode (GradeCode2) — Foreign key → Calss.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 — Primary key — NOT NULL
  • Member_name

MemberDetail (MemberDatail)

  • Member_id — Foreign key → Member.Member_id — NOT NULL

Subject

  • subjectcode — Primary key — NOT NULL
  • subjectname