SQl Code表设计

在Asp.net后有很多常用的表结构 membership就是一个典型，除此还有code表
CREATE TABLE [dbo].[CodeTables](
    [CodeTableID] [uniqueidentifier] NOT NULL,
    [ParentCodeTableID] [uniqueidentifier] NULL,
    [Name] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Alias] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Description] [varchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ItemCodeMinLength] [int] NULL,
    [ItemCodeMaxLength] [int] NULL,
    [CreatedBy] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CreatedDate] [datetime] NOT NULL,
    [LastUpdatedBy] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LastUpdatedDate] [datetime] NULL,
    [RecordStatus] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_CodeTables] PRIMARY KEY CLUSTERED
(
    [CodeTableID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[CodeItems](
    [CodeItemID] [uniqueidentifier] NOT NULL,
    [CodeTableID] [uniqueidentifier] NOT NULL,
    [ParentCodeItemID] [uniqueidentifier] NULL,
    [Description] [varchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Code] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CreatedBy] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CreatedDate] [datetime] NOT NULL,
    [LastUpdatedBy] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LastUpdatedDate] [datetime] NULL,
    [RecordStatus] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_CodeItems] PRIMARY KEY CLUSTERED
(