[dbo].[action]

Property	Value
Row Count	0
Created	11:07:58 AM Wednesday, March 07, 2007
Last Modified	11:09:57 AM Wednesday, March 07, 2007

Property

Value

Row Count

Created

11:07:58 AM Wednesday, March 07, 2007

Last Modified

11:09:57 AM Wednesday, March 07, 2007

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