GO
CREATE TABLE [dbo].[ZL_Survey](
[Surveyid] [int] IDENTITY(1,1) NOT NULL,
[Surveyname] [nvarchar](255) NOT NULL,
[Description] [text] NULL,
[Createdate] [datetime] NULL CONSTRAINT [DF_ZL_Survey_Createdate]  DEFAULT (getdate()),
[Endtime] [datetime] NULL CONSTRAINT [DF_ZL_Survey_Endtime]  DEFAULT (getdate()),
[Isopen] [bit] NULL CONSTRAINT [DF_ZL_Survey_Isopen]  DEFAULT ((1)),
[NeedLogin] [bit] NULL CONSTRAINT [DF_ZL_Survey_NeedLogin]  DEFAULT ((0)),
[Surtype] [int] NULL CONSTRAINT [DF_ZL_Survey_Surtype]  DEFAULT ((1)),
[Iprepeat] [int] NULL CONSTRAINT [DF_ZL_Survey_Iprepeat]  DEFAULT ((1)),
[StartTime] [datetime] NULL CONSTRAINT [DF_ZL_Survey_StartTime]  DEFAULT (getdate()),
[IsStatus] [bit] NULL CONSTRAINT [DF_ZL_Survey_IsStatus]  DEFAULT ((0)),
[IsCheck] [bit] NULL CONSTRAINT [DF_ZL_Survey_IsCheck]  DEFAULT ((0)),
[IsShow] [int] Null

CONSTRAINT [PK_ZL_Survey] PRIMARY KEY CLUSTERED
(
[Surveyid] 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]