GO
CREATE TABLE [dbo].[ZL_Client_Enterprise](
[Flow] [int] IDENTITY(1,1) NOT NULL,
[Code] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Bank_Open] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Bank_Code] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Tax_Code] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Co_Status] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Co_Size] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Co_Management] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Reg_Capital] [money] NULL,
[Sales] [money] NULL,
[Operation_Bound] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Homepage] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Message_Address] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Phone] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Fax_phone] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Add_Date] [dateTime] NULL,
[ZipCodeW] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[country] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[province] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[city] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_ZL_Client_Enterprise] PRIMARY KEY CLUSTERED
([Code] ASC
) ON [PRIMARY]
) ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'企业编号' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Enterprise', @level2type=N'COLUMN', @level2name=N'Code'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'开户银行' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Enterprise', @level2type=N'COLUMN', @level2name=N'Bank_Open'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'银行帐号' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Enterprise', @level2type=N'COLUMN', @level2name=N'Bank_Code'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'税号' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Enterprise', @level2type=N'COLUMN', @level2name=N'Tax_Code'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'行业地位' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Enterprise', @level2type=N'COLUMN', @level2name=N'Co_Status'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'公司规模' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Enterprise', @level2type=N'COLUMN', @level2name=N'Co_Size'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'经营状态' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Enterprise', @level2type=N'COLUMN', @level2name=N'Co_Management'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'注册资本' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Enterprise', @level2type=N'COLUMN', @level2name=N'Reg_Capital'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'年销售额' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Enterprise', @level2type=N'COLUMN', @level2name=N'Sales'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'业务范围' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Enterprise', @level2type=N'COLUMN', @level2name=N'Operation_Bound'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'网址' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Enterprise', @level2type=N'COLUMN', @level2name=N'Homepage'