CREATE TABLE [dbo].[grpcls_classes_cies]
(
[clscie_class_id] [int] NOT NULL,
[clscie_company_id] [int] NOT NULL,
[clscie_default_group] [varchar] (3) COLLATE French_CI_AS NULL,
[clscie_default_class] [varchar] (3) COLLATE French_CI_AS NULL,
[clscie_default_theft] [varchar] (3) COLLATE French_CI_AS NULL,
[clscie_sra_group] [varchar] (2) COLLATE French_CI_AS NULL,
[clscie_sra_class] [varchar] (2) COLLATE French_CI_AS NULL,
[clscie_sra_repair] [varchar] (2) COLLATE French_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[grpcls_classes_cies] ADD CONSTRAINT [PK_grpcls_classes_cies] PRIMARY KEY CLUSTERED  ([clscie_class_id], [clscie_company_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[grpcls_classes_cies] ADD CONSTRAINT [FK_grpcls_classes_cies_grpcls_classes] FOREIGN KEY ([clscie_class_id]) REFERENCES [dbo].[grpcls_classes] ([clsc_class_id])
GO
ALTER TABLE [dbo].[grpcls_classes_cies] ADD CONSTRAINT [FK_grpcls_classes_cies_act_cies] FOREIGN KEY ([clscie_company_id]) REFERENCES [dbo].[act_cies] ([cie_actor_id])
GO
