Loading

Database best practices

Nombre Apellido

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi11y ago
Hi,
This was the good idea to create look type data.
here it may chance to human mistake...