electronics_vendor_proj_v1

Tables (10)

Contract (Untitled7)

  • contract_id (Key) — Primary key — NOT NULL
  • customer_id (Key2) — Foreign key → Customer.customer_id — NOT NULL
  • valid (Field)
  • date (Field2)

Customer (Untitled6)

  • customer_id (Key) — Primary key — NOT NULL
  • name (Field)
  • phone_number (Field3)
  • card_info (Field2)

Delivery (Untitled10)

  • tracking_id (Key) — Primary key — NOT NULL
  • shipper_id (Key2) — Foreign key → Shipper.shipper_id — NOT NULL

Inventory (Untitled2)

  • inventory_id (Key) — Primary key — NOT NULL
  • product_id (Key2) — Foreign key → Product.product_id — NOT NULL
  • location_id (Key4) — Foreign key → Location.location_id — NOT NULL
  • manufacturer_id (Key22) — Foreign key → Product.manufacturer_id — NOT NULL

Location (Untitled4)

  • location_id (Key) — Primary key — NOT NULL
  • name (Field)
  • location (Field2)
  • type (Field3)

Manufacturer (Untitled5)

  • manufacturer_id (Key) — Primary key — NOT NULL
  • name (Field)
  • address (Field2)
  • phone_number (Field3)

Package (Untitled11)

  • Key — Primary key — NOT NULL
  • product_id (Key2) — Foreign key → Product.product_id — NOT NULL
  • manufacturer_id (Key22) — Foreign key → Product.manufacturer_id — NOT NULL
  • package_product_id (Key3) — Foreign key → Product.product_id — NOT NULL

Product (Untitled)

  • product_id (Key) — Primary key — NOT NULL
  • manufacturer_id (Key2) — Foreign key → Manufacturer.manufacturer_id — NOT NULL
  • name (Field)
  • type (Field2)
  • price (Field3)

Sales (Untitled8)

  • sales_id (Key) — Primary key — NOT NULL
  • inventory_id (Key2) — Foreign key → Inventory.inventory_id — NOT NULL
  • product_id (Key22) — Foreign key → Inventory.product_id — NOT NULL
  • location_id (Key4) — Foreign key → Inventory.location_id — NOT NULL
  • manufacturer_id (Key222) — Foreign key → Inventory.manufacturer_id — NOT NULL
  • customer_id (Key5) — Foreign key → Customer.customer_id — NOT NULL
  • time (Field)
  • tracking_id (Key6) — Foreign key → Delivery.tracking_id — NOT NULL

Shipper (Untitled9)

  • shipper_id (Key) — Primary key — NOT NULL
  • company_name (Field)
  • phone_number (Field2)
  • address (Field3)