[dbo].[HAREXECUTABLEACTION]

Property	Value
Row Count	38
Created	4:59:43 AM Monday, March 02, 2009
Last Modified	5:00:29 AM Monday, March 02, 2009

Property

Value

Row Count

Created

4:59:43 AM Monday, March 02, 2009

Last Modified

5:00:29 AM Monday, March 02, 2009

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key HAREXECUTABLEACTION_PK: RESOURCETYPEOBJID\ACTIONOBJID$	RESOURCETYPEOBJID	int	4
$Cluster Primary Key HAREXECUTABLEACTION_PK: RESOURCETYPEOBJID\ACTIONOBJID$	ACTIONOBJID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key HAREXECUTABLEACTION_PK: RESOURCETYPEOBJID\ACTIONOBJID$

RESOURCETYPEOBJID

int

$Cluster Primary Key HAREXECUTABLEACTION_PK: RESOURCETYPEOBJID\ACTIONOBJID$

ACTIONOBJID

int

	Name	Columns	Unique
$Cluster Primary Key HAREXECUTABLEACTION_PK: RESOURCETYPEOBJID\ACTIONOBJID$	HAREXECUTABLEACTION_PK	RESOURCETYPEOBJID, ACTIONOBJID

Name

Columns

Unique

$Cluster Primary Key HAREXECUTABLEACTION_PK: RESOURCETYPEOBJID\ACTIONOBJID$

HAREXECUTABLEACTION_PK

RESOURCETYPEOBJID, ACTIONOBJID

Name	Columns
HAREXECUTABLEACTION_ACTID_FK	ACTIONOBJID->[dbo].[HARACTION].[ACTIONOBJID]
HAREXECUTABLEACTION_RTID_FK	RESOURCETYPEOBJID->[dbo].[HARRESOURCETYPE].[RESOURCETYPEOBJID]

Name

Columns

HAREXECUTABLEACTION_ACTID_FK

ACTIONOBJID->[dbo].[HARACTION].[ACTIONOBJID]

HAREXECUTABLEACTION_RTID_FK

RESOURCETYPEOBJID->[dbo].[HARRESOURCETYPE].[RESOURCETYPEOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HAREXECUTABLEACTION table stores the identify of the resource type of an auditable action which is the resource or parent resource on which action is executed.
Caption	COLUMN	ACTIONOBJID	Object ID identifying the audit action. This column identifies a record in the HARACTION table.
Caption	COLUMN	RESOURCETYPEOBJID	Object ID of the resource type on which the action is executed. For example, for a Create State action this will be the resource type of the project on which the action is executed against. For an Update State action, this will be the resource type of a state object. This column is an index to the HARRESOURCETYPE table.

Name

Level 2 Type

Level 2 Name

Value

Caption

The HAREXECUTABLEACTION table stores the identify of the resource type of an auditable action which is the resource or parent resource on which action is executed.

Caption

COLUMN

ACTIONOBJID

Object ID identifying the audit action. This column identifies a record in the HARACTION table.

Caption

COLUMN

RESOURCETYPEOBJID

Object ID of the resource type on which the action is executed. For example, for a Create State action this will be the resource type of the project on which the action is executed against. For an Update State action, this will be the resource type of a state object. This column is an index to the HARRESOURCETYPE table.

SQL Script

CREATE TABLE [dbo].[HAREXECUTABLEACTION]
(
[RESOURCETYPEOBJID] [int] NOT NULL,
[ACTIONOBJID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HAREXECUTABLEACTION] ADD CONSTRAINT [HAREXECUTABLEACTION_PK] PRIMARY KEY CLUSTERED ([RESOURCETYPEOBJID], [ACTIONOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HAREXECUTABLEACTION] ADD CONSTRAINT [HAREXECUTABLEACTION_ACTID_FK] FOREIGN KEY ([ACTIONOBJID]) REFERENCES [dbo].[HARACTION] ([ACTIONOBJID])
GO
ALTER TABLE [dbo].[HAREXECUTABLEACTION] ADD CONSTRAINT [HAREXECUTABLEACTION_RTID_FK] FOREIGN KEY ([RESOURCETYPEOBJID]) REFERENCES [dbo].[HARRESOURCETYPE] ([RESOURCETYPEOBJID])
GO
EXEC sp_addextendedproperty N'Caption', N'The HAREXECUTABLEACTION table stores the identify of the resource type of an auditable action which is the resource or parent resource on which action is executed. ', 'SCHEMA', N'dbo', 'TABLE', N'HAREXECUTABLEACTION', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID identifying the audit action. This column identifies a record in the HARACTION table.', 'SCHEMA', N'dbo', 'TABLE', N'HAREXECUTABLEACTION', 'COLUMN', N'ACTIONOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of the resource type on which the action is executed. For example, for a Create State action this will be the resource type of the project on which the action is executed against. For an Update State action, this will be the resource type of a state object. This column is an index to the HARRESOURCETYPE table.', 'SCHEMA', N'dbo', 'TABLE', N'HAREXECUTABLEACTION', 'COLUMN', N'RESOURCETYPEOBJID'
GO