MOH - Laravel Schema Designer

Products

id increments
type enum
timestamps timestamps
priceCategoryId integer
name string
generatedName string
variantName string
barCode string
companyId string
paymentMethod enum
categoryId integer
subCategoryId integer
state enum
priceCalculation json
vatKey enum
unit string
purchasePrice float
currency enum
transferPrice string
shopCanManage boolean
ntakDetails json

priceCategories

id increments
timestamps timestamps
categoryName string
sumPrice float
lastCheckDate date

Stock

id increments
barCode string
wareHouseId string
timestamps timestamps
productId string
price float
transferPrice float
shopId integer
vatKey enum
type enum

wareHouses

id increments
timestamps timestamps

ProductMainCategories

id increments
timestamps timestamps
softDeletes softDeletes
name string (60)
useOwnProduction boolean
useFood boolean
useNonFood boolean
useGastro boolean

ProductSubCategories

id increments
timestamps timestamps
softDeletes softDeletes
categoryId integer
name string

Product_competenciesCalculation

id increments
timestamps timestamps
companiesId integer
competenciesId string
netPurchasePrice integer
grossPurchasePrice integer
vat enum
productId integer

shops

id increments
timestamps timestamps
companiesId integer
shopName string
address string
contactName string
contactTitle string
contactPhone string

productShopPrices

id increments
timestamps timestamps
shopId integer
canSell boolean
netPrice integer
grossPrice integer
hasExtraPrice boolean
profitMargin integer
minStock integer
maxStock integer

product_graphicalCode

id increments
timestamps timestamps
code string
name string

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01