[dbo].[ca_cic_portlet

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	9
Created	12:40:24 PM Sunday, December 05, 2010
Last Modified	12:40:24 PM Sunday, December 05, 2010

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

12:40:24 PM Sunday, December 05, 2010

Last Modified

12:40:24 PM Sunday, December 05, 2010

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key pk_cic_portlet_content: user_uuid\type\content_uuid$ $Foreign Keys fk_cic_portlet_content: [dbo].[ca_cic_portlet].user_uuid\type$	user_uuid	binary(16)	16
$Cluster Primary Key pk_cic_portlet_content: user_uuid\type\content_uuid$ $Foreign Keys fk_cic_portlet_content: [dbo].[ca_cic_portlet].user_uuid\type$	type	tinyint	1
	str_data1	nvarchar(512)	1024
	str_data2	nvarchar(512)	1024
	str_data3	nvarchar(512)	1024
	str_data4	nvarchar(512)	1024
	str_data5	nvarchar(512)	1024
	str_data6	nvarchar(512)	1024
	str_data7	nvarchar(512)	1024
	str_data8	nvarchar(512)	1024
$Cluster Primary Key pk_cic_portlet_content: user_uuid\type\content_uuid$	content_uuid	binary(16)	16

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_cic_portlet_content: user_uuid\type\content_uuid$ $Foreign Keys fk_cic_portlet_content: [dbo].[ca_cic_portlet].user_uuid\type$

user_uuid

binary(16)

$Cluster Primary Key pk_cic_portlet_content: user_uuid\type\content_uuid$ $Foreign Keys fk_cic_portlet_content: [dbo].[ca_cic_portlet].user_uuid\type$

type

tinyint

str_data1

nvarchar(512)

1024

str_data2

nvarchar(512)

1024

str_data3

nvarchar(512)

1024

str_data4

nvarchar(512)

1024

str_data5

nvarchar(512)

1024

str_data6

nvarchar(512)

1024

str_data7

nvarchar(512)

1024

str_data8

nvarchar(512)

1024

$Cluster Primary Key pk_cic_portlet_content: user_uuid\type\content_uuid$

content_uuid

binary(16)

	Name	Columns	Unique
$Cluster Primary Key pk_cic_portlet_content: user_uuid\type\content_uuid$	pk_cic_portlet_content	user_uuid, type, content_uuid

Name

Columns

Unique

$Cluster Primary Key pk_cic_portlet_content: user_uuid\type\content_uuid$

pk_cic_portlet_content

user_uuid, type, content_uuid

Name	Columns
fk_cic_portlet_content	user_uuid->[dbo].[ca_cic_portlet].[user_uuid] type->[dbo].[ca_cic_portlet].[type]

Name

Columns

fk_cic_portlet_content

user_uuid->[dbo].[ca_cic_portlet].[user_uuid]
type->[dbo].[ca_cic_portlet].[type]

Type	Action	Owning Principal
Grant	Delete	cicuser
Grant	Insert	cicuser
Grant	Select	cicuser
Grant	Update	cicuser

Type

Action

Owning Principal

Grant

Delete

cicuser

Grant

Insert

cicuser

Grant

Select

cicuser

Grant

Update

cicuser

SQL Script

CREATE TABLE [dbo].[ca_cic_portlet_content]
(
[user_uuid] [binary] (16) NOT NULL,
[type] [tinyint] NOT NULL,
[str_data1] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[str_data2] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[str_data3] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[str_data4] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[str_data5] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[str_data6] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[str_data7] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[str_data8] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[content_uuid] [binary] (16) NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ca_cic_portlet_content] ADD CONSTRAINT [pk_cic_portlet_content] PRIMARY KEY CLUSTERED ([user_uuid], [type], [content_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_cic_portlet_content] ADD CONSTRAINT [fk_cic_portlet_content] FOREIGN KEY ([user_uuid], [type]) REFERENCES [dbo].[ca_cic_portlet] ([user_uuid], [type])
GO
GRANT SELECT ON  [dbo].[ca_cic_portlet_content] TO [cicuser]
GRANT INSERT ON  [dbo].[ca_cic_portlet_content] TO [cicuser]
GRANT DELETE ON  [dbo].[ca_cic_portlet_content] TO [cicuser]
GRANT UPDATE ON  [dbo].[ca_cic_portlet_content] TO [cicuser]
GO