I am not too experienced in database best practices so I am wondering if anyone has some advice on whether to make a new database table or just differentiate between columns on an existing table.
For example, if I had a table for uploaded documents...
id | type | description | url
I can either enforce an enumeration requirement at the application level that requires
type to be either
or I can make a different document table for each of these. Having different tables would make me feel a bit safer, but then I would need to add more endpoints to the consuming application to take care of creation, destruction, etc so it seems a bit cumbersome. Any advice so I don't shoot myself in the foot?