[dbo].[ai_orgdef

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	157
Created	11:06:58 AM Wednesday, March 07, 2007
Last Modified	11:10:02 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)	Default
hwuuid	uniqueidentifier	16
orgnm	nvarchar(255)	510	(' ')
region	nvarchar(255)	510	(' ')

	Name	Columns
	ai_orgdef_rel_ak1	hwuuid
	ai_orgdef_rel_ak2	region
	ai_orgdef_rel_ak3	orgnm

Type	Action	Owning Principal
Grant	Delete	aiadmin
Grant	Insert	aiadmin
Grant	Select	aiadmin
Grant	Update	aiadmin
Grant	Select	aipublic

SQL Script

CREATE TABLE [dbo].[ai_orgdef_rel]
(
[hwuuid] [uniqueidentifier] NOT NULL,
[orgnm] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_orgdef__orgnm__34C04EDE] DEFAULT (' '),
[region] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_orgdef__regio__35B47317] DEFAULT (' ')
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_orgdef_rel_ak1] ON [dbo].[ai_orgdef_rel] ([hwuuid]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [ai_orgdef_rel_ak3] ON [dbo].[ai_orgdef_rel] ([orgnm]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_orgdef_rel_ak2] ON [dbo].[ai_orgdef_rel] ([region]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_orgdef_rel] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_orgdef_rel] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_orgdef_rel] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_orgdef_rel] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_orgdef_rel] TO [aipublic]
GO