GO
CREATE TABLE [dbo].[Customer] (
    [Id]               UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [Name]             NVARCHAR (100)   NULL,
    [Phone]            NVARCHAR (50)    NULL,
    [Email]            NVARCHAR (100)   NULL,
    [ContactFirstName] NVARCHAR (50)    NULL,
    [ContactLastName]  NVARCHAR (50)    NULL,
    [StreetAndNumber]  NVARCHAR (50)    NULL,
    [PostalCode]       NVARCHAR (50)    NULL,
    [City]             NVARCHAR (50)    NULL,
    [Country]          NVARCHAR (50)    NULL,
    [CustomerNumber]   NVARCHAR (50)    NULL
);


GO