restaurant reservations
Tables (15)
LoginCredential (Login_info)
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
- Restaurant_ID (Reserve_ID) — Primary key — NOT NULL
- name
- Address
- Category
- Business_Hour
- Store_num
RestaurantTable (Rest_table)
User
- User_ID (ID) — Primary key — NOT NULL
- name
- email
- Phone_number (Phone_num)
- User_Type (Type)
- Date_Registration (Date_Regist)
UserEventParticipation (UserEvent)
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)