1
vote
2answers
128 views

Foreign Key constraint on fixed value field - Ever appropriate?

I have a short (15 rows) look-up table that lists the valid values for several columns in the database. I don't think it can be considered a One-True-Lookup-Table, it is about a single definite ...
14
votes
4answers
2k views

Where should you define foreign keys?

Is it better to define foreign keys in the database or in the code part of an application?