DROP TABLE [dbo].[Customer]
CREATE TABLE [dbo].[Customer](
[CustomerID] [int] IDENTITY(10000,1) NOT NULL,
[CustomerCode] [nchar](10) NOT NULL,
[CompanyName] [nvarchar](40) NOT NULL,
[ContactName] [nvarchar](30) NULL,
[ContactTitle] [nvarchar](30) NULL,
[AddressLine1] [nvarchar](60) NULL,
[AddressLine2] [nvarchar](60) NULL,
[City] [nvarchar](30) NULL,
[Region] [nvarchar](30) NULL,
[PostalCode] [nvarchar](10) NULL,
[Country] [nvarchar](30) NULL,
[Phone] [nvarchar](24) NULL,
[Fax] [nvarchar](24) NULL,
[DateCreated] [DateTime2] NULL,
[DateUpdated] [DateTime2] NULL
)
DROP TABLE [dbo].[Product]
CREATE TABLE [dbo].[Product](
[ProductID] [int] IDENTITY(1,1) NOT NULL,
[ProductNumber] [nvarchar](40) NOT NULL,
[ProductName] [nvarchar](40) NOT NULL,
[UnitPrice] [money] NULL,
[DateOfLastOrder] [datetime2] NULL
)
DROP TABLE [dbo].[Order_Header]
CREATE TABLE [dbo].[Order_Header](
[OrderID] [int] IDENTITY(10000,1) NOT NULL,
[CustomerID] [int],
[OrderDate] [datetime] NULL,
[ShipName] [nvarchar](40) NULL,
[ShipAddressLine1] [nvarchar](60) NULL,
[ShipAddressLine2] [nvarchar](60) NULL,
[ShipCity] [nvarchar](30) NULL,
[ShipRegion] [nvarchar](30) NULL,
[ShipPostalCode] [nvarchar](10) NULL,
[ShipCountry] [nvarchar](15) NULL
)
DROP TABLE [dbo].[Order_Detail]
CREATE TABLE [dbo].[Order_Detail](
[OrderID] [int] NOT NULL,
[ProductID] [int] NOT NULL,
[UnitPrice] [money] NOT NULL,
[Quantity] [smallint] NOT NULL
)