Designing a database for a reservation request, for example. Hotel

Question

I built one, but I am convinced that this is wrong.

I had a table for customer information, and another table with each date (i.e. a weekly vacation would have seven entries).

Is there a better way?

I am code in PHP with MySQL

Answer 1

Here you go

I found it on this page: List of free database models .

WARNING . Currently (November '11), Google reports that the site contains malware: http://safebrowsing.clients.google.com/safebrowsing/diagnostic?client=Firefox&hl=en-US&site=http://www.databaseanswers.org /data_models/hotels/hotel_reservations_popkin.htm

Answer 2

PMS. , , , , . . , . .

, MySQL, startdate/enddate . "where date in (date)".

:

Bookings (id, main-guest-id, arrivaltime, departime,...)

BookingGuests (id, guest-id)

BookingGuestNights (date, room, rate)

Answer 3

, :

• , ?
• ?
• , , ?

Answer 4

, . , , , .

• 1 (, -, , ).
• / . , /, . , 10 2 .

Answer 5

, .

= html.

CodeIgniter Calendar . ( , ), . , , .

.

,

Answer 6

? , , , , .

Answer 7

... , . , .

Answer 8

, . "".

stay.check_in_time_scheduled
stay.check_in_time_actual
stay.check_out_time_scheduled
stay.check_out_time_actual

Answer 9

, ? , , / , . , , , ( ) ..

, , , .

Answer 10

- , . . , , .

, , , .

. "", " ", .

.

Answer 11

(, , )

, , X n .., .

/ /num ... :)

, SQL-:)

Answer 12

. .

:

"" .

.

• ixVisit
• ixCusomer
• sNote

:

• ixCustomer
• sFirstName
• sLastName

:

Stay , . , udpated.

• ixStay
• dtArrive
• dtLeave
• sNote

- - : SELECT CRUD. - 99% SELECT 1% CRUD. CRUD , SELECT. , . CRUD, SELECT , SELECTS Stay.

, : ", , , "

-, , , , .