capstone

Tables (4)

room

  • room number — Primary key — NOT NULL
  • Key (Key2) — Foreign key → rooms.Key — NOT NULL
  • seat number — varchar(10) — 좌석 번호

rooms

  • Key — Primary key — NOT NULL
  • room number — varchar(10) — 강의실 번호

seat

  • seat number — Primary key — NOT NULL
  • room number — Foreign key → room.room number — NOT NULL
  • Key (Key2) — Foreign key → room.Key — NOT NULL
  • ID — int — NOT NULL — 좌석에 위치한 학생의 번호(없으면 0)

user data (uesr data)

  • ID — int — Primary key — NOT NULL — Auto increment
  • student ID — int — NOT NULL — 학번
  • name — varchar(10) — NOT NULL — 이름
  • tag ID — int — NOT NULL — RFID 태그 ID
  • etc.. (etc...) — 기타