GoldHoo/doc/调整记录/已更新正式环境/2021-03-25 14.50.sql

USE [befri_Goldhoo]
GO

/****** Object:  View [replenish].[V_CusReplenishResource]    Script Date: 2021/3/25 14:48:47 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [replenish].[V_CusReplenishResource]
AS
SELECT crr.CusReplenishResourceId, crr.CusRepNumber, crr.Sequence, crr.ResourceId, crr.Description, rr.HandledUrl, 
                  rr.ThumbnailUrl, rr.OriginalUrl, rr.ResourceName, rr.ResourceTypeId, rr.MediaType, rr.TagUrl, rr.FileSize, 
                  rr.Extension, rr.UploadedBy, rr.UploadedOn, rr.Removed
FROM     replenish.CusReplenishResource AS crr LEFT OUTER JOIN
                  dbo.ResourceRepository AS rr ON crr.ResourceId = rr.ResourceId

GO