CREATE TABLE [dbo].[nm_masterbroker_comm_values]
(
[mbcv_type_code] [dbo].[ais_code_short] NOT NULL,
[mbcv_date_setup] [date] NOT NULL,
[mbcv_value] [dbo].[ais_decimal4] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[nm_masterbroker_comm_values] ADD CONSTRAINT [PK_nm_masterbroker_comm_values] PRIMARY KEY CLUSTERED  ([mbcv_type_code], [mbcv_date_setup]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[nm_masterbroker_comm_values] ADD CONSTRAINT [FK_nm_masterbroker_comm_values_nm_masterbroker_comm_types] FOREIGN KEY ([mbcv_type_code]) REFERENCES [dbo].[nm_masterbroker_comm_types] ([mbct_type_code])
GO
