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 | 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
| 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)
| 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)
| 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)
| 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)
| 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
| 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)
| 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)
| 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
| 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
| 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
| 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
| 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
| 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)
| 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
| 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
| 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
| 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)
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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)
| 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
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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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)
| 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)
| 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)
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| Column name | Description | Data type |
|---|
LISTENERID (PK) | The Unique Identifier for the Listener. | BIGINT | OSID (PK) | The Unique Identifier for the Listener. | BIGINT |
Constraints
| 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
| 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)
| Column name | Description | Data type |
|---|
HELPERID (PK) | The Unique Identifier for the helper. | BIGINT | OSID (PK) | The Unique Identifier for the helper. | BIGINT |
Constraints
| 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
| 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)
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
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
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
| 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
| 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
| 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
| 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
| 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
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)
| 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)
| 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)
| 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
| 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
| 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
| 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
| 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
| 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)
| Column name | Description | Data type |
|---|
WHOISID (PK) | | BIGINT | | SSLRESOURCEID | | BIGINT |
| COMMONNAME | | CHAR |
| EXPIRY | | CHAR |
| ISPUBLICDOMAIN | | BOOLEAN |
Constraints
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)
