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: https://www.youtube.com/playlist?list=PLnaFUQM6DNkgYbw-Hlf4JGuEA2XqNFXhk

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 Learn.PHPMaker.Help@gmail.com
SHARE || SUBSCRIBE || LIKE

Видео 02 - Inventory Project - Stock Inventory Table DB Design - Inventory with PHPMaker канала Learn PHPMaker