studyroom_reservation

Tables (4)

reservation (예약)

  • id (key) — int — Primary key — NOT NULL
  • userId (key2) — int — Foreign key → user.id — NOT NULL
  • roomId (key3) — int — Foreign key → seat.roomId — NOT NULL
  • seatId (key4) — int — Foreign key → seat.id — NOT NULL
  • startTime (Field) — timeStamp
  • endTime (Field2) — timeStamp
  • status (Field3) — varchar(10)

seat (좌석)

  • id (key) — int — Primary key — NOT NULL
  • roomId (key2) — int — Foreign key → studyroom.id — NOT NULL
  • number (Field) — int

studyroom (스터디룸)

  • id (key) — int — Primary key — NOT NULL
  • name (Field) — varchar(15)
  • totalSeat (Field2) — int

user (사용자)

  • id (key) — int — Primary key — NOT NULL
  • name (Field) — varchar(10)
  • email (Field2) — varchar(50)
  • phonenumber (Field3) — varchar(15)
  • activated (Field4) — varchar(10)