USE [MERCEDES_ENTITY]
GO
ALTER TABLE [dbo].[IntegratorMappingDetails] DROP CONSTRAINT [FK_IntegratorMappingDetails_IntegratorMappings]
GO
/****** Object:  Table [dbo].[IntegratorMappingDetails]    Script Date: 4/3/2023 3:18:37 PM ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[IntegratorMappingDetails]') AND TYPE IN (N'U'))
DROP TABLE [dbo].[IntegratorMappingDetails]
GO
/****** Object:  Table [dbo].[IntegratorMappingDetails]    Script Date: 4/3/2023 3:18:37 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[IntegratorMappingDetails](
    [integrator_mapping_detail_id] [INT] NOT NULL,
    [integrator_mapping_id] [INT] NOT NULL,
    [text_origin] [VARCHAR](100) NOT NULL,
    [text_destination] [VARCHAR](100) NOT NULL,
    [format] [VARCHAR](50) NULL,
 CONSTRAINT [PK_IntegratorMappingDetails] PRIMARY KEY CLUSTERED
(
    [integrator_mapping_detail_id] ASC,
    [integrator_mapping_id] ASC,
    [text_origin] ASC,
    [text_destination] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[IntegratorMappingDetails] ([integrator_mapping_detail_id], [integrator_mapping_id], [text_origin], [text_destination], [format]) VALUES (1, 1, N'business_name', N'business_name_test', NULL)
GO
INSERT [dbo].[IntegratorMappingDetails] ([integrator_mapping_detail_id], [integrator_mapping_id], [text_origin], [text_destination], [format]) VALUES (2, 1, N'commercial_name', N'commercial_name_test', NULL)
GO
INSERT [dbo].[IntegratorMappingDetails] ([integrator_mapping_detail_id], [integrator_mapping_id], [text_origin], [text_destination], [format]) VALUES (3, 1, N'country_id', N'country_id_test', NULL)
GO
INSERT [dbo].[IntegratorMappingDetails] ([integrator_mapping_detail_id], [integrator_mapping_id], [text_origin], [text_destination], [format]) VALUES (4, 1, N'creation_date', N'creation_date_test', NULL)
GO
INSERT [dbo].[IntegratorMappingDetails] ([integrator_mapping_detail_id], [integrator_mapping_id], [text_origin], [text_destination], [format]) VALUES (5, 1, N'economic_sector_id', N'economic_sector_id_test', NULL)
GO
INSERT [dbo].[IntegratorMappingDetails] ([integrator_mapping_detail_id], [integrator_mapping_id], [text_origin], [text_destination], [format]) VALUES (6, 1, N'entity_id', N'entity_id_test', NULL)
GO
INSERT [dbo].[IntegratorMappingDetails] ([integrator_mapping_detail_id], [integrator_mapping_id], [text_origin], [text_destination], [format]) VALUES (7, 1, N'external_reference', N'external_reference_test', NULL)
GO
INSERT [dbo].[IntegratorMappingDetails] ([integrator_mapping_detail_id], [integrator_mapping_id], [text_origin], [text_destination], [format]) VALUES (8, 1, N'fiscal_key_id', N'fiscal_key_id_test', NULL)
GO
INSERT [dbo].[IntegratorMappingDetails] ([integrator_mapping_detail_id], [integrator_mapping_id], [text_origin], [text_destination], [format]) VALUES (9, 1, N'fiscal_key_value', N'fiscal_key_value_test', NULL)
GO
INSERT [dbo].[IntegratorMappingDetails] ([integrator_mapping_detail_id], [integrator_mapping_id], [text_origin], [text_destination], [format]) VALUES (10, 1, N'status', N'status_test', NULL)
GO
ALTER TABLE [dbo].[IntegratorMappingDetails]  WITH CHECK ADD  CONSTRAINT [FK_IntegratorMappingDetails_IntegratorMappings] FOREIGN KEY([integrator_mapping_id])
REFERENCES [dbo].[IntegratorMappings] ([integrator_mapping_id])
GO
ALTER TABLE [dbo].[IntegratorMappingDetails] CHECK CONSTRAINT [FK_IntegratorMappingDetails_IntegratorMappings]
GO