Fields
Name |
Engine |
Collation |
Row Count |
Data Length |
Last Inserted Id |
Comment |
Average Row Length |
Row Format |
Created |
Updated |
Table Name |
Name |
Data Type |
Primary Key |
Unique |
Required |
Autoincrement |
Charset |
Collation |
Comment |
Orders
|
OrderID
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
Orders
|
CustomerID
|
varchar(5)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
Orders
|
EmployeeID
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
Orders
|
OrderDate
|
datetime
|
|
|
|
|
NULL
|
NULL
|
|
Orders
|
RequiredDate
|
datetime
|
|
|
|
|
NULL
|
NULL
|
|
Orders
|
ShippedDate
|
datetime
|
|
|
|
|
NULL
|
NULL
|
|
Orders
|
ShipVia
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
Orders
|
Freight
|
decimal(10,4)
|
|
|
|
|
NULL
|
NULL
|
|
Orders
|
ShipName
|
varchar(40)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
Orders
|
ShipAddress
|
varchar(60)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
Orders
|
ShipCity
|
varchar(15)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
Orders
|
ShipRegion
|
varchar(15)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
Orders
|
ShipPostalCode
|
varchar(10)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
Orders
|
ShipCountry
|
varchar(15)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|