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