CREATE TABLE [dbo].[ObjectType] (
	 ID		SmallInt	IDENTUTY
	 CONSTRAINT [PK_ObjectType]	PRIMARY KEY
	,Name		SysName		NOT NULL
	 CONSTARINT [UQ_ObjectType]	UNIQUE
)
CREATE TABLE [dbo].[Property] (
	 ID		SmallInt	IDENTUTY
	 CONSTRAINT [PK_Property]	PRIMARY KEY
	,Name		SysName		NOT NULL
	,CONSTARINT [UQ_Property]	UNIQUE
	,Type		Int		NOT NULL	-- Значения из sys.types.user_type_id
)
CREATE TABLE [dbo].[PropertyObjectType] (
	 ObjectType	SmallInt
	 CONSTRAINT [FK_PropertyObjectType_ObjectType]	REFERNCES [dbo].[ObjectType] ([ID])
	,Property	SmallInt
	 CONSTRAINT [FK_PropertyObjectType_Property]	REFERNCES [dbo].[Property] ([ID])
	,CONSTRAINT [PK_PropertyObjectType]		PRIMARY KEY (
		 ObjectType
		,Property
	)
)
CREATE TABLE [dbo].[Object] (
	 ID	Int		IDENTUTY
	 CONSTRAINT [PK_Object]		PRIMARY KEY
	,Type	SmallInt	NOT NULL
	 CONSTRAINT [FK_Object_Type]	REFERNCES [dbo].[ObjectType] ([ID])
	-- ... набор стандартных полей
)
CREATE TABLE [dbo].[ObjectProperty] (
	 [Object]	Int		IDENTUTY
	 CONSTRAINT [FK_ObjectProperty_Object]		REFERNCES [dbo].[Object] ([ID])
	,Property	SmallInt
	 CONSTRAINT [FK_ObjectProperty_Property]	REFERNCES [dbo].[Property] ([ID])
	,CONSTRAINT [PK_ObjectProperty]			PRIMARY KEY (
		 [Object]
		,Property
	)
	,Value		Sql_Variant	NOT NULL
)