[aiowner].[ai_swdef_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	45202
Created	9:12:28 AM Thursday, November 06, 2008
Last Modified	7:34:17 PM Friday, March 19, 2010

	Name	Data Type	Max Length (Bytes)	Default
	source_type_id	int	4
	source_domuuid_char	varchar(36)	36
	source_pubuuid_char	varchar(36)	36
$Indexes ai_swdef_prop_s_ak4: source_swuuid_char\source_domid\source_apid$	source_swuuid_char	varchar(36)	36
	source_domuuid	uniqueidentifier	16
	source_pubuuid	uniqueidentifier	16
	source_swuuid	uniqueidentifier	16
$Indexes ai_swdef_prop_s_ak2: source_domid\source_apid$ $Indexes ai_swdef_prop_s_ak4: source_swuuid_char\source_domid\source_apid$	source_domid	int	4
	source_pubid	int	4
$Indexes ai_swdef_prop_s_ak2: source_domid\source_apid$ $Indexes ai_swdef_prop_s_ak4: source_swuuid_char\source_domid\source_apid$	source_apid	int	4
	pubuuid	uniqueidentifier	16
	swuuid	uniqueidentifier	16
	swpub	nvarchar(128)	256	('')
	swname	nvarchar(128)	256	('')
	swver	nvarchar(255)	510
	swrel	nvarchar(128)	256
	swmod	nvarchar(128)	256
	swbld	nvarchar(128)	256
	swnote	nvarchar(128)	256
	swlang	nvarchar(128)	256

Name	Columns
ai_swdef_prop_s_ak1	source_swuuid
ai_swdef_prop_s_ak2	source_domid, source_apid
ai_swdef_prop_s_ak3	swname
ai_swdef_prop_s_ak4	source_swuuid_char, source_domid, source_apid

SQL Script

CREATE TABLE [aiowner].[ai_swdef_prop_s]
(
[source_type_id] [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 NOT NULL,
[source_domuuid] [uniqueidentifier] NULL,
[source_pubuuid] [uniqueidentifier] NULL,
[source_swuuid] [uniqueidentifier] NULL,
[source_domid] [int] NOT NULL,
[source_pubid] [int] NULL,
[source_apid] [int] NOT NULL,
[pubuuid] [uniqueidentifier] NULL,
[swuuid] [uniqueidentifier] NULL,
[swpub] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_swdef___swpub__4C71B3F0] DEFAULT (''),
[swname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_swdef___swnam__4D65D829] DEFAULT (''),
[swver] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[swrel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[swmod] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[swbld] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[swnote] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[swlang] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_prop_s_ak2] ON [aiowner].[ai_swdef_prop_s] ([source_domid], [source_apid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_prop_s_ak1] ON [aiowner].[ai_swdef_prop_s] ([source_swuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_prop_s_ak4] ON [aiowner].[ai_swdef_prop_s] ([source_swuuid_char], [source_domid], [source_apid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_swdef_prop_s_ak3] ON [aiowner].[ai_swdef_prop_s] ([swname]) ON [PRIMARY]
GO