restaurant reservations

Tables (15)

Event

    LoginCredential (Login_info)

      Membersihp (Membership)

        Menu

          Notification (Notice)

            Payment (Pay)

              Reserve

              • Reserve_ID — Primary key — NOT NULL
              • User_ID — Foreign key → User.User_ID — NOT NULL
              • Restaurant_ID (Reserve_ID2) — Foreign key → Restaurant.Restaurant_ID — NOT NULL
              • Date_Reservation
              • The number of people
              • Status

              Restaurant (Rest)

                Restaurant

                • Restaurant_ID (Reserve_ID) — Primary key — NOT NULL
                • name
                • Address
                • Category
                • Business_Hour
                • Store_num

                RestaurantTable (Rest_table)

                  Review

                  • Field

                  User

                  • User_ID (ID) — Primary key — NOT NULL
                  • name
                  • email
                  • Phone_number (Phone_num)
                  • User_Type (Type)
                  • Date_Registration (Date_Regist)

                  UserEventParticipation (UserEvent)

                    UserPoint (User_Point)

                      WaitingList (Wait_List)

                      • WaitingID (Key) — Primary key — NOT NULL
                      • User_ID (ID) — Foreign key → User.User_ID — NOT NULL
                      • Restaurant_ID (Field3)
                      • Date_Reservation (Field4)
                      • Time_Reservation (Field5)
                      • The number of People (Field6)
                      • Status (Field7)