Advertisement
EmmanuelU

Waitless SQL Database Table Design

Mar 1st, 2020
482
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. Order:
  2. Order_ID (int)
  3. Dining_Table_ID (int)
  4. Order_Type (string)
  5. Order_Time (datetime)
  6. Completed (int)
  7. Completed_Time (string)
  8.  
  9.  
  10. DiningTable:
  11. Dining_Table_ID (int)
  12. Employee_ID (int)
  13. Seats (int)
  14. is_Active (int)
  15. is_Occupied (int)
  16. Seating_time (datetime)
  17. Reservation_Name (string)
  18. Has_Birthday (int)
  19. Special_Request (string)
  20.  
  21. Employee:
  22. Employee_ID (int)
  23. F_Name (string)
  24. L_Name (string)
  25. Is_Manager (int)
  26. Hire_Date (datetime)
  27. Birth_Date (datetime)
  28. Address (string)
  29. Phone (string)
  30. Token (string)
  31. Salary (decimal)
  32. Title (string)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement