MR_Object

Columns

#	Column	Data Type	Nullable	PK	Identity	Computed	Collation
1	Object_Id	int	No	Yes	Yes	No
2	Branch_Id	int	No	No	No	No
3	Space_Id	int	No	No	No	No
4	Application_Id	int	No	No	No	No
5	Object_Type_Id	int	No	No	No	No
6	Source_Object_Id	int	Yes	No	No	No
7	Parent_Object_Id	int	Yes	No	No	No
8	Created_Version_Id	int	No	No	No	No
9	Start_Version_Id	int	No	No	No	No
10	Last_Changed_Version_Id	int	No	No	No	No
11	End_Version_Id	int	Yes	No	No	No
12	Is_Deleted	bit	No	No	No	No
13	Text_Value	nvarchar	Yes	No	No	No	Czech_CI_AS
14	Name	nvarchar	No	No	No	No	Czech_CI_AS
15	Workflow_State_Id	int	No	No	No	No
16	Sort_Order	int	No	No	No	No
17	Hierarchy_Path	nvarchar	Yes	No	No	No	Czech_CI_AS
18	Numbering	nvarchar	Yes	No	No	No	Czech_CI_AS
19	Requested_For_Approval_Version_Id	int	Yes	No	No	No
20	Approved_Version_Id	int	Yes	No	No	No
21	Declined_Version_Id	int	Yes	No	No	No
22	Concept_Approval_State_Id	smallint	Yes	No	No	No

Foreign Keys

Column	References
Object_Type_Id	C_Object_Type.Object_Type_Id
Workflow_State_Id	C_Workflow_State.Workflow_State_Id
Start_Version_Id	MR_Version.Version_Id
End_Version_Id	MR_Version.Version_Id
Parent_Object_Id	MR_Object.Object_Id
Approved_Version_Id	MR_Version.Version_Id
Application_Id	C_Application.Application_Id
Last_Changed_Version_Id	MR_Version.Version_Id
Requested_For_Approval_Version_Id	MR_Version.Version_Id
Space_Id	MR_Space.Space_Id
Declined_Version_Id	MR_Version.Version_Id
Source_Object_Id	MR_Object.Object_Id
Created_Version_Id	MR_Version.Version_Id

Referenced By

Column	Referenced By
Object_Id	MR_Comment.Object_Id
Object_Id	MR_Object.Parent_Object_Id
Object_Id	MR_Object_Data.Object_Id
Object_Id	R_User_Object.Object_Id
Object_Id	MR_Object_Relation.To_Object_Id
Object_Id	UB_Visited_MR_Object.Object_Id
Object_Id	MR_Object_Relation.From_Object_Id
Object_Id	MR_Object.Source_Object_Id
Object_Id	MR_Attribute.Object_Id

Is Data Source For

View	Columns
Object	Parent_Object_Id, Workflow_State_Id, Name, Hierarchy_Path, Is_Deleted, Object_Type_Id, Branch_Id, Application_Id, Object_Id, Space_Id
Object_Attribute	Name
Object_Data	Name
Object_User	Name
Relation	Name

Data Lineage

graph LR
  n1256["MR_Object"]
  n1532["Object_User"]
  n1533["Object_Attribute"]
  n1559["Object"]
  n1561["Object_Data"]
  n1562["Relation"]
  n1256 --> n1532
  n1256 --> n1533
  n1256 --> n1559
  n1256 --> n1561
  n1256 --> n1562
  style n1256 fill:#00A081,stroke:#008068,color:#fff
  click n1256 href "/actual/mrobject/"
  click n1532 href "/actual/objectuser/"
  click n1533 href "/actual/objectattribute/"
  click n1559 href "/actual/object/"
  click n1561 href "/actual/objectdata/"
  click n1562 href "/actual/relation/"

Columns

Foreign Keys

Referenced By

Is Data Source For

Data Lineage

Related articles

We use cookies