CREATE TABLE [dbo].[HARACTION]
(
[ACTIONOBJID] [int] NOT NULL,
[RESOURCETYPEOBJID] [int] NOT NULL,
[ACTIONNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARACTION] ADD CONSTRAINT [HARACTION_PK] PRIMARY KEY CLUSTERED ([ACTIONOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARACTION_RTID_IND] ON [dbo].[HARACTION] ([RESOURCETYPEOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARACTION] ADD CONSTRAINT [HARACTION_RTID_FK] FOREIGN KEY ([RESOURCETYPEOBJID]) REFERENCES [dbo].[HARRESOURCETYPE] ([RESOURCETYPEOBJID])
GO
EXEC sp_addextendedproperty N'Caption', N'The HARACTION table stores the definition of CA SCM actions that are auditable.', 'SCHEMA', N'dbo', 'TABLE', N'HARACTION', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the audit action (for example, Update state)', 'SCHEMA', N'dbo', 'TABLE', N'HARACTION', 'COLUMN', N'ACTIONNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID identifying the audit action', 'SCHEMA', N'dbo', 'TABLE', N'HARACTION', 'COLUMN', N'ACTIONOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of the resource type associated with the action (for example, 7 for State)', 'SCHEMA', N'dbo', 'TABLE', N'HARACTION', 'COLUMN', N'RESOURCETYPEOBJID'
GO
[dbo].[HARACTION]
![Foreign Keys HARACTION_RTID_FK: [dbo].[HARRESOURCETYPE].RESOURCETYPEOBJID](../../Images/fk.gif)
