CREATE TABLE [dbo].[grpcls_brands]
(
[clsb_group_code] [dbo].[ais_code_short] NOT NULL,
[clsb_brand_code] [dbo].[ais_code_short] NOT NULL
) ON [PRIMARY]


GO
ALTER TABLE [dbo].[grpcls_brands] ADD CONSTRAINT [PK_grpcls_groups_brands] PRIMARY KEY CLUSTERED  ([clsb_group_code], [clsb_brand_code]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[grpcls_brands] ADD CONSTRAINT [FK_grpcls_groups_brands_nm_brands] FOREIGN KEY ([clsb_brand_code]) REFERENCES [dbo].[nm_brands] ([brd_brand_code])
GO
ALTER TABLE [dbo].[grpcls_brands] ADD CONSTRAINT [FK_grpcls_groups_brands_grpcls_groups] FOREIGN KEY ([clsb_group_code]) REFERENCES [dbo].[grpcls_groups] ([clsg_group_code])
GO
