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)