|
Ahmed
I assume
Hotel A
Hotel B
Hotel C
and
Grand Suite
Presidential Suite
Classic Suite
Deluxe Suite
Are ids and not the data.
If that is the case Have a Table where your unique identifier is the identifier of the photo.
Photos
--------
Photo Id Photo Data
And then Photo Id should be mapped to Hotel / GuestRoomTypes and other things.
Also Just a note never have the table name as plurals
|