Change_Log

Definition

CREATE   VIEW
  [mr].[Change_Log] AS
SELECT
  [l].[Change_Log_Id],
  CAST([v].[Created] AS DATETIME2(3)) [Event_Time],
  REPLACE(
    REPLACE([lt].[Name_Key], 'changelog.type.', ''),
    '.name',
    ''
  ) [Event_Type],
  REPLACE(
    REPLACE([opt].[Name], 'enum.operation.type.', ''),
    '.name',
    ''
  ) [Record_Type],
  [l].[Space_Id],
  [l].[Application_Id],
  [l].[Object_Id],
  [l].[Object_Type_Id],
  [u].[User_Id],
  [l].[Previous_Value],
  [l].[New_Value]
FROM
  [dbo].[MR_Change_Log] [l]
  JOIN [dbo].[MR_Version] [v]  ON [v].[Version_Id] = [l].[Version_Id]
  JOIN [dbo].[C_Change_Log_Type] [lt]  ON [lt].[Change_Log_Type_Id] = [l].[Change_Log_Type_Id]
  JOIN [dbo].[APP_Operation_Type] [opt]  ON [opt].[Operation_Type_Id] = [lt].[Operation_Type_Id]
  JOIN [dbo].[APP_User] [u]  ON [u].[User_Id] = [v].[Creator_Id]

Columns

#	Column	Data Type	Nullable	Source
1	Change_Log_Id	int	No	MR_Change_Log.Change_Log_Id
2	Event_Time	datetime2	Yes	MR_Version.Created
3	Event_Type	nvarchar	Yes	C_Change_Log_Type.Name_Key
4	Record_Type	nvarchar	Yes	APP_Operation_Type.Name
5	Space_Id	int	Yes	MR_Change_Log.Space_Id
6	Application_Id	int	Yes	MR_Change_Log.Application_Id
7	Object_Id	int	Yes	MR_Change_Log.Object_Id
8	Object_Type_Id	int	Yes	MR_Change_Log.Object_Type_Id
9	User_Id	int	No	APP_User.User_Id
10	Previous_Value	nvarchar	Yes	MR_Change_Log.Previous_Value
11	New_Value	nvarchar	Yes	MR_Change_Log.New_Value

graph LR
  n1558["Change_Log"]
  n1251["MR_Version"]
  n1254["MR_Change_Log"]
  n1263["C_Change_Log_Type"]
  n1272["APP_Operation_Type"]
  n1288["APP_User"]
  n1251 --> n1558
  n1254 --> n1558
  n1263 --> n1558
  n1272 --> n1558
  n1288 --> n1558
  style n1558 fill:#00A081,stroke:#008068,color:#fff
  click n1558 href "/actual/changelog/"
  click n1251 href "/actual/mrversion/"
  click n1254 href "/actual/mrchangelog/"
  click n1263 href "/actual/cchangelogtype/"
  click n1272 href "/actual/appoperationtype/"
  click n1288 href "/actual/appuser/"