1
Answer

Database best practices

So, I have two tables: 

RequestStatus

VALUES:   "Open", "In Progress" or "Complete"

 

DeviceStatus. 

VALUES:  "Active" or "Inactive"

 
Right now I have two tables but, since the table structure is the same ("StatusId" and "StatusText"), I was thinking that a single "Status" table with another column (may be "StatusType) to differentiate the '"type of status" would be a better practice.
 
Any opinions/suggestions? 
Answers (1)