Grade
Tables (7)
Class
- classcode — Primary key — NOT NULL
- gradecode — Foreign key → Grade.gradecode — NOT NULL
ClassSubject
- classcode — Foreign key → Class.classcode — NOT NULL
- gradecode — Foreign key → Class.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 (member_id) — Primary key — NOT NULL
- member_name
MemberDetail
- member _id (member_id) — Foreign key → Member.member _id — NOT NULL
Subject
- subjectcode — Primary key — NOT NULL
- subjectname