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