User

Definition

CREATE   VIEW
  [sec].[User] AS
SELECT
  [u].[User_Id],
  [u].[Name] AS [User],
  [u].[Email],
  [u].[Is_Group],
  [u].[Description],
  [u].[Created],
  [c].[Login] [Creator],
  [u].[First_Name],
  [u].[Last_Name],
  [u].[Phone],
  [u].[Is_Deleted],
  [u].[Login],
  [u].[Role_Id],
  [r].[Enum_Key]
FROM
  [dbo].[APP_User]  [u]
  JOIN [dbo].[APP_Role] [r] ON [r].[Role_Id] = [u].[Role_Id]
  LEFT JOIN [dbo].[APP_User] [c] ON [c].[User_Id] = [u].[Created_By]

Columns

#	Column	Data Type	Nullable	Source
1	User_Id	int	No	APP_User.User_Id
2	User	nvarchar	No	APP_User.Name
3	Email	varchar	Yes	APP_User.Email
4	Is_Group	bit	No	APP_User.Is_Group
5	Description	nvarchar	Yes	APP_User.Description
6	Created	datetime	Yes	APP_User.Created
7	Creator	nvarchar	Yes	APP_User.Login
8	First_Name	nvarchar	Yes	APP_User.First_Name
9	Last_Name	nvarchar	Yes	APP_User.Last_Name
10	Phone	nvarchar	Yes	APP_User.Phone
11	Is_Deleted	bit	No	APP_User.Is_Deleted
12	Login	nvarchar	Yes	APP_User.Login
13	Role_Id	int	Yes	APP_User.Role_Id
14	Enum_Key	nvarchar	No	APP_Role.Enum_Key

graph LR
  n1546["User"]
  n1262["APP_Role"]
  n1288["APP_User"]
  n1262 --> n1546
  n1288 --> n1546
  style n1546 fill:#00A081,stroke:#008068,color:#fff
  click n1546 href "/actual/user/"
  click n1262 href "/actual/approle/"
  click n1288 href "/actual/appuser/"