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)