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