Tables Schema

Find below the list of available tables from which you can fetch data. Click on the respective table link to get information like column name, description, and data type.

AppGatewayServerDetails
AMP_REMOTE_APPLICATIONS
AMP_REMOTE_APPLICATIONS_MAPPING
AMP_SSH_COMMANDS
AMP_COMMANDS_GROUP
AMP_COMMANDS_GROUP_MEMBERS
AMP_ACCOUNT_COMMAND_GROUP_MAPPING
AMP_RESOURCE_COMMAND_GROUP_MAPPING
AMP_RES_GROUP_COMMAND_GROUP_MAPPING
AMP_WebsiteRecordedSessionInfo
AaaContactInfo
AaaUser
AaaUserContactInfo

AaaPamModule
AaaPasswordRule
AaaLogin
AaaAccount
AaaAccSession
AaaRole
AaaAuthorizedRole
CIEM_CLOUD_ACCOUNTS
CIEM_AWS_IAM_USER
CIEM_AWS_IAM_GROUP
CIEM_AWS_IAM_ROLE
CIEM_AUDIT
CIEM_AWS_RISK_ACTIVE

PAM_ADMP_FeaturesList
PAM_LOCALGROUP_FeaturesList
PAM_ResElevationAccounts
PAM_SSPEAPPLIST
PAM_RESOURCEAPPMAPPING
PAM_USERSREMOTECONNECTACCESSDETAILS
PAM_Kube_Secrets
PAM_Kube_Secret_Keys
PAM_Kube_Secrets_Mapping
PAM_SSPEAccountElevationAccount
PAM_SSPEResourceCommandGroup
PAM_SSPEAccountCommandGroup
PAM_JIT_Product_Mapping

Ptrx_PasswordRule
Ptrx_Resource
Ptrx_Password
Ptrx_Account
Ptrx_AccountProperties
Ptrx_ResourceSync
Ptrx_PasswordHistory
Ptrx_Owner
Ptrx_ResourceSystem
Ptrx_ResourceSystemMembers
Ptrx_PersonalSettings
Ptrx_ResourceGroup
Ptrx_CriteriaGroup

Ptrx_ResourceGroupMembers
Ptrx_UserResGroup
Ptrx_UserGroup
Ptrx_UserGroupMembers
Ptrx_AuditConfiguration
Ptrx_UserAudit
Ptrx_ResGrpUser
Ptrx_ResGrpUserGroup
Ptrx_ResUserGroup
Ptrx_ResourceUser
Ptrx_AccountUserGroup
Ptrx_AccountUser
Ptrx_AccessedTime

Ptrx_UserDetails
Ptrx_UserGroupOption
Ptrx_ResGrpPasswordRotation
Ptrx_ListenerDetails
Ptrx_ResTypeListener
Ptrx_SuperAdmin
Ptrx_AutoLogonHelper
Ptrx_ResTypeAutoLogon
Ptrx_SchTasksDetails
Ptrx_TaskAudit
Ptrx_AccessControl
Ptrx_AccessControlMapping
Ptrx_ResourceAccessControl

Ptrx_AccountAccessControl
Ptrx_AccessControlAdmin
Ptrx_AccessControlAutoApproval
Ptrx_AccessControlUsers
Ptrx_RequestRelease
Ptrx_RequestReleaseAudit
Ptrx_RequestDomainDetails
Ptrx_DualApproval
Ptrx_TwoFactorAuth
Ptrx_UsersTwoFactorAuth
Ptrx_SyslogCollector
Ptrx_OfflineUserSettings
Ptrx_OfflineUGSettings

Ptrx_LandingServers
Ptrx_LandingServerOrder
Ptrx_UsersMobileAccessDetails
Ptrx_UsersAddonAccessDetails
Ptrx_LanguageMapping
Ptrx_ScheduleDisplayName
Ptrx_SshMessage
Ptrx_ServiceAccountMapping
Ptrx_AppPoolAccountMapping
Ptrx_AccessControlAdminGroup
Ptrx_UserStatus
Ptrx_ImportedUsersMapping
Ptrx_Role

Ptrx_RoleTree
Ptrx_RoleCategoryMapping
Ptrx_FeatureRoleMapping
Ptrx_RoleCategoryLanguageMap
Ptrx_IISWebsite
Ptrx_PKIAccountMapping
Ptrx_ADSSP_DomainDetails
Ptrx_ADMP_DomainDetails
Ptrx_ADSSP_PMP_DomainMapping
Ptrx_ADMP_PMP_DomainMapping
Ptrx_AgentInfo
Ptrx_AgentAuthTokenMapping
Ptrx_UserAgentAuthtokenMapping

Ptrx_ServerInfo
Ptrx_AgentOwnerMapping
Ptrx_ResourceAgentPort
Ptrx_UserAgentPort
Ptrx_AgentPingStatus
Ptrx_SdkPolicies
Ptrx_SdkClient
Ptrx_UserTrustScoreWeight
Ptrx_DeviceTrustScoreWeight
Ptrx_UserDeviceTrustScoreWeight
Ptrx_UserTrustPrivilegeGroupMapping
Ptrx_UserTrustIPMapping
Ptrx_DeviceTrustPrivilegeGroupMapping

Ptrx_UserTrustScore
Ptrx_UserAuthTrustScore
Ptrx_DeviceTrustScore
Ptrx_DeviceTrustAgentInformation
Ptrx_LogonTimeConfig
Ptrx_UserAgentInfo
Ptrx_UserDeviceTrustAgentInformation
Ptrx_UserDeviceTrustScore
Ptrx_ZTAgentOSQueryResponse
PTRX_AccessPolicy
PTRX_AccessPolicyAdmins
Ptrx_AccessPolicy_Details
Ptrx_AccessPolicyMapping

Ptrx_AccessPolicy_ResourceGroup_Mapping
Ptrx_AccessPolicy_CriteriaDetails
Ptrx_ZTConfigurationUserAuthDetails
Ptrx_ZTConfigurationUserDeviceDetails
Ptrx_ZTConfigurationDeviceDetails
Ptrx_ZTAgentOSQueryDetails
Ptrx_ZTScoreDetails
Ptrx_SdkClientAudit
Ptrx_TOTP_Details
Ptrx_DatabaseConf
Ptrx_JDBCProperties
Ptrx_DatabasePropertiesMapping
Ptrx_AppGatewayResMapping

PKI_SSLCoreCertData
PKI_SSLCertificateDetails
PKI_SSLIssuerDetails
PKIAudit
PKI_WHOISDATA
PKI_AuditConfiguration

AppGatewayServerDetails

Top

Column name	Description	Data type
serverid (PK)	Unique identifier of the endpoints	BIGINT
servername	Unique name for endpoint	CHAR
description	Description for endpoint	CHAR
hostname	Hostname	CHAR
pam_hostname	Hostname	CHAR
authtoken	Authtoken for endpoint	SCHAR
state	Flag variable for endpoint	BIGINT
osType	osType of appgateway installed	CHAR
isActive	osType of appgateway installed	BOOLEAN
version	Version of the AG	CHAR

Constraints

Primary key AppGatewayServerDetails(serverid)

AMP_REMOTE_APPLICATIONS

Top

Column name	Description	Data type
APPLICATION_ID (PK)	Application unique id	BIGINT
REMOTE_NAME	Name for user reference	CHAR
APPLICATION_NAME	Name of the application	CHAR
PARAMETERS	Parameters that will be passed while opening RDP	CHAR

Constraints

Primary key AMP_REMOTE_APPLICATIONS(APPLICATION_ID)

AMP_REMOTE_APPLICATIONS_MAPPING

Top

Column name	Description	Data type
RESOURCE_ID (PK)	PTRX_RESOURCE.RESOURCEID	BIGINT
APPLICATION_ID (PK)	Application unique id	BIGINT

Constraints

