27,579
社区成员
发帖
与我相关
我的任务
分享
/****** 实体属性表 ******/
CREATE TABLE [dbo].[EntityProperty](
[Id] [int] IDENTITY(1,1) NOT NULL,
[EntityId] [int] NOT NULL,
[Type] [int] NOT NULL,
[Name] [nvarchar](60) NOT NULL,
[Alias] [nvarchar](60) NULL,
[Description] [nvarchar](200) NULL,
[CreatedOn] [date] NOT NULL,
[UpdatedOn] [date] NULL,
CONSTRAINT [PK_EntityProperty] PRIMARY KEY CLUSTERED
(
[Id] 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
/****** 实体表 ******/
CREATE TABLE [dbo].[Entity](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](60) NOT NULL,
[Description] [nvarchar](200) NULL,
[CreatedOn] [date] NOT NULL,
[UpdatedOn] [date] NULL,
CONSTRAINT [PK_Entity] PRIMARY KEY CLUSTERED
(
[Id] 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
/****** 属性值表 ******/
CREATE TABLE [dbo].[PropertyValue](
[Id] [int] IDENTITY(1,1) NOT NULL,
/****** 这个Identity是用来区分一个实体的标示符的,比如说,一个学生的ID,这样我就能取得所有该学生的所有属性 ******/
[PropertyIdentity] [nvarchar](64) NOT NULL,
[PropertyId] [int] NOT NULL,
[Value] [nvarchar](4000) NOT NULL,
CONSTRAINT [PK_PropertyValue] PRIMARY KEY CLUSTERED
(
[Id] 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