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