RdsDiagram
Organization
primary_key: INTEGER
name: VARCHAR(-1)
User
Id: INTEGER
password: INTEGER
email: VARCHAR(0)
organizationId: INTEGER
UserDetails
Id: INTEGER
Phone: VARCHAR(0)
Name: VARCHAR(0)
UserId: INTEGER
GeneralStatuses
Id: INTEGER
Caption: VARCHAR(0)
UserStatus
Id: INTEGER
UserId: INTEGER
StatusId: INTEGER
Expired: TIMESTAMP
SetBy: INTEGER
Roles
Id: INTEGER
Name: VARCHAR(0)
Position: INTEGER
Permissions
Id: INTEGER
Caption: INTEGER
UserRoles
Id: INTEGER
UserId: INTEGER
RoleId: INTEGER
SetBy: INTEGER
RolePermission
RoleId: INTEGER
Id: INTEGER
PermissionId: INTEGER
RefreshTokens
Id: INTEGER
UserId: INTEGER
Token: INTEGER
Expiry: TIMESTAMP
IP ADDRESS: VARCHAR(0)
USER_AGENT: VARCHAR(0)
AccessTokens
Id: INTEGER
UserId: INTEGER
Token: INTEGER
IP_ADDRESS: VARCHAR(0)
USER_AGENT: VARCHAR(0)
RefreshTokenStatus
Id: INTEGER
StatusId: INTEGER
RefreshTokenId: INTEGER
SetBy: INTEGER
RefreshTokens_Id: INTEGER
BlacklistedAccessTokens
Id: INTEGER
AccessToken: INTEGER
SetBy: INTEGER
OrganizationContactInfo
primary_key: INTEGER
OrganizationId: INTEGER
Phone: CHARACTER(0)
Person: CHARACTER(0)
Address: CHARACTER(0)
Email: INTEGER
CometChatUser
primary_key: INTEGER