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.

AaaContactInfo
AaaUser
AaaUserContactInfo
AaaPasswordRule
AaaLogin
AaaAccount
AaaAccSession
AaaRole
AaaAuthorizedRole
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_ListenerDetails

Ptrx_ResTypeListener
Ptrx_SuperAdmin
Ptrx_SchTasksDetails
Ptrx_TaskAudit
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_AccessControl
Ptrx_AccessControlMapping
Ptrx_ResourceAccessControl
Ptrx_AccountAccessControl
Ptrx_AccessControlAdmin
Ptrx_AccessControlAutoApproval
Ptrx_AccessControlUsers
Ptrx_RequestRelease
Ptrx_RequestDomainDetails
Ptrx_TwoFactorAuth
Ptrx_UsersTwoFactorAuth

Ptrx_UsersMobileAccessDetails
Ptrx_UsersAddonAccessDetails
Ptrx_LanguageMapping
Ptrx_ServiceAccountMapping
Ptrx_AppPoolAccountMapping
Ptrx_UserStatus
Ptrx_ImportedUsersMapping
Ptrx_Role
Ptrx_IISWebsite
Ptrx_ADSSP_DomainDetails
Ptrx_ADSSP_PMP_DomainMapping
Ptrx_AgentInfo
Ptrx_AgentAuthTokenMapping

Ptrx_UserAgentAuthtokenMapping
Ptrx_AgentOwnerMapping
Ptrx_ResourceAgentPort
Ptrx_UserAgentPort
Ptrx_AgentPingStatus
Ptrx_DatabaseConf
Ptrx_JDBCProperties
Ptrx_DatabasePropertiesMapping
Ptrx_TOTP_Details
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

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

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

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

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

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

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

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 Entra ID	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

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 - Entra ID, 3 - LDAP	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_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

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

Constraints

Primary key Ptrx_SuperAdmin(USERID)
Foreign key Ptrx_SuperAdmin_FK(USERID) references AaaUser(USER_ID) 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

Constraints

Primary key Ptrx_TaskAudit(TASKAUDITID)

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_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

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_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_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_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_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_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. Entra ID	BIGINT
USERID (PK)	Unique User Identifier	BIGINT

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_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_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_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_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_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_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_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_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