GO

CREATE TABLE [dbo].[ZL_BossInfo](

[nodeid] [int] IDENTITY(1,1) NOT NULL,

[parentid] [int] NULL,

[shoptype] [int] NULL,

[userid] [int] NULL,

[Childs] [int] NULL CONSTRAINT [DF_ZL_BossInfo_Childs]  DEFAULT ((0)),

[CMoney] [money] NULL,

[Province] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[city] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[CName] [nchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[Address] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[Agent] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[license] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[CTel] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[CInfo] [ntext] COLLATE Chinese_PRC_CI_AS NULL,

[ContractNum] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[AccountPeople] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[Bank] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[BankNum] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[AccountPeople2] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[Bank2] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[BankNum2] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[linkname] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[linksex] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[linkPositions] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[linktel] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[fax] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[PostCode] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[email] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[Documents] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

[DocumentsNUm] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,

CONSTRAINT [PK_ZL_BossInfo] PRIMARY KEY CLUSTERED 

([nodeid] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]