CREATE TABLE [dbo].[umr_values]
(
[umrv_umr_code] [dbo].[ais_code_long] NOT NULL,
[umrv_date] [date] NOT NULL,
[umrv_value] [varchar] (30) COLLATE French_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[umr_values] ADD CONSTRAINT [PK_umr_values] PRIMARY KEY CLUSTERED  ([umrv_umr_code], [umrv_date]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[umr_values] ADD CONSTRAINT [FK_umr_values_nm_umr1] FOREIGN KEY ([umrv_umr_code]) REFERENCES [dbo].[nm_umr] ([umr_umr_code])
GO
