Brand Management

Tables (6)

Brand

  • brandId — int — Primary key — NOT NULL
  • brandName — varchar
  • establishedDate — date
  • brandLogo — varchar
  • brandimage (brandImage) — varchar
  • city — varchar
  • address — varchar
  • brandUrl — varchar
  • description — varchar
  • facebookUrl — varchar
  • youtubeUrl — varchar
  • twitterUrl — varchar
  • instagramUrl — varchar

BrandContact

  • contactId — int — Primary key — NOT NULL
  • largeCategory — varchar — Foreign key → ProductCategory.largeCategory — NOT NULL
  • mediumCategory — varchar — Foreign key → ProductCategory.mediumCategory — NOT NULL
  • brandId — int — Foreign key → Brand.brandId — NOT NULL
  • mainLine — varchar
  • Id — varchar
  • contactStartDate — date
  • contactEndDate — date
  • status — varchar
  • createDate — date
  • creator — varchar
  • modifyDate — date
  • modifier — varchar

BrandContactItem

  • Key (contactId) — int — Primary key — NOT NULL
  • Key (itemNumber) — int — Primary key — NOT NULL
  • Field (manager) — varchar
  • Field (position) — varchar
  • Field (phoneNumber) — varchar
  • Field (cellphoneNumber) — varchar
  • Field (email) — varchar

Product

  • productId — int — Primary key — NOT NULL
  • brandId — int — Foreign key → Brand.brandId — NOT NULL
  • largeCategory — varchar — Foreign key → ProductCategory.largeCategory — NOT NULL
  • mediumCategory — varchar — Foreign key → ProductCategory.mediumCategory — NOT NULL
  • productCode (productCode2) — varchar — Foreign key → ProductCode.productCode — NOT NULL
  • FDA — varchar
  • image — varchar
  • directions — varchar
  • ingredients — varchar
  • volume — int
  • launchDate — date
  • manufactureCountry — varchar
  • retailPrice — int
  • quantity — int
  • progressStatus — varchar
  • file — varchar
  • remark — varchar

ProductCategory

  • largeCategory — varchar — Primary key — NOT NULL
  • mediumCategory — varchar — Primary key — NOT NULL
  • largeCategoryName — varchar
  • mediumCategoryName — varchar

ProductCode

  • productCode — varchar — Primary key — NOT NULL
  • productName — varchar
  • useYN — boolean
  • createDate — date
  • creator — varchar