#sql

hotels id, name, geo
buildings id, hotelID, name
rooms id, buildingID, floor, num, roomTypeID
roomTypes id, name, code, ord
params id,name, desc
roomParams id, roomID, paramID, desc
sevices id,name, desc, price
hotelServices id, serviceID, hotelID, desc
orders id, createdBy, created, roomID, startDate, endDate, total, customerID
orderPersons id, contanctID, orderID, age, sex
orderReviews id, orderID, text, rate, pros, cons, contactID, answer
contacts id, fio, city, phone, ....
customers id, contactID, ...
visitOrders id, orderID, hotelServiceID, created, createdBy, price, desc, statusID
visitOrderStatuses id, name, code, color