Table NameNameData TypePrimary KeyUniqueRequiredAutoincrementCharsetCollationComment
customerscustomerNumberint(11)truefalsetruefalse
customerscustomerNamevarchar(50)falsefalsetruefalselatin1latin1_swedish_ci
customerscontactLastNamevarchar(50)falsefalsetruefalselatin1latin1_swedish_ci
customerscontactFirstNamevarchar(50)falsefalsetruefalselatin1latin1_swedish_ci
customersphonevarchar(50)falsefalsetruefalselatin1latin1_swedish_ci
customersaddressLine1varchar(50)falsefalsetruefalselatin1latin1_swedish_ci
customersaddressLine2varchar(50)falsefalsefalsefalselatin1latin1_swedish_ci
customerscityvarchar(50)falsefalsetruefalselatin1latin1_swedish_ci
customersstatevarchar(50)falsefalsefalsefalselatin1latin1_swedish_ci
customerspostalCodevarchar(15)falsefalsefalsefalselatin1latin1_swedish_ci
customerscountryvarchar(50)falsefalsetruefalselatin1latin1_swedish_ci
customerssalesRepEmployeeNumberint(11)falsefalsefalsefalse
customerscreditLimitdoublefalsefalsefalsefalse