Comment

Definition

CREATE   VIEW
  [mr].[Comment] AS
SELECT
  [c].[Comment_Id],
  [c].[Parent_Comment_Id],
  [c].[Object_Id],
  [c].[Start_Version_Id],
  [c].[End_Version_Id],
  [c].[User_Id],
  [c].[Text_Value] [Value],
  [c].[State_Id],
  [c].[Workflow_State_Id],
  [c].[Data]
FROM
  [dbo].[MR_Comment] [c]

Columns

#	Column	Data Type	Nullable	Source
1	Comment_Id	int	No	MR_Comment.Comment_Id
2	Parent_Comment_Id	int	Yes	MR_Comment.Parent_Comment_Id
3	Object_Id	int	No	MR_Comment.Object_Id
4	Start_Version_Id	int	No	MR_Comment.Start_Version_Id
5	End_Version_Id	int	Yes	MR_Comment.End_Version_Id
6	User_Id	int	No	MR_Comment.User_Id
7	Value	nvarchar	Yes	MR_Comment.Text_Value
8	State_Id	int	No	MR_Comment.State_Id
9	Workflow_State_Id	int	Yes	MR_Comment.Workflow_State_Id
10	Data	nvarchar	Yes	MR_Comment.Data

graph LR
  n1540["Comment"]
  n1276["MR_Comment"]
  n1276 --> n1540
  style n1540 fill:#00A081,stroke:#008068,color:#fff
  click n1540 href "/actual/comment/"
  click n1276 href "/actual/mrcomment/"