USE [DNF_09] GO

/****** Object:  Table [dbo].[Dnft_tra_TreeCode]    Script Date: 11/07/2011 16:40:18 ******/ SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER ON GO

SET ANSI_PADDING ON GO

CREATE TABLE [dbo].[Dnft_tra_TreeCode](  [key_seq] [varchar](50) NOT NULL,  [link_key_seq] [varchar](50) NULL,  [Tree_Name] [nvarchar](100) NULL,  [SortID] [int] NULL,  [up_uid] [varchar](20) NOT NULL,  [up_dtime] [datetime] NOT NULL,  [cr_uid] [nvarchar](50) NOT NULL,  [cr_dtime] [datetime] NOT NULL,  [up_LKey] [varchar](50) NULL,  [OrgKey] [varchar](50) NULL,  [cr_LKey] [varchar](50) NULL,  CONSTRAINT [PK_Dnft_tra_TreeCode_key_seq ] PRIMARY KEY NONCLUSTERED (  [key_seq] ASC )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] ) ON [PRIMARY]

GO

SET ANSI_PADDING OFF GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dnft_tra_TreeCode', @level2type=N'COLUMN',@level2name=N'key_seq' GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dnft_tra_TreeCode', @level2type=N'COLUMN',@level2name=N'link_key_seq' GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'树名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dnft_tra_TreeCode', @level2type=N'COLUMN',@level2name=N'Tree_Name' GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dnft_tra_TreeCode', @level2type=N'COLUMN',@level2name=N'SortID' GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新人账号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dnft_tra_TreeCode', @level2type=N'COLUMN',@level2name=N'up_uid' GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dnft_tra_TreeCode', @level2type=N'COLUMN',@level2name=N'up_dtime' GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人账号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dnft_tra_TreeCode', @level2type=N'COLUMN',@level2name=N'cr_uid' GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dnft_tra_TreeCode', @level2type=N'COLUMN',@level2name=N'cr_dtime' GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dnft_tra_TreeCode', @level2type=N'COLUMN',@level2name=N'up_LKey' GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组织键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dnft_tra_TreeCode', @level2type=N'COLUMN',@level2name=N'OrgKey' GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dnft_tra_TreeCode', @level2type=N'COLUMN',@level2name=N'cr_LKey' GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'树编号(临时表)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dnft_tra_TreeCode' GO

ALTER TABLE [dbo].[Dnft_tra_TreeCode] ADD  CONSTRAINT [DF__Dnft_tra___key_s__2894462D]  DEFAULT (newid()) FOR [key_seq] GO

ALTER TABLE [dbo].[Dnft_tra_TreeCode] ADD  CONSTRAINT [DF__Dnft_tra___link___29886A66]  DEFAULT ('') FOR [link_key_seq] GO

ALTER TABLE [dbo].[Dnft_tra_TreeCode] ADD  CONSTRAINT [DF__Dnft_tra___up_ui__2A7C8E9F]  DEFAULT ('') FOR [up_uid] GO

ALTER TABLE [dbo].[Dnft_tra_TreeCode] ADD  CONSTRAINT [DF__Dnft_tra___up_dt__2B70B2D8]  DEFAULT (getdate()) FOR [up_dtime] GO

ALTER TABLE [dbo].[Dnft_tra_TreeCode] ADD  CONSTRAINT [DF__Dnft_tra___cr_ui__2C64D711]  DEFAULT ('') FOR [cr_uid] GO

ALTER TABLE [dbo].[Dnft_tra_TreeCode] ADD  CONSTRAINT [DF__Dnft_tra___cr_dt__2D58FB4A]  DEFAULT (getdate()) FOR [cr_dtime] GO