[dbo].[action]

Property	Value
Row Count	0
Created	12:30:39 PM Sunday, December 05, 2010
Last Modified	12:33:25 PM Sunday, December 05, 2010

Property

Value

Row Count

Created

12:30:39 PM Sunday, December 05, 2010

Last Modified

12:33:25 PM Sunday, December 05, 2010

Name	Data Type	Max Length (Bytes)
actionid	int	4
requesttime	datetime	8
starttime	datetime	8
finishtime	datetime	8
actiongroupid	int	4
actiontype	int	4
actionstatus	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

actionid

int

requesttime

datetime

starttime

datetime

finishtime

datetime

actiongroupid

int

actiontype

int

actionstatus

int

	Name	Columns	Unique
	XPKaction	actionid

Name

Columns

Unique

XPKaction

actionid

Name	Columns
$actio_r00003db000000000	actiontype->[dbo].[actiontype].[actiontype]

Name

Columns

$actio_r00003db000000000

actiontype->[dbo].[actiontype].[actiontype]

SQL Script

CREATE TABLE [dbo].[action]
(
[actionid] [int] NOT NULL,
[requesttime] [datetime] NULL,
[starttime] [datetime] NULL,
[finishtime] [datetime] NULL,
[actiongroupid] [int] NOT NULL,
[actiontype] [int] NULL,
[actionstatus] [int] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[action] ADD CONSTRAINT [XPKaction] PRIMARY KEY CLUSTERED ([actionid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[action] ADD CONSTRAINT [$actio_r00003db000000000] FOREIGN KEY ([actiontype]) REFERENCES [dbo].[actiontype] ([actiontype])
GO