waiting
Tables (5)
Reservation (Untitled5)
- ReservationId (Key) — Primary key — NOT NULL
- storeStatusId (Key3) — Foreign key → storeStatus.storeStatusId — NOT NULL
- storeId (Key22) — Foreign key → storeStatus.storeId — NOT NULL
- userId (Key222) — Foreign key → storeStatus.userId — NOT NULL
- myTurn (Field)
- waitindStatus (Field2)
- userId (Key2) — Foreign key → Users.userId — NOT NULL
Review (Untitled2)
- reviewId (Key) — Primary key — NOT NULL
- storeId (Key3) — Foreign key → Users.userId — NOT NULL
- userId (Key22) — Foreign key → store.userId — NOT NULL
- content (Field)
Users (Untitled3)
- userId (Key) — Primary key — NOT NULL
- email (Field6)
- userName (Field)
- password (Field2)
- phoneNum (Field3)
- role (Field5)
store (Untitled)
- storeId (Key) — Primary key — NOT NULL
- userId (Key2) — Foreign key → Users.userId — NOT NULL
- storeImage (Field)
- storeName (Field2)
- storeTel (Field3)
- mapX (Field4)
- mapY (Field5)
- rate (Field6)
- adress (Field7)
storeStatus (Untitled4)
- storeStatusId (Key) — Primary key — NOT NULL
- storeId (Key2) — Foreign key → store.storeId — NOT NULL
- userId (Key22) — Foreign key → store.userId — NOT NULL
- totalTableCnt (Field)
- availableTableCnt (Field2)
- reservationCnt (Field3)
- limitWaitingCnt (Field4)