빈강의실

테이블 (5)

Untitled

  • Key — 기본 키 — NOT NULL

강의 (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