CREATE TABLE [aiowner].[ai_hfdef_prop_s]
(
[source_set_priority] [int] NULL,
[source_domuuid_char] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[source_pubuuid_char] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[source_swuuid_char] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[source_domuuid] [uniqueidentifier] NULL,
[source_pubuuid] [uniqueidentifier] NULL,
[source_swuuid] [uniqueidentifier] NULL,
[source_domid] [int] NULL,
[source_pubid] [int] NULL,
[source_apid] [int] NULL,
[pubuuid] [uniqueidentifier] NULL,
[hfuuid] [uniqueidentifier] NULL,
[hfpub] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hfname] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hfsp] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hfid] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hfver] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hfrel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hfmod] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hfbld] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hfnote] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hflang] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_prop_s_ak1] ON [aiowner].[ai_hfdef_prop_s] ([hfname]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_prop_s_ak3] ON [aiowner].[ai_hfdef_prop_s] ([source_apid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hfdef_prop_s_ak2] ON [aiowner].[ai_hfdef_prop_s] ([source_domid]) ON [PRIMARY]
GO