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
)