Object

Definition

CREATE   VIEW
  [mr].[Object] AS
SELECT
  [o].[Object_Id],
  [o].[Space_Id],
  [o].[Application_Id],
  [a].[Enum_Key] [Application],
  [o].[Object_Type_Id],
  [ot].[Enum_Key] [Object_Type],
  [o].[Parent_Object_Id],
  [p].[Name] [Parent_Object_Name],
  [o].[Is_Deleted],
  CASE
    WHEN [o].[Branch_Id] = 1 THEN 0
    ELSE 1
  END AS [Is_Concept],
  [o].[Name] [Object_Name],
  [o].[Hierarchy_Path],
  [o].[Workflow_State_Id],
  [w].[Enum_Key] [Workflow_State]
FROM
  [dbo].[MR_Object] [o]
  JOIN [dbo].[C_Object_Type] [ot] ON [ot].[Object_Type_Id] = [o].[Object_Type_Id]
  JOIN [dbo].[C_Application] [a] ON [a].[Application_Id] = [o].[Application_Id]
  JOIN [dbo].[C_Workflow_State] [w] ON [w].[Workflow_State_Id] = [o].[Workflow_State_Id]
  LEFT JOIN [dbo].[MR_Object] [p] ON [p].[Object_Id] = [o].[Parent_Object_Id]

Columns

#	Column	Data Type	Nullable	Source
1	Object_Id	int	No	MR_Object.Object_Id
2	Space_Id	int	No	MR_Object.Space_Id
3	Application_Id	int	No	MR_Object.Application_Id
4	Application	nvarchar	No	C_Application.Enum_Key
5	Object_Type_Id	int	No	MR_Object.Object_Type_Id
6	Object_Type	nvarchar	No	C_Object_Type.Enum_Key
7	Parent_Object_Id	int	Yes	MR_Object.Parent_Object_Id
8	Parent_Object_Name	nvarchar	Yes	MR_Object.Name
9	Is_Deleted	bit	No	MR_Object.Is_Deleted
10	Is_Concept	int	No	MR_Object.Branch_Id
11	Object_Name	nvarchar	No	MR_Object.Name
12	Hierarchy_Path	nvarchar	Yes	MR_Object.Hierarchy_Path
13	Workflow_State_Id	int	No	MR_Object.Workflow_State_Id
14	Workflow_State	nvarchar	No	C_Workflow_State.Enum_Key

graph LR
  n1559["Object"]
  n1256["MR_Object"]
  n1259["C_Application"]
  n1264["C_Workflow_State"]
  n1267["C_Object_Type"]
  n1256 --> n1559
  n1259 --> n1559
  n1264 --> n1559
  n1267 --> n1559
  style n1559 fill:#00A081,stroke:#008068,color:#fff
  click n1559 href "/actual/object/"
  click n1256 href "/actual/mrobject/"
  click n1259 href "/actual/capplication/"
  click n1264 href "/actual/cworkflowstate/"
  click n1267 href "/actual/cobjecttype/"