CREATE TABLE [dbo].[usm_form_entities]
(
[form_entity_id] [bigint] NOT NULL,
[form_entity_name] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[form_entity_type] [int] NOT NULL,
[tenant_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[last_modified] [datetime] NOT NULL,
[created_by] [binary] (16) NOT NULL,
[created] [datetime] NOT NULL,
[is_system] [int] NOT NULL,
[form_entity_parent_id] [bigint] NULL,
[form_entity_path] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[form_entity_position] [int] NULL,
[last_modified_by] [binary] (16) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_form_entities] ADD CONSTRAINT [XPKusm_form_entities] PRIMARY KEY CLUSTERED ([form_entity_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_forrm_entities_idx_2] ON [dbo].[usm_form_entities] ([form_entity_parent_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_forrm_entities_idx_3] ON [dbo].[usm_form_entities] ([form_entity_path]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_forrm_entities_idx_1] ON [dbo].[usm_form_entities] ([tenant_id], [form_entity_name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_form_entities] ADD CONSTRAINT [XFK1usm_form_entities] FOREIGN KEY ([tenant_id]) REFERENCES [dbo].[usm_tenant_ext] ([tenant_id])
GO
ALTER TABLE [dbo].[usm_form_entities] ADD CONSTRAINT [XFK2usm_form_entities] FOREIGN KEY ([created_by]) REFERENCES [dbo].[ca_contact] ([contact_uuid])
GO
ALTER TABLE [dbo].[usm_form_entities] ADD CONSTRAINT [XFK3usm_form_entities] FOREIGN KEY ([form_entity_parent_id]) REFERENCES [dbo].[usm_form_entities] ([form_entity_id])
GO
ALTER TABLE [dbo].[usm_form_entities] ADD CONSTRAINT [XFK4usm_form_entities] FOREIGN KEY ([last_modified_by]) REFERENCES [dbo].[ca_contact] ([contact_uuid])
GO