• CREATE TABLE [dbo].[Client](

    [ID] [int] IDENTITY(100,1) NOT NULL,

    [FirstName] [varchar](50) NULL,

    [MiddleName] [varchar](50) NULL,

    [LastName] [varchar](50) NULL,

    [NationalID] [varchar](15) NULL,

    [Address1] [varchar](50) NULL,

    [Address2] [varchar](50) NULL,

    [City] [varchar](50) NULL,

    [State] [char](2) NULL,

    [PostalCode] [char](10) NULL,

    [BirthDate] [date] NULL,

    [HomePhoneNumber] [char](10) NULL,

    [WorkPhoneNumber] [char](10) NULL,

    [CellPhoneNumber] [char](10) NULL,

    [EmailAddress1] [varchar](50) NULL,

    [EmailAddress2] [varchar](50) NULL

    )