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