ProdcutManagement
Tables (15)
Company (company)
- CompanyID (company_id) — INT(11) — Primary key — NOT NULL
- CompanyName (company_name) — Varchar(50)
- CompanyAddress (company_address) — Varchar(255)
- CompanyCEO (company_ceo) — Varchar(50)
Company_Product (company_product)
- Company_ProductID (Key) — INT(11) — Primary key — NOT NULL
- CompanyID (company_id) — INT(11) — Foreign key → Company.CompanyID — NOT NULL
- ProductID (product_id) — INT(11) — Foreign key → Product.ProductID — NOT NULL
Company_Warehouse (company_warehouse)
- Company_WarehouseID (Key) — INT(11) — Primary key — NOT NULL
- CompanyID (company_id) — INT(11) — Foreign key → Company.CompanyID — NOT NULL
- WarehouseID (warehouse_id) — INT(11) — Foreign key → Warehouse.WarehouseID — NOT NULL
Contract (contact)
- ContractID (contract_id) — INT(11) — Primary key — NOT NULL
- PayingSubjectID (paying_subject_id) — INT(11)
- TotalPrice (total_price) — INT(11)
- ContractDate (contract_date) — date
- CompanyID (company_id) — INT(11) — Foreign key → Company.CompanyID — NOT NULL
Contract_Payment (CopyOfcontact)
- Contract_Payment (contract_id) — INT(11) — Primary key — NOT NULL
- ContractID (contract_id2) — INT(11) — Foreign key → Contract.ContractID — NOT NULL
- PaymentID (Key) — INT(11) — Foreign key → Payment.PaymentID — NOT NULL
- PrepaidAccountID (Key2) — INT(11) — Foreign key → Prepaid_Account.PrepaidAccountID — NOT NULL
Payment (Untitled)
- PaymentID (Key) — INT(11) — Primary key — NOT NULL
- PaymentPrice (Field) — INT(11)
- CompanyID (company_id) — INT(11) — Foreign key → Company.CompanyID — NOT NULL
- PaymentMethodID (Key2) — INT(11) — Foreign key → PaymentMethod.PaymentMethodID — NOT NULL
PaymentMethod (CopyOfUntitled2)
- PaymentMethodID (Key) — INT(11) — Primary key — NOT NULL
- PaymentMethodName (Field) — Varchar(50)
- PrepaidAccountID (Key2) — INT(11) — Foreign key → Prepaid_Account.PrepaidAccountID — NOT NULL
Prepaid_Account (CopyOfUntitled)
- PrepaidAccountID (Key) — INT(11) — Primary key — NOT NULL
- InitialBalance (Field) — INT(11)
- CurrentBalance (Field2) — INT(11)
Product (product)
- ProductID (product_id) — INT(11) — Primary key — NOT NULL
- ProductName (product_name) — Varchar(50)
- ProductCategoryID (product_id2) — INT(11) — Foreign key → ProductCategory.ProductCategoryID — NOT NULL
ProductCategory (CopyOfproduct2)
- ProductCategoryID (product_id) — INT(11) — Primary key — NOT NULL
- ProductCategoryName (product_name) — Varchar(50)
Product_Contract (CopyOfcontact2)
- Product_ContractID (contract_id) — INT(11) — Primary key — NOT NULL
- TotalQuantity (Field) — INT(11)
- ContractID (contract_id2) — INT(11) — Foreign key → Contract.ContractID — NOT NULL
- ProductID (product_id) — INT(11) — Foreign key → Product.ProductID — NOT NULL
Product_Shipment (CopyOfproduct)
- ProductShipmentID (product_id) — INT(11) — Primary key — NOT NULL
- ProductID (product_id2) — INT(11) — Foreign key → Product.ProductID — NOT NULL
- ShipmentID (Key) — INT(11) — Foreign key → Shipment.ShipmentID — NOT NULL
Shipment (Untitled2)
- ShipmentID (Key) — INT(11) — Primary key — NOT NULL
- ShipmentPrice (Field) — INT(11)
- ShipmentDate (Field2) — date
- ArrivedDate (Field3) — date
- ShipmentQuantity (Field4) — INT(11)
- CompanyID (company_id) — INT(11) — Foreign key → Company.CompanyID — NOT NULL
Warehouse (warehouse)
- WarehouseID (warehouse_id) — INT(11) — Primary key — NOT NULL
- WarehouseName (warehouse_name) — Varchar(50)
- WarehouseAddress (warehouse_address) — Varchar(255)
WarehouseManager (CopyOfwarehouse)
- WarehouseManagerID (warehouse_id) — INT(11) — Primary key — NOT NULL
- WarehouseManagerName (warehouse_name) — Varchar(50)
- WarehousemanagerContact (warehouse_address) — Varchar(255)
- WarehouseManagerOccupation (Field) — Varchar(255)
- WarehouseID (warehouse_id2) — INT(11) — Foreign key → Warehouse.WarehouseID — NOT NULL