CnS

Tables (6)

administrator (관리자)

  • id (Key) — varchar(9) — Primary key — NOT NULL
  • password (Field) — varchar(20)

course (c)

  • id (course_PK) — varchar(9) — Primary key — NOT NULL
  • 대상 학년 — int
  • credit (학점) — int
  • name (과목명) — varchar(20)
  • classNumber (분반) — int
  • professor (교수) — varchar(20)
  • capacity (정원) — int

course_registration (cr)

  • id ((student_FK + couse_FK )) — Primary key — NOT NULL
  • course_id (course_FK) — varchar(9) — Foreign key → course.id — NOT NULL
  • student_PK (id) — varchar(9) — Foreign key → student.student_PK — NOT NULL

place (장소)

  • place (place_PK) — varchar(10) — Primary key — NOT NULL
  • name (이름) — varchar(10)

registed_course (등록된 수업)

  • id ((course_FK + place_FK)) — Primary key — NOT NULL
  • course_id (course_FK) — varchar(9) — Foreign key → course.id — NOT NULL
  • place_id (place_FK) — varchar(10) — Foreign key → place.place — NOT NULL
  • start_time (시작 시간) — time
  • end_time (종료 시간) — time

student

  • student_PK (id) — int — Primary key — NOT NULL
  • 이메일 (email) — varchar(15)
  • 패스워드 (password) — varchar(20)
  • 학생 이름 (name) — varchar(15)
  • 학년 (grade) — int(1)
  • 수강 학점 (credits) — int(2)