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)