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