빈강의실
테이블 (5)
강의 (LECTURE)
- LECTURE_LECTURECODE (lecture_lecturecode) — VARCHAR(20) — 기본 키 — NOT NULL
- USER_CODE (user_code) — VARCHAR(10) — 외래 키 → 사용자.USER_CODE — NOT NULL
- API_BUILDINGLOCATION (api_buildinglocation) — VARCHAR(10) — 외래 키 → 위치.API_BUILDINGLOCATION — NOT NULL
- USER_CODE (user_code2) — Int(10) — 외래 키 → 학생.USER_CODE
- USER_MAJOR (user_major) — VARCHAR(20)
- LECTURE_NAME (lecture_name) — VARCHAR(10)
- LECTURE_ROOMNAME (lecture_roomname) — VARCHAR(10)
- LECTURE_TIME (lecture_time) — VARCHAR(10)
- API_EMPTYROOMLOCATION (api_emptyroomlocation) — VARCHAR(10)
- LECTURE_EMPTYTIME (lecture_emptytime) — VARCHAR(10)
- LECTURE_FLOOR (lecture__floor) — INT(5)
- LECTURE_BUILDIGNAME (lecture_buildingname) — VARCHAR(10)
- LECTURE_ROOMCODE (lecture_roomcode) — VARCHAR(20) — NOT NULL
- LECTURE_EMPTYROOMCODE (lecture_emptyroomcode) — VARCHAR(20) — NOT NULL
사용자 (USER)
- USER_CODE (user_code) — VARCHAR(10) — 기본 키 — NOT NULL
- USER_ID (user_id) — VARCHAR(20)
- USER_PASSWORD (user_password) — VARCHAR(50)
- USER_MAJOR (user_major) — VARCHAR(50)
- USER_NAME (user_name) — VARCHAR(10)
- USER_SEX (user_sex) — VARCHAR(10)
- USER_DATE (user_date) — VARCHAR(10)
- USER_JOIN (user_join) — VARCHAR(10
- USER_SECESSION (user_secession) — boolean
- USER_STUDENTID (user_studentid) — int(10) — NOT NULL
위치 (API)
- API_BUILDINGLOCATION (api_buildinglocation) — VARCHAR(10) — 기본 키 — NOT NULL
- LECTURE_EMPTYROOMCODE (lecture_emptyroomcode) — VARCHAR(20)
- LECTURE_ROOMCODE (lecture_roomcode) — VARCHAR(20)
- API_EMPTYROOMLOCATION (api_emptyroomlocation) — VARCHAR(10) — NOT NULL
학생 (STUDENT)
- USER_CODE (user_code) — Int(10) — 기본 키
- USER_MAJOR (user_major) — VARCHAR(50)
- USER_NAME (user_name) — VARCHAR(10)
- USER_CODE (user_code2) — VARCHAR(10) — 외래 키 → 사용자.USER_CODE — NOT NULL
- STUDENT_FAVORITE (student_favorite) — VARCHAR(10) — NOT NULL