[aiowner].[ai_hfdef_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	12975
Created	9:12:22 AM Thursday, November 06, 2008
Last Modified	9:12:22 AM Thursday, November 06, 2008

Name	Data Type	Max Length (Bytes)	Default
pubuuid	uniqueidentifier	16
hfuuid	uniqueidentifier	16	(newid())
hfpub	nvarchar(128)	256	('')
hfname	nvarchar(128)	256
hfsp	nvarchar(128)	256
hfid	nvarchar(128)	256
hfver	nvarchar(128)	256
hfrel	nvarchar(128)	256
hfmod	nvarchar(128)	256
hfbld	nvarchar(128)	256
hfnote	nvarchar(128)	256
hflang	nvarchar(128)	256
laction	nvarchar(32)	64	('ADDED')
lactdate	datetime	8	(getdate())

SQL Script

CREATE TABLE [aiowner].[ai_hfdef_prop_p]
(
[pubuuid] [uniqueidentifier] NOT NULL,
[hfuuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF__ai_hfdef___hfuui__1709C778] DEFAULT (newid()),
[hfpub] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hfdef___hfpub__17FDEBB1] DEFAULT (''),
[hfname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT 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,
[laction] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_hfdef___lacti__18F20FEA] DEFAULT ('ADDED'),
[lactdate] [datetime] NULL CONSTRAINT [DF__ai_hfdef___lactd__19E63423] DEFAULT (getdate())
) ON [PRIMARY]
GO