表名:t_Category 描述:用于存放分类管理数据,届时,可以使用单独页面进行管理。 字段定义: f_intCategoryId f_intOrganizationId f_intParentId 0 – 首级目录 f_strNodePath 节点路径 0,123,456,667 f_isLeafNode 是否为叶子节点 TRUE / FALSE f_strOrderBy f_strNumber f_strName f_strValue 值 f_strDescription f_dtmCreated f_dtmLastModify f_strNote 建表语句: USE [db_NLMRPII] GO /****** 对象: Table [dbo].[t_Category] 脚本日期: 06/10/2011 13:44:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[t_Category]( [f_intCategoryId] [int] IDENTITY(1,1) NOT NULL, [f_intOrganizationId] [int] NOT NULL CONSTRAINT [DF_t_Category_f_intOrganizationId] DEFAULT ((0)), [f_intParentId] [int] NOT NULL CONSTRAINT [DF__T_CATEGOR__F_INT__7C8480AE] DEFAULT ((0)), [f_strNodePath] [varchar](100) NULL, [f_isLeafNode] [varchar](5) NULL CONSTRAINT [DF__T_CATEGOR__F_ISL__7D78A4E7] DEFAULT ((0)), [f_strOrderBy] [int] NULL, [f_strNumber] [varchar](100) NULL, [f_strName] [varchar](100) NULL, [f_strValue] [varchar](100) NULL, [f_strDescription] [varchar](500) NULL, [f_dtmCreated] [datetime] NOT NULL CONSTRAINT [DF_t_Category_f_dtmCreated] DEFAULT (getdate()), [f_dtmLastModified] [datetime] NULL CONSTRAINT [DF_t_Category_f_dtmLastModified] DEFAULT (getdate()), [f_strNote] [varchar](500) NULL, CONSTRAINT [PK_t_Category] PRIMARY KEY CLUSTERED ( [f_intCategoryId] 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'组织机构表ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_Category', @level2type=N'COLUMN',@level2name=N'f_intOrganizationId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'123,345,234,567' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_Category', @level2type=N'COLUMN',@level2name=N'f_strNodePath' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否为 叶子节点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_Category', @level2type=N'COLUMN',@level2name=N'f_isLeafNode'