SQLize | PHPize | SQLtest

CREATE TABLE [dbo].[CLIENT]( [ID] [int] IDENTITY(1,1) NOT NULL, [CODE] [int] NULL, [EXTERNAL_CODE] [varchar](20) NULL, [IDATE_TIME] [datetime] NOT NULL CONSTRAINT [DF_CLIENT_IDATE_TIME] DEFAULT (getdate()), [CDATE_TIME] [datetime] NULL, [SYS_REC] [tinyint] NOT NULL CONSTRAINT [DF_CLIENT_SYS_REC] DEFAULT ((0)), [FLAG_ACT] [tinyint] NOT NULL CONSTRAINT [DF_CLIENT_FLAG_ACT] DEFAULT ((1)), [FLAG_SEL] [tinyint] NOT NULL CONSTRAINT [DF_CLIENT_FLAG_SEL] DEFAULT ((0)), [FNAME] [varchar](255) NOT NULL, [SEX_CODE] [int] NOT NULL CONSTRAINT [DF_CLIENT_SEX_CODE] DEFAULT ((0)), [PHONE] [varchar](50) NULL, [EMAIL] [varchar](50) NULL, [CITY_NAME] [varchar](50) NULL, [ADDRESS] [varchar](255) NULL, [REG_DATE_TIME] [datetime] NOT NULL CONSTRAINT [DF_CLIENT_REG_DATE_TIME] DEFAULT (getdate()), [BIRTH_DATE] [datetime] NULL, [MEMORY_DATE] [datetime] NULL, [PHOTO_FILE_NAME] [varchar](50) NULL, [NOTE] [text] NULL, [INFO_SOURCE_ID] [int] NULL, [CLIENT_CLASSIFIER01_CODE] [varchar](4) NULL, [CLIENT_CLASSIFIER02_CODE] [varchar](4) NULL, [CLIENT_CLASSIFIER03_CODE] [varchar](4) NULL, [CLIENT_CLASSIFIER04_CODE] [varchar](4) NULL, [CLIENT_CLASSIFIER05_CODE] [varchar](4) NULL, [CLIENT_CLASSIFIER06_CODE] [varchar](4) NULL, [CLIENT_CLASSIFIER07_CODE] [varchar](4) NULL, [CLIENT_CLASSIFIER08_CODE] [varchar](4) NULL, [CLIENT_CLASSIFIER09_CODE] [varchar](4) NULL, [CLIENT_CLASSIFIERS_CODES] [varchar](50) NULL, [FLAG_SYNC] [tinyint] NOT NULL CONSTRAINT [DF_CLIENT_FLAG_SYNC] DEFAULT ((0)), [PARENT_ID] [int] NULL, [PARENT_NAME] [varchar](80) NULL, [PARENT_PHONE] [varchar](60) NULL, [PHOTO] [image] NULL, CONSTRAINT [PK_CLIENT] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[CLIENT] WITH NOCHECK ADD CONSTRAINT [FK1_CLIENT] FOREIGN KEY([CLIENT_CLASSIFIER01_CODE]) REFERENCES [dbo].[CLIENT_CLASSIFIER] ([CODE]) GO ALTER TABLE [dbo].[CLIENT] CHECK CONSTRAINT [FK1_CLIENT] GO ALTER TABLE [dbo].[CLIENT] WITH NOCHECK ADD CONSTRAINT [FK10_CLIENT] FOREIGN KEY([INFO_SOURCE_ID]) REFERENCES [dbo].[INFO_SOURCE] ([ID]) GO ALTER TABLE [dbo].[CLIENT] CHECK CONSTRAINT [FK10_CLIENT] GO ALTER TABLE [dbo].[CLIENT] WITH NOCHECK ADD CONSTRAINT [FK2_CLIENT] FOREIGN KEY([CLIENT_CLASSIFIER02_CODE]) REFERENCES [dbo].[CLIENT_CLASSIFIER] ([CODE]) GO ALTER TABLE [dbo].[CLIENT] CHECK CONSTRAINT [FK2_CLIENT] GO ALTER TABLE [dbo].[CLIENT] WITH NOCHECK ADD CONSTRAINT [FK3_CLIENT] FOREIGN KEY([CLIENT_CLASSIFIER03_CODE]) REFERENCES [dbo].[CLIENT_CLASSIFIER] ([CODE]) GO ALTER TABLE [dbo].[CLIENT] CHECK CONSTRAINT [FK3_CLIENT] GO ALTER TABLE [dbo].[CLIENT] WITH NOCHECK ADD CONSTRAINT [FK4_CLIENT] FOREIGN KEY([CLIENT_CLASSIFIER04_CODE]) REFERENCES [dbo].[CLIENT_CLASSIFIER] ([CODE]) GO ALTER TABLE [dbo].[CLIENT] CHECK CONSTRAINT [FK4_CLIENT] GO ALTER TABLE [dbo].[CLIENT] WITH NOCHECK ADD CONSTRAINT [FK5_CLIENT] FOREIGN KEY([CLIENT_CLASSIFIER05_CODE]) REFERENCES [dbo].[CLIENT_CLASSIFIER] ([CODE]) GO ALTER TABLE [dbo].[CLIENT] CHECK CONSTRAINT [FK5_CLIENT] GO ALTER TABLE [dbo].[CLIENT] WITH NOCHECK ADD CONSTRAINT [FK6_CLIENT] FOREIGN KEY([CLIENT_CLASSIFIER06_CODE]) REFERENCES [dbo].[CLIENT_CLASSIFIER] ([CODE]) GO ALTER TABLE [dbo].[CLIENT] CHECK CONSTRAINT [FK6_CLIENT] GO ALTER TABLE [dbo].[CLIENT] WITH NOCHECK ADD CONSTRAINT [FK7_CLIENT] FOREIGN KEY([CLIENT_CLASSIFIER07_CODE]) REFERENCES [dbo].[CLIENT_CLASSIFIER] ([CODE]) GO ALTER TABLE [dbo].[CLIENT] CHECK CONSTRAINT [FK7_CLIENT] GO ALTER TABLE [dbo].[CLIENT] WITH NOCHECK ADD CONSTRAINT [FK8_CLIENT] FOREIGN KEY([CLIENT_CLASSIFIER08_CODE]) REFERENCES [dbo].[CLIENT_CLASSIFIER] ([CODE]) GO ALTER TABLE [dbo].[CLIENT] CHECK CONSTRAINT [FK8_CLIENT] GO ALTER TABLE [dbo].[CLIENT] WITH NOCHECK ADD CONSTRAINT [FK9_CLIENT] FOREIGN KEY([CLIENT_CLASSIFIER09_CODE]) REFERENCES [dbo].[CLIENT_CLASSIFIER] ([CODE]) GO ALTER TABLE [dbo].[CLIENT] CHECK CONSTRAINT [FK9_CLIENT]