wideworldimporters

Tables (6)

customers (Untitled4)

  • CustomerID (Key) — int(11) — Primary key — NOT NULL
  • CustumerName (Field) — varchar(100) — NOT NULL
  • BillToCustomerID (Field2) — int(11) — NOT NULL
  • Field3

orderlines (Untitled2)

  • OrderLineID (Key) — int(11) — Primary key — NOT NULL
  • OrderID (Key2) — int(11) — Foreign key → orders.OrderID — NOT NULL
  • stockItemID — int(11) — Foreign key → stockitems.stockItemID — NOT NULL
  • Description (Field) — varchar(100)
  • Quantity (Field2) — int(11) — NOT NULL
  • UnitPrice (Field3) — decimal(18,2)
  • TaxRate (Field4) — decimal(18,3) — NOT NULL
  • PickedQuantity (Field5) — int(11) — NOT NULL
  • PickingCompletedWhen (Field6) — datetime
  • LastEditedBy (Field7) — int(11) — NOT NULL
  • LastEditedWhen (Field8) — datetime — NOT NULL

orders (Untitled3)

  • OrderID (Key) — int(11) — Primary key — NOT NULL

productattributes (custom)

  • id — int(6) auto_increment — Primary key — NOT NULL
  • attribute_name — varchar(45) — The name of the attribute
  • attribute_code — varchar(45) — The code of the attribute
  • attribute_type — int(2) foreign key — The type of attribute

productattributevalue (2)

  • id — int(6) auto_increment — Primary key — NOT NULL
  • attribute_id — int(6) — Foreign key → productattributes.id — NOT NULL — To which attribute this value belongs
  • stockitem_id — int(11) — Foreign key → stockitems.stockItemID — To which product (stockitem) this value belongs
  • attribute_value — mediumtext — NOT NULL — The value to store

stockitems (Untitled)

  • stockItemID — int(11) — Primary key — NOT NULL
  • stockItemName — varchar(100) — NOT NULL
  • SupplierID — int(11) — NOT NULL
  • ColorID — int(11)
  • Brand — varchar(50)
  • Size — varchar(20)
  • Barcode — varchar(50)
  • TaxRate — decimal(18,3) — NOT NULL
  • UnitPrice — decimal(18,2) — NOT NULL
  • MarketingComments — longtext
  • Photo — longblob
  • CustomFields — longtext
  • LastEditedBy — int(11) — NOT NULL