CREATE TABLE [dbo].[md_dictionaries_strings]
(
[dicts_dictionary_code] [dbo].[ais_code_short] NOT NULL,
[dicts_string_name] [dbo].[ais_name] NOT NULL,
[dicts_string] [nvarchar] (255) COLLATE French_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[md_dictionaries_strings] ADD CONSTRAINT [PK_md_dictionaries_strings] PRIMARY KEY CLUSTERED  ([dicts_dictionary_code], [dicts_string_name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[md_dictionaries_strings] ADD CONSTRAINT [FK_md_dictionaries_strings_md_dictionaries] FOREIGN KEY ([dicts_dictionary_code]) REFERENCES [dbo].[md_dictionaries] ([dict_dictionary_code])
GO
ALTER TABLE [dbo].[md_dictionaries_strings] ADD CONSTRAINT [FK_md_dictionaries_strings_md_strings] FOREIGN KEY ([dicts_string_name]) REFERENCES [dbo].[md_strings] ([str_string_name])
GO
