Skip to main content
1 of 3

Why not create a property table for each property (like propReservationStatus and propReservationSendStatus) that holds the statuses:

Id Description
---------------
1 Decline
2 Accept
3 Waiting

and so on and then define a column ReservationStatusId in your table as a foreign key to the property table?

This scenario has some advantages:

  • translations of the status independant from id
  • better maintenance/extensibility (after six months would you still know what 1/2/3 is?)