02 - Inventory Project - Stock Inventory Table DB Design - Inventory with PHPMaker

Описание: In this video we setup Stock Items Table for the project "Inventory Management System" I will explain you all the fields. You can use following sql statement at your local database.

CREATE TABLE `stock_items` (
`StockItemID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`ProductName` VARCHAR(99) NOT NULL,
`ProductCode` VARCHAR(99) NOT NULL,
`CategoryIDFK` INTEGER UNSIGNED,
`Quantity` FLOAT(10,0) DEFAULT 0,
`UnitsOfMeasurement` VARCHAR(45),
`PurchasingPrice` FLOAT(10,2),
`SellingPrice` FLOAT(10,2),
`LowStockQty` INTEGER UNSIGNED,
`ProductImage` VARCHAR(255),
`Notes` VARCHAR(255),
`CreatedByIDFK` INTEGER UNSIGNED,
`CreatedDate` DATETIME,
`LastUpdatedByIDFK` INTEGER UNSIGNED,
`LastUpdatedDate` DATETIME,
PRIMARY KEY (`StockItemID`)
);

Create Inventory Management System from Scratch with PHPMaker series:    • Inventory Management System with PHPMaker  

Topics covered in this video tutorial:
How to create Inventory Management System?
Setup database table for Inventory project?
Inventory Project table setup

Kindly check video in detail and let us know your thoughts in comments.

For any query related to PHPMaker or PHPMaker project work you can contact us on [email protected]


SHARE || SUBSCRIBE || LIKE