Php/mysql

I need to enter grocery coupon info into a database. Will require the following fields tables:

Manufacturers:
MfgID(PK)
Manufacturer
MfgPrefix(FK)

MfgPrefix:
MfgPrefix
MfgID(FK)

Brands:
BrandID(PK)
MfgID(FK)
Brand

Varieties:
VarietyID(PK)
BrandID(FK)
Variety

Details:
DetailID(PK)
VarietyID(FK)
Size
Unit
Pkg
UPC

Coupon:
CouponID(PK)
Barcode
MfgID(FK)???
BrandID(FK)???
RequiredPurchase**(ask me)
Qty
Get**(ask me)
ExpDate

I need one form to be able to …

Leave a Reply

Your email address will not be published. Required fields are marked *