• Please create an empty database and run following sqls.

    Add some data into them .

    USE [SampleProperty]

    GO

    /****** Object: Table [dbo].[EPropertyData] Script Date: 01/16/2014 16:36:46 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    CREATE TABLE [dbo].[EPropertyData](

    [ID] [int] IDENTITY(1,1) NOT NULL,

    [ObjectId] [int] NULL,

    [PropertyDefID] [int] NULL,

    [PropValue] [nvarchar](255) NULL,

    CONSTRAINT [aaaaaEPropertyData2_PK] PRIMARY KEY NONCLUSTERED

    (

    [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

    USE [SampleProperty]

    GO

    /****** Object: Table [dbo].[Equipment] Script Date: 01/16/2014 16:37:34 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    CREATE TABLE [dbo].[Equipment](

    [EquipId] [int] IDENTITY(1,1) NOT NULL,

    [EquipmentNo] [nvarchar](200) NULL,

    [Description] [nvarchar](110) NULL,

    [EqType] [nvarchar](50) NULL,

    [EquipTypeID] [int] NULL,

    [ParentID] [int] NULL,

    CONSTRAINT [aaaaaEquipment2_PK] PRIMARY KEY NONCLUSTERED

    (

    [EquipId] 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

    USE [SampleProperty]

    GO

    /****** Object: Table [dbo].[EquipmentTypes] Script Date: 01/16/2014 16:37:44 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    CREATE TABLE [dbo].[EquipmentTypes](

    [EquipTypeID] [int] NOT NULL,

    [EquipmentType] [nvarchar](50) NULL,

    CONSTRAINT [aaaaaEquipmentTypes2_PK] PRIMARY KEY NONCLUSTERED

    (

    [EquipTypeID] 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

    USE [SampleProperty]

    GO

    /****** Object: Table [dbo].[PropertyDef] Script Date: 01/16/2014 16:38:21 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    CREATE TABLE [dbo].[PropertyDef](

    [PropertyDefID] [int] IDENTITY(1,1) NOT NULL,

    [PropName] [nvarchar](100) NOT NULL,

    [Caption] [nvarchar](100) NULL,

    [ObjectTypeID] [int] NOT NULL,

    CONSTRAINT [aaaaaPropertyDef2_PK] PRIMARY KEY NONCLUSTERED

    (

    [PropertyDefID] 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