studyroom
Tables (6)
Equipment (장비)
- Equipment_id (장비ID) — int — Primary key — NOT NULL
- Equipment_name (장비이름) — varchar(255)
- room_id (스터디룸ID) — int — Foreign key → room.room_id — NOT NULL
Reservation (예약)
- Reservation_id (예약ID) — int — Primary key — NOT NULL
- room_id (스터디룸ID) — int — Foreign key → room.room_id — NOT NULL
- student_id (학생ID) — int — Foreign key → student.student_id — NOT NULL
- status_id (상태ID) — int — Foreign key → Status.status_id — NOT NULL
- time_id (사용시간ID) — int — Foreign key → time.time_id — NOT NULL
Status (상태)
- status_id (상태ID) — int — Primary key — NOT NULL
- status_name (상태명) — varchar(50)
room (스터디룸)
- room_id (스터디룸ID) — int — Primary key — NOT NULL
- room_name (스터디룸 이름) — varchar(100)
- capacity (수용가능인원) — int
- Location (위치) — varchar(100)
student (학생)
- student_id (학생ID) — int — Primary key — NOT NULL
- name (이름) — varchar(50)
time (사용시간)
- time_id (사용시간ID) — int — Primary key — NOT NULL
- time (시간) — DATETIME
- room_id (스터디룸ID) — int — Foreign key → room.room_id — NOT NULL