Welcome Guest, Not a member yet? Register   Sign In
Avoid conflict between column names ?
#6

(This post was last modified: 11-07-2017, 02:59 PM by PaulD.)

In my tables I have for example a recipes table: recipe_id, recipe_name and in an ingredients table: ingredient_id, ingredient_name. Just be careful not to use recipe as your table name base for any other table. So the recipe_items table is: item_id, item_recipe_id and item_ingredient_id.

No conflicts, no problems, very clear to use. (IMHO)

Paul
Reply


Messages In This Thread
Avoid conflict between column names ? - by Coool6 - 11-07-2017, 12:38 AM
RE: Avoid conflict between column names ? - by PaulD - 11-07-2017, 02:59 PM



Theme © iAndrew 2016 - Forum software by © MyBB