database design - two different subjects use one table -


i'm building program registerd user can book apartments , / or put reservations restaurants etc. bookings , reservations come in 1 list (this nog hard do).

now bumped frustrating problem.

you can create 2 different tables 1 bookings , 1 reservations, data same except booking.

or

you insert same data in table fk table more data booking? problem each time have reservation fk null don't like.

maybe there others ways don't know yet. whats best option do?

create static table store below data.

table name:booking type     id  typename     1   reservations     2   booking  

now use these ids in table have same attributes differentiate type.


Comments

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -