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...) — 기타