Hello, i am on o project for a hotel reservation system and i have a question i'd like to know if someone can help me. When a customer makes a reservation online i want it to be pending till reception get a confirmation call and then update it to the booking table. So anyone has any idea at all how or if i can do that?
Simply have a status field on a booking which should have options like pending, confirmed, cancelled with possibly others like payment pending etc. Either have it as a single field or have a separate table with the different options and use it as a foreign key for the bookings table status field which would mean that DDLs/ pivot tables/ reports etc can reference the options table and so in future if new options are added you dont need to rewrite code.