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