02 - Inventory Project - Stock Inventory Table DB Design - Inventory with PHPMaker
Автор: Learn PHPMaker
Загружено: 2022-11-03
Просмотров: 2440
Описание:
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
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: