Entity Definition

Logical Name : ManufacturerBrand
Physical Name : ID_BRN_MF

An associative (many-to-many) entity that links MANUFACTURER and BRAND. Brands, such as private label merchandise, can be produced by different MANUFACTURERs and a MANUFACTURER can produce different BRANDs

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ManufacturerID (FK)(PK) A unique system assigned identifier for the Manufacturer. ID_MF Identity integer Manufacturer(PA_MF)
BrandName (FK)(PK) A unique name to denote a class of ITEMs as a product. The brand can include private label ITEMs. NM_BRN Name varchar(40) Brand(ID_BRN)
EffectiveDate Date a manufacturer - brand association is available for use. DC_EF EffectiveDate date
ExpirationDate Date a manufacturer - brand association is no longer available for use. DC_EP ExpirationDate date
CurrentStatusCode Current status of a ManufacturerBrand association. Valid values are A - Active I - Inactive CD_STS Code2Status char(2)


Parent Entity Verb Phrase Child Entity
Brand is produced by ManufacturerBrand
Manufacturer produces ManufacturerBrand

Logical Views containing ManufacturerBrand

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01120 - Item Selling Rules - Manufacturer Coupon View
Logical 02333 - Retail Transaction - Tender - Coupon View