[dbo].[ca_requirement_spec

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	49717
Created	11:08:06 AM Wednesday, March 07, 2007
Last Modified	9:08:10 PM Friday, December 05, 2008

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

49717

Created

11:08:06 AM Wednesday, March 07, 2007

Last Modified

9:08:10 PM Friday, December 05, 2008

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKca_requirement_spec_item: owner_object_uuid\requirement_spec_type\group_sequence\item_sequence_number$	item_sequence_number	tinyint	1
$Cluster Primary Key XPKca_requirement_spec_item: owner_object_uuid\requirement_spec_type\group_sequence\item_sequence_number$ $Foreign Keys $ca_re_r000005c100000000: [dbo].[ca_requirement_spec_group].owner_object_uuid\requirement_spec_type\group_sequence$ $Indexes xif1ca_requirement_spec_item: owner_object_uuid\group_sequence\requirement_spec_type$	owner_object_uuid	binary(16)	16
$Cluster Primary Key XPKca_requirement_spec_item: owner_object_uuid\requirement_spec_type\group_sequence\item_sequence_number$ $Foreign Keys $ca_re_r000005c100000000: [dbo].[ca_requirement_spec_group].owner_object_uuid\requirement_spec_type\group_sequence$ $Indexes xif1ca_requirement_spec_item: owner_object_uuid\group_sequence\requirement_spec_type$	group_sequence	smallint	2
$Cluster Primary Key XPKca_requirement_spec_item: owner_object_uuid\requirement_spec_type\group_sequence\item_sequence_number$ $Foreign Keys $ca_re_r000005c100000000: [dbo].[ca_requirement_spec_group].owner_object_uuid\requirement_spec_type\group_sequence$ $Indexes xif1ca_requirement_spec_item: owner_object_uuid\group_sequence\requirement_spec_type$	requirement_spec_type	tinyint	1
	referenced_object_uuid	binary(16)	16
	spec_item_operator	nvarchar(5)	10
	not_indicator	tinyint	1
	item_type_id	tinyint	1
	upper_bound_sw_def_uuid	binary(16)	16
	lang_code	nchar(5)	10
	class_id	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key XPKca_requirement_spec_item: owner_object_uuid\requirement_spec_type\group_sequence\item_sequence_number$

item_sequence_number

tinyint

$Cluster Primary Key XPKca_requirement_spec_item: owner_object_uuid\requirement_spec_type\group_sequence\item_sequence_number$ $Foreign Keys $ca_re_r000005c100000000: [dbo].[ca_requirement_spec_group].owner_object_uuid\requirement_spec_type\group_sequence$ $Indexes xif1ca_requirement_spec_item: owner_object_uuid\group_sequence\requirement_spec_type$

owner_object_uuid

binary(16)

group_sequence

smallint

requirement_spec_type

tinyint

referenced_object_uuid

binary(16)

spec_item_operator

nvarchar(5)

not_indicator

tinyint

item_type_id

tinyint

upper_bound_sw_def_uuid

binary(16)

lang_code

nchar(5)

class_id

int

	Name	Columns
$Cluster Primary Key XPKca_requirement_spec_item: owner_object_uuid\requirement_spec_type\group_sequence\item_sequence_number$	XPKca_requirement_spec_item	owner_object_uuid, requirement_spec_type, group_sequence, item_sequence_number
	ix_req_spec_item_class_id	class_id
	xif1ca_requirement_spec_item	owner_object_uuid, group_sequence, requirement_spec_type

Name

Columns

Unique

$Cluster Primary Key XPKca_requirement_spec_item: owner_object_uuid\requirement_spec_type\group_sequence\item_sequence_number$

XPKca_requirement_spec_item

owner_object_uuid, requirement_spec_type, group_sequence, item_sequence_number

ix_req_spec_item_class_id

class_id

xif1ca_requirement_spec_item

owner_object_uuid, group_sequence, requirement_spec_type

Name	Columns
$ca_re_r000005b700000000	lang_code->[dbo].[ca_language].[lang_code]
$ca_re_r000005c100000000	owner_object_uuid->[dbo].[ca_requirement_spec_group].[owner_object_uuid] requirement_spec_type->[dbo].[ca_requirement_spec_group].[requirement_spec_type] group_sequence->[dbo].[ca_requirement_spec_group].[group_sequence]
$ca_re_r000005cb00000000	class_id->[dbo].[ca_class_def].[class_id]

Name

Columns

$ca_re_r000005b700000000

lang_code->[dbo].[ca_language].[lang_code]

$ca_re_r000005c100000000

owner_object_uuid->[dbo].[ca_requirement_spec_group].[owner_object_uuid]
requirement_spec_type->[dbo].[ca_requirement_spec_group].[requirement_spec_type]
group_sequence->[dbo].[ca_requirement_spec_group].[group_sequence]

$ca_re_r000005cb00000000

class_id->[dbo].[ca_class_def].[class_id]

Type	Action	Owning Principal
Grant	Insert	ca_itrm_group
Grant	Delete	upmadmin_group
Grant	Insert	upmadmin_group
Grant	Delete	upmuser_group
Grant	Insert	upmuser_group
Grant	Delete	ca_itrm_group
Grant	Select	ca_itrm_group
Grant	Update	ca_itrm_group
Grant	Select	regadmin
Grant	Select	upmadmin_group
Grant	Update	upmadmin_group
Grant	Select	upmuser_group
Grant	Update	upmuser_group
Grant	Select	ca_itrm_group_ams

Type

Action

Owning Principal

Grant

Insert

ca_itrm_group

Grant

Delete

upmadmin_group

Grant

Insert

upmadmin_group

Grant

Delete

upmuser_group

Grant

Insert

upmuser_group

Grant

Delete

ca_itrm_group

Grant

Select

ca_itrm_group

Grant

Update

ca_itrm_group

Grant

Select

regadmin

Grant

Select

upmadmin_group

Grant

Update

upmadmin_group

Grant

Select

upmuser_group

Grant

Update

upmuser_group

Grant

Select

ca_itrm_group_ams

SQL Script

CREATE TABLE [dbo].[ca_requirement_spec_item]
(
[item_sequence_number] [tinyint] NOT NULL,
[owner_object_uuid] [binary] (16) NOT NULL,
[group_sequence] [smallint] NOT NULL,
[requirement_spec_type] [tinyint] NOT NULL,
[referenced_object_uuid] [binary] (16) NULL,
[spec_item_operator] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[not_indicator] [tinyint] NULL,
[item_type_id] [tinyint] NULL,
[upper_bound_sw_def_uuid] [binary] (16) NULL,
[lang_code] [nchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[class_id] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_requirement_spec_item] ADD CONSTRAINT [XPKca_requirement_spec_item] PRIMARY KEY CLUSTERED ([owner_object_uuid], [requirement_spec_type], [group_sequence], [item_sequence_number]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_req_spec_item_class_id] ON [dbo].[ca_requirement_spec_item] ([class_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1ca_requirement_spec_item] ON [dbo].[ca_requirement_spec_item] ([owner_object_uuid], [group_sequence], [requirement_spec_type]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_requirement_spec_item] ADD CONSTRAINT [$ca_re_r000005b700000000] FOREIGN KEY ([lang_code]) REFERENCES [dbo].[ca_language] ([lang_code])
GO
ALTER TABLE [dbo].[ca_requirement_spec_item] ADD CONSTRAINT [$ca_re_r000005c100000000] FOREIGN KEY ([owner_object_uuid], [requirement_spec_type], [group_sequence]) REFERENCES [dbo].[ca_requirement_spec_group] ([owner_object_uuid], [requirement_spec_type], [group_sequence])
GO
ALTER TABLE [dbo].[ca_requirement_spec_item] ADD CONSTRAINT [$ca_re_r000005cb00000000] FOREIGN KEY ([class_id]) REFERENCES [dbo].[ca_class_def] ([class_id])
GO
GRANT SELECT ON  [dbo].[ca_requirement_spec_item] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_requirement_spec_item] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_requirement_spec_item] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_requirement_spec_item] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_requirement_spec_item] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_requirement_spec_item] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_requirement_spec_item] TO [upmadmin_group]
GRANT INSERT ON  [dbo].[ca_requirement_spec_item] TO [upmadmin_group]
GRANT DELETE ON  [dbo].[ca_requirement_spec_item] TO [upmadmin_group]
GRANT UPDATE ON  [dbo].[ca_requirement_spec_item] TO [upmadmin_group]
GRANT SELECT ON  [dbo].[ca_requirement_spec_item] TO [upmuser_group]
GRANT INSERT ON  [dbo].[ca_requirement_spec_item] TO [upmuser_group]
GRANT DELETE ON  [dbo].[ca_requirement_spec_item] TO [upmuser_group]
GRANT UPDATE ON  [dbo].[ca_requirement_spec_item] TO [upmuser_group]
GO