Grade
Tables (7)
Class
- classcode — Primary key — NOT NULL
- gradecode — Foreign key → Grade.gradecode — NOT NULL
Grade
- gradecode — Primary key — NOT NULL
Subject
- subjectcode — Primary key — NOT NULL
- subjectname
classsubject
- classcode — Foreign key → Class.classcode — NOT NULL
- gradecode — Foreign key → Class.gradecode — NOT NULL
- subjectcode — Foreign key → Subject.subjectcode — NOT NULL
- regdate
- regtime
gradesubject
- gradecode — Foreign key → Grade.gradecode — NOT NULL
- subjectcode — Foreign key → Subject.subjectcode — NOT NULL
member
- member_id — Primary key — NOT NULL
- member_name
member detail
- member_id — Foreign key → member.member_id — NOT NULL