Primary key AMP_REMOTE_APPLICATIONS_MAPPING(APPLICATION_ID,RESOURCE_ID)
Foreign key AMP_REMOTE_APPLICATIONS_MAPPING_FK2(RESOURCE_ID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key AMP_REMOTE_APPLICATIONS_MAPPING_FK1(APPLICATION_ID) references AMP_REMOTE_APPLICATIONS(APPLICATION_ID) ON-DELETE-CASCADE

AMP_SSH_COMMANDS

Top

Column name	Description	Data type
COMMAND_ID (PK)	Unique ID for commands	BIGINT
COMMAND_NAME	Name of commands	CHAR
COMMAND	SSH command	CHAR
DESCRIPTION	Brief description about the command	CHAR

Constraints

Primary key AMP_SSH_COMMANDS(COMMAND_ID)

AMP_COMMANDS_GROUP

Top

Column name	Description	Data type
COMMAND_GROUP_ID (PK)	Unique ID for command group	BIGINT
COMMAND_GROUP_NAME	Name of command group	CHAR
DESCRIPTION	Brief description about the command group	CHAR

Constraints

Primary key AMP_COMMANDS_GROUP(COMMAND_GROUP_ID)

AMP_COMMANDS_GROUP_MEMBERS

Top

Column name	Description	Data type
COMMAND_ID (PK)	Command ID	BIGINT
COMMAND_GROUP_ID (PK)	Command group ID	BIGINT

Constraints

Primary key AMP_COMMANDS_GROUP_MEMBERS(COMMAND_GROUP_ID,COMMAND_ID)
Foreign key AMP_COMMANDS_GROUP_MEMBERS_FK1(COMMAND_GROUP_ID) references AMP_COMMANDS_GROUP(COMMAND_GROUP_ID) ON-DELETE-CASCADE
Foreign key AMP_COMMANDS_GROUP_MEMBERS_FK2(COMMAND_ID) references AMP_SSH_COMMANDS(COMMAND_ID) ON-DELETE-CASCADE

AMP_ACCOUNT_COMMAND_GROUP_MAPPING

Top

Column name	Description	Data type
COMMAND_GROUP_ID (PK)	command group id	BIGINT
ACCOUNT_ID (PK)	account id	BIGINT

Constraints

Primary key AMP_ACCOUNT_COMMAND_GROUP_MAPPING(ACCOUNT_ID,COMMAND_GROUP_ID)
Foreign key AMP_ACCOUNT_COMMAND_GROUP_MAPPING_FK2(ACCOUNT_ID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key AMP_ACCOUNT_COMMAND_GROUP_MAPPING_FK1(COMMAND_GROUP_ID) references AMP_COMMANDS_GROUP(COMMAND_GROUP_ID) ON-DELETE-CASCADE

AMP_RESOURCE_COMMAND_GROUP_MAPPING

Top

Column name	Description	Data type
COMMAND_GROUP_ID (PK)	command group id	BIGINT
RESOURCE_ID (PK)	resource id	BIGINT

Constraints

Primary key AMP_RESOURCE_COMMAND_GROUP_MAPPING(RESOURCE_ID,COMMAND_GROUP_ID)
Foreign key AMP_RESOURCE_COMMAND_GROUP_MAPPING_FK1(COMMAND_GROUP_ID) references AMP_COMMANDS_GROUP(COMMAND_GROUP_ID) ON-DELETE-CASCADE
Foreign key AMP_RESOURCE_COMMAND_GROUP_MAPPING_FK2(RESOURCE_ID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

AMP_RES_GROUP_COMMAND_GROUP_MAPPING

Top

Column name	Description	Data type
COMMAND_GROUP_ID (PK)	command group id	BIGINT
GROUP_ID (PK)	resource group id	BIGINT

Constraints

Primary key AMP_RES_GROUP_COMMAND_GROUP_MAPPING(GROUP_ID,COMMAND_GROUP_ID)
Foreign key AMP_RES_GROUP_COMMAND_GROUP_MAPPING_FK1(COMMAND_GROUP_ID) references AMP_COMMANDS_GROUP(COMMAND_GROUP_ID) ON-DELETE-CASCADE
Foreign key AMP_RES_GROUP_COMMAND_GROUP_MAPPING_FK2(GROUP_ID) references Ptrx_ResourceGroup(GROUPID) ON-DELETE-CASCADE

AMP_WebsiteRecordedSessionInfo

Top

Column name	Description	Data type
RECORDING_ID (PK)	The Unique Identifier for the Session Recording	BIGINT
SESSIONID	Unique session id	CHAR
USERID	Unique User Identifier	BIGINT
RESOURCEID	The Unique Resource identifier	BIGINT
ACCOUNTID	The Unique Resource identifier	BIGINT
NUMERICID	The Unique Resource identifier	BIGINT
IPADDRESS	IP address	CHAR
RESOURCE_URL	Resource URl of the resource	CHAR
ORIGIN	Origin of recording	CHAR
START_TIME	Time that the recording has started	DATETIME
LAST_MODIFIED_TIME	Time that the recording has been last updated	DATETIME
FILENAME	Temp File name of recorded session mp4	CHAR
LOCATION	File Location of the recorded session.	CHAR
PLAYSTATUS	To know the delete permission access for play	CHAR
BACKUP_STATUS	To know the backUP Status	BOOLEAN
ISMOVED	To get status of the uploaded file	BOOLEAN
LENGTH	Content length	BIGINT
DELETEPLAYREQUESTUSERID	User request for delete play	BIGINT
EXTERNAL_STORAGE_STATUS	To know the need to upload to external storage	BOOLEAN
IS_UPLOADED_EXTERNAL_STORAGE	To know the external storage upload status	BOOLEAN
USERNAME	Unique User Identifier	CHAR
ACCOUNTNAME	Unique Account Identifier	CHAR
RESOURCE_NAME	Unique Resource Identifier	CHAR
DURATION	duration	CHAR
IS_ALIVE	status	BOOLEAN
HELPDESKREQUESTID	HelpDesk Request ID	CHAR
OPERATIONTYPE	The type of the operation done.	BIGINT
REASON	The Reason operation failure.	CHAR

Constraints

Primary key AMP_WebsiteRecordedSessionInfo(RECORDING_ID)

AaaContactInfo

Top

Column name	Description	Data type
CONTACTINFO_ID (PK)	Unique identifier	BIGINT
EMAILID	Email id	CHAR
LANDLINE	Landline phone number	CHAR
MOBILE	Mobile phone number	CHAR
FAX	Fax number	CHAR
WEB_URL	Web URL	CHAR
RES_PHONE	Residence phone number	CHAR

Constraints

Primary key AaaContactInfo(CONTACTINFO_ID)

AaaUser

Top

Column name	Description	Data type
USER_ID (PK)	Unique identifier	BIGINT
FIRST_NAME	First name of user	NCHAR
MIDDLE_NAME	Middle name of user	NCHAR
LAST_NAME	Last name of user	NCHAR
CREATEDTIME	Create time of user	BIGINT
DESCRIPTION	Description message about user	CHAR

Constraints

Primary key AaaUser(USER_ID)

AaaUserContactInfo

Top

Column name	Description	Data type
CONTACTINFO_ID (PK)	Identifier of AaaContactInfo	BIGINT
USER_ID (PK)	Identifier of User	BIGINT

Constraints

Primary key AaaUserContactInfo(USER_ID,CONTACTINFO_ID)
Foreign key AaaUserContactInfo_FK1(USER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key AaaUserContactInfo_FK2(CONTACTINFO_ID) references AaaContactInfo(CONTACTINFO_ID) ON-DELETE-CASCADE

AaaPamModule

Top

Column name	Description	Data type
PAMMODULE_ID (PK)	Unique identifier	BIGINT
NAME	Name to identify the PAM module	CHAR
TYPE	This indicates the type of the PAM functional module. It can be one of auth (authentication), account (account validation), password (password validation) or session (session management).	CHAR
CLASSNAME	PAM module implemented class name	CHAR
DESCRIPTION	Description message for the PAM module	CHAR

Constraints

Primary key AaaPamModule(PAMMODULE_ID)

AaaPasswordRule

Top

Column name	Description	Data type
PASSWDRULE_ID (PK)	Unique identifier	BIGINT
NAME	Name of the password rule	CHAR
MIN_LENGTH	Governs the minimum length of the password	INTEGER
MAX_LENGTH	Governs the maximum length of the password	INTEGER
REQ_MIXEDCASE	Governs whether the password should contain mixed case	BOOLEAN
NUMOF_SPLCHAR	Governs the number of special characters to be used. If the value is -1 then, it is not considered for validation	INTEGER
BEGINWITH_LETTER	Governs whether the password should begin with a alphabet	BOOLEAN
LOGINNAME_INDEPNDT	Governs if password can be same as loginname	BOOLEAN
REQ_NUMBERS	Governs whether the password should contain numbers	BOOLEAN
ALLOW_SEQUENTIAL_CHARS	Governs whether the password should allows sequential characters	BOOLEAN

Constraints

Primary key AaaPasswordRule(PASSWDRULE_ID)

AaaLogin

Top

Column name	Description	Data type
LOGIN_ID (PK)	Unique identifier	BIGINT
USER_ID	Identifier of AaaUser who owns the loginname	BIGINT
NAME	Login name to be used to access accounts owned by user	NCHAR
DOMAINNAME	Domain name to be used to access accounts owned by user based on the domain.	CHAR

Constraints

Primary key AaaLogin(LOGIN_ID)
Foreign key AaaLogin_FK(USER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE

AaaAccount

Top

Column name	Description	Data type
ACCOUNT_ID (PK)	Unique identifier	BIGINT
LOGIN_ID	Identifier of AaaLogin	BIGINT
SERVICE_ID	Identifier of AaaService to which the account has access to	BIGINT
ACCOUNTPROFILE_ID	Identifier of AccountProfile that manages the validity of the account	BIGINT
CREATEDTIME	Time at which the account was created	BIGINT

Constraints

Primary key AaaAccount(ACCOUNT_ID)
Foreign key AaaAccount_FK3(ACCOUNTPROFILE_ID) references AaaAccAdminProfile(ACCOUNTPROFILE_ID)ON-DELETE-CASCADE
Foreign key AaaAccount_FK2(SERVICE_ID) references AaaService(SERVICE_ID)ON-DELETE-CASCADE
Foreign key AaaAccount_FK1(LOGIN_ID) references AaaLogin(LOGIN_ID) ON-DELETE-CASCADE

AaaAccSession

Top

Column name	Description	Data type
SESSION_ID (PK)	Unique identifier of the session	BIGINT
ACCOUNT_ID	Identifier of account to which the account belongs	BIGINT
USER_HOST	IP Address of the host from where the user is accessing the application	CHAR
APPLICATION_HOST	host name where the application is running	CHAR
OPENTIME	Time of session open, i.e, account login time	BIGINT
CLOSETIME	Time of session close, i.e, account logout or timeout time	BIGINT
STATUS	Status of the session	CHAR
USER_HOST_NAME	Host name from where the user connects the application.	CHAR
AUTHENTICATOR	Which authenticator is used	CHAR
APPLICATION_SERVER	host name where the application is running	CHAR

Constraints

Primary key AaaAccSession(SESSION_ID)
Foreign key AaaAccSession_FK(ACCOUNT_ID) references AaaAccount(ACCOUNT_ID) ON-DELETE-CASCADE

AaaRole

Top

Column name	Description	Data type
ROLE_ID (PK)	Unique identifier	BIGINT
NAME	Name of the role	CHAR
SERVICE_ID	Identifier of Service to which the role belongs to	BIGINT
DESCRIPTION	Description about the role	CHAR

Constraints

Primary key AaaRole(ROLE_ID)
Foreign key AaaRole_FK(SERVICE_ID) references AaaService(SERVICE_ID)ON-DELETE-CASCADE

AaaAuthorizedRole

Top

Column name	Description	Data type
ROLE_ID (PK)	Identifier of role which is mapped to account	BIGINT
ACCOUNT_ID (PK)	Identifier of AaaAccount to which the roles are mapped	BIGINT

Constraints

Primary key AaaAuthorizedRole(ACCOUNT_ID,ROLE_ID)
Foreign key AaaAuthorizedRole_FK1(ROLE_ID) references AaaRole(ROLE_ID) ON-DELETE-CASCADE
Foreign key AaaAuthorizedRole_FK(ACCOUNT_ID) references AaaAccount(ACCOUNT_ID) ON-DELETE-CASCADE

CIEM_CLOUD_ACCOUNTS

Top

Column name	Description	Data type
UID (PK)		BIGINT
USER_ID		BIGINT
CLOUD_TYPE		INTEGER
ACCOUNT_NAME		CHAR
SYNC_TIME		DATETIME
SYNC_STATUS		CHAR

Constraints

Primary key CIEM_CLOUD_ACCOUNTS(UID)

CIEM_AWS_IAM_USER

Top

Column name	Description	Data type
UID (PK)		BIGINT
AWS_AUTH_UID		BIGINT
USER_ID		CHAR
USERNAME		CHAR
GROUPS		CHAR
SERVICES		CHAR
PERMISSIONS_BOUNDARY_TYPE		CHAR
PERMISSIONS_BOUNDARY_ARN		CHAR
RESOURCES		CHAR
RISK		CHAR
RECOMMENDATIONS		CHAR
FIX		CHAR
LAST_ACTIVITY		CHAR
ARN		CHAR
CREATED_TIME		CHAR
MFA		CHAR
PASSWORD_AGE		CHAR
CONSOLE_ACCESS		CHAR
LAST_CONSOLE_ACTIVITY		CHAR
ACCESS_KEY_ID		CHAR
ACCESS_KEY_AGE		CHAR
LAST_ACCESS_KEY_ACTIVITY		CHAR
SIGNING_CERTS		CHAR
ISSYNC		BOOLEAN

Constraints

Primary key CIEM_AWS_IAM_USER(UID)
Foreign key CIEM_AWS_IAM_USER_FK1(AWS_AUTH_UID) references CIEM_AWS_AUTH(UID)ON-DELETE-CASCADE

CIEM_AWS_IAM_GROUP

Top

Column name	Description	Data type
UID (PK)		BIGINT
AWS_AUTH_UID		BIGINT
GROUP_ID		CHAR
GROUP_NAME		CHAR
USERS		CHAR
SERVICES		CHAR
RESOURCES		CHAR
RISK		CHAR
RECOMMENDATIONS		CHAR
FIX		CHAR
ARN		CHAR
CREATED_TIME		DATETIME
ISSYNC		BOOLEAN

Constraints

Primary key CIEM_AWS_IAM_GROUP(UID)
Foreign key CIEM_AWS_IAM_GROUP_FK1(AWS_AUTH_UID) references CIEM_AWS_AUTH(UID)ON-DELETE-CASCADE

CIEM_AWS_IAM_ROLE

Top

Column name	Description	Data type
UID (PK)		BIGINT
AWS_AUTH_UID		BIGINT
ROLE_ID		CHAR
ROLE_NAME		CHAR
ARN		CHAR
DESCRIPTION		CHAR
ASSUME_ROLE_POLICY_DOCUMENT	stroes additional datta in json format	CHAR
PERMISSIONS_BOUNDARY_TYPE		CHAR
PERMISSIONS_BOUNDARY_ARN		CHAR
TRUSTED_ENTITIES		CHAR
SERVICES		CHAR
RISK		CHAR
RECOMMENDATIONS		CHAR
FIX		CHAR
LAST_ACTIVITY_TIME		DATETIME
API_SESSION		CHAR
CREATION_TIME		DATETIME
ISSYNC		BOOLEAN

Constraints

Primary key CIEM_AWS_IAM_ROLE(UID)
Foreign key CIEM_AWS_IAM_ROLE_FK1(AWS_AUTH_UID) references CIEM_AWS_AUTH(UID)ON-DELETE-CASCADE

CIEM_AUDIT

Top

Column name	Description	Data type
AUDITID (PK)	Private key to identify the audit trails	BIGINT
AWS_AUTH_UID		BIGINT
OPERATEDBY	Audited user's first and last Name.	CHAR
USERNAME	Audited User.	CHAR
ACCOUNTNAME	Audited User.	CHAR
OPERATIONAUDITTIME	The Last time stamp when the resource was accessed or attempted any access.	DATETIME
IPADDRESS	IP Address from which action is performed.	CHAR
OPERATION_ID	operation_type id	INTEGER
OPERATIONTYPE	The type of the operation done.	CHAR
REASON	The Reason operation.	CHAR
ENTITYTYPE	Type of entity	CHAR
ENTITYNAME	Name of entity	CHAR
HELPDESKREQUESTID	HelpDesk Request ID	CHAR
SESSION_ID	Session IDs when the audits are made	BIGINT

Constraints

Primary key CIEM_AUDIT(AUDITID)

CIEM_AWS_RISK_ACTIVE

Top

Column name	Description	Data type
UID (PK)		BIGINT
AWS_AUTH_UID		BIGINT
ENTITY_TYPE		CHAR
ENTITY_UID		BIGINT
ENTITY_NAME		CHAR
RISK_UID		BIGINT
RISK_NAME		CHAR
DESCRIPTION		CHAR
RISK_TYPE		CHAR
STATUS		BOOLEAN
SEVERITY		CHAR
PERCENTAGE		INTEGER
NEW_POLICY_DOCUMENT	Newly generated policy	CHAR
OLD_POLICY_DOCUMENT	currently attached policy	CHAR
ASSOCIATED_LINKS	Need to store the associated links like group,inine,attached policy	CHAR
ADMIN_ACTIONS	Need to store the shadow admin actions	CHAR
CREATED_TIME		DATETIME
UPDATED_TIME		DATETIME

Constraints

Primary key CIEM_AWS_RISK_ACTIVE(UID)
Foreign key CIEM_AWS_RISK_ACTIVE_FK1(AWS_AUTH_UID) references CIEM_AWS_AUTH(UID)ON-DELETE-CASCADE

PAM_ADMP_FeaturesList

Top

Column name	Description	Data type
ACCESSCONTROL_ID (PK)	RESOURCE ID	BIGINT
GROUPELEVATION		BOOLEAN

Constraints

Primary key PAM_ADMP_FeaturesList(ACCESSCONTROL_ID)
Foreign key PAM_ADMP_FeaturesList_FK1(ACCESSCONTROL_ID) references Ptrx_AccessControl(ACCESSCONTROL_ID) ON-DELETE-CASCADE

PAM_LOCALGROUP_FeaturesList

Top

Column name	Description	Data type
ACCESSCONTROL_ID (PK)	ACCESSCONTROL ID	BIGINT
GROUPELEVATION		BOOLEAN

Constraints

Primary key PAM_LOCALGROUP_FeaturesList(ACCESSCONTROL_ID)
Foreign key PAM_LOCALGROUP_FeaturesList_FK1(ACCESSCONTROL_ID) references Ptrx_AccessControl(ACCESSCONTROL_ID) ON-DELETE-CASCADE

PAM_ResElevationAccounts

Top

Column name	Description	Data type
RESOURCEID (PK)	Unique Identifier for a Resource.	BIGINT
ACCOUNTID	Unique Identifier for a Account.	BIGINT
DOMAINRESOURCEID	Unique Identifier for a Domain Resource.	BIGINT
ACCOUNTTYPE	Identifier for a Account Type.	CHAR
ALLOWEDFILELIST	List of files allowed	CHAR
SSPELASTPINGTIME	Last Update Time of the SSPE	DATETIME

Constraints

Primary key PAM_ResElevationAccounts(RESOURCEID)
Foreign key PAM_ResElevationAccounts_FK3(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key PAM_ResElevationAccounts_FK2(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

PAM_SSPEAPPLIST

Top

Column name	Description	Data type
APPID (PK)	Unique Identifier for each application	BIGINT
APPNAME	Application Name	CHAR
APPFILENAME	Application File Name	CHAR
SHA256SUM	SHA256SUM of the file	CHAR

Constraints

Primary key PAM_SSPEAPPLIST(APPID)

PAM_RESOURCEAPPMAPPING

Top

Column name	Description	Data type
MAPPINGID (PK)	Unique Identifier for each application	BIGINT
RESOURCEID	Unique Identifier for a Resource.	BIGINT
APPID	Unique Identifier for a Application.	BIGINT

Constraints

Primary key PAM_RESOURCEAPPMAPPING(MAPPINGID)
Foreign key PAM_RESOURCEAPPMAPPING_FK3(APPID) references PAM_SSPEAPPLIST(APPID) ON-DELETE-CASCADE
Foreign key PAM_RESOURCEAPPMAPPING_FK2(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

PAM_USERSREMOTECONNECTACCESSDETAILS

Top

Column name	Description	Data type
USER_ID (PK)	Identifier of AaaUser	BIGINT
ENABLED	Status, whether the user can access mobile app	BOOLEAN

Constraints

Primary key PAM_USERSREMOTECONNECTACCESSDETAILS(USER_ID)
Foreign key PAM_USERSREMOTECONNECTACCESSDETAILS_FK1(USER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE

PAM_Kube_Secrets

Top

Column name	Description	Data type
SECRET_ID (PK)	Unique ID for each secret.	BIGINT
CLUSTER_ID	Cluster ID the secret belonging to	BIGINT
NAMESPACE_ID	Namespace ID the secret belonging to	BIGINT
ACCOUNT_ID	Account ID of the Kubernetes account created via integration.	BIGINT
SECRET_NAME	Name of the Secret	CHAR
SECRET_JSON	Secret JSON in the form of file or plain JSON	SBLOB

Constraints

Primary key PAM_Kube_Secrets(SECRET_ID)
Foreign key PAM_Kube_Secrets_FK1(CLUSTER_ID) references PAM_Kube_Clusters(CLUSTER_ID)ON-DELETE-CASCADE
Foreign key PAM_Kube_Secrets_FK3(ACCOUNT_ID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key PAM_Kube_Secrets_FK2(NAMESPACE_ID) references PAM_Kube_Namespaces(NAMESPACE_ID)ON-DELETE-CASCADE

PAM_Kube_Secret_Keys

Top

Column name	Description	Data type
SECRET_KEYS_ID (PK)	Unique ID for each key in the secret.	BIGINT
SECRET_ID	Secret ID the key belonging to	BIGINT
SECRET_KEY_NAME	Name of the Secret's Key	CHAR

Constraints

Primary key PAM_Kube_Secret_Keys(SECRET_KEYS_ID)
Foreign key PAM_Kube_Secret_Keys_FK1(SECRET_ID) references PAM_Kube_Secrets(SECRET_ID) ON-DELETE-CASCADE

PAM_Kube_Secrets_Mapping

Top

Column name	Description	Data type
SECRET_KEYS_ID (PK)	Key ID of the Secret mapped with PAM360 account.	BIGINT
SECRET_ID (PK)	Secret ID of the Secret mapped with PAM360 account	BIGINT
KUBE_RES_ACCOUNT_ID (PK)	Account ID of the Account mapped.	BIGINT
KUBE_RES_RESOURCE_ID (PK)	Resource ID of the Account mapped.	BIGINT
ACCOUNT_ID (PK)	Account ID of the Account mapped.	BIGINT
RESOURCE_ID (PK)	Resource ID of the Account mapped.	BIGINT

Constraints

Primary key PAM_Kube_Secrets_Mapping(RESOURCE_ID,ACCOUNT_ID,KUBE_RES_RESOURCE_ID,KUBE_RES_ACCOUNT_ID,SECRET_ID,SECRET_KEYS_ID)
Foreign key PAM_Kube_Secrets_Mapping_FK2(ACCOUNT_ID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key PAM_Kube_Secrets_Mapping_FK1(RESOURCE_ID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key PAM_Kube_Secrets_Mapping_FK4(SECRET_KEYS_ID) references PAM_Kube_Secret_Keys(SECRET_KEYS_ID) ON-DELETE-CASCADE
Foreign key PAM_Kube_Secrets_Mapping_FK3(SECRET_ID) references PAM_Kube_Secrets(SECRET_ID) ON-DELETE-CASCADE
Foreign key PAM_Kube_Secrets_Mapping_FK6(KUBE_RES_ACCOUNT_ID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key PAM_Kube_Secrets_Mapping_FK5(KUBE_RES_RESOURCE_ID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

PAM_SSPEAccountElevationAccount

Top

Column name	Description	Data type
ACCOUNTID_LOCAL (PK)	Unique Identifier for a Resource.	BIGINT
ACCOUNTID_PRIVILEGED	Unique Identifier for a Account.	BIGINT
DOMAINRESOURCEID	Unique Identifier for a Domain Resource.	BIGINT
ACCOUNTTYPE	Identifier for a Account Type.	CHAR
SSPELASTPINGTIME	Last Update Time of the SSPE	DATETIME

Constraints

Primary key PAM_SSPEAccountElevationAccount(ACCOUNTID_LOCAL)
Foreign key PAM_SSPEAccountElevationAccount_FK3(ACCOUNTID_PRIVILEGED) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key PAM_SSPEAccountElevationAccount_FK2(ACCOUNTID_LOCAL) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE

PAM_SSPEResourceCommandGroup

Top

Column name	Description	Data type
COMMAND_GROUP_ID (PK)	command group id	BIGINT
RESOURCE_ID (PK)	resource id	BIGINT

Constraints

Primary key PAM_SSPEResourceCommandGroup(RESOURCE_ID,COMMAND_GROUP_ID)
Foreign key PAM_SSPEResourceCommandGroup_FK2(RESOURCE_ID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key PAM_SSPEResourceCommandGroup_FK1(COMMAND_GROUP_ID) references AMP_COMMANDS_GROUP(COMMAND_GROUP_ID) ON-DELETE-CASCADE

PAM_SSPEAccountCommandGroup

Top

Column name	Description	Data type
COMMAND_GROUP_ID (PK)	command group id	BIGINT
ACCOUNT_ID (PK)	account id	BIGINT

Constraints

Primary key PAM_SSPEAccountCommandGroup(ACCOUNT_ID,COMMAND_GROUP_ID)
Foreign key PAM_SSPEAccountCommandGroup_FK2(ACCOUNT_ID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key PAM_SSPEAccountCommandGroup_FK1(COMMAND_GROUP_ID) references AMP_COMMANDS_GROUP(COMMAND_GROUP_ID) ON-DELETE-CASCADE

PAM_JIT_Product_Mapping

Top

Column name	Description	Data type
ACCESSCONTROL_ID (PK)	The Unique Identifier for the ACCESSCONTROL.	BIGINT
PRODUCT_NAME	Access control via PAM or ADMP	CHAR

Constraints

Primary key PAM_JIT_Product_Mapping(ACCESSCONTROL_ID)
Foreign key PAM_JIT_Product_Mapping_FK1(ACCESSCONTROL_ID) references Ptrx_AccessControl(ACCESSCONTROL_ID) ON-DELETE-CASCADE

Ptrx_PasswordRule

Top

Column name	Description	Data type
PASSWDRULEID (PK)	The Unique Identifier for the Password Rule.	BIGINT
PASSWDRULENAME	Unique name for the Password Rule	CHAR
ISPREDEFINEDPOLICY	True if the password policy is predefined(Low, Medium, Strong, OfflinePassword are predefined)	BOOLEAN
ISMINRQD	is minimum length of password string enabled	BOOLEAN
ISMAXRQD	is maximum length of the password string enabled	BOOLEAN
MINLENGTH	Minimum length of the Password String	INTEGER
MAXLENGTH	Maximumn length of the Password String	INTEGER
SPLCHAR	Special Characters Required in the Password String	CHAR
REQNOTCHARS	Characters not required in the Password	CHAR
LOWERCASE	Lowercase Characters allowed in the Password String	CHAR
NUMOFLOWERCASE	Number of Lower Case characters to be present in the Password String	INTEGER
NUMOFUPPERCASE	Number of Upper Case characters to be present in the Password String	INTEGER
NUMBERS	Numbers allowed in the Password String	CHAR
NUMOFNUMERAL	Number of Numerals to be present in the Password String	INTEGER
HEXADECIMAL	Hexadecimal Numbers allowed in the Password String	CHAR
OLDPASSWDNUM	Number of Old Passwords to be remembered	INTEGER
VALIDITYPERIOD	Number of days the Password is Valid	INTEGER
WARNINGPERIOD	The threshold time to warn the user about the Password Expiry	BIGINT
GRACEPERIOD	Number of Days the user can be allowed to skip the password change, though the password has been expired	BIGINT
CHECKSEQNCE	To check for certain sequences present in password	BOOLEAN
SEQNCELEN	The length of sequence to be matched	INTEGER
CONSECUTIVESQN	To check for same consecutive repeated characters in password	BOOLEAN
ALPHABETSQN	To check for consecutive natural alphabet characters in password	BOOLEAN
NUMERICSQN	To check for consecutive natural numeric characters in password	BOOLEAN
KEYBOARDSQN	To check for consecutive nearby keyboard characters in password	BOOLEAN
KEYBOARDSQNID	The Identifier for the keyboard layout	BIGINT
CHECKREPSUBS	To check for occurence of repeated substring in password	BOOLEAN
CHECKDICTWORD	To check for occurence of dictionary word in password	BOOLEAN
DICTIONARYID	The Unique Identifier for the Dictionary file.	BIGINT
CHECKOBVIOUSWORD	To check for occurence of obvious substituted dictionary word in password	BOOLEAN
CHECKANAGRAM	To check if password is an anagram of user name	BOOLEAN
CHECKSIMILARITY	To check if password is similar to previous passwords	BOOLEAN
SIMILARITYCOUNT	Number of previous passwords to check for similarity	INTEGER
ISCONFLICT	does the policy have a conflict.	BOOLEAN
STRENGTH	Strength of the policy	INTEGER

Constraints

Primary key Ptrx_PasswordRule(PASSWDRULEID)
Foreign key Ptrx_PasswordRule_FK(PASSWDRULEID) references AaaPasswordRule(PASSWDRULE_ID) ON-DELETE-CASCADE
Foreign key Ptrx_PasswordRule_FK2(DICTIONARYID) references Ptrx_BlacklistedPasswords(DICTIONARYID)ON-DELETE-CASCADE

Ptrx_Resource

Top

Column name	Description	Data type
RESOURCEID (PK)	Unique Identifier of the Resource	BIGINT
PASSWDRULEID		BIGINT
RESOURCENAME	The Resource Name which is a unique name for a System or Service	CHAR
DOMAINNAME	Domain Name of the resource	CHAR
SSHPORT	SSH connection port	BIGINT
ALACCID	Unique identifier of the Auto Logon Account	BIGINT
RESOURCEDESC	Any additional details about the resource.	CHAR
LOCATION	Any additional details about the resource.	CHAR
DEPARTMENT	Any additional details about the resource.	CHAR
IPADDRESS	IP address of the resource	CHAR
RESOURCEURL	Resource URl of the resource	CHAR
LASTMONITORSYNCTIME	Last Monitor Sync Time	BIGINT
COLUMN_LONG1	Column for custom long attribute.	BIGINT
COLUMN_LONG2	Column for custom long attribute.	BIGINT
COLUMN_LONG3	Column for custom long attribute.	BIGINT
COLUMN_LONG4	Column for custom long attribute.	BIGINT
COLUMN_CHAR1	Column for custom char attribute.	CHAR
COLUMN_CHAR2	Column for custom char attribute.	CHAR
COLUMN_CHAR3	Column for custom char attribute.	CHAR
COLUMN_CHAR4	Column for custom char attribute.	CHAR
COLUMN_CHAR5	Column for custom char attribute.	CHAR
COLUMN_CHAR6	Column for custom char attribute.	CHAR
COLUMN_CHAR7	Column for custom char attribute.	CHAR
COLUMN_CHAR8	Column for custom char attribute.	CHAR
COLUMN_CHAR9	Column for custom char attribute.	CHAR
COLUMN_SCHAR1	Column for custom char attribute.	SCHAR
COLUMN_SCHAR2	Column for custom char attribute.	SCHAR
COLUMN_SCHAR3	Column for custom char attribute.	SCHAR
COLUMN_DATE1	Column for custom date attribute.	DATETIME
COLUMN_DATE2	Column for custom date attribute.	DATETIME
COLUMN_DATE3	Column for custom date attribute.	DATETIME
COLUMN_DATE4	Column for custom date attribute.	DATETIME
COLUMN_FILE1	Column for custom file attribute.	CHAR
COLUMN_FILE2	Column for custom file attribute.	CHAR
COLUMN_FILE3	Column for custom file attribute.	CHAR
COLUMN_FILE4	Column for custom file attribute.	CHAR
AUTOSUBMIT	Autologin to the site	BOOLEAN
PORT	RDP connection port	BIGINT
EXECUTE_PWDADM	Execute pwdadm for IBM AIX resource type	BOOLEAN
DOMAIN_MEMBER_RDP	RDP allowed only to domain members from domain account if this is set to true	BOOLEAN
RESTRICT_LOCAL_ACCOUNT_RDP	Restricts RDP to this resource from local accounts if this is set to true	BOOLEAN
ISDISABLED	This flag is set to true if the resource is disabled in the AD	BOOLEAN
SECONDARY_DC_NAME	Name of the secondary domain controller provided in comma seperated format	CHAR
WEB_SESSION_RECORDING	Records the launched web session if the value is true	BOOLEAN
GATEWAY_SESSION_RECORDING	Records the launched web session if the value is true	BOOLEAN
WEB_SESSION_RECORDING_DISBALE_DUPLICATE	Records the launched web session if the value is true	BOOLEAN
WEB_SESSION_RECORDING_URL_LAUNCH	Records the launched web session if the value is true	BOOLEAN

Constraints

Primary key Ptrx_Resource(RESOURCEID)
Foreign key Ptrx_Resource_FK1(PASSWDRULEID) references AaaPasswordRule(PASSWDRULE_ID) ON-DELETE-CASCADE

Ptrx_Password

Top

Column name	Description	Data type
PASSWDID (PK)	Unique Identifier for the Password Entity.	BIGINT
DESCRIPTION	The column type of the custom attribute	CHAR
TIMESTAMP	Password Accessed Time	DATETIME
PASSWDLENGTH	Length of the password	BIGINT
ISALPHANUMERIC	Status of the password whether it contain both alphabet and numbers	BOOLEAN

Constraints

Primary key Ptrx_Password(PASSWDID)

Ptrx_Account

Top

Column name	Description	Data type
ACCOUNTID (PK)	The Unique Identifier for the User Account	BIGINT
RESOURCEID	A Unique Identifier to identify the Resources that has the login name and password pair.	BIGINT
PASSWDID	Unique Identifier for the Password Entity.	BIGINT
PASSWDRULEID		BIGINT
DESCRIPTION	Description of the account for ex, whether it is System specific account or application account.	CHAR
LOGINNAME	A Unique Identifier to identify the Resources that has the login name and password pair.	CHAR
DOMAINNAME	Domain name where the user account is present	CHAR
COMPLIANTSTATUS	Compliant status of the corresponding password	CHAR
COMPLIANTICON	Compliant icon of the corresponding password	CHAR
COMPLIANTREASON	Compliant reason of the corresponding password	CHAR
EXPIRYSTATUS	Expiry status of the corresponding password	CHAR
PASSWRDSYNCSTATUS	Sync status of the corresponding password with respect to resource	CHAR
TIMESTAMP	Account Creation Time	DATETIME
APPICATIONPORT	Port where the application is running	BIGINT
RESTARTSERVICE	Option to restart associated services to this account	BOOLEAN
RESETLOCALSERVICE	Option to reset associated local services to this account	BOOLEAN
MONITORSTATUS	Current monitor status	BOOLEAN
RESTARTAPPPOOL	Option to restart associated AppPool to this account	BOOLEAN
COLUMN_LONG1	Column for custom long attribute.	BIGINT
COLUMN_LONG2	Column for custom long attribute.	BIGINT
COLUMN_LONG3	Column for custom long attribute.	BIGINT
COLUMN_LONG4	Column for custom long attribute.	BIGINT
COLUMN_CHAR1	Column for custom char attribute.	CHAR
COLUMN_CHAR2	Column for custom char attribute.	CHAR
COLUMN_CHAR3	Column for custom char attribute.	CHAR
COLUMN_CHAR4	Column for custom char attribute.	CHAR
COLUMN_CHAR5	Column for custom char attribute.	CHAR
COLUMN_CHAR6	Column for custom char attribute.	CHAR
COLUMN_CHAR7	Column for custom char attribute.	CHAR
COLUMN_CHAR8	Column for custom char attribute.	CHAR
COLUMN_CHAR9	Column for custom char attribute.	CHAR
COLUMN_SCHAR1	Column for custom char attribute.	SCHAR
COLUMN_SCHAR2	Column for custom char attribute.	SCHAR
COLUMN_SCHAR3	Column for custom char attribute.	SCHAR
COLUMN_DATE1	Column for custom date attribute.	DATETIME
COLUMN_DATE2	Column for custom date attribute.	DATETIME
COLUMN_DATE3	Column for custom date attribute.	DATETIME
COLUMN_DATE4	Column for custom date attribute.	DATETIME
COLUMN_FILE1	Column for custom file attribute.	CHAR
COLUMN_FILE2	Column for custom file attribute.	CHAR
COLUMN_FILE3	Column for custom file attribute.	CHAR
COLUMN_FILE4	Column for custom file attribute.	CHAR
RECORDRDPSESSION	Option to record RDP sessions	BOOLEAN
RECORDCLISESSION	Option to record CLI sessions	BOOLEAN
RESETSERVICE	Option to reset password in associated services to this account	BOOLEAN
RESETAPPPOOL	Option to reset password in associated apppools to this account	BOOLEAN
RESETSCHTASK	Option to reset password in associated schtask to this account	BOOLEAN
RESETIISWEBCONF	Option to reset password in associated webconfig to this account	BOOLEAN
LASTSYNCUPDATEDTIME	The Last time stamp when the resource sync was checked.	DATETIME
COMMANDSETID	Mapping between Ptrx_command_set and ptrx_Account.	BIGINT
LASTSYNCSUCCESSTIME	The Last time stamp when the resource sync was SUCCESS.	DATETIME
PASSWRDFAILCOUNT	The password fail count when the resource sync was checked.	INTEGER
SECRETID	Client Id.	CHAR
WEB_SESSION_RECORDING	Records the launched web session if the value is true	BOOLEAN
HTTPS_GATEWAY_RECORDING	Records the launched proxy session if the value is true	BOOLEAN

Constraints

Primary key Ptrx_Account(ACCOUNTID)
Foreign key Ptrx_Account_FK(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_Account_FK2(PASSWDRULEID) references AaaPasswordRule(PASSWDRULE_ID) ON-DELETE-CASCADE
Foreign key Ptrx_Account_FK1(PASSWDID) references Ptrx_Password(PASSWDID) ON-DELETE-CASCADE

Ptrx_AccountProperties

Top

Column name	Description	Data type
ACCOUNTID (PK)	The Unique Identifier for the User Account	BIGINT
ISRESETALLOWED	The status of the account	BOOLEAN

Constraints

Primary key Ptrx_AccountProperties(ACCOUNTID)
Foreign key Ptrx_AccountStatus_FK(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE

Ptrx_ResourceSync

Top

Column name	Description	Data type
ACCOUNTTYPE (PK)	Different types of accounts used for password sync.	CHAR
ACCOUNTID (PK)	The Unique Identifier for the User Account	BIGINT
RESOURCEID (PK)	Unique Identifier of the Resource	BIGINT
SYNCMODE	Different types of password sync mode.	BIGINT
PROTOCOL	Different types of protocol used for password sync.	CHAR
PROMPTS	Prompts for the various protocol.	CHAR
DOMAINNAME	Domain Name used for MSSQL Server Authentication.	CHAR
USERNAME	User name for domain authentication Prompts for the various protocol.	CHAR
PASSWORD	Password of windows domain authentication account.	SCHAR
PORT	Port of MSSQL Server.	BIGINT
REMOVEENTER	If it is true then en will remove	BOOLEAN

Constraints

Primary key Ptrx_ResourceSync(RESOURCEID,ACCOUNTID,ACCOUNTTYPE)
Foreign key Ptrx_ResourceSync_FK1(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceSync_FK(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_PasswordHistory

Top

Column name	Description	Data type
PASSWDID (PK)	Unique Identifier for the Password History Entity.	BIGINT
PASSWORD	The old password for the account.	SCHAR
RESOURCEID	Resource for which password has been changed.	BIGINT
ACCOUNTID	User Account for which password has been changed .	BIGINT
MODIFIEDBY	Contains user name who modified password.	CHAR
IPADDRESS	Contains IP from where password change performed.	CHAR
NOTES	Contains reason for password change.	CHAR
TIMESTAMP	Password changed time	DATETIME
FILENAME	File name of the certificate.	CHAR
CERTIFICATE	The old certificate for the account.	SBLOB
STATUS	Different types of status of password success/failed.	BIGINT
AUDITID	Corresponding Audit Id	BIGINT

Constraints

Primary key Ptrx_PasswordHistory(PASSWDID)
Foreign key Ptrx_PasswordHistory_FK2(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key Ptrx_PasswordHistory_FK1(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_Owner

Top

Column name	Description	Data type
RESOURCEID (PK)	The Unique Resource identifier	BIGINT
USERID (PK)	Unique User Identifier	BIGINT

Constraints

Primary key Ptrx_Owner(USERID,RESOURCEID)
Foreign key Ptrx_Owner_FK1(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_Owner_FK2(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_ResourceSystem

Top

Column name	Description	Data type
OSID (PK)	Unique Identifier for a Resource System.	BIGINT
OPERATINGSYSTEM	Name for the OS	CHAR
ICON	Icon for the OS	CHAR
ISSYNCSUPPORTED	true means password sync is supported	BOOLEAN
ISCERTIFICATE	true means certificate storage is supported	BOOLEAN
SYNCTYPE	Type of sync technique (windows \ Linux) used for password sync.	CHAR
ISDEFAULT	Boolean to denote whether the Resource type has beeen set as default.	BOOLEAN
ISSELECTED	boolean value to identify whether to list in add resource ui	BOOLEAN
CATEGORY	Type of sync technique (windows \ Linux) used for password sync.	CHAR
ISPMPDEFAULTSUPPORTEDOSTYPE	boolean value to identify whether it is PMP added default resource type	BOOLEAN
CUSTOM_RESOURCE_TYPE	Type of custom resource type.1-like Linux, 2-like cisco.	INTEGER
RANDOM_UNIQUE_ID	Random unique id for the resource type (only for default resource types)	INTEGER

Constraints

Primary key Ptrx_ResourceSystem(OSID)

Ptrx_ResourceSystemMembers

Top

Column name	Description	Data type
RESOURCEID (PK)	Unique Identifier for a Resource.	BIGINT
OSID (PK)	Unique Identifier for a Resource System.	BIGINT

Constraints

Primary key Ptrx_ResourceSystemMembers(OSID,RESOURCEID)
Foreign key Ptrx_ResourceSystemMembers_FK1(OSID) references Ptrx_ResourceSystem(OSID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceSystemMembers_FK2(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_PersonalSettings

Top

Column name	Description	Data type
SETTINGID (PK)	Unique Identifier for a Personal settings.	BIGINT
USERID	The Unique Identifier for User.	BIGINT
STORAGETYPE	Storage type for personal account	CHAR
KEY	Key for personal account	SCHAR
KEYTYPE	KeyType for personal account	CHAR

Constraints

Primary key Ptrx_PersonalSettings(SETTINGID)
Foreign key Ptrx_PersonalSettings_FK1(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_ResourceGroup

Top

Column name	Description	Data type
GROUPID (PK)	Unique Identifier for a Resource Group.	BIGINT
PASSWDRULEID		BIGINT
USERID		BIGINT
PARENT_ID		BIGINT
NO_OF_PARENTS		BIGINT
GLOBAL_PARENT_ID		BIGINT
NO_OF_GLOBAL_PARENTS		BIGINT
GROUPNAME	Name for the Group	CHAR
GROUPDESC	Description for the Group	CHAR
TIMESTAMP	Resource Group Created Time	DATETIME
GROUPORIGINTYPE	Display order for Criteria. Null for group added locally. 1 for Import from Active Directory	INTEGER
GROUPTYPE	Type Of The Group eg. default group or Static or Dynamic	BIGINT

Constraints

Primary key Ptrx_ResourceGroup(GROUPID)
Foreign key Ptrx_ResourceGroup_FK2(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceGroup_FK1(PASSWDRULEID) references AaaPasswordRule(PASSWDRULE_ID) ON-DELETE-CASCADE

Ptrx_CriteriaGroup

Top

Column name	Description	Data type
CRITERIAID (PK)	Unique Identifier for a Resource Group By Criteria.	BIGINT
GROUPID	Unique Identifier for a AaaUser.	BIGINT
TABLENAME	Name for the Table and Column	CHAR
CRITERIA	CRITERIA for the Group	CHAR
CRITERIAVALUE	Value for the Group Criteria	CHAR

Constraints

Primary key Ptrx_CriteriaGroup(CRITERIAID)
Foreign key Ptrx_CriteriaGroup_FK(GROUPID) references Ptrx_ResourceGroup(GROUPID) ON-DELETE-CASCADE

Ptrx_ResourceGroupMembers

Top

Column name	Description	Data type
USERID (PK)	Unique Identifier of user who adds a resource to the resource group.	BIGINT
RESOURCEID (PK)	Unique Identifier for a Resource.	BIGINT
GROUPID (PK)	Unique Identifier for a Resource Group.	BIGINT

Constraints

Primary key Ptrx_ResourceGroupMembers(GROUPID,RESOURCEID,USERID)
Foreign key Ptrx_ResourceGroupMembers_FK3(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceGroupMembers_FK1(GROUPID) references Ptrx_ResourceGroup(GROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceGroupMembers_FK2(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_UserResGroup

Top

Column name	Description	Data type
USERID (PK)	Unique Identifier for a AaaUser.	BIGINT
GROUPID (PK)	Unique Identifier for a UserGroup	BIGINT

Constraints

Primary key Ptrx_UserResGroup(GROUPID,USERID)
Foreign key Ptrx_UserResGroup_FK1(GROUPID) references Ptrx_ResourceGroup(GROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_UserResGroup_FK2(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_UserGroup

Top

Column name	Description	Data type
USERGROUPID (PK)	Unique Identifier for a UserGroup.	BIGINT
GROUPNAME	Name for the Group	CHAR
GROUPDESC	Description for the Group	CHAR
TIMESTAMP	UserGroup Group Created Time	DATETIME
GROUPORIGINTYPE	Unique Identifier for import Null for group added locally. 1 for group imported from Active Directory 2 for group imported from LDAP 3 for group imported from Azure AD	INTEGER

Constraints

Primary key Ptrx_UserGroup(USERGROUPID)

Ptrx_UserGroupMembers

Top

Column name	Description	Data type
USERID (PK)	Unique Identifier for a AaaUser.	BIGINT
USERGROUPID (PK)	Unique Identifier for a UserGroup	BIGINT

Constraints

Primary key Ptrx_UserGroupMembers(USERGROUPID,USERID)
Foreign key Ptrx_UserGroupMembers_FK1(USERGROUPID) references Ptrx_UserGroup(USERGROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_UserGroupMembers_FK2(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_AuditConfiguration

Top

Column name	Description	Data type
CONF_ID (PK)	The unique identifier for the Account	BIGINT
OPERATION_TYPE	Type of audit operation.	CHAR
ISAUDIT	Should audit this operation	BOOLEAN
ISNOTIFY	Should notify this operation	BOOLEAN
AUDIT_TYPE	Type of audit.	CHAR
NOTIFYADMIN	Should notify this operation admins	BOOLEAN
NOTIFYAUDITOR	Should notify this operation auditors	BOOLEAN
ISSYSLOGNOTIFY	Should send this operation as syslog	BOOLEAN
ISSNMPTRAPNOTIFY	Should send this operation as snmp trap	BOOLEAN
ISMSPAUDITTYPE	Audit Type specific to MSP.	BOOLEAN
ISAUDITSFEED	Should audit this operation	BOOLEAN
PURGEAUDIT	Should audit be purged in Purge schedule	BOOLEAN
ICON	Icon for the Operation Type.	CHAR
THEME	Theme for the Operation Type.	CHAR

Constraints

Primary key Ptrx_AuditConfiguration(CONF_ID)

Ptrx_UserAudit

Top

Column name	Description	Data type
AUDITID (PK)	Private key to identify the audit trails	BIGINT
RESOURCENAME	Audited Resource Name.	CHAR
NAME	Audited user's first and last Name.	CHAR
OPERATEDBY	Audited user's first and last Name.	CHAR
LOGINNAME	Audited UserAccount.	CHAR
USERNAME	Audited Passafe User.	CHAR
LUSER	Audited By which Passafe User.	CHAR
LASTACCESSEDTIME	The Last time stamp when the resource was accessed or attempted any access.	DATETIME
IPADDRESS	IP Address from which action is performed.	CHAR
OPERATIONTYPE	The type of the operation done.	BIGINT
REASON	The Reason operation failure.	CHAR
OSTYPE	Resource operating system.	CHAR
RESOURCEID	Unique Identifier for a Resource	BIGINT
ACCOUNTID	Unique Identifier for a Account	BIGINT
CLIENTTYPE	Client which user used to connect pmp	INTEGER
HELPDESKREQUESTID	HelpDesk Request ID	CHAR
SESSION_ID	Session IDs when the audits are made	BIGINT
SERVER_ID	Server ID from where the audits are made	BIGINT
PARENT_AUDIT_ID	Private key to identify the audit task trails	BIGINT
PARENT_AUDIT_TABLE_ID	Private key to identify the audit task table trails	INTEGER
DONE_VIA	To check weather the task is handled through appgateway or PAM360	CHAR

Constraints

Primary key Ptrx_UserAudit(AUDITID)

Ptrx_ResGrpUser

Top

Column name	Description	Data type
ACCESSTYPE (PK)	The access type assigned to that user	CHAR
SHAREDUSERID (PK)	Unique Identifier for a AaaUser.	BIGINT
USERID (PK)	Unique Identifier for a AaaUser.	BIGINT
GROUPID (PK)	Unique Identifier for a ResourceGroup	BIGINT

Constraints

Primary key Ptrx_ResGrpUser(GROUPID,USERID,SHAREDUSERID,ACCESSTYPE)
Foreign key Ptrx_ResGrpUser_FK1(GROUPID) references Ptrx_ResourceGroup(GROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_ResGrpUser_FK2(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_ResGrpUser_FK3(SHAREDUSERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_ResGrpUserGroup

Top

Column name	Description	Data type
ACCESSTYPE (PK)	The access type assigned to that user	CHAR
USERID (PK)	Unique Identifier for a AaaUser.	BIGINT
USERGROUPID (PK)	Unique Identifier for a UserGroup.	BIGINT
GROUPID (PK)	Unique Identifier for a ResourceGroup	BIGINT

Constraints

Primary key Ptrx_ResGrpUserGroup(GROUPID,USERGROUPID,USERID,ACCESSTYPE)
Foreign key Ptrx_ResGrpUserGroup_FK1(GROUPID) references Ptrx_ResourceGroup(GROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_ResGrpUserGroup_FK2(USERGROUPID) references Ptrx_UserGroup(USERGROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_ResGrpUserGroup_FK3(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_ResUserGroup

Top

Column name	Description	Data type
ACCESSTYPE (PK)	The access type assigned to that user	CHAR
USERID (PK)	Unique Identifier for a AaaUser.	BIGINT
USERGROUPID (PK)	Unique Identifier for a UserGroup.	BIGINT
RESOURCEID (PK)	Unique Identifier for a Resource	BIGINT

Constraints

Primary key Ptrx_ResUserGroup(RESOURCEID,USERGROUPID,USERID,ACCESSTYPE)
Foreign key Ptrx_ResUserGroup_FK2(USERGROUPID) references Ptrx_UserGroup(USERGROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_ResUserGroup_FK1(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_ResUserGroup_FK3(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_ResourceUser

Top

Column name	Description	Data type
ACCESSTYPE (PK)	The access type assigned to that user	CHAR
SHAREDUSERID (PK)	Unique Identifier for a AaaUser.	BIGINT
USERID (PK)	Unique Identifier for a AaaUser.	BIGINT
RESOURCEID (PK)	Unique Identifier for a ResourceGroup	BIGINT

Constraints

Primary key Ptrx_ResourceUser(RESOURCEID,USERID,SHAREDUSERID,ACCESSTYPE)
Foreign key Ptrx_ResourceUser_FK1(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceUser_FK3(SHAREDUSERID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceUser_FK2(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_AccountUserGroup

Top

Column name	Description	Data type
USERID (PK)	Unique Identifier for a AaaUser.	BIGINT
USERGROUPID (PK)	Unique Identifier for a UserGroup.	BIGINT
ACCOUNTID (PK)	Unique Identifier for a Resource	BIGINT
ACCESSTYPE	The access type assigned to that user	CHAR

Constraints

Primary key Ptrx_AccountUserGroup(ACCOUNTID,USERGROUPID,USERID)
Foreign key Ptrx_AccountUserGroup_FK3(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccountUserGroup_FK2(USERGROUPID) references Ptrx_UserGroup(USERGROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_AccountUserGroup_FK1(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE

Ptrx_AccountUser

Top

Column name	Description	Data type
SHAREDUSERID (PK)	Unique Identifier for a AaaUser.	BIGINT
USERID (PK)	Unique Identifier for a AaaUser.	BIGINT
ACCOUNTID (PK)	Unique Identifier for a Account	BIGINT
ACCESSTYPE	The access type assigned to that user	CHAR

Constraints

Primary key Ptrx_AccountUser(ACCOUNTID,USERID,SHAREDUSERID)
Foreign key Ptrx_AccountUser_FK3(SHAREDUSERID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccountUser_FK2(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccountUser_FK1(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE

Ptrx_AccessedTime

Top

Column name	Description	Data type
ACCESSID (PK)	The Unique Identifier for the Ptrx_AccessedTime	BIGINT
ACCOUNTID	The Unique Identifier of Account table	BIGINT
USERID	The Unique Identifier of User Table	BIGINT
TIMESTAMP	Password Accessed Time	DATETIME

Constraints

Primary key Ptrx_AccessedTime(ACCESSID)
Foreign key Ptrx_AccessedTime_FK1(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccessedTime_FK2(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE

Ptrx_UserDetails

Top

Column name	Description	Data type
USERID (PK)	Unique Identifier for a AaaUser.	BIGINT
DEPT	Any additional details about the resource.	CHAR
LOCATION	Any additional details about the resource.	CHAR
RSAUSERNAME	User Name for RSA Authentication.	CHAR
PHONEFACTORUSERNAME	User Name for PhoneFactor Authentication	CHAR
RADIUSUSERNAME	User Name for RADIUS Authentication.	CHAR
DUOUSERNAME	User Name for Duo Security Authentication.	CHAR
ISIMPORTEDUSER	The Unique Identifier for user detail which specifies if its imported or not. 0 - Manual, 1 - AD, 2 - Azure AD, 3 - LDAP	BIGINT
WEBACCESSSTATUS	Denotes whether Web access is enabled for this user by admin. 0 - Not Enabled for once, 1 - Enabled, 2 - Disabled	BIGINT

Constraints

Primary key Ptrx_UserDetails(USERID)
Foreign key Ptrx_UserDetails_FK1(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_UserGroupOption

Top

Column name	Description	Data type
OPTIONID (PK)	The unique identifier for the configuration	BIGINT
USERGROUPID	Unique identifier for the UsersGROUP	BIGINT
CONFKEY	The configuration key name	CHAR
CONFVALUE	The configuration value.	CHAR

Constraints

Primary key Ptrx_UserGroupOption(OPTIONID)
Foreign key Ptrx_UserGroupOption_FK1(USERGROUPID) references Ptrx_UserGroup(USERGROUPID) ON-DELETE-CASCADE

Ptrx_ResGrpPasswordRotation

Top

Column name	Description	Data type
PWDROTATIONID (PK)	The unique identifier for the configuration	BIGINT
GROUPID	Unique identifier for the Ptrx_ResourceGroup	BIGINT
INSTANCEID	The configuration key name	BIGINT
NOTIFICATIONID	The configuration key name	BIGINT
SCHEDULETYPE	The configuration value.	CHAR

Constraints

Primary key Ptrx_ResGrpPasswordRotation(PWDROTATIONID)
Foreign key Ptrx_ResGrpPWDRotation_FK2(GROUPID) references Ptrx_ResourceGroup(GROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_ResGrpPWDRotation_FK1(INSTANCEID) references Ptrx_ScheduleIDMap(INSTANCE_ID)ON-DELETE-CASCADE
Foreign key Ptrx_ResGrpPWDRotation_FK3(NOTIFICATIONID) references Ptrx_ResGrpNotification(NOTIFICATIONID)ON-DELETE-CASCADE

Ptrx_ListenerDetails

Top

Column name	Description	Data type
LISTENERID (PK)	The Unique Identifier for the Listener.	BIGINT
OWNER	The Unique Identifier for User who owns the listener.	BIGINT
PRECOMMAND	Command used before calling the listener file	CHAR
LISTENERNAME	File name of the listener file	CHAR
LISTENER	The Certificate for the account.	SBLOB
PARAMETERS	Optional paramters for the listener	SCHAR
ISAPPROVED	true means listener is approved	BOOLEAN
APPROVEDBY	The Unique Identifier for User who approved/denied the listener.	BIGINT
TYPE	Type of Listener - default or custom implementation	BIGINT
LISTENERMODE	true means password listener is supported via agent	BIGINT
LISTENEREXECUTIONORDER	means password listener is supported for post and preset	BIGINT
SIZE	Byte Size of the listener	INTEGER
LAST_UPDATED_TIME	The Last updated time of the password reset listener.	DATETIME

Constraints

Primary key Ptrx_ListenerDetails(LISTENERID)
Foreign key Ptrx_ListenerDetails_FK2(APPROVEDBY) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_ListenerDetails_FK1(OWNER) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_ResTypeListener

Top

Column name	Description	Data type
LISTENERID (PK)	The Unique Identifier for the Listener.	BIGINT
OSID (PK)	The Unique Identifier for the Listener.	BIGINT

Constraints

Primary key Ptrx_ResTypeListener(OSID,LISTENERID)
Foreign key Ptrx_ResTypeListener_FK(OSID) references Ptrx_ResourceSystem(OSID) ON-DELETE-CASCADE
Foreign key Ptrx_ResTypeListener_FK1(LISTENERID) references Ptrx_ListenerDetails(LISTENERID) ON-DELETE-CASCADE

Ptrx_SuperAdmin

Top

Column name	Description	Data type
USERID (PK)	Unique User Identifier	BIGINT
ISSUPERADMIN	true means password sync is supported	BOOLEAN
PROFILE_ID	super admin specific properties based profile id	BIGINT

Constraints

Primary key Ptrx_SuperAdmin(USERID)
Foreign key Ptrx_SuperAdmin_FK(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_AutoLogonHelper

Top

Column name	Description	Data type
HELPERID (PK)	The Unique Identifier for the helper.	BIGINT
COMMAND_LINUX	Command used for auto logon helper	CHAR
COMMAND_WINDOWS	Command used for auto logon helper	CHAR
HELPERNAME	File name of the helper file	CHAR
ISAPPROVED	true means helper is approved	BOOLEAN

Constraints

Primary key Ptrx_AutoLogonHelper(HELPERID)

Ptrx_ResTypeAutoLogon

Top

Column name	Description	Data type
HELPERID (PK)	The Unique Identifier for the helper.	BIGINT
OSID (PK)	The Unique Identifier for the helper.	BIGINT

Constraints

Primary key Ptrx_ResTypeAutoLogon(OSID,HELPERID)
Foreign key Ptrx_ResTypeAutoLogon_FK(OSID) references Ptrx_ResourceSystem(OSID) ON-DELETE-CASCADE
Foreign key Ptrx_ResTypeAutoLogon_FK1(HELPERID) references Ptrx_AutoLogonHelper(HELPERID) ON-DELETE-CASCADE

Ptrx_SchTasksDetails

Top

Column name	Description	Data type
SCHTASKID (PK)	Unique Scheduled Task Identifier	BIGINT
ACCOUNTID	Unique Account Identifier	BIGINT
RESOURCEID	Unique reosurce Identifier	BIGINT
SCHTASKNAME	Name of the scheduled task	CHAR
STATUS	Status of the scheduled task	CHAR
TIMESTAMP	Time at which the scheduled task password changed	DATETIME

Constraints

Primary key Ptrx_SchTasksDetails(SCHTASKID)
Foreign key Ptrx_SchTasksDetails_FK2(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key Ptrx_SchTasksDetails_FK1(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_TaskAudit

Top

Column name	Description	Data type
TASKAUDITID (PK)	Private key to identify the audit trails	BIGINT
TASKNAME	Audited Task Name.	CHAR
SCHEDULENAME	Audited Schedule Name.	CHAR
CREATEDBY	FullName of the user crerated schedule	CHAR
SCHEDULE_START_TIME	The time stamp when the schedule started.	DATETIME
SCHEDULE_FINISH_TIME	The time stamp when the schedule completed.	DATETIME
STATUS	Schedule status	CHAR
SERVERID	Server Id in which the request processed	BIGINT

Constraints

Primary key Ptrx_TaskAudit(TASKAUDITID)

Ptrx_AccessControl

Top

Column name	Description	Data type
ACCESSCONTROL_ID (PK)	The Unique Identifier for the Accesscontrol.	BIGINT
RESOURCEID	The Unique Identifier for the Resource.	BIGINT
REQUEST_TIMEOUT	Request time out if it is not approved (in hours).	BIGINT
CHECKOUT_TIMEOUT	Time out for password checkout (in hours).	BIGINT
RESET_ALLOWED	Is reset allowed after password checked in	BOOLEAN
DUAL_APPROVAL	Is Multiple approval for password request is required	BOOLEAN
Approval_Count	Approval Count for password request is required	BIGINT
IS_REASON	Is reason necessary for password request	BOOLEAN
IS_REMIND	Is reason necessary for password request	BOOLEAN
REMINDER_MINUTES	Reset passwords after the given number of hours	BIGINT
IS_GRACETIME	Is grace time provided for password access	BOOLEAN
GRACE_TIME	Grace time for password user	BIGINT
AUTO_CHECKIN	Is Auto-Checkin enabled for password request	BOOLEAN
CHECKIN_TIME	Auto-Checkin time for password request	BIGINT
HELPDESK_APPROVAL	Is Rest approval for password request is required	BOOLEAN
HELPDESK_APPROVAL_SDP	Approval for password request in SDP only	BOOLEAN
STATUS	Is Access control enabled or disabled	BOOLEAN
AUTO_APPROVE	Is Auto Approve for Password Access Requests enabled or disabled	BOOLEAN
IS_ALLDAY_AUTOAPPROVED	Is Auto Approve for Password Access Requests enabled or disabled	BOOLEAN
FROM_HRS	Hours value for From time in Auto Approve	INTEGER
FROM_MINS	Mins value for From time in Auto Approve	INTEGER
TO_HRS	Hours value for To time in Auto Approve	INTEGER
TO_MINS	Mins value for To time in Auto Approve	INTEGER
INACTIVE_STATUS_CODE	Used to maintain inactive status reason during license expiry	BIGINT

Constraints

Primary key Ptrx_AccessControl(ACCESSCONTROL_ID)
Foreign key Ptrx_AccessControl_FK2(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_AccessControlMapping

Top

Column name	Description	Data type
ACCOUNTID (PK)	The Unique Identifier for the Account.	BIGINT
ACCESSCONTROL_ID (PK)	The Unique Identifier for the ACCESSCONTROL.	BIGINT
CONFIG_TYPE	Type of Accesscontrol configuration.	BIGINT

Constraints

Primary key Ptrx_AccessControlMapping(ACCESSCONTROL_ID,ACCOUNTID)
Foreign key Ptrx_AccessControlMapping_FK1(ACCESSCONTROL_ID) references Ptrx_AccessControl(ACCESSCONTROL_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccessControlMapping_FK2(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE

Ptrx_ResourceAccessControl

Top

Column name	Description	Data type
RESOURCEID (PK)	The Unique Identifier for the Resource.	BIGINT
ACCESSCONTROL_ID (PK)	The Unique Identifier for the ACCESSCONTROL.	BIGINT

Constraints

Primary key Ptrx_ResourceAccessControl(ACCESSCONTROL_ID,RESOURCEID)
Foreign key Ptrx_ResourceAccessControl_FK1(ACCESSCONTROL_ID) references Ptrx_AccessControl(ACCESSCONTROL_ID) ON-DELETE-CASCADE
Foreign key Ptrx_ResourceAccessControl_FK2(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_AccountAccessControl

Top

Column name	Description	Data type
ACCOUNTID (PK)	The Unique Identifier for the Resource.	BIGINT
ACCESSCONTROL_ID (PK)	The Unique Identifier for the ACCESSCONTROL.	BIGINT

Constraints

Primary key Ptrx_AccountAccessControl(ACCESSCONTROL_ID,ACCOUNTID)
Foreign key Ptrx_AccountAccessControl_FK2(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key Ptrx_AccountAccessControl_FK1(ACCESSCONTROL_ID) references Ptrx_AccessControl(ACCESSCONTROL_ID) ON-DELETE-CASCADE

Ptrx_AccessControlAdmin

Top

Column name	Description	Data type
USER_ID (PK)	The Unique Identifier for the User.	BIGINT
ACCESSCONTROL_ID (PK)	The Unique Identifier for the ACCESSCONTROL.	BIGINT
RESOURCEID	The Unique Identifier for the Resource.	BIGINT

Constraints

Primary key Ptrx_AccessControlAdmin(ACCESSCONTROL_ID,USER_ID)
Foreign key Ptrx_AccessControlAdmin_FK2(USER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccessControlAdmin_FK1(ACCESSCONTROL_ID) references Ptrx_AccessControl(ACCESSCONTROL_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccessControlAdmin_FK3(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_AccessControlAutoApproval

Top

Column name	Description	Data type
AUTOAPPROVAL_ID (PK)	The Unique Identifier for the Resource.	BIGINT
RESOURCEID	The Unique Identifier for the Resource.	BIGINT
ACCESSCONTROL_ID	The Unique Identifier for the ACCESSCONTROL.	BIGINT
FROM_HRS	Hours value for From time in Auto Approve	INTEGER
FROM_MINS	Mins value for From time in Auto Approve	INTEGER
TO_HRS	Hours value for To time in Auto Approve	INTEGER
TO_MINS	Mins value for To time in Auto Approve	INTEGER
AUTOAPPROVAL_DAY	Mins value for To time in Auto Approve	INTEGER

Constraints

Primary key Ptrx_AccessControlAutoApproval(AUTOAPPROVAL_ID)
Foreign key Ptrx_AccessControlAutoApproval_FK1(ACCESSCONTROL_ID) references Ptrx_AccessControl(ACCESSCONTROL_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccessControlAutoApproval_FK2(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_AccessControlUsers

Top

Column name	Description	Data type
USER_ID (PK)	The Unique Identifier for the User.	BIGINT
ACCESSCONTROL_ID (PK)	The Unique Identifier for the ACCESSCONTROL.	BIGINT
RESOURCEID	The Unique Identifier for the Resource.	BIGINT
IS_USERGROUP	Is user belong to excluded user group	BOOLEAN

Constraints

Primary key Ptrx_AccessControlUsers(ACCESSCONTROL_ID,USER_ID)
Foreign key Ptrx_AccessControlUsers_FK1(ACCESSCONTROL_ID) references Ptrx_AccessControl(ACCESSCONTROL_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccessControlUsers_FK2(USER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccessControlUsers_FK3(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_RequestRelease

Top

Column name	Description	Data type
REQUESTID (PK)	The Unique Identifier for the Request ID.	BIGINT
PASSWDID	The Unique Identifier for the Password.	BIGINT
USER_ID	The Unique Identifier for the User.	BIGINT
APRROVEDUSERID	The Unique Identifier for the User.	BIGINT
STATUS	Status of the password request.	BIGINT
STARTTIME	Request start time	DATETIME
ENDTIME	Request end time	DATETIME
CHECKOUT	Time stamp for request actions	DATETIME
TIMESTAMP	Time stamp for request actions	DATETIME
CREATEDTIME	Created TimeStamp	DATETIME
REASON	Reason for the Password Request	CHAR
REMINDERTIME	Reaminder time given by user	BIGINT
ADMIN_REASON	Auto-approval or auto-rejection reason will be maintained here.	CHAR
HELPDESKREQUESTID	HelpDesk Request ID given for password request	CHAR
SERVERID	Server Id in which the request processed	BIGINT

Constraints

Primary key Ptrx_RequestRelease(REQUESTID)
Foreign key Ptrx_RequestRelease_FK2(USER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_RequestRelease_FK1(PASSWDID) references Ptrx_Password(PASSWDID) ON-DELETE-CASCADE

Ptrx_RequestReleaseAudit

Top

Column name	Description	Data type
REQUESTID (PK)	The Unique Identifier for the Request ID.	BIGINT
PASSWDID	The Unique Identifier for the Password.	BIGINT
USER_ID	The Unique Identifier for the User.	BIGINT
STATUS	5 - Approved, 6 - Rejected, 7 - Cancelled	BIGINT
STARTTIME	Start time of the Request	DATETIME
ENDTIME	End time of the Request	DATETIME
CHECKOUTTIME	Timestamp of enduser when checkouts the password	DATETIME
TIMESTAMP	Time stamp for each actions like request raised, approved, checkout	DATETIME
CREATEDTIME	Created TimeStamp	DATETIME
COMPLETEDTIME	Time of the request killed may be rejected, checkin, cancelled	DATETIME
REASON	Reason for the Password Request	CHAR
REMINDERTIME	Reaminder time given by user	BIGINT
ADMIN_REASON	Auto-approval or auto-rejection reason will be maintained here.	CHAR
HELPDESKREQUESTID	HelpDesk Request ID given for password request	CHAR
ADMINCHECKIN_USERID	Userid Of Admin	BIGINT
ISADMINCHECKIN	Is checkin is done by admin.	BOOLEAN
ISSERVERCHECKIN	Is checkin is done by server.	BOOLEAN
LASTSTATUS	Status of the password request before the cycle ends.	BIGINT

Constraints

Primary key Ptrx_RequestReleaseAudit(REQUESTID)
Foreign key Ptrx_RequestReleaseAudit_FK2(USER_ID) references AaaUser(USER_ID) ON-DELETE-SET-NULL
Foreign key Ptrx_RequestReleaseAudit_FK1(PASSWDID) references Ptrx_Password(PASSWDID) ON-DELETE-CASCADE

Ptrx_RequestDomainDetails

Top

Column name	Description	Data type
TARGETRESOURCEID (PK)	Resource id selected while password request.	BIGINT
REQUESTID (PK)	The Unique Identifier for the Request ID.	BIGINT
DOMAINOPTION	Domain Account Option while password request.	BIGINT

Constraints

Primary key Ptrx_RequestDomainDetails(REQUESTID,TARGETRESOURCEID)
Foreign key Ptrx_RequestDomainDetails_FK1(REQUESTID) references Ptrx_RequestRelease(REQUESTID) ON-DELETE-CASCADE
Foreign key Ptrx_RequestDomainDetails_FK2(TARGETRESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_DualApproval

Top

Column name	Description	Data type
APPROVER_ID (PK)	The Unique Identifier for the User.	BIGINT
REQUESTID (PK)	The Unique Identifier for the Password.	BIGINT
PASSWDID	The Unique Identifier for the Password.	BIGINT
USER_ID	The Unique Identifier for the User.	BIGINT
STATUS	Status of the password request.	BIGINT
TIMESTAMP	Time stamp for request actions	DATETIME
ADMIN_REASON	Admin's reason for Approval	CHAR

Constraints

Primary key Ptrx_DualApproval(REQUESTID,APPROVER_ID)
Foreign key Ptrx_DualApproval_FK1(PASSWDID) references Ptrx_Password(PASSWDID) ON-DELETE-CASCADE
Foreign key Ptrx_DualApproval_FK3(APPROVER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_DualApproval_FK2(USER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_TwoFactorAuth

Top

Column name	Description	Data type
TWOFACTORID (PK)	The Unique Resource identifier	BIGINT
AUTHENTICATORNAME	Two factor Authentication name	CHAR
AUTHENTICATORCLASSNAME	Two factor Authentication name	CHAR
AUTHENTICATORSTATUS	Two factor authenticator status	BOOLEAN

Constraints

Primary key Ptrx_TwoFactorAuth(TWOFACTORID)

Ptrx_UsersTwoFactorAuth

Top

Column name	Description	Data type
USERTWOFACTORID (PK)	The unique identifier for the Account	BIGINT
USER_ID	The notication type value.	BIGINT
TWOFACTORID	The unique identifier for the Account	BIGINT

Constraints

Primary key Ptrx_UsersTwoFactorAuth(USERTWOFACTORID)
Foreign key Ptrx_UsersTwoFactorAuth_FK2(TWOFACTORID) references Ptrx_TwoFactorAuth(TWOFACTORID) ON-DELETE-CASCADE
Foreign key Ptrx_UsersTwoFactorAuth_FK1(USER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_SyslogCollector

Top

Column name	Description	Data type
COLLECTOR_ID (PK)	Unique Identifier for the syslog collector setting Entity.	BIGINT
COLLECTOR_NAME	Name of the syslog collector.	CHAR
COLLECTOR_APPNAME	Name of the syslog collector application.	CHAR
COLLECTOR_PORT	Port opened by syslog collector	BIGINT
PROTOCOL	Protocol used to connect syslog collector.	CHAR
FACILITY_NAME	Syslog's facility name	CHAR
MESSAGE_FORMAT	Choose syslog message formats	CHAR
TOKEN	Tokens used by cloud SIEM tool	SCHAR
IS_ENABLED	SIEM tool enabled status	BOOLEAN

Constraints

Primary key Ptrx_SyslogCollector(COLLECTOR_ID)

Ptrx_OfflineUserSettings

Top

Column name	Description	Data type
USERID (PK)	The Unique Identifier for User.	BIGINT
IS_XLS	Whether XLS format is allowed for corresponding user	BOOLEAN
IS_REASON	Is reason mandatory while exporting offline passwords	BOOLEAN
IS_PASSWORD	Include passwords in plain-text in the exported file	BOOLEAN
IS_CERT	Option to include password in XLS	BOOLEAN
IS_HTML	Whether HTML format is allowed for corresponding user	BOOLEAN
IS_RESET_HTML	Reset passwords exported to the file	BOOLEAN
RESET_DAYS	Reset passwords after the given number of days	BIGINT
RESET_HOURS	Reset passwords after the given number of hours	BIGINT
IS_DROPBOX	Is Dropbox sync allowed	BOOLEAN
IS_DELETE	Auto delete exported file from Dropbox	BOOLEAN
DELETE_DAYS	Delete file after the given number of days	BIGINT
DELETE_HOURS	Delete file after the given number of hours	BIGINT
IS_RESET_DROPBOX	Auto delete exported file from Dropbox	BOOLEAN

Constraints

Primary key Ptrx_OfflineUserSettings(USERID)
Foreign key Ptrx_OfflineUserSettings_FK(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_OfflineUGSettings

Top

Column name	Description	Data type
USERGROUPID (PK)	The Unique Identifier for User Group.	BIGINT
IS_XLS	Whether XLS format is allowed for corresponding user	BOOLEAN
IS_REASON	Is reason mandatory while exporting offline passwords	BOOLEAN
IS_PASSWORD	Include passwords in plain-text in the exported file	BOOLEAN
IS_CERT	Option to include password in XLS	BOOLEAN
IS_HTML	Whether HTML format is allowed for corresponding user	BOOLEAN
IS_RESET_HTML	Reset passwords exported to the file	BOOLEAN
RESET_DAYS	Reset passwords after the given number of days	BIGINT
RESET_HOURS	Reset passwords after the given number of hours	BIGINT
IS_DROPBOX	Is Dropbox sync allowed	BOOLEAN
IS_DELETE	Auto delete exported file from Dropbox	BOOLEAN
DELETE_DAYS	Delete file after the given number of days	BIGINT
DELETE_HOURS	Delete file after the given number of hours	BIGINT
IS_RESET_DROPBOX	Auto delete exported file from Dropbox	BOOLEAN

Constraints

Primary key Ptrx_OfflineUGSettings(USERGROUPID)
Foreign key Ptrx_OfflineUGSettings_FK(USERGROUPID) references Ptrx_UserGroup(USERGROUPID) ON-DELETE-CASCADE

Ptrx_LandingServers

Top

Column name	Description	Data type
LANDINGSERVERID (PK)	Unique Identifier for identifying the Landing server	BIGINT
LANDINGSERVERNAME	The Name for the Landing server which is a unique name	CHAR
LOCATION	Location of the Landing Server	CHAR
NOTES	Contains description of this landing server	CHAR
USERID	The Unique Identifier for User who created this landing server	BIGINT

Constraints

Primary key Ptrx_LandingServers(LANDINGSERVERID)
Foreign key Ptrx_LandingServers_FK1(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_LandingServerOrder

Top

Column name	Description	Data type
FAILOVER_ORDER (PK)	Order in which the resource/account combination should be considee	INTEGER
ACCOUNTID (PK)	Unique Identifier for a Resource.	BIGINT
RESOURCEID (PK)	Unique Identifier for a Resource.	BIGINT
LANDINGSERVERID (PK)	Unique Identifier for identifying the Landing server	BIGINT

Constraints

Primary key Ptrx_LandingServerOrder(LANDINGSERVERID,RESOURCEID,ACCOUNTID,FAILOVER_ORDER)
Foreign key Ptrx_LandingServerOrder_FK2(LANDINGSERVERID) references Ptrx_LandingServers(LANDINGSERVERID) ON-DELETE-CASCADE
Foreign key Ptrx_LandingServerOrder_FK1(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_LandingServerOrder_FK3(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE

Ptrx_UsersMobileAccessDetails

Top

Column name	Description	Data type
USER_ID (PK)	Identifier of AaaUser	BIGINT
ENABLED	Status, whether the user can access mobile app	BOOLEAN

Constraints

Primary key Ptrx_UsersMobileAccessDetails(USER_ID)
Foreign key UsersMobileAccessDetails_FK1(USER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_UsersAddonAccessDetails

Top

Column name	Description	Data type
USER_ID (PK)	Identifier of AaaUser	BIGINT
ENABLED	Status, whether the user can access browser extensions	BOOLEAN

Constraints

Primary key Ptrx_UsersAddonAccessDetails(USER_ID)
Foreign key UsersAddonAccessDetails_FK1(USER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_LanguageMapping

Top

Column name	Description	Data type
BASELANGUAGE (PK)	Value in Base Language	CHAR
LANGUAGEID (PK)	Unique Identifier for each language supported in Password Manager Pro	BIGINT
TRANSLATEDLANGUAGE	Value in Translated Language	CHAR

Constraints

Primary key Ptrx_LanguageMapping(LANGUAGEID,BASELANGUAGE)

Ptrx_ScheduleDisplayName

Top

Column name	Description	Data type
INSTANCEID (PK)	unique identifier to identify each schedule - from task_input	BIGINT
DISPLAYNAME	contains the diplay name of each schedule	CHAR
SCHEDULETYPEID	Identifier to find each schedule type	INTEGER

Constraints

Primary key Ptrx_ScheduleDisplayName(INSTANCEID)
Foreign key Ptrx_ScheduleDisplayName_FK1(INSTANCEID) references Ptrx_ScheduleIDMap(INSTANCE_ID)ON-DELETE-CASCADE

Ptrx_SshMessage

Top

Column name	Description	Data type
MSGID (PK)	Primary key to identify the recorded sessions	BIGINT
AUDITID		BIGINT
ORGANIZATIONID	The ID of the Organization to which the User is mapped.	BIGINT
MSGFRM		CHAR
MESSAGE		SCHAR
TIME	The time stamp when the message is send .	DATETIME

Constraints

Primary key Ptrx_SshMessage(MSGID)
Foreign key Ptrx_SshMessage_FK1(ORGANIZATIONID) references Ptrx_OrganizationDetails(ORGANIZATIONID)ON-DELETE-CASCADE

Ptrx_ServiceAccountMapping

Top

Column name	Description	Data type
SERVICENAME (PK)	Service name running in the resource	CHAR
RESOURCEID (PK)	A Unique Identifier to identify the Resources where the service runs	BIGINT
ACCOUNTID (PK)	The Unique Identifier for the Service Account	BIGINT
SERVICEID	Unique SERVICE Identifier	BIGINT

Constraints

Primary key Ptrx_ServiceAccountMapping(ACCOUNTID,RESOURCEID,SERVICENAME)
Foreign key Ptrx_ServiceAccountMapping_FK1(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_ServiceAccountMapping_FK2(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE

Ptrx_AppPoolAccountMapping

Top

Column name	Description	Data type
APPPOOLNAME (PK)	AppPool name running in the resource	CHAR
RESOURCEID (PK)	A Unique Identifier to identify the Resources where the apppool runs	BIGINT
ACCOUNTID (PK)	The Unique Identifier for the AppPool Account	BIGINT

Constraints

Primary key Ptrx_AppPoolAccountMapping(ACCOUNTID,RESOURCEID,APPPOOLNAME)
Foreign key Ptrx_AppPoolAccountMapping_FK1(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_AppPoolAccountMapping_FK2(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE

Ptrx_AccessControlAdminGroup

Top

Column name	Description	Data type
USERGROUPID (PK)	The Unique Identifier for the Group.	BIGINT
ACCESSCONTROL_ID (PK)	The Unique Identifier for the ACCESSCONTROL.	BIGINT
RESOURCEID	The Unique Identifier for the Resource.	BIGINT

Constraints

Primary key Ptrx_AccessControlAdminGroup(ACCESSCONTROL_ID,USERGROUPID)
Foreign key Ptrx_AccessControlAdminGroup_FK2(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_AccessControlAdminGroup_FK1(ACCESSCONTROL_ID) references Ptrx_AccessControl(ACCESSCONTROL_ID) ON-DELETE-CASCADE

Ptrx_UserStatus

Top

Column name	Description	Data type
USERID (PK)	Unique Identifier for a User.	BIGINT
STATUS	Status of the User	CHAR
UPDATEDTIME	Last updated time	DATETIME
UPDATEDUSER	The Unique Identifier for user who updated the user status.	BIGINT

Constraints

Primary key Ptrx_UserStatus(USERID)
Foreign key Ptrx_UserStatus_FK(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_ImportedUsersMapping

Top

Column name	Description	Data type
IMPORTTYPEID (PK)	The Unique Import Type Identifier. 1. AD 2. LDAP 3. AZURE AD	BIGINT
USERID (PK)	Unique User Identifier	BIGINT
LASTSYNCTIME	The time of user when last synced from AD, LDAP OR AZURE AD	DATETIME

Constraints

Primary key Ptrx_ImportedUsersMapping(USERID,IMPORTTYPEID)
Foreign key Ptrx_ImportedUsersMapping_FK1(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_Role

Top

Column name	Description	Data type
ROLEID (PK)	The Unique Identifier for the Custom Roles	BIGINT
AAAROLE_ROLEID	The Unique Identifier for the Custom Roles	BIGINT
ROLENAME	Custom Role Name	CHAR
DESCRIPTION	Role Description	CHAR
ROLETYPE	Contains Role type	TINYINT
MODIFIEDBY	Last Modified By	CHAR
APPROVEDBY	Creation/Modification Approved By	CHAR
OPERATEDTIME	Last Operation Time	DATETIME
ISSELECTED	boolean value to identify whether to filter this role out	BOOLEAN
ISSUPERROLE	boolean value to identify whether the role has super admin capabilities	BOOLEAN
DEFAULTROLE	boolean value to identify whether the role is default role	BOOLEAN

Constraints

Primary key Ptrx_Role(ROLEID)
Foreign key Ptrx_Role_FK1(AAAROLE_ROLEID) references AaaRole(ROLE_ID) ON-DELETE-CASCADE

Ptrx_RoleTree

Top

Column name	Description	Data type
CATEGORYID (PK)	Unique identifier of the Category	BIGINT
CATEGORYLABEL	Name of the Category	CHAR
PARENT	Node's Parent Index - Root's Parent being -1	BIGINT
CHILDPOSITION	Specifies which position this category is in its Parent's children list	INTEGER
PRIVILEGE	Contains Privilege Level	TINYINT
LICENSESUPPORT	Specifies Whether the Category is supported by the License	TINYINT

Constraints

Primary key Ptrx_RoleTree(CATEGORYID)

Ptrx_RoleCategoryMapping

Top

Column name	Description	Data type
CATEGORYID (PK)	The Unique Identifier for the Custom Roles	BIGINT
ROLEID (PK)	The Unique Identifier for the Custom Roles	BIGINT

Constraints

Primary key Ptrx_RoleCategoryMapping(ROLEID,CATEGORYID)
Foreign key Ptrx_RoleCategoryMapping_FK(ROLEID) references Ptrx_Role(ROLEID) ON-DELETE-CASCADE
Foreign key Ptrx_RoleCategoryMapping_FK1(CATEGORYID) references Ptrx_RoleTree(CATEGORYID) ON-DELETE-CASCADE

Ptrx_FeatureRoleMapping

Top

Column name	Description	Data type
CATEGORYID (PK)	The Unique Identifier for the Custom Roles	BIGINT
ROLEID (PK)	The Unique Identifier of each feature Roles	BIGINT

Constraints

Primary key Ptrx_FeatureRoleMapping(ROLEID,CATEGORYID)
Foreign key Ptrx_FeatureRoleMapping_FK1(CATEGORYID) references Ptrx_RoleTree(CATEGORYID) ON-DELETE-CASCADE
Foreign key Ptrx_FeatureRoleMapping_FK(ROLEID) references AaaRole(ROLE_ID) ON-DELETE-CASCADE

Ptrx_RoleCategoryLanguageMap

Top

Column name	Description	Data type
LANGUAGEID (PK)	Unique Identifier for each language supported in Password Manager Pro	BIGINT
CATEGORYID (PK)	Unique Identifier for each language supported in Password Manager Pro	BIGINT
TRANSLATEDCATEGORYLABEL	Value in Translated Language	CHAR

Constraints

Primary key Ptrx_RoleCategoryLanguageMap(CATEGORYID,LANGUAGEID)
Foreign key Ptrx_RoleCategoryLanguageMap_FK2(LANGUAGEID) references Ptrx_SupportedLanguages(LANGUAGEID)ON-DELETE-CASCADE
Foreign key Ptrx_RoleCategoryLanguageMap_FK1(CATEGORYID) references Ptrx_RoleTree(CATEGORYID) ON-DELETE-CASCADE

Ptrx_IISWebsite

Top

Column name	Description	Data type
CONFID (PK)	The Unique Identifier for the Websites.	BIGINT
RESOURCEID	Resources ID running in the resource	BIGINT
ACCOUNTID	The Unique Identifier for the IIS Account	BIGINT
IISWEBSITENAME	ISS Website name running in the resource	CHAR
WEBCONFPATH	web.config Path of the IIS Website	CHAR
WEBCONFLINE	Connection String line	CHAR
TIMESTAMP	Time noted while fetching	DATETIME

Constraints

Primary key Ptrx_IISWebsite(CONFID)
Foreign key Ptrx_Ptrx_IISWebsite_FK2(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key Ptrx_Ptrx_IISWebsite_FK1(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_PKIAccountMapping

Top

Column name	Description	Data type
ACCOUNTID (PK)	Unique Identifier of the account	BIGINT
PKI_ACCOUNTID	Unique Identifier of the account	BIGINT
ISPKIENABLED	Is pki key is enabled for the account	BOOLEAN

Constraints

Primary key Ptrx_PKIAccountMapping(ACCOUNTID)
Foreign key Ptrx_PKIAccountMapping_FK(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE

Ptrx_ADSSP_DomainDetails

Top

Column name	Description	Data type
DOMAIN_ID (PK)	Unique Identifier for a Domain.	BIGINT
DOMAINNAME	Unique identifier	CHAR
DISPLAY_NAME		CHAR
USERNAME		CHAR

Constraints

Primary key Ptrx_ADSSP_DomainDetails(DOMAIN_ID)

Ptrx_ADMP_DomainDetails

Top

Column name	Description	Data type
DOMAIN_ID (PK)	Unique Identifier for a Domain.	BIGINT
DOMAINNAME	Unique identifier	CHAR
DISPLAY_NAME		CHAR
USERNAME		CHAR

Constraints

Primary key Ptrx_ADMP_DomainDetails(DOMAIN_ID)

Ptrx_ADSSP_PMP_DomainMapping

Top

Column name	Description	Data type
ACCOUNTID (PK)	A Unique Identifier to identify the account in ADSSP.	BIGINT
RESOURCEID (PK)	A Unique Identifier to identify the Resource that matched with ADSSP domain.	BIGINT
DOMAIN_ID (PK)	Unique Identifier for ADSSP Domain.	BIGINT

Constraints

Primary key Ptrx_ADSSP_PMP_DomainMapping(DOMAIN_ID,RESOURCEID,ACCOUNTID)
Foreign key Ptrx_ADSSP_PMP_DomainMapping_FK1(DOMAIN_ID) references Ptrx_ADSSP_DomainDetails(DOMAIN_ID) ON-DELETE-CASCADE
Foreign key Ptrx_ADSSP_PMP_DomainMapping_FK2(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_ADSSP_PMP_DomainMapping_FK3(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE

Ptrx_ADMP_PMP_DomainMapping

Top

Column name	Description	Data type
ACCOUNTID (PK)	A Unique Identifier to identify the account in ADMP.	BIGINT
RESOURCEID (PK)	A Unique Identifier to identify the Resource that matched with ADMP domain.	BIGINT
DOMAIN_ID (PK)	Unique Identifier for ADMP Domain.	BIGINT

Constraints

Primary key Ptrx_ADMP_PMP_DomainMapping(DOMAIN_ID,RESOURCEID,ACCOUNTID)
Foreign key Ptrx_ADMP_PMP_DomainMapping_FK2(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_ADMP_PMP_DomainMapping_FK3(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key Ptrx_ADMP_PMP_DomainMapping_FK1(DOMAIN_ID) references Ptrx_ADMP_DomainDetails(DOMAIN_ID) ON-DELETE-CASCADE

Ptrx_AgentInfo

Top

Column name	Description	Data type
AGENT_ID (PK)		BIGINT
IPADDRESS		CHAR
AGENT_NAME		CHAR
USER_NAME		CHAR
LOGINNAME		CHAR
PASSWORD		SCHAR
OSTYPE		CHAR
TIME		DATETIME
AUTH_TOKEN		SCHAR
AGENT_TYPE	Type of the Agent installed.	INTEGER
AGENT_USAGE_TYPE		CHAR
IS_DISASSOCIATED	True if Agent is Disassociated from its Resource	BOOLEAN
IS_ZT_ENABLED	True if Zero Trust Feature is enabled	BOOLEAN
IS_SSPE_ENABLED	True if Self Service Priviledge Elevation is Enabled	BOOLEAN
IS_PASSWORD_RESET_ENABLED	True if Password Reset Enabled	BOOLEAN
AGENT_VERSION	Product Version for which the agent Installed	BIGINT

Constraints

Primary key Ptrx_AgentInfo(AGENT_ID)

Ptrx_AgentAuthTokenMapping

Top

Column name	Description	Data type
AGENT_ID (PK)		BIGINT
RESOURCEID (PK)	Unique Identifier for a Resource.	BIGINT

Constraints

Primary key Ptrx_AgentAuthTokenMapping(RESOURCEID,AGENT_ID)
Foreign key Ptrx_AgentAuthTokenMapping_FK1(AGENT_ID) references Ptrx_AgentInfo(AGENT_ID) ON-DELETE-CASCADE

Ptrx_UserAgentAuthtokenMapping

Top

Column name	Description	Data type
AGENT_ID (PK)		BIGINT
USER_ID (PK)	Unique Identifier for a agent associated user.	BIGINT

Constraints

Primary key Ptrx_UserAgentAuthtokenMapping(USER_ID,AGENT_ID)
Foreign key Ptrx_UserAgentAuthTokenMapping_FK2(USER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_UserAgentAuthTokenMapping_FK1(AGENT_ID) references Ptrx_AgentInfo(AGENT_ID) ON-DELETE-CASCADE

Ptrx_ServerInfo

Top

Column name	Description	Data type
SERVERID (PK)	Unique identifier of the SERVER	BIGINT
SERVER_DNS	Server's address - dns / ipaddress	CHAR
SERVER_TYPE	Type of the server	CHAR
SERVER_VERSION	Server's PMP Version	INTEGER
CONFIGURATION_DETAILS	Server's additional Configuration details - Data must be in json format	CHAR
OPERATIONS	Server's to do operations - data must be in json format	CHAR
TIMESTAMP	Records the last server scheduled query timestamp for SDBMS	BIGINT
SERVER_ALIAS	Server alias set by user	CHAR
SERVER_PORT	Server alias set by user	INTEGER
STATUS	Server status during latest timestamp update	CHAR
DB_NAME	Database Name Of the server	CHAR
DB_DNS	Domain Name Of The Server	CHAR
DB_PORT	Server alias set by user	INTEGER
LAST_STARTUP_VERSION	Server's previously started version after applying PPM	INTEGER

Constraints

Primary key Ptrx_ServerInfo(SERVERID)

Ptrx_AgentOwnerMapping

Top

Column name	Description	Data type
AGENT_ID (PK)	The Unique Agent identifier	BIGINT
USERID (PK)	Unique User Identifier	BIGINT

Constraints

Primary key Ptrx_AgentOwnerMapping(USERID,AGENT_ID)
Foreign key Ptrx_AgentOwnerMapping_FK2(AGENT_ID) references Ptrx_AgentInfo(AGENT_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AgentOwnerMapping_FK1(USERID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_ResourceAgentPort

Top

Column name	Description	Data type
RESOURCEID (PK)	Unique Identifier for a Resource.	BIGINT
AGENT_ID		BIGINT
PORT	Port of the Agent	CHAR
SCHEDULETIME	Schedule Time of the Agent	BIGINT
ISONEWAYAGENT	Flag to check is the Agent is oneway	BOOLEAN

Constraints

Primary key Ptrx_ResourceAgentPort(RESOURCEID)
Foreign key Ptrx_ResourceAgentPort_FK(AGENT_ID) references Ptrx_AgentInfo(AGENT_ID) ON-DELETE-CASCADE

Ptrx_UserAgentPort

Top

Column name	Description	Data type
USERID (PK)	Unique Identifier for a Resource.	BIGINT
AGENT_ID		BIGINT
PORT	Port of the Agent	CHAR
SCHEDULETIME	Schedule Time of the Agent	BIGINT
ISONEWAYAGENT	Flag to check is the Agent is oneway	BOOLEAN

Constraints

Primary key Ptrx_UserAgentPort(USERID)
Foreign key Ptrx_UserAgentPort_FK(AGENT_ID) references Ptrx_AgentInfo(AGENT_ID) ON-DELETE-CASCADE

Ptrx_AgentPingStatus

Top

Column name	Description	Data type
AGENT_ID (PK)		BIGINT
RESOURCEID	Unique Identifier for a Resource.	BIGINT
LASTUPDATETIME	Last Update Time of the Agent	BIGINT

Constraints

Primary key Ptrx_AgentPingStatus(AGENT_ID)
Foreign key Ptrx_AgentPingStatus_FK(AGENT_ID) references Ptrx_AgentInfo(AGENT_ID) ON-DELETE-CASCADE

Ptrx_SdkPolicies

Top

Column name	Description	Data type
POLICYID (PK)	Unique identifier for SDK policy	BIGINT
POLICYNAME	Unique name for the policy	CHAR
POLICYKEY	The secret key associated with the policy	SCHAR
USER_ID	Unique id of user associated to this rule	BIGINT

Constraints

Primary key Ptrx_SdkPolicies(POLICYID)
Foreign key Ptrx_SdkPolicies_FK(USER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_SdkClient

Top

Column name	Description	Data type
CLIENTID (PK)	Unique identifier for SDK Client	BIGINT
CLIENTNAME	Unique display name for the Client	CHAR
NOTES	Description to denote the purpose of this SDK client	CHAR
CLIENTSECRET	The Hashed Secret key for the client	SCHAR
POLICYID	Unique ID of the SDK policy associated with the client	BIGINT
REGISTEREDREMOTEHOST	The remote host name while SDK registration	CHAR
CLIENTPATH	the file path where SDK is located	CHAR
CLIENTMACHINE	the client sdk machine name	CHAR
CLIENTTYPE	the type of the sdk used	CHAR
IP	the Ip of the client at the time of registration	CHAR
CREATEDTIME	Specifies the clients created time	BIGINT
LASTACCESSEDTIME	Specifies the last accessed time of the client	BIGINT
ISREGISTRATIONTOKENUPDATED	Boolean value to know if the client has regenerated the registration token	BOOLEAN

Constraints

Primary key Ptrx_SdkClient(CLIENTID)
Foreign key Ptrx_SdkClient_FK(POLICYID) references Ptrx_SdkPolicies(POLICYID) ON-DELETE-CASCADE

Ptrx_UserTrustScoreWeight

Top

Column name	Description	Data type
UserScoreWeight_ID (PK)	Unique identifier for the weightage	BIGINT
SignIn_Attempts	Weightage of no log on failure	INTEGER
Password_Strength	Weightage of password strength	INTEGER
SignIn_Time	Weightage of anomalous sign in time	INTEGER
SignIn_Location	Weightage of anomalous sign in location	INTEGER
SignIn_IP	Weightage of anomalous signin ip	INTEGER
SignIn_Device	Weightage of anomalous signin device	INTEGER
Privileged_Group	Weightage of privileged user	INTEGER

Constraints

Primary key Ptrx_UserTrustScoreWeight(UserScoreWeight_ID)

Ptrx_DeviceTrustScoreWeight

Top

Column name	Description	Data type
DeviceScoreWeight_ID (PK)	Unique identifier for the weightage	BIGINT
Password_Protected	Weightage for password logon	INTEGER
OS_Version	Weightage of vulnerable OS version	INTEGER
Plugin_Addon_Extension	Weightage of vulnerable plugin, addon and extension	INTEGER
Application_Package	Weightage of vulnerable application and package	INTEGER
Process_Services	Weightage of suspicious process and services	INTEGER
AV_Software	Weightage of antivirus protection	INTEGER
Firewall_Enabled	Weightage of firewall protection	INTEGER
Open_Ports	Weightage of unused open ports	INTEGER
Secure_Boot	Weightage of secure boot	INTEGER
Driver_Integrity	Weightage of integrity verification	INTEGER
Session_Recording	Weightage of session recording	INTEGER
Privileged_Group	Weightage for privileged group	INTEGER
PE_Agent	Weightage of privilege elevation agent	INTEGER

Constraints

Primary key Ptrx_DeviceTrustScoreWeight(DeviceScoreWeight_ID)

Ptrx_UserDeviceTrustScoreWeight

Top

Column name	Description	Data type
DeviceScoreWeight_ID (PK)	Unique identifier for the weightage	BIGINT
Password_Protected	Weightage for password logon	INTEGER
OS_Version	Weightage of vulnerable OS version	INTEGER
Plugin_Addon_Extension	Weightage of vulnerable plugin, addon and extension	INTEGER
Application_Package	Weightage of vulnerable application and package	INTEGER
Process_Services	Weightage of suspicious process and services	INTEGER
AV_Software	Weightage of antivirus protection	INTEGER
Firewall_Enabled	Weightage of firewall protection	INTEGER
Open_Ports	Weightage of unused open ports	INTEGER
Secure_Boot	Weightage of secure boot	INTEGER
Driver_Integrity	Weightage of integrity verification	INTEGER
PE_Agent	Weightage of privilege elevation agent	INTEGER

Constraints

Primary key Ptrx_UserDeviceTrustScoreWeight(DeviceScoreWeight_ID)

Ptrx_UserTrustPrivilegeGroupMapping

Top

Column name	Description	Data type
Mapping_ID (PK)	Unique identifier for the user trust mapping	BIGINT
UserScoreWeight_ID	user score weightage reference column	BIGINT
UserGroup_ID	user group reference column	BIGINT

Constraints

Primary key Ptrx_UserTrustPrivilegeGroupMapping(Mapping_ID)
Foreign key Ptrx_UserTrustPrivilegeGroupMapping_FK(UserScoreWeight_ID) references Ptrx_UserTrustScoreWeight(UserScoreWeight_ID) ON-DELETE-CASCADE
Foreign key Ptrx_UserTrustPrivilegeGroupMapping_FK1(UserGroup_ID) references Ptrx_UserGroup(USERGROUPID) ON-DELETE-CASCADE

Ptrx_UserTrustIPMapping

Top

Column name	Description	Data type
Mapping_ID (PK)	Unique identifier for the user trust mapping	BIGINT
UserScoreWeight_ID	user score weightage reference column	BIGINT
IPRange	ip range	CHAR

Constraints

Primary key Ptrx_UserTrustIPMapping(Mapping_ID)
Foreign key Ptrx_UserTrustIPMapping_FK(UserScoreWeight_ID) references Ptrx_UserTrustScoreWeight(UserScoreWeight_ID) ON-DELETE-CASCADE

Ptrx_DeviceTrustPrivilegeGroupMapping

Top

Column name	Description	Data type
Mapping_ID (PK)	Unique identifier for the privilege mapping	BIGINT
DeviceScoreWeight_ID	device score weightage reference column	BIGINT
Group_ID	privilege group id	BIGINT

Constraints

Primary key Ptrx_DeviceTrustPrivilegeGroupMapping(Mapping_ID)
Foreign key Ptrx_DeviceTrustPrivilegeGroupMapping_FK1(Group_ID) references Ptrx_ResourceGroup(GROUPID) ON-DELETE-CASCADE
Foreign key Ptrx_DeviceTrustPrivilegeGroupMapping_FK(DeviceScoreWeight_ID) references Ptrx_DeviceTrustScoreWeight(DeviceScoreWeight_ID) ON-DELETE-CASCADE

Ptrx_UserTrustScore

Top

Column name	Description	Data type
UserScore_ID (PK)	Unique identifier for the user trust score	BIGINT
User_ID	user id reference column	BIGINT
Score	user trust score	INTEGER
Last_Update_Time	Last modified time	DATETIME

Constraints

Primary key Ptrx_UserTrustScore(UserScore_ID)
Foreign key Ptrx_UserTrustScore_FK(User_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_UserAuthTrustScore

Top

Column name	Description	Data type
UserScore_ID (PK)	Unique identifier for the user trust score	BIGINT
User_ID	user id reference column	BIGINT
Score	user trust score	INTEGER
Last_Update_Time	Last modified time	DATETIME

Constraints

Primary key Ptrx_UserAuthTrustScore(UserScore_ID)
Foreign key Ptrx_UserAuthTrustScore_FK(User_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_DeviceTrustScore

Top

Column name	Description	Data type
DeviceScore_ID (PK)	Unique identifier for the device trust score	BIGINT
Resource_ID	resource id reference column	BIGINT
Score	user trust score	INTEGER
Last_Update_Time	Last modified time	DATETIME

Constraints

Primary key Ptrx_DeviceTrustScore(DeviceScore_ID)
Foreign key Ptrx_DeviceTrustScore_FK(Resource_ID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_DeviceTrustAgentInformation

Top

Column name	Description	Data type
Info_ID (PK)	Unique identifier for the device trust score	BIGINT
Resource_ID	resource id reference column	BIGINT
Has_Antivirus_Software		BOOLEAN
Has_Encrypted_Storage		BOOLEAN
Has_Firewall_Enabled		BOOLEAN
Has_No_Suspicious_Process		BOOLEAN
Has_Secure_Boot		BOOLEAN
Last_Updated_Time		DATETIME

Constraints

Primary key Ptrx_DeviceTrustAgentInformation(Info_ID)
Foreign key Ptrx_DeviceTrustAgentInformation_FK(Resource_ID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE

Ptrx_LogonTimeConfig

Top

Column name	Description	Data type
Config_ID (PK)	Unique identifier for the table	BIGINT
UserGroup_ID	user group id reference column	BIGINT
LogonTime		CHAR
Enabled	Status of the config	BOOLEAN
Last_Updated_Time		DATETIME

Constraints

Primary key Ptrx_LogonTimeConfig(Config_ID)
Foreign key Ptrx_LogonTimeConfig_FK(UserGroup_ID) references Ptrx_UserGroup(USERGROUPID) ON-DELETE-CASCADE

Ptrx_UserAgentInfo

Top

Column name	Description	Data type
AGENT_ID (PK)		BIGINT
IPADDRESS		CHAR
AGENT_NAME		CHAR
USER_NAME		CHAR
OSTYPE		CHAR
TIME		DATETIME
AUTH_TOKEN		SCHAR
AGENT_TYPE	Type of the Agent installed.	INTEGER
IS_ZT_ENABLED	True if Zero Trust Feature is enabled	BOOLEAN
DEVICE_ID		SCHAR

Constraints

Primary key Ptrx_UserAgentInfo(AGENT_ID)

Ptrx_UserDeviceTrustAgentInformation

Top

Column name	Description	Data type
Info_ID (PK)	Unique identifier for the device trust score	BIGINT
AGENT_ID	resource id reference column	BIGINT
Has_Antivirus_Software		BOOLEAN
Has_Encrypted_Storage		BOOLEAN
Has_Firewall_Enabled		BOOLEAN
Has_No_Suspicious_Process		BOOLEAN
Has_Secure_Boot		BOOLEAN
Last_Updated_Time		DATETIME

Constraints

Primary key Ptrx_UserDeviceTrustAgentInformation(Info_ID)
Foreign key Ptrx_UserDeviceTrustAgentInformation_FK(AGENT_ID) references Ptrx_UserAgentInfo(AGENT_ID) ON-DELETE-CASCADE

Ptrx_UserDeviceTrustScore

Top

Column name	Description	Data type
DeviceScore_ID (PK)	Unique identifier for the device trust score	BIGINT
AGENT_ID	resource id reference column	BIGINT
Score	user trust score	INTEGER
Last_Update_Time	Last modified time	DATETIME

Constraints

Primary key Ptrx_UserDeviceTrustScore(DeviceScore_ID)
Foreign key Ptrx_UserDeviceTrustScore_FK(AGENT_ID) references Ptrx_UserAgentInfo(AGENT_ID) ON-DELETE-CASCADE

Ptrx_ZTAgentOSQueryResponse

Top

Column name	Description	Data type
AGENT_ID (PK)	The Unique Agent identifier	BIGINT
USERID	Unique User Identifier	BIGINT
RESOURCEID	Unique Resource Identifier	BIGINT
OSQUERY_RESPONSE	values.	SBLOB
TIMESTAMP	Time stamp for osquery response fetched	DATETIME

Constraints

Primary key Ptrx_ZTAgentOSQueryResponse(AGENT_ID)
Foreign key Ptrx_ZTAgentOSQueryResponse_FK(AGENT_ID) references Ptrx_AgentInfo(AGENT_ID) ON-DELETE-CASCADE

PTRX_AccessPolicy

Top

Column name	Description	Data type
POLICY_ID (PK)	The Unique Identifier for the Access Policy.	BIGINT
POLICY_NAME	Name of the Policy	CHAR
POLICY_DESC	Policy Description.	CHAR
POLICY_OWNERID	User who created the policy.	BIGINT
POLICY_APPROVERID	Approver who approves the policy	BIGINT
POLICY_STATUS	Status of the policy	BIGINT
TIMESTAMP	Time stamp for Policy	DATETIME

Constraints

Primary key PTRX_AccessPolicy(POLICY_ID)

PTRX_AccessPolicyAdmins

Top

Column name	Description	Data type
USER_ID (PK)	The Unique Identifier for the User.	BIGINT
POLICY_ID (PK)	The Unique Identifier for the Access Policy.	BIGINT
APPROVAL_ID	The Unique Identifier for the Approval Admin.	BIGINT

Constraints

Primary key PTRX_AccessPolicyAdmins(POLICY_ID,USER_ID)
Foreign key Ptrx_AccessPolicy_Admins_FK2(USER_ID) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccessPolicy_Admins_FK1(POLICY_ID) references PTRX_AccessPolicy(POLICY_ID) ON-DELETE-CASCADE

Ptrx_AccessPolicy_Details

Top

Column name	Description	Data type
POLICY_CONDITION_ID (PK)	The Unique Identifier for the Access Policy.	BIGINT
POLICY_ID	The Unique Identifier for the Access Policy.	BIGINT
CONDITION_NAME	NAme of the condition	CHAR
CONDITION_DESC	Condition Description.	CHAR
ISRDP	Is RDP allowed.	BOOLEAN
ISSSH	Is ssh allowed.	BOOLEAN
iSREMOTEAPP	Is Remote app allowed.	BOOLEAN
ISLANDINGSERVER	Is Landing server allowed.	BOOLEAN
ISPASSWORDRESET	Is password reset allowed.	BOOLEAN
ISPRIVILEGEELEVATION	Is Privilege Elevation allowed.	BOOLEAN
ISSQL	Is SQL allowed.	BOOLEAN
ISSSPELIN	Is SSPELIN allowed.	BOOLEAN
ISSSPEWIN	Is SQL allowed.	BOOLEAN
ISPASSWORDVIEW	Is Password view allowed.	BOOLEAN
POLICY_ACTIONID	Action for the Access Policy.	BIGINT
TIMESTAMP	Time stamp for Policy	DATETIME
ISPOLICYSAVED	Is Access Policy Saved after adding condition.	BOOLEAN
ISPOLICYAPPROVED	Is Access Policy approved .	BOOLEAN

Constraints

Primary key Ptrx_AccessPolicy_Details(POLICY_CONDITION_ID)
Foreign key Ptrx_AccessPolicy_Details_FK1(POLICY_ID) references PTRX_AccessPolicy(POLICY_ID) ON-DELETE-CASCADE

Ptrx_AccessPolicyMapping

Top

Column name	Description	Data type
ACCOUNTID (PK)	The Unique Identifier for the Account.	BIGINT
POLICY_ID (PK)	The Unique Identifier for the Access Policy.	BIGINT
CONFIG_TYPE	Configuration mapping.	BIGINT
TIMESTAMP	Time stamp for Policy	DATETIME

Constraints

Primary key Ptrx_AccessPolicyMapping(POLICY_ID,ACCOUNTID)
Foreign key Ptrx_AccessPolicyMapping_FK2(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE
Foreign key Ptrx_AccessPolicyMapping_FK1(POLICY_ID) references PTRX_AccessPolicy(POLICY_ID) ON-DELETE-CASCADE

Ptrx_AccessPolicy_ResourceGroup_Mapping

Top

Column name	Description	Data type
GROUPID (PK)	The Unique Identifier for the Resource Group.	BIGINT
POLICY_ID (PK)	The Unique Identifier for the Access Policy.	BIGINT
TIMESTAMP	Time stamp for Policy	DATETIME

Constraints

Primary key Ptrx_AccessPolicy_ResourceGroup_Mapping(POLICY_ID,GROUPID)
Foreign key Ptrx_AcsPolicy_ResGrp_Mapping_FK1(POLICY_ID) references PTRX_AccessPolicy(POLICY_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AcsPolicy_ResGrp_Mapping_FK2(GROUPID) references Ptrx_ResourceGroup(GROUPID) ON-DELETE-CASCADE

Ptrx_AccessPolicy_CriteriaDetails

Top

Column name	Description	Data type
POLICY_ID (PK)	The Unique Identifier for the Access Policy.	BIGINT
POLICY_CONDITION_ID (PK)	The Unique Identifier for the Access Policy condition.	BIGINT
CRITERIA_ID (PK)	The Unique Identifier for the Access Policy criteria details.	BIGINT
CRITERIAEXPRESSION	Type of the criteria.	CHAR
CRITERIAVALUE	values.	SBLOB

Constraints

Primary key Ptrx_AccessPolicy_CriteriaDetails(CRITERIA_ID,POLICY_CONDITION_ID,POLICY_ID)
Foreign key Ptrx_AccPolicy_CriteriaDetails_FK1(POLICY_CONDITION_ID) references Ptrx_AccessPolicy_Details(POLICY_CONDITION_ID) ON-DELETE-CASCADE
Foreign key Ptrx_AccPolicy_CriteriaDetails_FK2(POLICY_ID) references PTRX_AccessPolicy(POLICY_ID) ON-DELETE-CASCADE

Ptrx_ZTConfigurationUserAuthDetails

Top

Column name	Description	Data type
PROFILE_ID (PK)	ID for the Profile	BIGINT
USERAUTHCONF_ID (PK)	The Unique Identifier for the Access Policy criteria details.	BIGINT
CONFIGURATION_VALUE	values.	SBLOB

Constraints

Primary key Ptrx_ZTConfigurationUserAuthDetails(USERAUTHCONF_ID,PROFILE_ID)

Ptrx_ZTConfigurationUserDeviceDetails

Top

Column name	Description	Data type
PROFILE_ID (PK)	ID for the Profile	BIGINT
USERDEVICECONF_ID (PK)	The Unique Identifier for the Access Policy criteria details.	BIGINT
CONFIGURATION_VALUE	values.	SBLOB

Constraints

Primary key Ptrx_ZTConfigurationUserDeviceDetails(USERDEVICECONF_ID,PROFILE_ID)

Ptrx_ZTConfigurationDeviceDetails

Top

Column name	Description	Data type
PROFILE_ID (PK)	ID for the Profile	BIGINT
DEVICECONF_ID (PK)	The Unique Identifier for the Access Policy criteria details.	BIGINT
CONFIGURATION_VALUE	values.	SBLOB

Constraints

Primary key Ptrx_ZTConfigurationDeviceDetails(DEVICECONF_ID,PROFILE_ID)

Ptrx_ZTAgentOSQueryDetails

Top

Column name	Description	Data type
PROFILE_ID (PK)	ID for the Profile	BIGINT
OSQUERY_ID (PK)	The Unique Identifier for the Access Policy criteria details.	BIGINT
OSQUERY_DETAILS	values.	SBLOB
OS_TYPE	Type of os	CHAR
TIMESTAMP	Time stamp for Policy	DATETIME

Constraints

Primary key Ptrx_ZTAgentOSQueryDetails(OSQUERY_ID,PROFILE_ID)

Ptrx_ZTScoreDetails

Top

Column name	Description	Data type
PROFILE_ID (PK)	ID for the Profile	BIGINT
SCORE_ID (PK)	The Unique Identifier for the Access Policy criteria details.	BIGINT
COMMONID	ID of the resource or user	BIGINT
SCORE_DETAILS	values.	SBLOB
SCORE_TYPE	Type From which score has been updated	BIGINT
TIMESTAMP	Time stamp for Policy	DATETIME

Constraints

Primary key Ptrx_ZTScoreDetails(SCORE_ID,PROFILE_ID)

Ptrx_SdkClientAudit

Top

Column name	Description	Data type
AUDITID (PK)	Private key to identify the audit trails	BIGINT
CLIENTNAME	Audited Client name.	CHAR
CLIENTID	Unique ID of the SDK client	BIGINT
OPERATEDBY	Audited user's first and last name.	CHAR
LOGINNAME	Audited user's login name.	CHAR
ASSOCIATEDRULE	Associated rule of the client	CHAR
TIMESTAMP	The Last time stamp when the resource was accessed or attempted any access.	DATETIME
IPADDRESS	IP Address from which action is performed.	CHAR
OPERATION	The exact operation performed.	CHAR

Constraints

Primary key Ptrx_SdkClientAudit(AUDITID)

Ptrx_TOTP_Details

Top

Column name	Description	Data type
ACCOUNTID (PK)	Unique Account Identifier	BIGINT
TOTP_ALGORITHM	TOTP Algortihm	CHAR
TOTP_VALIDITY	TOTP time period	INTEGER
TOTP_DIGITS	TOTP Digits	INTEGER
TOTP_SECRET	TOTP Secret	SCHAR

Constraints

Primary key Ptrx_TOTP_Details(ACCOUNTID)
Foreign key Ptrx_TOTP_Details_FK(ACCOUNTID) references Ptrx_Account(ACCOUNTID) ON-DELETE-CASCADE

Ptrx_DatabaseConf

Top

Column name	Description	Data type
CONF_ID (PK)	The unique identifier for the configuration	BIGINT
RESOURCEID	Unique identifier of the resource	BIGINT
TYPEID	Unique identifier of the resource type	BIGINT
CLASSNAME	Driver class name	CHAR
DISCOVERYQUERY	Sql query to fetch user accounts	CHAR
CHANGE_PWD_QUERY	Query to change password of user account	CHAR
JARFILE	Name of driver jar to be used while connecting to database	CHAR
MODIFIED_BY	Id of the user who modified the property	BIGINT
APPROVED_BY	Id of the user who approved the configuration	BIGINT
APPROVED_TIME	Column for custom date attribute.	DATETIME
ALLOW_EDIT_DB_ATTRIBUTES_AT_RESOURCE	Edit db attributes operation at resource level is allowed if this is set to true	BOOLEAN

Constraints

Primary key Ptrx_DatabaseConf(CONF_ID)
Foreign key Ptrx_DatabasConf_FK1(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_DatabaseConf_FK3(MODIFIED_BY) references AaaUser(USER_ID) ON-DELETE-CASCADE
Foreign key Ptrx_DatabaseConf_FK2(TYPEID) references Ptrx_ResourceSystem(OSID) ON-DELETE-CASCADE
Foreign key Ptrx_DatabaseConf_FK4(APPROVED_BY) references AaaUser(USER_ID) ON-DELETE-CASCADE

Ptrx_JDBCProperties

Top

Column name	Description	Data type
PROPERTY_ID (PK)	The unique identifier for the allowed connection property	BIGINT
KEY	Key for the allowed connection property	CHAR
DEFAULT_VALUE	The connection property key name	CHAR
PROPERTY_TYPE	Different types of JDBC Properties.	BIGINT
ISDEFAULTPROPERTY	True if the JDBC property is predefined	BOOLEAN
MODIFIEDBY	Id of the user who updated the property	BIGINT

Constraints

Primary key Ptrx_JDBCProperties(PROPERTY_ID)
Foreign key Ptrx_JDBCProperties_FK1(MODIFIEDBY) references AaaUser(USER_ID)

Ptrx_DatabasePropertiesMapping

Top

Column name	Description	Data type
PROPERTY_MAP_ID (PK)	The unique identifier for the connection property	BIGINT
CONF_ID	Unique identifier of the database configuration	BIGINT
PROPERTY_ID	Unique identifier of the database configuration	BIGINT

Constraints

Primary key Ptrx_DatabasePropertiesMapping(PROPERTY_MAP_ID)
Foreign key Ptrx_DatabasePropertiesMapping_FK1(CONF_ID) references Ptrx_DatabaseConf(CONF_ID) ON-DELETE-CASCADE
Foreign key Ptrx_DatabasePropertiesMapping_FK2(PROPERTY_ID) references Ptrx_JDBCProperties(PROPERTY_ID) ON-DELETE-CASCADE

Ptrx_AppGatewayResMapping

Top

Column name	Description	Data type
RESOURCEID (PK)	The Unique Identifier for the Resource.	BIGINT
GATEWAYID	The Unique Identifier for the Endpoint.	BIGINT

Constraints

Primary key Ptrx_AppGatewayResMapping(RESOURCEID)
Foreign key Ptrx_AppGatewayResMapping_FK2(RESOURCEID) references Ptrx_Resource(RESOURCEID) ON-DELETE-CASCADE
Foreign key Ptrx_AppGatewayResMapping_FK1(GATEWAYID) references AppGatewayServerDetails(serverid) ON-DELETE-CASCADE

PKI_SSLCoreCertData

Top

Column name	Description	Data type
SSL_RESOURCEID (PK)	This is a surrogate key. The value is auto generated to identify a SSL Resource uniquely.	BIGINT
RESOURCEID	This is a surrogate key. The value is auto generated to identify the host (domain) uniquely	BIGINT
RESOURCENAME	cert deployed resource name.	SCHAR
CERT_DOMAIN_NAME	Domain Name from the certificate	SCHAR
PORT	Port to connect with the domain	INTEGER
RESOURCE_DESCRIPTION	Description for a give devices.	SCHAR
CA	is self signed or CA Certificate	CHAR
CREATIONTIME	The time at which the resource was created	DATETIME
LOGIN_ID	Stores the login id of the user who created the certificate	BIGINT
CREATED_BY	Certificate Created User	SCHAR
CERT_TYPE	For identifying the certificate is AD/Domain certificate	CHAR
ISNEWKEY	It's for create a new key for renewing MSCA certificates	BOOLEAN
IS_AUTODEPLOY	It's for deploying the certifcate to mapped servers after renewal	BOOLEAN
CERTIFICATE_TEMPLATE	MS CA Certificate template distinguishedName name	CHAR
TEMPLATE_NAME	MS CA Certificate template display Name	CHAR
MSCA_NAME	MS CA name	CHAR
ISROOT	Identify the root certificate	INTEGER

Constraints

Primary key PKI_SSLCoreCertData(SSL_RESOURCEID)
Foreign key PKI_SSLCoreCertData_FK1(RESOURCEID) references Resources(RESOURCEID)ON-DELETE-CASCADE

PKI_SSLCertificateDetails

Top

Column name	Description	Data type
SSL_RESOURCEID (PK)	Value to identify a certificate domain (host) uniquely	BIGINT
KEY_STRENGTH		BIGINT
FROM_DATE	Certificate is valid from data	DATETIME
EXPIRY_DATE	Certificate expires date	DATETIME
DAYS_TO_EXPIRY	Number of days to expire	BIGINT
FINGERPRINT		CHAR
KEYALGORITHM		CHAR
SERIALNUMBER		CHAR
SIGNATURE_ALGORITHM		CHAR
SANS	Subject Alternative Names	CHAR
CURRENT_CERTIFICATE	Stores the current SSL certificate information	SBLOB
KEYSTORE_CONTENT	Stores the keystore content	SBLOB
KEYSTORE_PASS	Keystore passphrase	SCHAR
KEYSTORE_TYPE	Keystore type	CHAR
EMAIL	Comma seperated Email Address	SCHAR

Constraints

Primary key PKI_SSLCertificateDetails(SSL_RESOURCEID)
Foreign key PKI_SSLCertificateDetails_FK1(SSL_RESOURCEID) references PKI_SSLCoreCertData(SSL_RESOURCEID) ON-DELETE-CASCADE

PKI_SSLIssuerDetails

Top

Column name	Description	Data type
SSL_RESOURCEID (PK)	This is a surrogate key. Host ID associated with the given domain and certificate	BIGINT
ISSUER_NAME	Stores the certificate issuer name	CHAR
ORGANIZATION	Organization Name	CHAR
ORGANIZATION_UNIT	organization unit	CHAR

Constraints

Primary key PKI_SSLIssuerDetails(SSL_RESOURCEID)
Foreign key PKI_SSLIssuerDetails_FK1(SSL_RESOURCEID) references PKI_SSLCoreCertData(SSL_RESOURCEID) ON-DELETE-CASCADE

PKIAudit

Top

Column name	Description	Data type
AUDITID (PK)	Private key to identify the audit trails	BIGINT
HOST_ADDRESS	Remote host address.	CHAR
LOGIN_ID	Audited user's login Id.	BIGINT
SESSION_ID	Session id	BIGINT
USERNAME	Audited user's first and last Name.	CHAR
OPERATIONAUDITTIME	The Last time stamp when the resource was accessed or attempted any access.	DATETIME
OPERATION_ID	operation_type id	INTEGER
OPERATIONTYPE	The type of the operation done.	CHAR
REASON	The Reason operation failure.	CHAR
KEY_PARAMS	I18N key parameters.	CHAR

Constraints

Primary key PKIAudit(AUDITID)

PKI_WHOISDATA

Top

Column name	Description	Data type
WHOISID (PK)		BIGINT
SSLRESOURCEID		BIGINT
COMMONNAME		CHAR
EXPIRY		CHAR
ISPUBLICDOMAIN		BOOLEAN

Constraints

Primary key PKI_WHOISDATA(WHOISID)
Foreign key PKI_WHOISDATA_FK(SSLRESOURCEID) references PKI_SSLCoreCertData(SSL_RESOURCEID) ON-DELETE-CASCADE

PKI_AuditConfiguration

Top

Column name	Description	Data type
CONF_ID (PK)	The unique identifier for the operation_type	BIGINT
OPERATION_ID	operation_type id	INTEGER
AUDIT_TYPE	Type of audit operation.	CHAR
ISAUDIT	Should audit this operation	BOOLEAN
ISNOTIFY	Should notify this operation in mail for kmp users (usergroups in pmp),and notified mailids	BOOLEAN
IS_SNMP_NOTIFY	Should notify this operation in snmp(PMP)	BOOLEAN
IS_SYSLOG_NOTIFY	Should notify this operation in syslog server	BOOLEAN
NOTIFYADMIN	Should notify this operation admins	BOOLEAN
NOTIFYAUDITOR	Should notify this operation to all auditors(for PMP)	BOOLEAN

Constraints

Primary key PKI_AuditConfiguration(CONF_ID)