[dbo].[externalaction]

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

Name	Data Type	Max Length (Bytes)
actionid	int	4
acceptingactorcountry	varchar(50)	50
acceptingactororganisation	varchar(50)	50
acceptingactororgunit	varchar(50)	50
acceptingactorname	varchar(50)	50
actortype	int	4
actorname	varchar(50)	50
actioncomment	varchar(300)	300
acceptingactorcomment	varchar(300)	300

	Name	Columns	Unique
	XPKexternalaction	actionid

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

SQL Script

CREATE TABLE [dbo].[externalaction]
(
[actionid] [int] NOT NULL,
[acceptingactorcountry] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[acceptingactororganisation] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[acceptingactororgunit] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[acceptingactorname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[actortype] [int] NULL,
[actorname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[actioncomment] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[acceptingactorcomment] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[externalaction] ADD CONSTRAINT [XPKexternalaction] PRIMARY KEY CLUSTERED ([actionid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[externalaction] ADD CONSTRAINT [$exter_r00003e0400000000] FOREIGN KEY ([actionid]) REFERENCES [dbo].[action] ([actionid])
GO