For example, let's say I have a products table that has a SKU, Size, and Color fields and an Orders table that has an Order ID, but also needs the sku information and QTY. Using this convention, my product table will have these fields:
and my Orders table will have these fields:
ORD_ID, PROD_SKU, ORD_QTY
Because the quantity and the ID in the orders table belong to that table, they start with the
ORDprefix. But because the
PROD_SKUis borrowed from the Products table, the
PRODprefix, indicates clearly that this is the SKU from the Products table.