ERD-Migration
Tables (12)
address
- addressID — int — Primary key — NOT NULL
- addressLine1 — varchar(60) — NOT NULL
- addressLine2 — varchar(60)
- city — varchar(30) — NOT NULL
- stateProvince — VARCHAR(60) — NOT NULL
- countryRegion — VARCHAR(60) — NOT NULL
- postalCode — varchar(15) — NOT NULL
- rowguid — text — NOT NULL
- modifiedDate — datetime — NOT NULL
buildversion
- systemInformationID — int
- database — Version`
- versionDate — datetime
- modifiedDate — datetime
customer
- customerID — int — Primary key — NOT NULL
- nameStyle — text — NOT NULL
- title — varchar(8)
- firstName — text — NOT NULL
- middleName — text
- lastName — text — NOT NULL
- suffix — varchar(10)
- companyName — varchar(128)
- salesPerson — varchar(256)
- emailAddress — varchar(50)
- phone — text
- passwordHash — varchar(128) — NOT NULL
- passwordSalt — varchar(10) — NOT NULL
- rowguid — text — NOT NULL
- modifiedDate — datetime — NOT NULL
customeraddress
- addressID (addressID2) — int — Foreign key → address.addressID — NOT NULL
- customerID (customerID2) — int — Foreign key → customer.customerID — NOT NULL
- addressType — text — NOT NULL
- rowguid — text — NOT NULL
- modifiedDate — datetime — NOT NULL
errorlog
- errorLogID — bigint — Primary key — NOT NULL
- errorTime — datetime — NOT NULL
- userName — text — NOT NULL
- errorNumber — int — NOT NULL
- errorSeverity — int
- errorState — int
- errorProcedure — varchar(126)
- errorLine — int
- errorMessage — varchar(4000) — NOT NULL
product
- productID — int — Primary key — NOT NULL
- name — NVARCHAR(50) — NOT NULL
- productNumber — NVARCHAR(25) — NOT NULL
- color — NVARCHAR(15)
- standardCost — text — NOT NULL
- listPrice — text — NOT NULL
- weight — DECIMAL(8,2)
- size — NVARCHAR(10)
- sellStartDate — datetime — NOT NULL
- sellEndDate — datetime
- discontinuedDate — datetime
- thumbNailPhoto — TEXT
- thumbnailPhotoFileName — VARCHAR(50)
- rowguid — text — NOT NULL
- modifiedDate — datetime — NOT NULL
- productModelID (productModelID2) — int — Foreign key → productModel.productModelID — NOT NULL
- productCategoryID (productCategoryID2) — int — Foreign key → productcategory.productCategoryID — NOT NULL
productModel
- productModelID — int — Primary key — NOT NULL
- name — text — NOT NULL
- catalogDescription — text
- rowguid — text — NOT NULL
- modifiedDate — datetime — NOT NULL
productcategory
- productCategoryID — int — Primary key — NOT NULL
- name — text — NOT NULL
- rowguid — text — NOT NULL
- modifiedDate — datetime — NOT NULL
- productCategoryID (productCategoryID2) — int — Foreign key → productcategory.productCategoryID — NOT NULL
productdescription
- productDescriptionID — int — Primary key — NOT NULL
- description — varchar(400) — NOT NULL
- rowguid — text — NOT NULL
- modifiedDate — datetime — NOT NULL
productmodeldesc
- culture — char(6) — Primary key — NOT NULL
- productModelID — int — Foreign key → productModel.productModelID — NOT NULL
- productDescriptionID (productDescriptionID2) — int — Foreign key → productdescription.productDescriptionID — NOT NULL
- rowguid — text
- modifiedDate — datetime
salesorderdetail
- salesOrderDetailID — int — Primary key — NOT NULL
- salesOrderID (salesOrderID2) — int — Foreign key → salesorderheader.salesOrderID — NOT NULL
- orderQty — smallint — NOT NULL
- productID — int — NOT NULL
- unitPrice — text — NOT NULL
- unitPriceDiscount — text — NOT NULL
- lineTotal — text — NOT NULL
- rowguid — text — NOT NULL
- modifiedDate — datetime — NOT NULL
- productID (productID2) — int — Foreign key → product.productID — NOT NULL
salesorderheader
- salesOrderID — int — Primary key — NOT NULL
- revisionNumber — tinyint — NOT NULL
- orderDate — datetime — NOT NULL
- dueDate — datetime — NOT NULL
- shipDate — datetime
- status — tinyint — NOT NULL
- onlineOrderFlag — int — NOT NULL
- salesOrderNumber — text
- purchaseOrderNumber — text
- accountNumber — text
- customerID — int — NOT NULL
- shipToAddressID — int
- billToAddressID — int
- shipMethod — varchar(50) — NOT NULL
- creditCardApprovalCode — varchar(15)
- subTotal — text — NOT NULL
- taxAmt — text — NOT NULL
- freight — text — NOT NULL
- totalDue — text — NOT NULL
- comment — longtext
- rowguid — text — NOT NULL
- modifiedDate — datetime — NOT NULL
- addressID — int — Foreign key → address.addressID — NOT NULL
- customerID (customerID2) — int — Foreign key → customer.customerID — NOT NULL