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