indukSystem
Tables (8)
Circle (동아리)
- seqNo (circleNo) — int(11) — Primary key — NOT NULL
- 동아리이름 (name) — varchar(50)
- 종류 (type) — varchar(50)
- 등록일 (regDate) — dateTime
Grade (학점)
- seqNo (gradeNo) — int(11) — Primary key — NOT NULL
- seqNo (studentNo) — int(11) — Foreign key → student.seqNo — NOT NULL
- 성적 (grade) — varchar(8)
- 학기 (semester) — int(11)
- 등록일 (regDate) — dateTime
Major (전공)
- seqNo (majorNo) — int(11) — Primary key — NOT NULL
- 전공명 (name) — varchar(50)
- 등록일 (regDate) — dateTime
Subject (과목)
- seqNo (subjectNo) — int(11) — Primary key — NOT NULL
- 학년 (grade) — int(1)
- 과목명 (subject) — varchar(100)
- 사용여부 (isApply) — int(1)
- 등록일 (regDate) — dateTime
attendance (출결)
- seqNo (attendanceNo) — int(11) — Primary key — NOT NULL
- seqNo (studentNo) — int(11) — Foreign key → student.seqNo — NOT NULL
- seqNo (subjectNo) — int(11) — Foreign key → Subject.seqNo — NOT NULL
- 주차 (week) — int(10)
- 출석여부 (isAttend) — int(1)
- 등록일 (regDate) — dateTime
class (수강신청)
- seqNo (classNo) — int(11) — Primary key — NOT NULL
- seqNo (studentNo) — int(11) — Foreign key → student.seqNo — NOT NULL
- seqNo (subjectNo) — int(11) — Foreign key → Subject.seqNo — NOT NULL
- 등록일 (regDate) — dateTime
student (학생)
- seqNo (studentNo) — int(11) — Primary key — NOT NULL
- seqNo (circleNo) — int(11) — Foreign key → Circle.seqNo — NOT NULL
- seqNo (majorNo) — int(11) — Foreign key → Major.seqNo — NOT NULL
- 학생이름 (name) — varchar(50)
- 성별 (sex) — varchar(50)
- 생일 (birthday) — dateTime
- 주소 (address) — varchar(50)
- 학년 (grade) — int(1)
- 휴학여부 (isApply) — int(1)
- 등록일 (regDate) — dateTime
takeSchool (휴 / 복학)
- seqNo (takeNo) — int(11) — Primary key — NOT NULL
- seqNo (studentNo) — int(11) — Foreign key → student.seqNo — NOT NULL
- 종류 (type) — varchar(8)
- 등록일 (regDate) — dateTime