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
Post a Comment