APP_User

This is the main repository of all users in Dawiso. It stores every information we keep about users - their basic attributes along with references to Role_Id that links to the APP_Role table to show what role they have. The table also tracks whether users is an individual or it it is a group through the Is_Group flag - when this is set, it means the record represents a user group rather than an individual user. The relationship to which user groups users belongs to is handled in the APP_User_In_Group table.

Columns

#	Column	Data Type	Nullable	PK	Identity	Computed	Collation
1	User_Id	int	No	Yes	Yes	No
2	Name	nvarchar	No	No	No	No	Czech_CI_AS
3	Email	varchar	Yes	No	No	No	Czech_CI_AS
4	Is_Group	bit	No	No	No	No
5	Description	nvarchar	Yes	No	No	No	Czech_CI_AS
6	Creator_Id	int	Yes	No	No	No
7	Created	datetime	Yes	No	No	No
8	First_Name	nvarchar	Yes	No	No	No	Czech_CI_AS
9	Last_Name	nvarchar	Yes	No	No	No	Czech_CI_AS
10	Phone	nvarchar	Yes	No	No	No	Czech_CI_AS
11	Created_By	int	No	No	No	No
12	Is_Deleted	bit	No	No	No	No
13	Login	nvarchar	Yes	No	No	No	Czech_CI_AS
14	Role_Id	int	Yes	No	No	No

Referenced By

Column	Referenced By
User_Id	C_Translation.Updater_Id
User_Id	R_User_Object.User_Id
User_Id	MR_Version.Original_Creator_Id
User_Id	C_Translation_Key.Creator_Id
User_Id	UB_Visited_Url.User_Id
User_Id	MR_Comment.User_Id
User_Id	UB_Visited_MR_Object.User_Id
User_Id	APP_User_In_Group.Group_Id
User_Id	C_Translation.Creator_Id
User_Id	C_Translation_Key.Updater_Id
User_Id	APP_Applied_Permission.User_Id
User_Id	APP_User_In_Group.User_Id
User_Id	UB_Visited_Space_Application.User_Id
User_Id	UB_Fulltext_Search.User_Id
User_Id	R_User_Space.User_Id
User_Id	MR_Version.Creator_Id

Is Data Source For

View	Columns
Change_Log	User_Id
Logs_General	Login
Object_User	Name, Login
Relation	Login
Space	Login
User	Name, Login, Created, Description, Last_Name, User_Id, Phone, Is_Group, Is_Deleted, Role_Id, Email, First_Name
User_roles_in_spaces	Name, Login, Created, Description, User_Id, Is_Group, Is_Deleted, Email
User_Space	Login
User_Space_Application	Login
User_Space_Permissions	Name, Login, Created, Description, User_Id, Is_Group, Is_Deleted, Email

Data Lineage

graph LR
  n1288["APP_User"]
  n1532["Object_User"]
  n1539["User_Space_Permissions"]
  n1545["Logs_General"]
  n1546["User"]
  n1549["User_Space"]
  n1555["User_roles_in_spaces"]
  n1557["Space"]
  n1558["Change_Log"]
  n1560["User_Space_Application"]
  n1562["Relation"]
  n1288 --> n1532
  n1288 --> n1539
  n1288 --> n1545
  n1288 --> n1546
  n1288 --> n1549
  n1288 --> n1555
  n1288 --> n1557
  n1288 --> n1558
  n1288 --> n1560
  n1288 --> n1562
  style n1288 fill:#00A081,stroke:#008068,color:#fff
  click n1288 href "/actual/appuser/"
  click n1532 href "/actual/objectuser/"
  click n1539 href "/actual/userspacepermissions/"
  click n1545 href "/actual/logsgeneral/"
  click n1546 href "/actual/user/"
  click n1549 href "/actual/userspace/"
  click n1555 href "/actual/userrolesinspaces/"
  click n1557 href "/actual/space/"
  click n1558 href "/actual/changelog/"
  click n1560 href "/actual/userspaceapplication/"
  click n1562 href "/actual/relation/"

Columns

Referenced By

Is Data Source For

Data Lineage

Related articles

We use cookies