[dbo].[si_financial

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:31 AM Wednesday, March 07, 2007
Last Modified	11:09:44 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key $si_fi_u000014f400000000: uuid\data_source$ $Indexes ix_si_financial_prop_1: type\uuid$	uuid	binary(16)	16
$Cluster Primary Key $si_fi_u000014f400000000: uuid\data_source$	data_source	varchar(256)	256
$Indexes ix_si_financial_prop_1: type\uuid$	type	nvarchar(100)	200
	last_update_date	datetime	8
	label	nvarchar(100)	200
	actual_cost	money	8
	desired_cost	money	8
	industry_cost	money	8

	Name	Columns
$Cluster Primary Key $si_fi_u000014f400000000: uuid\data_source$	$si_fi_u000014f400000000	uuid, data_source
	baseidx_si_financial_prop	uuid
	ix_si_financial_prop_1	type, uuid
	ix_si_financial_prop_2	last_update_date

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

SQL Script

CREATE TABLE [dbo].[si_financial_prop]
(
[uuid] [binary] (16) NOT NULL,
[data_source] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[type] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [datetime] NULL,
[label] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[actual_cost] [money] NULL,
[desired_cost] [money] NULL,
[industry_cost] [money] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[si_financial_prop] ADD CONSTRAINT [$si_fi_u000014f400000000] PRIMARY KEY CLUSTERED ([uuid], [data_source]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_si_financial_prop_2] ON [dbo].[si_financial_prop] ([last_update_date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_si_financial_prop_1] ON [dbo].[si_financial_prop] ([type], [uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_si_financial_prop] ON [dbo].[si_financial_prop] ([uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[si_financial_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_financial_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_financial_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_financial_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_financial_prop] TO [aipublic]
GRANT SELECT ON  [dbo].[si_financial_prop] TO [aiuser]
GRANT INSERT ON  [dbo].[si_financial_prop] TO [aiuser]
GRANT DELETE ON  [dbo].[si_financial_prop] TO [aiuser]
GRANT UPDATE ON  [dbo].[si_financial_prop] TO [aiuser]
GRANT SELECT ON  [dbo].[si_financial_prop] TO [siadmins]
GRANT INSERT ON  [dbo].[si_financial_prop] TO [siadmins]
GRANT DELETE ON  [dbo].[si_financial_prop] TO [siadmins]
GRANT UPDATE ON  [dbo].[si_financial_prop] TO [siadmins]
GO