BGF
Tables (15)
Categories
- CategoryID — INT
- CategoryName — VARCHAR(255) — NOT NULL
- ParentCategoryID — INT
InventoryLocations
- LocationID — INT
- LocationName — VARCHAR(255)
- LocationType — ENUM('Warehouse', 'Store', 'Distribution Center')
- Address — TEXT
InventoryTransactions
- TransactionID — INT
- TransactionDate — DATE
- ProductID — INT
- PartID — INT
- Quantity — INT — NOT NULL
- SourceLocationID — INT
- DestinationLocationID — INT
- SupplierID — INT
- OrderID — INT
- TransactionType — ENUM('Inbound', 'Outbound', 'Transfer')
Members
- MemberID — INT
- MemberName — VARCHAR(255)
- MemberType — ENUM('Customer', 'Supplier')
- ContactInfo — TEXT
- Address — TEXT
OrderDetails
- OrderDetailID — INT
- OrderID — INT
- ProductID — INT
- PartID — INT
- PackageID — INT
- Quantity — INT — NOT NULL
- Price — DECIMAL(10, 2) — NOT NULL
Orders
- OrderID — INT
- MemberID — INT
- OrderDate — DATE
- OrderType — ENUM('Purchase', 'Sales')
PackageCategories
- PackageCategoryID — INT
- PackageID — INT
- CategoryID — INT
PackageContents
- PackageContentID — INT
- PackageID — INT
- ProductID — INT
- PartID — INT
- Quantity — INT — NOT NULL
PartCategories
- PartCategoryID — INT
- PartID — INT
- CategoryID — INT
Parts
- PartID — INT
- PartName — VARCHAR(255)
- PartDescription — TEXT
- PartSpecification — TEXT
ProductCategories
- ProductCategoryID — INT
- ProductID — INT
- CategoryID — INT
ProductPackages
- PackageID — INT
- PackageName — VARCHAR(255)
- PackageDescription — TEXT
Products
- ProductID — INT
- ProductName — VARCHAR(255)
- ProductDescription — TEXT
SupplierItems
- SupplierItemID — INT
- SupplierID — INT
- ProductID — INT
- PartID — INT
- PackageID — INT
Suppliers
- SupplierID — INT
- SupplierName — VARCHAR(255)
- ContactInfo — TEXT
- Address — TEXT