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)