[dbo].[approvalaction]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:08:02 AM Wednesday, March 07, 2007
Last Modified	11:09:57 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
actionid	int	4
approvercountry	varchar(50)	50
approverorganisation	varchar(50)	50
approverorgunit	varchar(50)	50
approvername	varchar(50)	50
approval	int	4
actortype	int	4
actorname	varchar(50)	50
approvercomment	varchar(300)	300
approvalcomment	varchar(300)	300

	Name	Columns	Unique
	XPKapprovalaction	actionid

Name	Columns
$appro_r00003ddf00000000	actionid->[dbo].[action].[actionid]

SQL Script

CREATE TABLE [dbo].[approvalaction]
(
[actionid] [int] NOT NULL,
[approvercountry] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[approverorganisation] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[approverorgunit] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[approvername] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[approval] [int] NULL,
[actortype] [int] NULL,
[actorname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[approvercomment] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[approvalcomment] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[approvalaction] ADD CONSTRAINT [XPKapprovalaction] PRIMARY KEY CLUSTERED ([actionid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[approvalaction] ADD CONSTRAINT [$appro_r00003ddf00000000] FOREIGN KEY ([actionid]) REFERENCES [dbo].[action] ([actionid])
GO