CREATE TABLE [dbo].[act_cies]
(
[cie_actor_id] [int] NOT NULL,
[cie_rowver] [timestamp] NOT NULL,
[cie_met_code] [dbo].[ais_code_short] NULL,
[cie_display_name] [nvarchar] (64) COLLATE French_CI_AS NULL,
[cie_short_code] [dbo].[ais_code_short] NULL,
[cie_treaty] [bit] NOT NULL CONSTRAINT [DF__act_cies__cie_treaty] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[act_cies] ADD CONSTRAINT [PK_act_cies] PRIMARY KEY CLUSTERED  ([cie_actor_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[act_cies] ADD CONSTRAINT [FK_act_cies_act_actors] FOREIGN KEY ([cie_actor_id]) REFERENCES [dbo].[act_actors] ([act_actor_id])
GO
ALTER TABLE [dbo].[act_cies] ADD CONSTRAINT [FK_act_cies_cts_methods] FOREIGN KEY ([cie_met_code]) REFERENCES [dbo].[cts_methods] ([ctsm_met_code])
GO
