/****** Object:  View [dbo].[All_Nodes]    Script Date: 2020-12-29 8:47:08 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO




CREATE VIEW [dbo].[All_Nodes]
AS
SELECT *, 'Core' AS Area FROM Core_Nodes
UNION ALL
SELECT *, 'Image' AS Area FROM Image_Nodes
UNION ALL
SELECT *, 'Import' AS Area FROM Import_Nodes
UNION ALL
SELECT *, 'Product' AS Area FROM Product_Nodes
UNION ALL
SELECT *, 'Result' AS Area FROM Result_Nodes
UNION ALL
SELECT *, 'System' AS Area FROM System_Nodes
UNION ALL
SELECT *, 'User' AS Area FROM User_Nodes
;


GO


/****** Object:  View [dbo].[All_Nodes_History]    Script Date: 2020-12-29 8:47:08 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO




CREATE VIEW [dbo].[All_Nodes_History]
AS
SELECT *, 'Core' AS Area FROM Core_Nodes_History
UNION ALL
SELECT *, 'Image' AS Area FROM Image_Nodes_History
UNION ALL
SELECT *, 'Import' AS Area FROM Import_Nodes_History
UNION ALL
SELECT *, 'Product' AS Area FROM Product_Nodes_History
UNION ALL
SELECT *, 'Result' AS Area FROM Result_Nodes_History
UNION ALL
SELECT *, 'System' AS Area FROM System_Nodes_History
UNION ALL
SELECT *, 'User' AS Area FROM User_Nodes_History
;


GO


/****** Object:  View [dbo].[All_Props]    Script Date: 2020-12-29 8:47:08 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO




CREATE VIEW [dbo].[All_Props]
AS
SELECT *, 'Core' AS Area FROM Core_Props
UNION ALL
SELECT *, 'Image' AS Area FROM Image_Props
UNION ALL
SELECT *, 'Import' AS Area FROM Import_Props
UNION ALL
SELECT *, 'Product' AS Area FROM Product_Props
UNION ALL
SELECT *, 'Result' AS Area FROM Result_Props
UNION ALL
SELECT *, 'System' AS Area FROM System_Props
UNION ALL
SELECT *, 'User' AS Area FROM User_Props
;


GO


/****** Object:  View [dbo].[All_Props_History]    Script Date: 2020-12-29 8:47:08 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO




CREATE VIEW [dbo].[All_Props_History]
AS
SELECT *, 'Core' AS Area FROM Core_Props_History
UNION ALL
SELECT *, 'Image' AS Area FROM Image_Props_History
UNION ALL
SELECT *, 'Import' AS Area FROM Import_Props_History
UNION ALL
SELECT *, 'Product' AS Area FROM Product_Props_History
UNION ALL
SELECT *, 'Result' AS Area FROM Result_Props_History
UNION ALL
SELECT *, 'System' AS Area FROM System_Props_History
UNION ALL
SELECT *, 'User' AS Area FROM User_Props_History
;


GO