[aiowner].[ai_hfdef_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	15216
Created	11:24:56 PM Monday, January 10, 2011
Last Modified	11:24:56 PM Monday, January 10, 2011

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__3017CE69] DEFAULT (newid()),
[hfpub] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hfdef___hfpub__310BF2A2] 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__320016DB] DEFAULT ('ADDED'),
[lactdate] [datetime] NULL CONSTRAINT [DF__ai_hfdef___lactd__32F43B14] DEFAULT (getdate())
) ON [PRIMARY]

GO