SchemaSpy Analysis of SIEM.public - ColumnsWe recommend you use the Views and not the Tables for any reports you write | Generated by SchemaSpy |
Generated by SchemaSpy on Mon Mar 26 23:24 EDT 2012 |
| |||||
|
SIEM.public contains 2050 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
actvy | access_lvl | varchar | 50 | Access level | |||
actvy | actvy_desc | varchar | 255 | √ | null | Activity description | |
actvy | actvy_id | uuid | 2147483647 | Activity identifier | |||
actvy | actvy_name | varchar | 255 | Activity name | |||
actvy | actvy_typ_cd | varchar | 1 | Activity type code | |||
actvy | app_name | varchar | 25 | √ | null | Application name | |
actvy | created_by | int4 | 10 | √ | null | User who created object | |
actvy | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
actvy | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
actvy | exec_loc | varchar | 50 | Execution location | |||
actvy | input_formatter | varchar | 255 | √ | null | Input formatter | |
actvy | modified_by | int4 | 10 | √ | null | User who last modified object | |
actvy | output_formatter | varchar | 255 | √ | null | Output formatter | |
actvy | processor | varchar | 255 | √ | null | Processor | |
actvy_parm | actvy_id | uuid | 2147483647 | Activity identifier | |||
actvy_parm | actvy_parm_id | uuid | 2147483647 | Activity parameter identifier | |||
actvy_parm | created_by | int4 | 10 | √ | null | User who created object | |
actvy_parm | data_subtyp | varchar | 50 | √ | null | Activity parameter data subtype | |
actvy_parm | data_typ | varchar | 50 | Activity parameter data type | |||
actvy_parm | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
actvy_parm | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
actvy_parm | formatter | varchar | 255 | √ | null | Activity parameter formatter | |
actvy_parm | modified_by | int4 | 10 | √ | null | User who last modified object | |
actvy_parm | parm_desc | varchar | 255 | √ | null | Activity parameter description | |
actvy_parm | parm_name | varchar | 255 | Activity Parameter name | |||
actvy_parm | parm_typ_cd | varchar | 1 | Activity parameter type code | |||
actvy_parm | parm_val | varchar | 1000 | √ | null | Activity parameter value | |
actvy_parm | rqrd_f | bool | 1 | √ | null | Required flag | |
actvy_parm_rpt_v | actvy_id | uuid | 2147483647 | √ | null | Activity identifier | |
actvy_parm_rpt_v | actvy_parm_id | uuid | 2147483647 | √ | null | Activity parameter identifier | |
actvy_parm_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
actvy_parm_rpt_v | data_subtyp | varchar | 50 | √ | null | Activity parameter data subtype | |
actvy_parm_rpt_v | data_typ | varchar | 50 | √ | null | Activity parameter data type | |
actvy_parm_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
actvy_parm_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
actvy_parm_rpt_v | formatter | varchar | 255 | √ | null | Activity parameter formatter | |
actvy_parm_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
actvy_parm_rpt_v | parm_desc | varchar | 255 | √ | null | Activity parameter description | |
actvy_parm_rpt_v | parm_name | varchar | 255 | √ | null | Activity Parameter name | |
actvy_parm_rpt_v | parm_typ_cd | varchar | 1 | √ | null | Activity parameter type code | |
actvy_parm_rpt_v | parm_val | varchar | 1000 | √ | null | Activity parameter value | |
actvy_parm_rpt_v | rqrd_f | bool | 1 | √ | null | Required flag | |
actvy_ref | actvy_id | uuid | 2147483647 | Activity identifier | |||
actvy_ref | created_by | int4 | 10 | √ | null | User who created object | |
actvy_ref | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
actvy_ref | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
actvy_ref | modified_by | int4 | 10 | √ | null | User who last modified object | |
actvy_ref | refd_actvy_id | uuid | 2147483647 | Referenced activity identifier | |||
actvy_ref | seq_num | int4 | 10 | Sequence number | |||
actvy_ref_parm_val | actvy_id | uuid | 2147483647 | Activity identifier | |||
actvy_ref_parm_val | actvy_parm_id | uuid | 2147483647 | Activity parameter identifier | |||
actvy_ref_parm_val | created_by | int4 | 10 | √ | null | User who created object | |
actvy_ref_parm_val | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
actvy_ref_parm_val | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
actvy_ref_parm_val | modified_by | int4 | 10 | √ | null | User who last modified object | |
actvy_ref_parm_val | parm_val | varchar | 1000 | Activity parameter value | |||
actvy_ref_parm_val | seq_num | int4 | 10 | Sequence number | |||
actvy_ref_parm_val_rpt_v | actvy_id | uuid | 2147483647 | √ | null | Activity identifier | |
actvy_ref_parm_val_rpt_v | actvy_parm_id | uuid | 2147483647 | √ | null | Activity parameter identifier | |
actvy_ref_parm_val_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
actvy_ref_parm_val_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
actvy_ref_parm_val_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
actvy_ref_parm_val_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
actvy_ref_parm_val_rpt_v | parm_val | varchar | 1000 | √ | null | Activity parameter value | |
actvy_ref_parm_val_rpt_v | seq_num | int4 | 10 | √ | null | Sequence number | |
actvy_ref_rpt_v | actvy_id | uuid | 2147483647 | √ | null | Activity identifier | |
actvy_ref_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
actvy_ref_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
actvy_ref_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
actvy_ref_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
actvy_ref_rpt_v | refd_actvy_id | uuid | 2147483647 | √ | null | Referenced activity identifier | |
actvy_ref_rpt_v | seq_num | int4 | 10 | √ | null | Sequence number | |
actvy_rpt_v | access_lvl | varchar | 50 | √ | null | Access level | |
actvy_rpt_v | actvy_desc | varchar | 255 | √ | null | Activity description | |
actvy_rpt_v | actvy_id | uuid | 2147483647 | √ | null | Activity identifier | |
actvy_rpt_v | actvy_name | varchar | 255 | √ | null | Activity name | |
actvy_rpt_v | actvy_typ_cd | varchar | 1 | √ | null | Activity type code | |
actvy_rpt_v | app_name | varchar | 25 | √ | null | Application name | |
actvy_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
actvy_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
actvy_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
actvy_rpt_v | exec_loc | varchar | 50 | √ | null | Execution location | |
actvy_rpt_v | input_formatter | varchar | 255 | √ | null | Input formatter | |
actvy_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
actvy_rpt_v | output_formatter | varchar | 255 | √ | null | Output formatter | |
actvy_rpt_v | processor | varchar | 255 | √ | null | Processor | |
adv_nxs_feed | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_feed | date_created | timestamp | 29,6 | Date the entry was created | |||
adv_nxs_feed | date_modified | timestamp | 29,6 | Date the entry was modified | |||
adv_nxs_feed | file_name | varchar | 256 | The filename of the Advisor feed file. | |||
adv_nxs_feed | generation | timestamp | 29,6 | The unique ID to which each feed file belongs. | |||
adv_nxs_feed | hash_value | varchar | 256 | The hash value of the Advisor feed file. | |||
adv_nxs_feed | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_feed | processing_end_time | timestamp | 29,6 | √ | null | Time stamp indicating when the processing of the feed files ended. | |
adv_nxs_feed | processing_start_time | timestamp | 29,6 | Time stamp indicating when the processing of the feed files started. | |||
adv_nxs_feed | records_inserted | int4 | 10 | √ | null | The number of records inserted into the database. | |
adv_nxs_feed | records_updated | int4 | 10 | √ | null | The number of records updated into the database. | |
adv_nxs_feed_v | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_feed_v | date_created | timestamp | 29,6 | √ | null | Date the entry was created | |
adv_nxs_feed_v | date_modified | timestamp | 29,6 | √ | null | Date the entry was modified | |
adv_nxs_feed_v | file_name | varchar | 256 | √ | null | The filename of the Advisor feed file. | |
adv_nxs_feed_v | generation | timestamp | 29,6 | √ | null | The unique ID to which each feed file belongs. | |
adv_nxs_feed_v | hash_value | varchar | 256 | √ | null | The hash value of the Advisor feed file. | |
adv_nxs_feed_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_feed_v | processing_end_time | timestamp | 29,6 | √ | null | Time stamp indicating when the processing of the feed files ended. | |
adv_nxs_feed_v | processing_start_time | timestamp | 29,6 | √ | null | Time stamp indicating when the processing of the feed files started. | |
adv_nxs_feed_v | records_inserted | int4 | 10 | √ | null | The number of records inserted into the database. | |
adv_nxs_feed_v | records_updated | int4 | 10 | √ | null | The number of records updated into the database. | |
adv_nxs_kb_patch | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_kb_patch | date_created | timestamp | 29,6 | Date the entry was created | |||
adv_nxs_kb_patch | date_modified | timestamp | 29,6 | Date the entry was modified | |||
adv_nxs_kb_patch | id | int4 | 10 | The unique ID for the row. | |||
adv_nxs_kb_patch | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_kb_patch | osvdb_id | int4 | 10 | The ID of the vulnerability in the OSVDB. | |||
adv_nxs_kb_patch | ref_value | text | 2147483647 | √ | null | The URL that has the patch information. | |
adv_nxs_kb_patch | type_id | int4 | 10 | √ | null | The unique ID of the patch. | |
adv_nxs_kb_patch | type_name | varchar | 128 | √ | null | The type of the patch used to remove the vulnerability. | |
adv_nxs_kb_patch_v | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_kb_patch_v | date_created | timestamp | 29,6 | √ | null | Date the entry was created | |
adv_nxs_kb_patch_v | date_modified | timestamp | 29,6 | √ | null | Date the entry was modified | |
adv_nxs_kb_patch_v | id | int4 | 10 | √ | null | The unique ID for the row. | |
adv_nxs_kb_patch_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_kb_patch_v | osvdb_id | int4 | 10 | √ | null | The ID of the vulnerability in the OSVDB. | |
adv_nxs_kb_patch_v | ref_value | text | 2147483647 | √ | null | The URL that has the patch information. | |
adv_nxs_kb_patch_v | type_id | int4 | 10 | √ | null | The unique ID of the patch. | |
adv_nxs_kb_patch_v | type_name | varchar | 128 | √ | null | The type of the patch used to remove the vulnerability. | |
adv_nxs_kb_productsref | base_name | varchar | 128 | √ | null | Name of the product that is affected by the vulnerability. | |
adv_nxs_kb_productsref | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_kb_productsref | date_created | timestamp | 29,6 | Date the entry was created | |||
adv_nxs_kb_productsref | date_modified | timestamp | 29,6 | Date the entry was modified | |||
adv_nxs_kb_productsref | id | int4 | 10 | The unique ID for the row. | |||
adv_nxs_kb_productsref | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_kb_productsref | osvdb_id | int4 | 10 | The ID of the vulnerability in the OSVDB. | |||
adv_nxs_kb_productsref | type_name | varchar | 128 | √ | null | Indicates whether the product is affected by the vulnerability or not. | |
adv_nxs_kb_productsref | vendor_name | varchar | 128 | √ | null | Name of the vendor of the product that is affected by the vulnerability. | |
adv_nxs_kb_productsref | version_name | varchar | 128 | √ | null | Version of the product that is affected by the vulnerability. | |
adv_nxs_kb_productsref_v | base_name | varchar | 128 | √ | null | Name of the product that is affected by the vulnerability. | |
adv_nxs_kb_productsref_v | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_kb_productsref_v | date_created | timestamp | 29,6 | √ | null | Date the entry was created | |
adv_nxs_kb_productsref_v | date_modified | timestamp | 29,6 | √ | null | Date the entry was modified | |
adv_nxs_kb_productsref_v | id | int4 | 10 | √ | null | The unique ID for the row. | |
adv_nxs_kb_productsref_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_kb_productsref_v | osvdb_id | int4 | 10 | √ | null | The ID of the vulnerability in the OSVDB. | |
adv_nxs_kb_productsref_v | type_name | varchar | 128 | √ | null | Indicates whether the product is affected by the vulnerability or not. | |
adv_nxs_kb_productsref_v | vendor_name | varchar | 128 | √ | null | Name of the vendor of the product that is affected by the vulnerability. | |
adv_nxs_kb_productsref_v | version_name | varchar | 128 | √ | null | Version of the product that is affected by the vulnerability. | |
adv_nxs_mappings | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_mappings | date_created | timestamp | 29,6 | Date the entry was created | |||
adv_nxs_mappings | date_modified | timestamp | 29,6 | Date the entry was modified | |||
adv_nxs_mappings | deleted | timestamp | 29,6 | √ | null | Time stamp indicating when the mapping was marked as invalid. | |
adv_nxs_mappings | inserted | timestamp | 29,6 | Time stamp indicating when the mapping information was entered in the vendor database. | |||
adv_nxs_mappings | is_deleted | bool | 1 | TRUE indicates that the mapping is marked as invalid. | |||
adv_nxs_mappings | mapping_direct | bool | 1 | TRUE indicates that the mapping is direct. | |||
adv_nxs_mappings | mapping_indirect | bool | 1 | TRUE indicates that the mapping is indirect. | |||
adv_nxs_mappings | mapping_ngram | bool | 1 | TRUE indicates that the mapping is n-gram. | |||
adv_nxs_mappings | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_mappings | source_product_id | int4 | 10 | The unique ID of the source product. | |||
adv_nxs_mappings | source_signature_id | varchar | 256 | √ | null | The unique ID of the source signature. | |
adv_nxs_mappings | target_product_id | int4 | 10 | The unique ID of the target product. | |||
adv_nxs_mappings | target_signature_id | varchar | 256 | √ | null | The unique ID of the target signature. | |
adv_nxs_mappings | updated | timestamp | 29,6 | Time stamp indicating when the mapping was updated in the vendor database. | |||
adv_nxs_mappings_v | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_mappings_v | date_created | timestamp | 29,6 | √ | null | Date the entry was created | |
adv_nxs_mappings_v | date_modified | timestamp | 29,6 | √ | null | Date the entry was modified | |
adv_nxs_mappings_v | deleted | timestamp | 29,6 | √ | null | Time stamp indicating when the mapping was marked as invalid. | |
adv_nxs_mappings_v | inserted | timestamp | 29,6 | √ | null | Time stamp indicating when the mapping information was entered in the vendor database. | |
adv_nxs_mappings_v | is_deleted | bool | 1 | √ | null | TRUE indicates that the mapping is marked as invalid. | |
adv_nxs_mappings_v | mapping_direct | bool | 1 | √ | null | TRUE indicates that the mapping is direct. | |
adv_nxs_mappings_v | mapping_indirect | bool | 1 | √ | null | TRUE indicates that the mapping is indirect. | |
adv_nxs_mappings_v | mapping_ngram | bool | 1 | √ | null | TRUE indicates that the mapping is n-gram. | |
adv_nxs_mappings_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_mappings_v | source_product_id | int4 | 10 | √ | null | The unique ID of the source product. | |
adv_nxs_mappings_v | source_signature_id | varchar | 256 | √ | null | The unique ID of the source signature. | |
adv_nxs_mappings_v | target_product_id | int4 | 10 | √ | null | The unique ID of the target product. | |
adv_nxs_mappings_v | target_signature_id | varchar | 256 | √ | null | The unique ID of the target signature. | |
adv_nxs_mappings_v | updated | timestamp | 29,6 | √ | null | Time stamp indicating when the mapping was updated in the vendor database. | |
adv_nxs_osvdb_details | attack_scenario | text | 2147483647 | √ | null | Description of how a vulnerability can be exploited. | |
adv_nxs_osvdb_details | attack_type_auth_manage | bool | 1 | TRUE indicates that the attack type is authentication management. For example, brute force attack, default password, and cookie poisoning. | |||
adv_nxs_osvdb_details | attack_type_crypt | bool | 1 | TRUE indicates that the attack type is cryptographic. For example, weak encryption (implementation or algorithm), no encryption (plaintext), and sniffing. | |||
adv_nxs_osvdb_details | attack_type_dos | bool | 1 | TRUE indicates that the attack type is denial of service. For example, saturation flood, crash, lock up, and forced reboot. | |||
adv_nxs_osvdb_details | attack_type_hijack | bool | 1 | TRUE indicates that the attack type is hijack. For example, man-in-the-middle attacks, IP spoofing, session timeout or take-over, and session replay. | |||
adv_nxs_osvdb_details | attack_type_info_disclose | bool | 1 | TRUE indicates that the attack type is information disclosure. For example, comments, passwords, fingerprinting, and system information. | |||
adv_nxs_osvdb_details | attack_type_infrastruct | bool | 1 | TRUE indicates that the attack type is infrastructure. For example, DNS poisoning and route manipulation. | |||
adv_nxs_osvdb_details | attack_type_input_manip | bool | 1 | TRUE indicates that the attack type is input manipulation. For example, XSS, SQL injection, file retrieval, directory traversal, overflows, and URL encoding. | |||
adv_nxs_osvdb_details | attack_type_miss_config | bool | 1 | TRUE indicates that the attack type is misconfiguration. For example, default files, debugging enabled, and directory indexing. | |||
adv_nxs_osvdb_details | attack_type_other | bool | 1 | TRUE indicates that the attack type does not fall under any of the above attack types. | |||
adv_nxs_osvdb_details | attack_type_race | bool | 1 | TRUE indicates that the attack type is race condition. For example, symlink. | |||
adv_nxs_osvdb_details | attack_type_unknown | bool | 1 | TRUE indicates that the attack type is unknown. | |||
adv_nxs_osvdb_details | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_osvdb_details | date_created | timestamp | 29,6 | Date the entry was created | |||
adv_nxs_osvdb_details | date_modified | timestamp | 29,6 | Date the entry was modified | |||
adv_nxs_osvdb_details | description | text | 2147483647 | √ | null | A brief description of the vulnerability. | |
adv_nxs_osvdb_details | exploit_available | bool | 1 | TRUE indicates that the exploit is available for the vulnerability. | |||
adv_nxs_osvdb_details | exploit_rumored | bool | 1 | TRUE indicates that the exploit is rumored to exist for the vulnerability. | |||
adv_nxs_osvdb_details | exploit_unavailable | bool | 1 | TRUE indicates that the exploit is not available for the vulnerability. | |||
adv_nxs_osvdb_details | exploit_unknown | bool | 1 | TRUE indicates that the exploit is unknown for the vulnerability. | |||
adv_nxs_osvdb_details | full_description | text | 2147483647 | √ | null | The complete description of the vulnerability. | |
adv_nxs_osvdb_details | impact_available | bool | 1 | TRUE indicates that the impact of the attack is loss of availability of a service or information. | |||
adv_nxs_osvdb_details | impact_confidential | bool | 1 | TRUE indicates that the impact of the attack(s) is loss of confidential information. For example, passwords, server information, environment variables, confirmation of file existence, path disclosure, file content access, and SQL injection. | |||
adv_nxs_osvdb_details | impact_integrity | bool | 1 | TRUE indicates that the impact of the attack(s) is loss of integrity, which results in data modifications by unauthorized persons. For example, unauthorized file modification, deletion, or creation, remote file inclusion, and arbitrary command execution. | |||
adv_nxs_osvdb_details | impact_unknown | bool | 1 | TRUE indicates that the impact of the attack is unknown. | |||
adv_nxs_osvdb_details | inserted | timestamp | 29,6 | Time stamp indicating when the vulnerability was inserted in the vendor database. | |||
adv_nxs_osvdb_details | location_dialup | bool | 1 | TRUE indicates that the vulnerability can be exploited using a dial-up connection. | |||
adv_nxs_osvdb_details | location_local | bool | 1 | TRUE indicates that the vulnerability can be exploited on a local system. | |||
adv_nxs_osvdb_details | location_physical | bool | 1 | TRUE indicates that the vulnerability can be exploited with only physical system access<literal/>. | |||
adv_nxs_osvdb_details | location_remote | bool | 1 | TRUE indicates that the vulnerability can be exploited on a remote system. | |||
adv_nxs_osvdb_details | location_unknown | bool | 1 | TRUE indicates that the vulnerability is exploited in an unknown location. | |||
adv_nxs_osvdb_details | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_osvdb_details | osvdb_id | int4 | 10 | The unique ID of the vulnerability in the OSVDB. | |||
adv_nxs_osvdb_details | osvdb_title | varchar | 256 | √ | null | The normalized name of the vulnerability. | |
adv_nxs_osvdb_details | published | timestamp | 29,6 | Time stamp indicating when the vulnerability was published in the OSVDB. | |||
adv_nxs_osvdb_details | severity | int4 | 10 | √ | null | Indicates the severity of the vulnerability. The rating is 1- 10. The higher the number, the more urgent the vulnerability. | |
adv_nxs_osvdb_details | solution_description | text | 2147483647 | √ | null | Description of the solution that is used to fix the vulnerability. | |
adv_nxs_osvdb_details | updated | timestamp | 29,6 | Time stamp indicating when the vulnerability was updated in the vendor database. | |||
adv_nxs_osvdb_details | urgency | int4 | 10 | √ | null | Indicates the urgency of the vulnerability. The rating is 1- 10. The higher the number, the more urgent the vulnerability. | |
adv_nxs_osvdb_details | vuln_best_prac | bool | 1 | TRUE indicates that the vulnerability is a result of not following the best practices in the configuration or usage of the vulnerable system or software. | |||
adv_nxs_osvdb_details | vuln_concern | bool | 1 | TRUE indicates that the vulnerability requires additional concern for remediation. | |||
adv_nxs_osvdb_details | vuln_myth_fake | bool | 1 | TRUE indicates that the vulnerability is a myth or a false alarm. | |||
adv_nxs_osvdb_details | vuln_verified | bool | 1 | TRUE indicates that the existence of the vulnerability has been verified. | |||
adv_nxs_osvdb_details | vuln_web_check | bool | 1 | TRUE indicates that the vulnerability is a common problem in Web servers or Web applications. | |||
adv_nxs_osvdb_details_v | attack_scenario | text | 2147483647 | √ | null | Description of how a vulnerability can be exploited. | |
adv_nxs_osvdb_details_v | attack_type_auth_manage | bool | 1 | √ | null | TRUE indicates that the attack type is authentication management. For example, brute force attack, default password, and cookie poisoning. | |
adv_nxs_osvdb_details_v | attack_type_crypt | bool | 1 | √ | null | TRUE indicates that the attack type is cryptographic. For example, weak encryption (implementation or algorithm), no encryption (plaintext), and sniffing. | |
adv_nxs_osvdb_details_v | attack_type_dos | bool | 1 | √ | null | TRUE indicates that the attack type is denial of service. For example, saturation flood, crash, lock up, and forced reboot. | |
adv_nxs_osvdb_details_v | attack_type_hijack | bool | 1 | √ | null | TRUE indicates that the attack type is hijack. For example, man-in-the-middle attacks, IP spoofing, session timeout or take-over, and session replay. | |
adv_nxs_osvdb_details_v | attack_type_info_disclose | bool | 1 | √ | null | TRUE indicates that the attack type is information disclosure. For example, comments, passwords, fingerprinting, and system information. | |
adv_nxs_osvdb_details_v | attack_type_infrastruct | bool | 1 | √ | null | TRUE indicates that the attack type is infrastructure. For example, DNS poisoning and route manipulation. | |
adv_nxs_osvdb_details_v | attack_type_input_manip | bool | 1 | √ | null | TRUE indicates that the attack type is input manipulation. For example, XSS, SQL injection, file retrieval, directory traversal, overflows, and URL encoding. | |
adv_nxs_osvdb_details_v | attack_type_miss_config | bool | 1 | √ | null | TRUE indicates that the attack type is misconfiguration. For example, default files, debugging enabled, and directory indexing. | |
adv_nxs_osvdb_details_v | attack_type_other | bool | 1 | √ | null | TRUE indicates that the attack type does not fall under any of the above attack types. | |
adv_nxs_osvdb_details_v | attack_type_race | bool | 1 | √ | null | TRUE indicates that the attack type is race condition. For example, symlink. | |
adv_nxs_osvdb_details_v | attack_type_unknown | bool | 1 | √ | null | TRUE indicates that the attack type is unknown. | |
adv_nxs_osvdb_details_v | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_osvdb_details_v | date_created | timestamp | 29,6 | √ | null | Date the entry was created | |
adv_nxs_osvdb_details_v | date_modified | timestamp | 29,6 | √ | null | Date the entry was modified | |
adv_nxs_osvdb_details_v | description | text | 2147483647 | √ | null | A brief description of the vulnerability. | |
adv_nxs_osvdb_details_v | exploit_available | bool | 1 | √ | null | TRUE indicates that the exploit is available for the vulnerability. | |
adv_nxs_osvdb_details_v | exploit_rumored | bool | 1 | √ | null | TRUE indicates that the exploit is rumored to exist for the vulnerability. | |
adv_nxs_osvdb_details_v | exploit_unavailable | bool | 1 | √ | null | TRUE indicates that the exploit is not available for the vulnerability. | |
adv_nxs_osvdb_details_v | exploit_unknown | bool | 1 | √ | null | TRUE indicates that the exploit is unknown for the vulnerability. | |
adv_nxs_osvdb_details_v | full_description | text | 2147483647 | √ | null | The complete description of the vulnerability. | |
adv_nxs_osvdb_details_v | impact_available | bool | 1 | √ | null | TRUE indicates that the impact of the attack is loss of availability of a service or information. | |
adv_nxs_osvdb_details_v | impact_confidential | bool | 1 | √ | null | TRUE indicates that the impact of the attack(s) is loss of confidential information. For example, passwords, server information, environment variables, confirmation of file existence, path disclosure, file content access, and SQL injection. | |
adv_nxs_osvdb_details_v | impact_integrity | bool | 1 | √ | null | TRUE indicates that the impact of the attack(s) is loss of integrity, which results in data modifications by unauthorized persons. For example, unauthorized file modification, deletion, or creation, remote file inclusion, and arbitrary command execution. | |
adv_nxs_osvdb_details_v | impact_unknown | bool | 1 | √ | null | TRUE indicates that the impact of the attack is unknown. | |
adv_nxs_osvdb_details_v | inserted | timestamp | 29,6 | √ | null | Time stamp indicating when the vulnerability was inserted in the vendor database. | |
adv_nxs_osvdb_details_v | location_dialup | bool | 1 | √ | null | TRUE indicates that the vulnerability can be exploited using a dial-up connection. | |
adv_nxs_osvdb_details_v | location_local | bool | 1 | √ | null | TRUE indicates that the vulnerability can be exploited on a local system. | |
adv_nxs_osvdb_details_v | location_physical | bool | 1 | √ | null | TRUE indicates that the vulnerability can be exploited with only physical system access<literal/>. | |
adv_nxs_osvdb_details_v | location_remote | bool | 1 | √ | null | TRUE indicates that the vulnerability can be exploited on a remote system. | |
adv_nxs_osvdb_details_v | location_unknown | bool | 1 | √ | null | TRUE indicates that the vulnerability is exploited in an unknown location. | |
adv_nxs_osvdb_details_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_osvdb_details_v | osvdb_id | int4 | 10 | √ | null | The unique ID of the vulnerability in the OSVDB. | |
adv_nxs_osvdb_details_v | osvdb_title | varchar | 256 | √ | null | The normalized name of the vulnerability. | |
adv_nxs_osvdb_details_v | published | timestamp | 29,6 | √ | null | Time stamp indicating when the vulnerability was published in the OSVDB. | |
adv_nxs_osvdb_details_v | severity | int4 | 10 | √ | null | Indicates the severity of the vulnerability. The rating is 1- 10. The higher the number, the more urgent the vulnerability. | |
adv_nxs_osvdb_details_v | solution_description | text | 2147483647 | √ | null | Description of the solution that is used to fix the vulnerability. | |
adv_nxs_osvdb_details_v | updated | timestamp | 29,6 | √ | null | Time stamp indicating when the vulnerability was updated in the vendor database. | |
adv_nxs_osvdb_details_v | urgency | int4 | 10 | √ | null | Indicates the urgency of the vulnerability. The rating is 1- 10. The higher the number, the more urgent the vulnerability. | |
adv_nxs_osvdb_details_v | vuln_best_prac | bool | 1 | √ | null | TRUE indicates that the vulnerability is a result of not following the best practices in the configuration or usage of the vulnerable system or software. | |
adv_nxs_osvdb_details_v | vuln_concern | bool | 1 | √ | null | TRUE indicates that the vulnerability requires additional concern for remediation. | |
adv_nxs_osvdb_details_v | vuln_myth_fake | bool | 1 | √ | null | TRUE indicates that the vulnerability is a myth or a false alarm. | |
adv_nxs_osvdb_details_v | vuln_verified | bool | 1 | √ | null | TRUE indicates that the existence of the vulnerability has been verified. | |
adv_nxs_osvdb_details_v | vuln_web_check | bool | 1 | √ | null | TRUE indicates that the vulnerability is a common problem in Web servers or Web applications. | |
adv_nxs_products | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_products | date_created | timestamp | 29,6 | Date the entry was created | |||
adv_nxs_products | date_modified | timestamp | 29,6 | Date the entry was modified | |||
adv_nxs_products | internal_name | varchar | 256 | Short name of the product that is used in generating the exploitdetection.csv file. This name is used by Collectors for exploit detection. For example, if the product name is Cisco Secure IDS, the internal name is Secure. | |||
adv_nxs_products | is_active | bool | 1 | TRUE represents the product is selected for exploit detection in the Advisor window of Sentinel Control Center. FALSE represents attacks from this product are not populated in the exploitdetection.csv file. | |||
adv_nxs_products | is_attack | bool | 1 | TRUE indicates that the product is IDS. | |||
adv_nxs_products | is_kb | bool | 1 | TRUE indicates that the product is Knowledge Base. | |||
adv_nxs_products | is_populate_attack_code | bool | 1 | TRUE by default. If the value is FALSE, the attack code is not populated in the exploitDetection.csv file. | |||
adv_nxs_products | is_populate_attack_name | bool | 1 | TRUE by default. If the value is FALSE, the attack name is not populated in the exploitDetection.csv file. | |||
adv_nxs_products | is_vuln | bool | 1 | TRUE indicates that the product is Vulnerability Scanner. | |||
adv_nxs_products | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_products | product_id | int4 | 10 | The unique ID of the product. | |||
adv_nxs_products | product_name | varchar | 256 | Name of the product. For example, Cisco* Secure IDS, Enterasys* Dragon* Network Sensor, or McAfee* IntruShield*. | |||
adv_nxs_products_v | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_products_v | date_created | timestamp | 29,6 | √ | null | Date the entry was created | |
adv_nxs_products_v | date_modified | timestamp | 29,6 | √ | null | Date the entry was modified | |
adv_nxs_products_v | internal_name | varchar | 256 | √ | null | Short name of the product that is used in generating the exploitdetection.csv file. This name is used by Collectors for exploit detection. For example, if the product name is Cisco Secure IDS, the internal name is Secure. | |
adv_nxs_products_v | is_active | bool | 1 | √ | null | TRUE represents the product is selected for exploit detection in the Advisor window of Sentinel Control Center. FALSE represents attacks from this product are not populated in the exploitdetection.csv file. | |
adv_nxs_products_v | is_attack | bool | 1 | √ | null | TRUE indicates that the product is IDS. | |
adv_nxs_products_v | is_kb | bool | 1 | √ | null | TRUE indicates that the product is Knowledge Base. | |
adv_nxs_products_v | is_populate_attack_code | bool | 1 | √ | null | TRUE by default. If the value is FALSE, the attack code is not populated in the exploitDetection.csv file. | |
adv_nxs_products_v | is_populate_attack_name | bool | 1 | √ | null | TRUE by default. If the value is FALSE, the attack name is not populated in the exploitDetection.csv file. | |
adv_nxs_products_v | is_vuln | bool | 1 | √ | null | TRUE indicates that the product is Vulnerability Scanner. | |
adv_nxs_products_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_products_v | product_id | int4 | 10 | √ | null | The unique ID of the product. | |
adv_nxs_products_v | product_name | varchar | 256 | √ | null | Name of the product. For example, Cisco* Secure IDS, Enterasys* Dragon* Network Sensor, or McAfee* IntruShield*. | |
adv_nxs_signatures | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_signatures | date_created | timestamp | 29,6 | Date the entry was created | |||
adv_nxs_signatures | date_modified | timestamp | 29,6 | Date the entry was modified | |||
adv_nxs_signatures | inserted | timestamp | 29,6 | Time stamp indicating when the signature information was entered in the vendor database. | |||
adv_nxs_signatures | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_signatures | product_id | int4 | 10 | The unique ID of the product. | |||
adv_nxs_signatures | published | timestamp | 29,6 | Time stamp indicating when the signature was published for the product by the vendor. | |||
adv_nxs_signatures | signature_id | varchar | 256 | √ | null | The unique ID of the signature. | |
adv_nxs_signatures | signature_name | varchar | 256 | √ | null | Name of the signature. | |
adv_nxs_signatures | updated | timestamp | 29,6 | Time stamp indicating when the signature information was updated in the vendor database. | |||
adv_nxs_signatures_v | created_by | int4 | 10 | √ | null | User who created object | |
adv_nxs_signatures_v | date_created | timestamp | 29,6 | √ | null | Date the entry was created | |
adv_nxs_signatures_v | date_modified | timestamp | 29,6 | √ | null | Date the entry was modified | |
adv_nxs_signatures_v | inserted | timestamp | 29,6 | √ | null | Time stamp indicating when the signature information was entered in the vendor database. | |
adv_nxs_signatures_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
adv_nxs_signatures_v | product_id | int4 | 10 | √ | null | The unique ID of the product. | |
adv_nxs_signatures_v | published | timestamp | 29,6 | √ | null | Time stamp indicating when the signature was published for the product by the vendor. | |
adv_nxs_signatures_v | signature_id | varchar | 256 | √ | null | The unique ID of the signature. | |
adv_nxs_signatures_v | signature_name | varchar | 256 | √ | null | Name of the signature. | |
adv_nxs_signatures_v | updated | timestamp | 29,6 | √ | null | Time stamp indicating when the signature information was updated in the vendor database. | |
annotations | action | varchar | 255 | √ | null | Actions | |
annotations | ann_id | int4 | 10 | Identifier for the annotations | |||
annotations | created_by | int4 | 10 | √ | null | User who created object | |
annotations | date_created | timestamptz | 35,6 | Date the entry was created | |||
annotations | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
annotations | modified_by | int4 | 10 | √ | null | User who last modified object | |
annotations | text | varchar | 4000 | √ | null | XML data of annotations used | |
annotations_rpt_v | action | varchar | 255 | √ | null | Annotations actions | |
annotations_rpt_v | ann_id | int4 | 10 | √ | null | Identifier for the annotations | |
annotations_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
annotations_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
annotations_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
annotations_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
annotations_rpt_v | text | varchar | 4000 | √ | null | XML data of annotations used | |
asset | asset_ctgry_id | int8 | 19 | Asset category identifier | |||
asset | asset_id | uuid | 2147483647 | Asset identifier | |||
asset | asset_name | varchar | 255 | √ | null | Description of the asset | |
asset | asset_val_id | int8 | 19 | Asset value code | |||
asset | created_by | int4 | 10 | √ | null | User who created object | |
asset | crit_id | int8 | 19 | Asset criticality code | |||
asset | cust_id | int8 | 19 | Customer identifier | |||
asset | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset | env_identity_id | int8 | 19 | Environment identify code | |||
asset | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset | physical_asset_id | uuid | 2147483647 | Physical asset identifier | |||
asset | physical_asset_ind | bool | 1 | √ | null | Physical asset indicator | |
asset | prdt_id | int8 | 19 | Product identifier | |||
asset | sensitivity_id | int8 | 19 | Asset sensitivity code | |||
asset_category_rpt_v | asset_category_id | int8 | 19 | √ | null | ID of the Asset Category | |
asset_category_rpt_v | asset_category_name | varchar | 100 | √ | null | Name of the Asset Category such as | |
asset_category_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
asset_category_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset_category_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset_category_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset_ctgry | asset_ctgry_id | int8 | 19 | ID of the Asset Category | |||
asset_ctgry | asset_ctgry_name | varchar | 100 | Name of the Asset Category such as | |||
asset_ctgry | created_by | int4 | 10 | √ | null | User who created object | |
asset_ctgry | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset_ctgry | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset_ctgry | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset_hostname | asset_hostname_id | uuid | 2147483647 | Asset alternate hostname identifier | |||
asset_hostname | created_by | int4 | 10 | √ | null | User who created object | |
asset_hostname | cust_id | int8 | 19 | √ | null | Customer identifier | |
asset_hostname | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset_hostname | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset_hostname | host_name | varchar | 255 | √ | null | Host name | |
asset_hostname | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset_hostname | physical_asset_id | uuid | 2147483647 | Physical asset identifier | |||
asset_hostname_rpt_v | asset_hostname_id | uuid | 2147483647 | √ | null | Asset alternate hostname identifier | |
asset_hostname_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
asset_hostname_rpt_v | cust_id | int8 | 19 | √ | null | Customer identifier | |
asset_hostname_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset_hostname_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset_hostname_rpt_v | host_name | varchar | 255 | √ | null | Host name | |
asset_hostname_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset_hostname_rpt_v | physical_asset_id | uuid | 2147483647 | √ | null | Physical asset identifier | |
asset_ip | asset_ip_id | uuid | 2147483647 | Asset alternate IP identifier | |||
asset_ip | created_by | int4 | 10 | √ | null | User who created object | |
asset_ip | cust_id | int8 | 19 | √ | null | Customer identifier | |
asset_ip | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset_ip | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset_ip | ip_addr | int4 | 10 | √ | null | Asset IP address | |
asset_ip | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset_ip | physical_asset_id | uuid | 2147483647 | Physical asset identifier | |||
asset_ip_rpt_v | asset_ip_id | uuid | 2147483647 | √ | null | Asset alternate IP identifier | |
asset_ip_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
asset_ip_rpt_v | cust_id | int8 | 19 | √ | null | Customer identifier | |
asset_ip_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset_ip_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset_ip_rpt_v | ip_address | int4 | 10 | √ | null | Asset IP address | |
asset_ip_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset_ip_rpt_v | physical_asset_id | uuid | 2147483647 | √ | null | Physical asset identifier | |
asset_loc | addr_line_1 | varchar | 255 | √ | null | The location at which this asset is located; internal codes or full address | |
asset_loc | addr_line_2 | varchar | 255 | √ | null | The latitude/longitude coordinates of the asset | |
asset_loc | building_name | varchar | 255 | √ | null | Name of the building where asset is present | |
asset_loc | city | varchar | 100 | √ | null | City name of the asset situated | |
asset_loc | cntry | varchar | 100 | √ | null | Country name in which asset is present | |
asset_loc | created_by | int4 | 10 | √ | null | User who created object | |
asset_loc | cust_id | int8 | 19 | √ | null | Reference to customer id | |
asset_loc | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset_loc | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset_loc | loc_id | int8 | 19 | Unique identifier for asset location | |||
asset_loc | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset_loc | state | varchar | 100 | √ | null | State of the city where asset is located | |
asset_loc | zip_cd | varchar | 50 | √ | null | Zip code of the country | |
asset_location_rpt_v | address_line_1 | varchar | 255 | √ | null | Address of the asset location | |
asset_location_rpt_v | address_line_2 | varchar | 255 | √ | null | Address of the asset location | |
asset_location_rpt_v | building_name | varchar | 255 | √ | null | Name of the building where asset is present | |
asset_location_rpt_v | city | varchar | 100 | √ | null | City name of the asset situated | |
asset_location_rpt_v | country | varchar | 100 | √ | null | Country name in which asset is present | |
asset_location_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
asset_location_rpt_v | cust_id | int8 | 19 | √ | null | Reference to customer id | |
asset_location_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset_location_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset_location_rpt_v | location_id | int8 | 19 | √ | null | Unique identifier for asset location | |
asset_location_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset_location_rpt_v | state | varchar | 100 | √ | null | State of the city where asset is located | |
asset_location_rpt_v | zip_code | varchar | 50 | √ | null | Zip code of the country | |
asset_rpt_v | asset_category_id | int8 | 19 | √ | null | Asset category identifier | |
asset_rpt_v | asset_id | uuid | 2147483647 | √ | null | Asset identifier | |
asset_rpt_v | asset_name | varchar | 255 | √ | null | Asset name | |
asset_rpt_v | asset_value_code | int8 | 19 | √ | null | Asset value code | |
asset_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
asset_rpt_v | criticality_id | int8 | 19 | √ | null | Asset criticality code | |
asset_rpt_v | cust_id | int8 | 19 | √ | null | Customer identifier | |
asset_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset_rpt_v | environment_identity_cd | int8 | 19 | √ | null | Environment identify code | |
asset_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset_rpt_v | physical_asset_id | uuid | 2147483647 | √ | null | Physical asset identifier | |
asset_rpt_v | physical_asset_ind | bool | 1 | √ | null | Physical asset indicator | |
asset_rpt_v | product_id | int8 | 19 | √ | null | Product identifier | |
asset_rpt_v | sensitivity_id | int8 | 19 | √ | null | Asset sensitivity code | |
asset_val_lkup | asset_val_id | int8 | 19 | Unique identifier for asset value | |||
asset_val_lkup | asset_val_name | varchar | 50 | Name of asset value | |||
asset_val_lkup | created_by | int4 | 10 | √ | null | User who created object | |
asset_val_lkup | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset_val_lkup | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset_val_lkup | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset_value_rpt_v | asset_value_id | int8 | 19 | √ | null | Unique identifier for asset value | |
asset_value_rpt_v | asset_value_name | varchar | 50 | √ | null | Name of asset value | |
asset_value_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
asset_value_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset_value_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset_value_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset_x_entity_x_role | asset_id | uuid | 2147483647 | Reference to asset id | |||
asset_x_entity_x_role | created_by | int4 | 10 | √ | null | User who created object | |
asset_x_entity_x_role | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset_x_entity_x_role | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset_x_entity_x_role | entity_typ_cd | varchar | 5 | Entity type code | |||
asset_x_entity_x_role | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset_x_entity_x_role | organization_id | uuid | 2147483647 | Reference to the organization id | |||
asset_x_entity_x_role | person_id | uuid | 2147483647 | Reference to the person id | |||
asset_x_entity_x_role | person_role_seq | int4 | 10 | √ | null | Sequence of the person role | |
asset_x_entity_x_role | role_cd | varchar | 5 | Role code | |||
asset_x_entity_x_role_rpt_v | asset_id | uuid | 2147483647 | √ | null | Reference to asset id | |
asset_x_entity_x_role_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
asset_x_entity_x_role_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
asset_x_entity_x_role_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
asset_x_entity_x_role_rpt_v | entity_type_code | varchar | 5 | √ | null | Entity type code | |
asset_x_entity_x_role_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
asset_x_entity_x_role_rpt_v | organization_id | uuid | 2147483647 | √ | null | Reference to the organization id | |
asset_x_entity_x_role_rpt_v | person_id | uuid | 2147483647 | √ | null | Reference to the person id | |
asset_x_entity_x_role_rpt_v | person_role_sequence | int4 | 10 | √ | null | Sequence of the person role | |
asset_x_entity_x_role_rpt_v | role_code | varchar | 5 | √ | null | Role code | |
associations | created_by | int4 | 10 | √ | null | User who created object | |
associations | date_created | timestamptz | 35,6 | Date the entry was created | |||
associations | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
associations | id1 | int4 | 10 | ID1. For example, incident ID. | |||
associations | id2 | int4 | 10 | ID2. For example, user ID. | |||
associations | modified_by | int4 | 10 | √ | null | User who last modified object | |
associations | table1 | varchar | 64 | Table name 1. For example, incidents | |||
associations | table2 | varchar | 64 | Table name 2. For example, users. | |||
associations_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
associations_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
associations_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
associations_rpt_v | id1 | int4 | 10 | √ | null | ID1. For example, incident ID. | |
associations_rpt_v | id2 | int4 | 10 | √ | null | ID2. For example, user ID. | |
associations_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
associations_rpt_v | table1 | varchar | 64 | √ | null | Table name 1. For example, incidents | |
associations_rpt_v | table2 | varchar | 64 | √ | null | Table name 2. For example, users. | |
attachments | attachment_desc | varchar | 255 | √ | null | Attachment description | |
attachments | attachment_id | int4 | 10 | Attachment identifier | |||
attachments | created_by | int4 | 10 | √ | null | User who created object | |
attachments | data | text | 2147483647 | √ | null | Attachment data | |
attachments | date_created | timestamptz | 35,6 | Date the entry was created | |||
attachments | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
attachments | file_ext | varchar | 32 | √ | null | File extension | |
attachments | modified_by | int4 | 10 | √ | null | User who last modified object | |
attachments | name | varchar | 255 | √ | null | Attachment name | |
attachments | src_ref | varchar | 64 | √ | null | Source reference | |
attachments | sub_typ | varchar | 32 | √ | null | Attachment subtype | |
attachments | typ | varchar | 32 | √ | null | Attachment type | |
attachments_rpt_v | attachment_description | varchar | 255 | √ | null | Attachment description | |
attachments_rpt_v | attachment_id | int4 | 10 | √ | null | Attachment identifier | |
attachments_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
attachments_rpt_v | data | text | 2147483647 | √ | null | Attachment data | |
attachments_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
attachments_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
attachments_rpt_v | file_extension | varchar | 32 | √ | null | File extension | |
attachments_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
attachments_rpt_v | name | varchar | 255 | √ | null | Attachment name | |
attachments_rpt_v | source_reference | varchar | 64 | √ | null | Source reference | |
attachments_rpt_v | sub_type | varchar | 32 | √ | null | Attachment subtype | |
attachments_rpt_v | type | varchar | 32 | √ | null | Attachment type | |
configs | application | varchar | 255 | Application identifier | |||
configs | created_by | int4 | 10 | √ | null | User who created object | |
configs | data | text | 2147483647 | √ | null | XML data | |
configs | date_created | timestamptz | 35,6 | Date the entry was created | |||
configs | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
configs | modified_by | int4 | 10 | √ | null | User who last modified object | |
configs | unit | varchar | 64 | Application unit | |||
configs | usr_id | varchar | 32 | User name. | |||
configs | value | varchar | 255 | √ | null | Text value if any | |
configs_rpt_v | application | varchar | 255 | √ | null | Application identifier | |
configs_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
configs_rpt_v | data | text | 2147483647 | √ | null | XML data | |
configs_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
configs_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
configs_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
configs_rpt_v | unit | varchar | 64 | √ | null | Application unit | |
configs_rpt_v | usr_id | varchar | 32 | √ | null | User name. | |
configs_rpt_v | value | varchar | 255 | √ | null | Text value if any | |
console_slms | certificate | varchar | 8192 | Certificate details | |||
console_slms | console_metadata | varchar | 8192 | Metadata of console | |||
console_slms | created_by | int4 | 10 | √ | null | User who created object | |
console_slms | date_created | timestamptz | 35,6 | Date the entry was created | |||
console_slms | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
console_slms | display_name | varchar | 255 | Display name on console | |||
console_slms | is_enabled | bool | 1 | √ | null | True indicates Active | |
console_slms | modified_by | int4 | 10 | √ | null | User who last modified object | |
console_slms | network_address | varchar | 255 | Network address | |||
console_slms | port | int4 | 10 | √ | null | Port Number | |
console_slms | slm_id | uuid | 2147483647 | Unique identifier of SLM on console | |||
console_slms | user_group_id | uuid | 2147483647 | √ | null | Id of the user group | |
contacts_rpt_v | cell | varchar | 64 | √ | null | Mobile number of the user contact | |
contacts_rpt_v | cnt_id | int4 | 10 | √ | null | Id of the user 1-Admin | |
contacts_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
contacts_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
contacts_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
contacts_rpt_v | department | varchar | 128 | √ | null | Department that user belongs to | |
contacts_rpt_v | varchar | 255 | √ | null | Emailid of the user | ||
contacts_rpt_v | first_name | varchar | 64 | √ | null | Entered user name | |
contacts_rpt_v | last_name | varchar | 64 | √ | null | Surname of the user | |
contacts_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
contacts_rpt_v | pager | varchar | 64 | √ | null | Any extra information of the user | |
contacts_rpt_v | phone | varchar | 64 | √ | null | Contact number of the user | |
contacts_rpt_v | title | varchar | 128 | √ | null | Title of the user | |
corr_act_def | corr_act_def_id | uuid | 2147483647 | Correlation actions identifier | |||
corr_act_def | corr_act_def_name | varchar | 255 | Name of the correlation action | |||
corr_act_def | corr_act_meta_id | uuid | 2147483647 | Correlation actionsmeta data identifier | |||
corr_act_def | created_by | int4 | 10 | √ | null | User who created object | |
corr_act_def | date_created | timestamptz | 35,6 | Date the entry was created | |||
corr_act_def | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
corr_act_def | modified_by | int4 | 10 | √ | null | User who last modified object | |
corr_act_meta | corr_act_meta_class_name | varchar | 255 | Class name of correlation action meta data | |||
corr_act_meta | corr_act_meta_id | uuid | 2147483647 | Id of correlation action meta data | |||
corr_act_meta | corr_act_meta_name | varchar | 255 | Name of correlation action meta data | |||
corr_act_meta | created_by | int4 | 10 | √ | null | User who created object | |
corr_act_meta | date_created | timestamptz | 35,6 | Date the entry was created | |||
corr_act_meta | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
corr_act_meta | modified_by | int4 | 10 | √ | null | User who last modified object | |
corr_act_parm | corr_act_def_id | uuid | 2147483647 | Correlation action identifier | |||
corr_act_parm | corr_act_parm_def_id | uuid | 2147483647 | Correlation action parameter definition identifier | |||
corr_act_parm | corr_act_parm_id | uuid | 2147483647 | Correlation action parameter identifier | |||
corr_act_parm | corr_act_parm_value | varchar | 4000 | Correlation action parameter value | |||
corr_act_parm | corr_act_plugin_parms | text | 2147483647 | √ | null | Plugin parameters of correlation action | |
corr_act_parm | created_by | int4 | 10 | √ | null | User who created object | |
corr_act_parm | date_created | timestamptz | 35,6 | Date the entry was created | |||
corr_act_parm | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
corr_act_parm | modified_by | int4 | 10 | √ | null | User who last modified object | |
corr_act_parm_def | corr_act_handler | varchar | 255 | √ | null | Correlation action handler | |
corr_act_parm_def | corr_act_meta_id | uuid | 2147483647 | Correlation action meta data identifer | |||
corr_act_parm_def | corr_act_parm_def_id | uuid | 2147483647 | Correlation action parameter definition identifier | |||
corr_act_parm_def | corr_act_parm_name | varchar | 255 | Correlation action parameter name | |||
corr_act_parm_def | created_by | int4 | 10 | √ | null | User who created object | |
corr_act_parm_def | date_created | timestamptz | 35,6 | Date the entry was created | |||
corr_act_parm_def | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
corr_act_parm_def | modified_by | int4 | 10 | √ | null | User who last modified object | |
corr_deploy_config | corr_deploy_config_id | uuid | 2147483647 | Correlation deploy configuration identifier | |||
corr_deploy_config | corr_deploy_config_name | varchar | 255 | √ | null | Correlation deploy configuration name | |
corr_deploy_config | corr_engine_config_id | uuid | 2147483647 | Correlation Engine configuration identifier | |||
corr_deploy_config | created_by | int4 | 10 | √ | null | User who created object | |
corr_deploy_config | date_created | timestamptz | 35,6 | Date the entry was created | |||
corr_deploy_config | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
corr_deploy_config | deploy_state | bool | 1 | TRUE indicates that it is deployed | |||
corr_deploy_config | modified_by | int4 | 10 | √ | null | User who last modified object | |
corr_engine_config | corr_engine_config_hostip | varchar | 255 | Correlation Engine Host IP address | |||
corr_engine_config | corr_engine_config_hostname | varchar | 255 | Correlation Engine Host name | |||
corr_engine_config | corr_engine_config_id | uuid | 2147483647 | Correlation Engine configuration identifier | |||
corr_engine_config | corr_engine_config_name | varchar | 255 | √ | null | Correlation Engine configuration name | |
corr_engine_config | created_by | int4 | 10 | √ | null | User who created object | |
corr_engine_config | date_created | timestamptz | 35,6 | Date the entry was created | |||
corr_engine_config | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
corr_engine_config | engine_state | bool | 1 | Correlation Engine status | |||
corr_engine_config | modified_by | int4 | 10 | √ | null | User who last modified object | |
corr_rule | child_rules | text | 2147483647 | √ | null | Correlations child rule | |
corr_rule | created_by | int4 | 10 | √ | null | User who created object | |
corr_rule | date_created | timestamptz | 35,6 | Date the entry was created | |||
corr_rule | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
corr_rule | modified_by | int4 | 10 | √ | null | User who last modified object | |
corr_rule | rule_data | text | 2147483647 | √ | null | Correlation Rule data | |
corr_rule | rule_desc | text | 2147483647 | √ | null | Correlation Rule description | |
corr_rule | rule_id | uuid | 2147483647 | Unique Identifier of Correlation rule | |||
corr_rule | rule_lg | text | 2147483647 | √ | null | Correlation Rule language | |
corr_rule | rule_name | varchar | 255 | Name of the correlation rule | |||
corr_rule | rule_type | varchar | 255 | Correlation Rule type | |||
corr_rule | trigger_data | text | 2147483647 | √ | null | Trigger data | |
corr_rule_cfg | corr_deploy_config_id | uuid | 2147483647 | Correlation Deployment Configuration identifier | |||
corr_rule_cfg | corr_engine_config_id | uuid | 2147483647 | Correlation Engine configuration identifier | |||
corr_rule_cfg | corr_rule_config_id | uuid | 2147483647 | Correlation Rule Configuration identifier | |||
corr_rule_cfg | corr_rule_config_name | varchar | 255 | √ | null | Correlation Rule Configuration name | |
corr_rule_cfg | corr_rule_def_id | uuid | 2147483647 | Correlation Rule Definition Identifier | |||
corr_rule_cfg | created_by | int4 | 10 | √ | null | User who created object | |
corr_rule_cfg | date_created | timestamptz | 35,6 | Date the entry was created | |||
corr_rule_cfg | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
corr_rule_cfg | deploy_state | bool | 1 | TRUE indicates that it is deployed | |||
corr_rule_cfg | modified_by | int4 | 10 | √ | null | User who last modified object | |
correlated_events | child_evt_id | uuid | 2147483647 | Id of the child event | |||
correlated_events | child_evt_time | timestamptz | 35,6 | Time of the child event | |||
correlated_events | created_by | int4 | 10 | √ | null | User who created object | |
correlated_events | date_created | timestamptz | 35,6 | Date the entry was created | |||
correlated_events | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
correlated_events | modified_by | int4 | 10 | √ | null | User who last modified object | |
correlated_events | parent_evt_id | uuid | 2147483647 | Reference to the parent event id | |||
correlated_events | parent_evt_time | timestamptz | 35,6 | Time of the parent event | |||
correlated_events | parent_part_id | int8 | 19 | Partition id of parent event | |||
correlated_events_rpt_v | child_evt_id | uuid | 2147483647 | √ | null | Id of the child event | |
correlated_events_rpt_v | child_evt_time | timestamptz | 35,6 | √ | null | Time of the child event | |
correlated_events_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
correlated_events_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
correlated_events_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
correlated_events_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
correlated_events_rpt_v | parent_evt_id | uuid | 2147483647 | √ | null | Reference to the parent event id | |
correlated_events_rpt_v | parent_evt_time | timestamptz | 35,6 | √ | null | Time of the parent event | |
correlated_events_rpt_v | parent_part_id | int8 | 19 | √ | null | Partition id of parent event | |
crit_lkup | created_by | int4 | 10 | √ | null | User who created object | |
crit_lkup | crit_id | int8 | 19 | Asset criticality code | |||
crit_lkup | crit_name | varchar | 50 | Asset criticality name | |||
crit_lkup | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
crit_lkup | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
crit_lkup | modified_by | int4 | 10 | √ | null | User who last modified object | |
criticality_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
criticality_rpt_v | criticality_id | int8 | 19 | √ | null | Asset criticality code | |
criticality_rpt_v | criticality_name | varchar | 50 | √ | null | Asset criticality name | |
criticality_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
criticality_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
criticality_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
cust | created_by | int4 | 10 | √ | null | User who created object | |
cust | cust_id | int8 | 19 | Customer identifier | |||
cust | cust_name | varchar | 255 | √ | null | Customer name | |
cust | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
cust | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
cust | modified_by | int4 | 10 | √ | null | User who last modified object | |
cust_hierarchy | created_by | int4 | 10 | √ | null | User who created object | |
cust_hierarchy | cust_hierarchy_id | int8 | 19 | Customer hierarchy ID | |||
cust_hierarchy | cust_hierarchy_lvl1 | varchar | 255 | √ | null | Customer hierarchy level 1 | |
cust_hierarchy | cust_hierarchy_lvl2 | varchar | 255 | √ | null | Customer hierarchy level 2 | |
cust_hierarchy | cust_hierarchy_lvl3 | varchar | 255 | √ | null | Customer hierarchy level 3 | |
cust_hierarchy | cust_hierarchy_lvl4 | varchar | 255 | √ | null | Customer hierarchy level 4 | |
cust_hierarchy | cust_name | varchar | 255 | Customer Name | |||
cust_hierarchy | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
cust_hierarchy | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
cust_hierarchy | modified_by | int4 | 10 | √ | null | User who last modified object | |
cust_hierarchy_v | created_by | int4 | 10 | √ | null | User who created object | |
cust_hierarchy_v | cust_hierarchy_id | int8 | 19 | √ | null | Customer hierarchy ID | |
cust_hierarchy_v | cust_hierarchy_lvl1 | varchar | 255 | √ | null | Customer hierarchy level 1 | |
cust_hierarchy_v | cust_hierarchy_lvl2 | varchar | 255 | √ | null | Customer hierarchy level 2 | |
cust_hierarchy_v | cust_hierarchy_lvl3 | varchar | 255 | √ | null | Customer hierarchy level 3 | |
cust_hierarchy_v | cust_hierarchy_lvl4 | varchar | 255 | √ | null | Customer hierarchy level 4 | |
cust_hierarchy_v | cust_name | varchar | 255 | √ | null | Customer Name | |
cust_hierarchy_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
cust_hierarchy_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
cust_hierarchy_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
cust_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
cust_rpt_v | cust_id | int8 | 19 | √ | null | Customer identifier | |
cust_rpt_v | customer_name | varchar | 255 | √ | null | Customer name | |
cust_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
cust_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
cust_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
disk_monitor | computed_time | timestamptz | 35,6 | Timestamp of the disk space computation | |||
disk_monitor | disk_size_allocated | numeric | 131089 | Disk size allocated | |||
disk_monitor | disk_size_used | numeric | 131089 | Disk size used | |||
disk_monitor | storage_type | varchar | 50 | Storage Type | |||
dist_search_config | created_by | int4 | 10 | √ | null | User who created object | |
dist_search_config | date_created | timestamptz | 35,6 | Date the entry was created | |||
dist_search_config | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
dist_search_config | dist_report_password | varchar | 255 | Distributive Report password | |||
dist_search_config | dist_search_password | varchar | 255 | √ | null | Distributive Search password | |
dist_search_config | is_console_enabled | bool | 1 | √ | null | Is console enabled for search? | |
dist_search_config | is_target_enabled | bool | 1 | √ | null | Is target enabled for search? | |
dist_search_config | modified_by | int4 | 10 | √ | null | User who last modified object | |
dist_search_config | slm_id | uuid | 2147483647 | Sentinel Log Manager Id | |||
entity_typ_lkup | created_by | int4 | 10 | √ | null | User who created object | |
entity_typ_lkup | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
entity_typ_lkup | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
entity_typ_lkup | entity_typ_cd | varchar | 5 | Entity type code | |||
entity_typ_lkup | entity_typ_name | varchar | 50 | Entity type name | |||
entity_typ_lkup | modified_by | int4 | 10 | √ | null | User who last modified object | |
entity_type_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
entity_type_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
entity_type_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
entity_type_rpt_v | entity_type_code | varchar | 5 | √ | null | Entity type code | |
entity_type_rpt_v | entity_type_name | varchar | 50 | √ | null | Entity type name | |
entity_type_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
env_identity_lkup | created_by | int4 | 10 | √ | null | User who created object | |
env_identity_lkup | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
env_identity_lkup | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
env_identity_lkup | env_identity_id | int8 | 19 | Environment identity code | |||
env_identity_lkup | env_identity_name | varchar | 255 | Environment identity name | |||
env_identity_lkup | modified_by | int4 | 10 | √ | null | User who last modified object | |
env_identity_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
env_identity_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
env_identity_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
env_identity_rpt_v | env_identity_name | varchar | 255 | √ | null | Environment identity name | |
env_identity_rpt_v | environment_identity_id | int8 | 19 | √ | null | Environment identity code | |
env_identity_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_content | content_context | text | 2147483647 | √ | null | Content context | |
esec_content | content_desc | text | 2147483647 | √ | null | Content description | |
esec_content | content_hash | varchar | 255 | √ | null | Content hash | |
esec_content | content_id | varchar | 255 | Content identifier | |||
esec_content | content_name | varchar | 255 | Content name | |||
esec_content | content_state | int4 | 10 | Content state | |||
esec_content | content_typ | varchar | 100 | Content type | |||
esec_content | created_by | int4 | 10 | √ | null | User who created object | |
esec_content | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_content | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_content | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_content_grp | content_external_id | varchar | 255 | √ | null | Content external identifier | |
esec_content_grp | content_grp_desc | text | 2147483647 | √ | null | Content group description | |
esec_content_grp | content_grp_id | uuid | 2147483647 | Content group identifier | |||
esec_content_grp | content_grp_name | varchar | 255 | Content group name | |||
esec_content_grp | created_by | int4 | 10 | √ | null | User who created object | |
esec_content_grp | ctrl_id | uuid | 2147483647 | Control identifier | |||
esec_content_grp | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_content_grp | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_content_grp | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_content_grp_content | content_grp_id | uuid | 2147483647 | Content group identifier | |||
esec_content_grp_content | content_hash | varchar | 255 | √ | null | Content hash | |
esec_content_grp_content | content_id | varchar | 255 | Content identifier | |||
esec_content_grp_content | content_typ | varchar | 100 | Content type | |||
esec_content_grp_content | created_by | int4 | 10 | √ | null | User who created object | |
esec_content_grp_content | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_content_grp_content | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_content_grp_content | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_content_grp_content_rpt_v | content_grp_id | uuid | 2147483647 | √ | null | Content group identifier | |
esec_content_grp_content_rpt_v | content_hash | varchar | 255 | √ | null | Content hash | |
esec_content_grp_content_rpt_v | content_id | varchar | 255 | √ | null | Content identifier | |
esec_content_grp_content_rpt_v | content_typ | varchar | 100 | √ | null | Content type | |
esec_content_grp_content_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
esec_content_grp_content_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_content_grp_content_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_content_grp_content_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_content_grp_rpt_v | content_external_id | varchar | 255 | √ | null | Content external identifier | |
esec_content_grp_rpt_v | content_grp_desc | text | 2147483647 | √ | null | Content group description | |
esec_content_grp_rpt_v | content_grp_id | uuid | 2147483647 | √ | null | Content group identifier | |
esec_content_grp_rpt_v | content_grp_name | varchar | 255 | √ | null | Content group name | |
esec_content_grp_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
esec_content_grp_rpt_v | ctrl_id | uuid | 2147483647 | √ | null | Control identifier | |
esec_content_grp_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_content_grp_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_content_grp_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_content_pack | content_external_id | varchar | 255 | √ | null | Content external identifier | |
esec_content_pack | content_pack_desc | text | 2147483647 | √ | null | Content pack description | |
esec_content_pack | content_pack_id | uuid | 2147483647 | Content pack identifier | |||
esec_content_pack | content_pack_name | varchar | 255 | Content pack name | |||
esec_content_pack | created_by | int4 | 10 | √ | null | User who created object | |
esec_content_pack | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_content_pack | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_content_pack | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_content_pack_rpt_v | content_external_id | varchar | 255 | √ | null | Content external identifier | |
esec_content_pack_rpt_v | content_pack_desc | text | 2147483647 | √ | null | Content pack description | |
esec_content_pack_rpt_v | content_pack_id | uuid | 2147483647 | √ | null | Content pack identifier | |
esec_content_pack_rpt_v | content_pack_name | varchar | 255 | √ | null | Content pack name | |
esec_content_pack_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
esec_content_pack_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_content_pack_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_content_pack_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_content_rpt_v | content_context | text | 2147483647 | √ | null | Content context | |
esec_content_rpt_v | content_desc | text | 2147483647 | √ | null | Content description | |
esec_content_rpt_v | content_hash | varchar | 255 | √ | null | Content hash | |
esec_content_rpt_v | content_id | varchar | 255 | √ | null | Content identifier | |
esec_content_rpt_v | content_name | varchar | 255 | √ | null | Content name | |
esec_content_rpt_v | content_state | int4 | 10 | √ | null | Content state | |
esec_content_rpt_v | content_typ | varchar | 100 | √ | null | Content type | |
esec_content_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
esec_content_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_content_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_content_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_ctrl | content_external_id | varchar | 255 | √ | null | Content external identifier | |
esec_ctrl | created_by | int4 | 10 | √ | null | User who created object | |
esec_ctrl | ctrl_ctgry_id | uuid | 2147483647 | √ | null | Control category identifier | |
esec_ctrl | ctrl_desc | text | 2147483647 | √ | null | Control description | |
esec_ctrl | ctrl_id | uuid | 2147483647 | Control identifier | |||
esec_ctrl | ctrl_name | varchar | 255 | Control name | |||
esec_ctrl | ctrl_notes | text | 2147483647 | √ | null | Control notes | |
esec_ctrl | ctrl_state | int4 | 10 | Control state | |||
esec_ctrl | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_ctrl | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_ctrl | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_ctrl_ctgry | content_external_id | varchar | 255 | √ | null | Content external identifier | |
esec_ctrl_ctgry | content_pack_id | uuid | 2147483647 | Content pack identifier | |||
esec_ctrl_ctgry | created_by | int4 | 10 | √ | null | User who created object | |
esec_ctrl_ctgry | ctrl_ctgry_desc | text | 2147483647 | √ | null | Control category description | |
esec_ctrl_ctgry | ctrl_ctgry_id | uuid | 2147483647 | Control category identifier | |||
esec_ctrl_ctgry | ctrl_ctgry_name | varchar | 255 | Control category name | |||
esec_ctrl_ctgry | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_ctrl_ctgry | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_ctrl_ctgry | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_ctrl_ctgry_rpt_v | content_external_id | varchar | 255 | √ | null | Content external identifier | |
esec_ctrl_ctgry_rpt_v | content_pack_id | uuid | 2147483647 | √ | null | Content pack identifier | |
esec_ctrl_ctgry_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
esec_ctrl_ctgry_rpt_v | ctrl_ctgry_desc | text | 2147483647 | √ | null | Control category description | |
esec_ctrl_ctgry_rpt_v | ctrl_ctgry_id | uuid | 2147483647 | √ | null | Control category identifier | |
esec_ctrl_ctgry_rpt_v | ctrl_ctgry_name | varchar | 255 | √ | null | Control category name | |
esec_ctrl_ctgry_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_ctrl_ctgry_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_ctrl_ctgry_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_ctrl_rpt_v | content_external_id | varchar | 255 | √ | null | Content external identifier | |
esec_ctrl_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
esec_ctrl_rpt_v | ctrl_ctgry_id | uuid | 2147483647 | √ | null | Control category identifier | |
esec_ctrl_rpt_v | ctrl_desc | text | 2147483647 | √ | null | Control description | |
esec_ctrl_rpt_v | ctrl_id | uuid | 2147483647 | √ | null | Control identifier | |
esec_ctrl_rpt_v | ctrl_name | varchar | 255 | √ | null | Control name | |
esec_ctrl_rpt_v | ctrl_notes | text | 2147483647 | √ | null | Control notes | |
esec_ctrl_rpt_v | ctrl_state | int4 | 10 | √ | null | Control state | |
esec_ctrl_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_ctrl_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_ctrl_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_db_patches | applied_by | varchar | 20 | √ | null | Database patch applied by | |
esec_db_patches | date_applied | timestamptz | 35,6 | √ | null | Date of patch applied | |
esec_db_patches | db_patch | varchar | 20 | Database patch number | |||
esec_db_patches | sts | varchar | 50 | √ | null | Database patch statistics | |
esec_db_version | applied_by | varchar | 50 | √ | null | User who has applied the database | |
esec_db_version | applied_date | timestamptz | 35,6 | √ | null | Timestamp of database used | |
esec_db_version | db_version | varchar | 50 | Database Version number | |||
esec_db_version | sts | varchar | 50 | √ | null | Database status | |
esec_display | alignment | int4 | 10 | √ | null | The horizontal alignment | |
esec_display | created_by | int4 | 10 | √ | null | User who created object | |
esec_display | date_created | timestamptz | 35,6 | Date the entry was created | |||
esec_display | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
esec_display | description | varchar | 2048 | √ | null | Textual description of the tag | |
esec_display | display_object | varchar | 32 | The parent object of the property | |||
esec_display | enabled | bool | 1 | √ | null | TRUE Indicates that the tag is shown. | |
esec_display | format | int4 | 10 | √ | null | The enumerated formatter for displaying the property | |
esec_display | label | varchar | 255 | √ | null | The display string of tag. | |
esec_display | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_display | position | int4 | 10 | √ | null | Position of tag within display. | |
esec_display | ref_config | varchar | 4000 | √ | null | Referential data configuration | |
esec_display | tag | varchar | 255 | The native tag name of the property | |||
esec_display | type | int4 | 10 | √ | null | Indicates datatype of tag: 1-string, 2-ULONG,3-date, 4-uuid, 5-ipv4 | |
esec_display | width | int4 | 10 | √ | null | The column width | |
esec_display_rpt_v | alignment | int4 | 10 | √ | null | The horizontal alignment | |
esec_display_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
esec_display_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_display_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_display_rpt_v | description | varchar | 2048 | √ | null | Textual description of the tag | |
esec_display_rpt_v | display_object | varchar | 32 | √ | null | The parent object of the property | |
esec_display_rpt_v | enabled | bool | 1 | √ | null | TRUE Indicates that the tag is shown. | |
esec_display_rpt_v | format | int4 | 10 | √ | null | The enumerated formatter for displaying the property | |
esec_display_rpt_v | label | varchar | 255 | √ | null | The display string of tag. | |
esec_display_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_display_rpt_v | position | int4 | 10 | √ | null | Position of tag within display. | |
esec_display_rpt_v | ref_config | varchar | 4000 | √ | null | Referential data configuration | |
esec_display_rpt_v | tag | varchar | 255 | √ | null | The native tag name of the property | |
esec_display_rpt_v | type | int4 | 10 | √ | null | Indicates datatype of tag: 1-string, 2-ULONG,3-date, 4-uuid, 5-ipv4 | |
esec_display_rpt_v | width | int4 | 10 | √ | null | The column width | |
esec_namespace | created_by | int4 | 10 | √ | null | User who created object | |
esec_namespace | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_namespace | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_namespace | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_namespace | namespace_desc | varchar | 1024 | √ | null | Namespace description | |
esec_namespace | namespace_id | uuid | 2147483647 | Namespace identifier | |||
esec_namespace | namespace_name | varchar | 255 | Name of the namespace | |||
esec_namespace_leaf | created_by | int4 | 10 | √ | null | User who created object | |
esec_namespace_leaf | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_namespace_leaf | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_namespace_leaf | leaf_id | uuid | 2147483647 | Namespace leaf identifier | |||
esec_namespace_leaf | leaf_name | varchar | 255 | Name of namespace leaf | |||
esec_namespace_leaf | leaf_value | varchar | 255 | Namespace leaf value | |||
esec_namespace_leaf | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_port_reference | created_by | int4 | 10 | √ | null | User who created object | |
esec_port_reference | date_created | timestamptz | 35,6 | Date the entry was created | |||
esec_port_reference | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
esec_port_reference | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_port_reference | port_description | varchar | 512 | √ | null | Port description. | |
esec_port_reference | port_keyword | varchar | 64 | √ | null | Per http://www.iana.org/assignments/port-numbers, the keyword representation of the port. | |
esec_port_reference | port_number | int4 | 10 | Per http://www.iana.org/assignments/port-numbers, the numerical representation of the port. This port number is typically associated with the Transport Protocol level in the TCP/IP stack. | |||
esec_port_reference | protocol_number | int4 | 10 | Per http://www.iana.org/assignments/protocol-numbers, the numerical identifiers used to represent protocols that are encapsulated in an IP packet. | |||
esec_port_reference_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
esec_port_reference_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_port_reference_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_port_reference_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_port_reference_rpt_v | port_description | varchar | 512 | √ | null | Port description. | |
esec_port_reference_rpt_v | port_keyword | varchar | 64 | √ | null | Per http://www.iana.org/assignments/port-numbers, the keyword representation of the port. | |
esec_port_reference_rpt_v | port_number | int4 | 10 | √ | null | Per http://www.iana.org/assignments/port-numbers, the numerical representation of the port. This port number is typically associated with the Transport Protocol level in the TCP/IP stack. | |
esec_port_reference_rpt_v | protocol_number | int4 | 10 | √ | null | Per http://www.iana.org/assignments/protocol-numbers, the numerical identifiers used to represent protocols that are encapsulated in an IP packet. | |
esec_protocol_reference | created_by | int4 | 10 | √ | null | User who created object | |
esec_protocol_reference | date_created | timestamptz | 35,6 | Date the entry was created | |||
esec_protocol_reference | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
esec_protocol_reference | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_protocol_reference | protocol_description | varchar | 512 | √ | null | IP packet protocol description. | |
esec_protocol_reference | protocol_keyword | varchar | 64 | √ | null | Per http://www.iana.org/assignments/protocol-numbers, the keyword used to represent protocols that are encapsulated in an IP packet. | |
esec_protocol_reference | protocol_number | int4 | 10 | Per http://www.iana.org/assignments/protocol-numbers, the numerical identifiers used to represent protocols that are encapsulated in an IP packet. | |||
esec_protocol_reference_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
esec_protocol_reference_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_protocol_reference_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_protocol_reference_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_protocol_reference_rpt_v | protocol_description | varchar | 512 | √ | null | IP packet protocol description. | |
esec_protocol_reference_rpt_v | protocol_keyword | varchar | 64 | √ | null | Per http://www.iana.org/assignments/protocol-numbers, the keyword used to represent protocols that are encapsulated in an IP packet. | |
esec_protocol_reference_rpt_v | protocol_number | int4 | 10 | √ | null | Per http://www.iana.org/assignments/protocol-numbers, the numerical identifiers used to represent protocols that are encapsulated in an IP packet. | |
esec_sequence | column_name | varchar | 255 | Name of the column in the table for which sequence is being used | |||
esec_sequence | created_by | int4 | 10 | √ | null | User who created object | |
esec_sequence | date_created | timestamptz | 35,6 | Date the entry was created | |||
esec_sequence | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
esec_sequence | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_sequence | seed | int4 | 10 | Generated value for the respective table and column | |||
esec_sequence | table_name | varchar | 32 | Name of the table for which sequence is being generated | |||
esec_sequence_rpt_v | column_name | varchar | 255 | √ | null | Name of the column in the table for which sequence is being used | |
esec_sequence_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
esec_sequence_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_sequence_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_sequence_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_sequence_rpt_v | seed | int4 | 10 | √ | null | Generated value for the respective table and column | |
esec_sequence_rpt_v | table_name | varchar | 32 | √ | null | Name of the table for which sequence is being generated | |
esec_user_report_state | created_by | int4 | 10 | √ | null | User who created object | |
esec_user_report_state | date_created | timestamptz | 35,6 | Date the entry was created | |||
esec_user_report_state | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
esec_user_report_state | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_user_report_state | report_id | uuid | 2147483647 | Identifier of the report | |||
esec_user_report_state | state | varchar | 64 | Status of the report | |||
esec_user_report_state | user_id | int4 | 10 | Identifier of the user | |||
esec_uuid_uuid_assoc | created_by | int4 | 10 | √ | null | User who created object | |
esec_uuid_uuid_assoc | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_uuid_uuid_assoc | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_uuid_uuid_assoc | id1 | uuid | 2147483647 | UUID for object 1 | |||
esec_uuid_uuid_assoc | id2 | uuid | 2147483647 | UUID for object 2 | |||
esec_uuid_uuid_assoc | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_uuid_uuid_assoc | object1 | varchar | 64 | Object 1 | |||
esec_uuid_uuid_assoc | object2 | varchar | 64 | Object 2 | |||
esec_uuid_uuid_assoc_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
esec_uuid_uuid_assoc_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
esec_uuid_uuid_assoc_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
esec_uuid_uuid_assoc_rpt_v | id1 | uuid | 2147483647 | √ | null | UUID for object 1 | |
esec_uuid_uuid_assoc_rpt_v | id2 | uuid | 2147483647 | √ | null | UUID for object 2 | |
esec_uuid_uuid_assoc_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
esec_uuid_uuid_assoc_rpt_v | object1 | varchar | 64 | √ | null | Object 1 | |
esec_uuid_uuid_assoc_rpt_v | object2 | varchar | 64 | √ | null | Object 2 | |
event_data_sync_policies | created_by | int4 | 10 | √ | null | ID of user that created this data sync policy. | |
event_data_sync_policies | date_created | timestamptz | 35,6 | √ | null | Date this data sync policy was created. | |
event_data_sync_policies | date_modified | timestamptz | 35,6 | √ | null | Date this data sync policy was last updated. | |
event_data_sync_policies | modified_by | int4 | 10 | √ | null | ID of user that last modified this data sync policy. | |
event_data_sync_policies | policy_id | uuid | 2147483647 | This is the UUID of the data sync policy. This column is indexed for lookup purposes. | |||
event_data_sync_policies | rdd_id | uuid | 2147483647 | √ | null | This is the UUID of the report data definition plugin associated with this data sync policy, if any. It will be NULL if there is no report data definition plugin associated with the policy. | |
event_data_sync_policies | rdd_name | varchar | 255 | √ | null | Remote database name | |
event_data_sync_policies | rdd_namespace | varchar | 255 | √ | null | Remote database namespace | |
event_data_sync_policies | sync_policy | text | 2147483647 | √ | null | This is an XML string that defines the policy. The XML generates an EventDataSyncPolicy data object as defined in the EventDataSyncConfigDefinition.xml file | |
evt_datasync_info | completed_to_partition | int8 | 19 | √ | null | all partitions with a partition number less than or equal to this number have been synced. | |
evt_datasync_info | events_processed | int8 | 19 | √ | null | the total number of events that passed the data sync policy filter criteria. | |
evt_datasync_info | events_read | int8 | 19 | √ | null | the total number of events that have been read through in all partitions that have been or are being processed. | |
evt_datasync_info | last_resync_id | varchar | 255 | √ | null | This is a UUID that is used internally to keep track of the last resync event that occurred. It is strictly used for internal housekeeping. | |
evt_datasync_info | latest_event_time | timestamptz | 35,6 | √ | null | the time of the latest event we have read up to. NOTE: This does NOT mean all events up to this point in time have been processed. It is simply the latest event we have seen so far. | |
evt_datasync_info | policy_id | varchar | 255 | This is the UUID of the corresponding data sync policy. The UUID is deliberately stored as a string to simplify cross-db platform implementation. | |||
evt_datasync_info | records_added | int8 | 19 | √ | null | the total number of records that have been added to the destination table since the start of syncing (or resync). | |
evt_datasync_info | start_date_time | timestamptz | 35,6 | √ | null | the point in time that events are synced from. NOTE: It is NOT the date that syncing started. | |
evt_datasync_info | total_record_updates | int8 | 19 | √ | null | the total number of record updates that have been performed on the destination table since the start of syncing (or resync). | |
evt_src | created_by | int4 | 10 | √ | null | User who created object | |
evt_src | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
evt_src | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
evt_src | evt_src_config | text | 2147483647 | √ | null | Configuration of event source | |
evt_src | evt_src_grp_id | uuid | 2147483647 | Reference to event source group id | |||
evt_src | evt_src_id | uuid | 2147483647 | Unique identifier of event source | |||
evt_src | evt_src_name | varchar | 255 | Name of the event source | |||
evt_src | map_filter | text | 2147483647 | √ | null | Filter of the event source | |
evt_src | modified_by | int4 | 10 | √ | null | User who last modified object | |
evt_src | state_ind | bool | 1 | Reference to State of event source | |||
evt_src_collector | created_by | int4 | 10 | √ | null | User who created object | |
evt_src_collector | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
evt_src_collector | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
evt_src_collector | evt_src_collector_id | uuid | 2147483647 | Event source collector identifier | |||
evt_src_collector | evt_src_collector_name | varchar | 255 | Event source collector name | |||
evt_src_collector | evt_src_collector_props | text | 2147483647 | √ | null | Event source collector properties | |
evt_src_collector | evt_src_mgr_id | uuid | 2147483647 | Event source manager identifier | |||
evt_src_collector | map_filter | text | 2147483647 | √ | null | Map filter | |
evt_src_collector | modified_by | int4 | 10 | √ | null | User who last modified object | |
evt_src_collector | sentinel_plugin_id | uuid | 2147483647 | Sentinel plug-in identifier | |||
evt_src_collector | state_ind | bool | 1 | State indicator | |||
evt_src_collector_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
evt_src_collector_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
evt_src_collector_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
evt_src_collector_rpt_v | evt_src_collector_id | uuid | 2147483647 | √ | null | Event source collector identifier | |
evt_src_collector_rpt_v | evt_src_collector_name | varchar | 255 | √ | null | Event source collector name | |
evt_src_collector_rpt_v | evt_src_collector_props | text | 2147483647 | √ | null | Event source collector properties | |
evt_src_collector_rpt_v | evt_src_mgr_id | uuid | 2147483647 | √ | null | Event source manager identifier | |
evt_src_collector_rpt_v | map_filter | text | 2147483647 | √ | null | Map filter | |
evt_src_collector_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
evt_src_collector_rpt_v | sentinel_plugin_id | uuid | 2147483647 | √ | null | Sentinel plug-in identifier | |
evt_src_collector_rpt_v | state_ind | bool | 1 | √ | null | State indicator | |
evt_src_deleted | created_by | int4 | 10 | √ | null | User who created object | |
evt_src_deleted | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
evt_src_deleted | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
evt_src_deleted | evt_src_config | text | 2147483647 | √ | null | Configuration of event source | |
evt_src_deleted | evt_src_grp_id | uuid | 2147483647 | Reference to event source group id | |||
evt_src_deleted | evt_src_id | uuid | 2147483647 | Unique identifier of event source | |||
evt_src_deleted | evt_src_name | varchar | 255 | Name of the event source | |||
evt_src_deleted | map_filter | text | 2147483647 | √ | null | Filter of the event source | |
evt_src_deleted | modified_by | int4 | 10 | √ | null | User who last modified object | |
evt_src_deleted | state_ind | bool | 1 | Reference to State of event source | |||
evt_src_grp | created_by | int4 | 10 | √ | null | User who created object | |
evt_src_grp | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
evt_src_grp | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
evt_src_grp | evt_src_collector_id | uuid | 2147483647 | Event source collector identifier | |||
evt_src_grp | evt_src_default_config | text | 2147483647 | √ | null | Event source default configuration | |
evt_src_grp | evt_src_grp_id | uuid | 2147483647 | Event source group identifier | |||
evt_src_grp | evt_src_grp_name | varchar | 255 | Event source group name | |||
evt_src_grp | evt_src_srvr_id | uuid | 2147483647 | √ | null | Event source server identifier | |
evt_src_grp | map_filter | text | 2147483647 | √ | null | Map filter | |
evt_src_grp | modified_by | int4 | 10 | √ | null | User who last modified object | |
evt_src_grp | sentinel_plugin_id | uuid | 2147483647 | Sentinel plug-in identifier | |||
evt_src_grp | state_ind | bool | 1 | √ | null | State indicator | |
evt_src_grp_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
evt_src_grp_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
evt_src_grp_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
evt_src_grp_rpt_v | evt_src_collector_id | uuid | 2147483647 | √ | null | Event source collector identifier | |
evt_src_grp_rpt_v | evt_src_default_config | text | 2147483647 | √ | null | Event source default configuration | |
evt_src_grp_rpt_v | evt_src_grp_id | uuid | 2147483647 | √ | null | Event source group identifier | |
evt_src_grp_rpt_v | evt_src_grp_name | varchar | 255 | √ | null | Event source group name | |
evt_src_grp_rpt_v | evt_src_srvr_id | uuid | 2147483647 | √ | null | Event source server identifier | |
evt_src_grp_rpt_v | map_filter | text | 2147483647 | √ | null | Map filter | |
evt_src_grp_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
evt_src_grp_rpt_v | sentinel_plugin_id | uuid | 2147483647 | √ | null | Sentinel plug-in identifier | |
evt_src_grp_rpt_v | state_ind | bool | 1 | √ | null | State indicator | |
evt_src_mgr | created_by | int4 | 10 | √ | null | User who created object | |
evt_src_mgr | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
evt_src_mgr | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
evt_src_mgr | evt_src_mgr_config | text | 2147483647 | √ | null | Event source manager configuration | |
evt_src_mgr | evt_src_mgr_id | uuid | 2147483647 | Event source manager identifier | |||
evt_src_mgr | evt_src_mgr_name | varchar | 255 | Event source manager name | |||
evt_src_mgr | modified_by | int4 | 10 | √ | null | User who last modified object | |
evt_src_mgr | sentinel_host_id | uuid | 2147483647 | √ | null | Sentinel host identifier | |
evt_src_mgr | sentinel_id | uuid | 2147483647 | Sentinel identifier | |||
evt_src_mgr | state_ind | bool | 1 | State indicator | |||
evt_src_mgr_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
evt_src_mgr_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
evt_src_mgr_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
evt_src_mgr_rpt_v | evt_src_mgr_config | text | 2147483647 | √ | null | Event source manager configuration | |
evt_src_mgr_rpt_v | evt_src_mgr_id | uuid | 2147483647 | √ | null | Event source manager identifier | |
evt_src_mgr_rpt_v | evt_src_mgr_name | varchar | 255 | √ | null | Event source manager name | |
evt_src_mgr_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
evt_src_mgr_rpt_v | sentinel_host_id | uuid | 2147483647 | √ | null | Sentinel host identifier | |
evt_src_mgr_rpt_v | sentinel_id | uuid | 2147483647 | √ | null | Sentinel identifier | |
evt_src_mgr_rpt_v | state_ind | bool | 1 | √ | null | State indicator | |
evt_src_offset | created_by | int4 | 10 | √ | null | User who created object | |
evt_src_offset | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
evt_src_offset | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
evt_src_offset | evt_src_id | uuid | 2147483647 | Event source identifier | |||
evt_src_offset | modified_by | int4 | 10 | √ | null | User who last modified object | |
evt_src_offset | offset_timestamp | timestamptz | 35,6 | √ | null | Offset timestamp | |
evt_src_offset | offset_val | text | 2147483647 | √ | null | Offset value | |
evt_src_offset_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
evt_src_offset_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
evt_src_offset_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
evt_src_offset_rpt_v | evt_src_id | uuid | 2147483647 | √ | null | Event source identifier | |
evt_src_offset_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
evt_src_offset_rpt_v | offset_timestamp | timestamptz | 35,6 | √ | null | Offset timestamp | |
evt_src_offset_rpt_v | offset_val | text | 2147483647 | √ | null | Offset value | |
evt_src_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
evt_src_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
evt_src_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
evt_src_rpt_v | evt_src_config | text | 2147483647 | √ | null | Configuration of event source | |
evt_src_rpt_v | evt_src_grp_id | uuid | 2147483647 | √ | null | Reference to event source group id | |
evt_src_rpt_v | evt_src_id | uuid | 2147483647 | √ | null | Unique identifier of event source | |
evt_src_rpt_v | evt_src_name | varchar | 255 | √ | null | Name of the event source | |
evt_src_rpt_v | map_filter | text | 2147483647 | √ | null | Filter of the event source | |
evt_src_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
evt_src_rpt_v | state_ind | bool | 1 | √ | null | Reference to State of event source | |
evt_src_srvr | created_by | int4 | 10 | √ | null | User who created object | |
evt_src_srvr | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
evt_src_srvr | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
evt_src_srvr | evt_src_mgr_id | uuid | 2147483647 | Event source manager identifier | |||
evt_src_srvr | evt_src_srvr_config | text | 2147483647 | √ | null | Event source server configuration | |
evt_src_srvr | evt_src_srvr_id | uuid | 2147483647 | Event source server identifier | |||
evt_src_srvr | evt_src_srvr_name | varchar | 255 | Event source server name | |||
evt_src_srvr | modified_by | int4 | 10 | √ | null | User who last modified object | |
evt_src_srvr | sentinel_plugin_id | uuid | 2147483647 | Sentinel plug-in identifier | |||
evt_src_srvr | state_ind | bool | 1 | State indicator | |||
evt_src_srvr_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
evt_src_srvr_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
evt_src_srvr_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
evt_src_srvr_rpt_v | evt_src_mgr_id | uuid | 2147483647 | √ | null | Event source manager identifier | |
evt_src_srvr_rpt_v | evt_src_srvr_config | text | 2147483647 | √ | null | Event source server configuration | |
evt_src_srvr_rpt_v | evt_src_srvr_id | uuid | 2147483647 | √ | null | Event source server identifier | |
evt_src_srvr_rpt_v | evt_src_srvr_name | varchar | 255 | √ | null | Event source server name | |
evt_src_srvr_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
evt_src_srvr_rpt_v | sentinel_plugin_id | uuid | 2147483647 | √ | null | Sentinel plug-in identifier | |
evt_src_srvr_rpt_v | state_ind | bool | 1 | √ | null | State indicator | |
ext_data | created_by | int4 | 10 | √ | null | User who created object | |
ext_data | date_created | timestamptz | 35,6 | Date the entry was created | |||
ext_data | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
ext_data | ext_data | text | 2147483647 | √ | null | External data | |
ext_data | ext_data_id | int4 | 10 | External data identifier | |||
ext_data | ext_data_type | varchar | 10 | √ | null | External data type | |
ext_data | modified_by | int4 | 10 | √ | null | User who last modified object | |
ext_data | source_data_id | varchar | 255 | √ | null | Source data identifier | |
ext_data | source_name | varchar | 50 | √ | null | Source name | |
external_data_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
external_data_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
external_data_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
external_data_rpt_v | external_data | text | 2147483647 | √ | null | External data | |
external_data_rpt_v | external_data_id | int4 | 10 | √ | null | External data identifier | |
external_data_rpt_v | external_data_type | varchar | 10 | √ | null | External data type | |
external_data_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
external_data_rpt_v | source_data_id | varchar | 255 | √ | null | Source data identifier | |
external_data_rpt_v | source_name | varchar | 50 | √ | null | Source name | |
filters | builder_data | text | 2147483647 | √ | null | If query was built using builder, then this column stores the builder data associated with it used to display it back in UI later. | |
filters | created_by | int4 | 10 | √ | null | User who created object | |
filters | date_created | timestamptz | 35,6 | Date the entry was created | |||
filters | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
filters | filter_desc | varchar | 1024 | √ | null | Description of the filter. | |
filters | filter_id | uuid | 2147483647 | This is the UUID of the filter. | |||
filters | filter_name | varchar | 255 | This is the name of the filter | |||
filters | is_freeform | bool | 1 | √ | null | Denotes whether the query was built using builder or freeform. | |
filters | modified_by | int4 | 10 | √ | null | User who last modified object | |
filters | share_type | varchar | 50 | Denotes how the filter is shared. It can have one of these four values - "NONE","EVERYONE","SAME_ROLE","SELECTED_ROLES" | |||
filters | user_owner_id | int4 | 10 | User ID of the owner of this filter | |||
filters | value | text | 2147483647 | The actual lucene query forming the filter. | |||
global_filter_corr_action_association | corr_act_def_id | uuid | 2147483647 | Correlation actions identifier | |||
global_filter_corr_action_association | created_by | int4 | 10 | √ | null | User who created object | |
global_filter_corr_action_association | date_created | timestamptz | 35,6 | Date the entry was created | |||
global_filter_corr_action_association | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
global_filter_corr_action_association | filter_id | uuid | 2147483647 | Unique identifier for filter | |||
global_filter_corr_action_association | modified_by | int4 | 10 | √ | null | User who last modified object | |
global_filters | active | varchar | 32 | Status of the filter | |||
global_filters | channel_action | varchar | 1024 | Channel action | |||
global_filters | created_by | int4 | 10 | √ | null | User who created object | |
global_filters | date_created | timestamptz | 35,6 | Date the entry was created | |||
global_filters | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
global_filters | expr | varchar | 2048 | Expression | |||
global_filters | expr_type | varchar | 1024 | Expession type | |||
global_filters | filter_id | uuid | 2147483647 | Unique identifier for filter | |||
global_filters | filter_name | varchar | 256 | Name of the global filter | |||
global_filters | filter_owner | varchar | 2147483647 | √ | null | Owner of the filter | |
global_filters | inline | bool | 1 | Inline | |||
global_filters | modified_by | int4 | 10 | √ | null | User who last modified object | |
global_filters | rule_index | int4 | 10 | Rule Index | |||
incidents | created_by | int4 | 10 | √ | null | User who created object | |
incidents | criticality_rating | varchar | 32 | √ | null | Reserved for future use by Novell. Use of this field for any other purpose might result in data being overwritten by future functionality. | |
incidents | date_created | timestamptz | 35,6 | Date the entry was created | |||
incidents | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
incidents | inc_cat | varchar | 255 | √ | null | Incident category | |
incidents | inc_desc | varchar | 4000 | √ | null | Incident description | |
incidents | inc_id | int4 | 10 | Incident identifier - sequence number | |||
incidents | inc_priority | int4 | 10 | √ | null | Incident priority | |
incidents | inc_res | varchar | 4000 | √ | null | Incident resolution | |
incidents | modified_by | int4 | 10 | √ | null | User who last modified object | |
incidents | name | varchar | 255 | √ | null | Incident name | |
incidents | severity | int4 | 10 | √ | null | Incident severity | |
incidents | severity_rating | varchar | 32 | √ | null | Average of all the event severities that comprise an incident. | |
incidents | stt_id | int4 | 10 | Incident State ID | |||
incidents | vulnerability_rating | varchar | 32 | √ | null | Reserved for future use by Novell. Use of this field for any other purpose might result in data being overwritten by future functionality. | |
incidents_assets | asset_id | uuid | 2147483647 | Asset Universal Unique Identifier (UUID) | |||
incidents_assets | created_by | int4 | 10 | √ | null | User who created object | |
incidents_assets | date_created | timestamptz | 35,6 | Date the entry was created | |||
incidents_assets | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
incidents_assets | inc_id | int4 | 10 | Incident identifier - sequence number | |||
incidents_assets | modified_by | int4 | 10 | √ | null | User who last modified object | |
incidents_assets_rpt_v | asset_id | uuid | 2147483647 | √ | null | Asset Universal Unique Identifier (UUID) | |
incidents_assets_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
incidents_assets_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
incidents_assets_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
incidents_assets_rpt_v | inc_id | int4 | 10 | √ | null | Incident identifier - sequence number | |
incidents_assets_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
incidents_events | created_by | int4 | 10 | √ | null | User who created object | |
incidents_events | date_created | timestamptz | 35,6 | Date the entry was created | |||
incidents_events | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
incidents_events | evt_id | uuid | 2147483647 | Event Universal Unique Identifier (UUID) | |||
incidents_events | evt_time | timestamptz | 35,6 | Event time | |||
incidents_events | inc_id | int4 | 10 | Incident identifier-sequence number | |||
incidents_events | modified_by | int4 | 10 | √ | null | User who last modified object | |
incidents_events | part_id | int8 | 19 | Incident partition Identifier | |||
incidents_events_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
incidents_events_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
incidents_events_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
incidents_events_rpt_v | evt_id | uuid | 2147483647 | √ | null | Event Universal Unique Identifier (UUID) | |
incidents_events_rpt_v | evt_time | timestamptz | 35,6 | √ | null | Event time | |
incidents_events_rpt_v | inc_id | int4 | 10 | √ | null | Incident identifier-sequence number | |
incidents_events_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
incidents_events_rpt_v | part_id | int8 | 19 | √ | null | Incident partition Identifier | |
incidents_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
incidents_rpt_v | criticality_rating | varchar | 32 | √ | null | Reserved for future use by Novell. Use of this field for any other purpose might result in data being overwritten by future functionality. | |
incidents_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
incidents_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
incidents_rpt_v | inc_cat | varchar | 255 | √ | null | Incident category | |
incidents_rpt_v | inc_desc | varchar | 4000 | √ | null | Incident description | |
incidents_rpt_v | inc_id | int4 | 10 | √ | null | Incident identifier - sequence number | |
incidents_rpt_v | inc_priority | int4 | 10 | √ | null | Incident priority | |
incidents_rpt_v | inc_res | varchar | 4000 | √ | null | Incident resolution | |
incidents_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
incidents_rpt_v | name | varchar | 255 | √ | null | Incident name | |
incidents_rpt_v | severity | int4 | 10 | √ | null | Incident severity | |
incidents_rpt_v | severity_rating | varchar | 32 | √ | null | Average of all the event severities that comprise an incident. | |
incidents_rpt_v | stt_id | int4 | 10 | √ | null | Incident State ID | |
incidents_rpt_v | vulnerability_rating | varchar | 32 | √ | null | Reserved for future use by Novell. Use of this field for any other purpose might result in data being overwritten by future functionality. | |
incidents_vuln | created_by | int4 | 10 | √ | null | User who created object | |
incidents_vuln | date_created | timestamptz | 35,6 | Date the entry was created | |||
incidents_vuln | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
incidents_vuln | inc_id | int4 | 10 | Incident identifier-sequence number | |||
incidents_vuln | modified_by | int4 | 10 | √ | null | User who last modified object | |
incidents_vuln | vuln_id | uuid | 2147483647 | Vulnerability Universal Unique Identifier (UUID) | |||
incidents_vuln_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
incidents_vuln_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
incidents_vuln_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
incidents_vuln_rpt_v | inc_id | int4 | 10 | √ | null | Incident identifier-sequence number | |
incidents_vuln_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
incidents_vuln_rpt_v | vuln_id | uuid | 2147483647 | √ | null | Vulnerability Universal Unique Identifier (UUID) | |
integrator_config | config_id | uuid | 2147483647 | Integrator Configuration identifier | |||
integrator_config | created_by | int4 | 10 | √ | null | User who created object | |
integrator_config | date_created | timestamptz | 35,6 | Date the entry was created | |||
integrator_config | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
integrator_config | description | varchar | 4000 | √ | null | Integrator Configuration description | |
integrator_config | integrator_properties | text | 2147483647 | √ | null | Integrator Configuration properties in XML form | |
integrator_config | modified_by | int4 | 10 | √ | null | User who last modified object | |
integrator_config | name | varchar | 255 | Integrator Configuration name | |||
integrator_config | plugin_id | uuid | 2147483647 | Sentinel Plugin identifier | |||
integrator_config | type | varchar | 255 | Integrator Configuration type | |||
ixlog_part | byte_count | int8 | 19 | √ | null | Size of the event | |
ixlog_part | correlated_events_exported | int8 | 19 | √ | null | Correlated events exported | |
ixlog_part | correlated_events_imported | int8 | 19 | √ | null | Correlated events imported | |
ixlog_part | created_by | int4 | 10 | √ | null | User who created object | |
ixlog_part | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
ixlog_part | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
ixlog_part | event_assoc_action | int4 | 10 | √ | null | Event associated action | |
ixlog_part | event_assoc_action_start_time | timestamptz | 35,6 | √ | null | Starting time of events associated action | |
ixlog_part | event_assoc_data_export_hash | varchar | 255 | √ | null | Hash for events associated data exported | |
ixlog_part | event_assoc_data_exported | bool | 1 | √ | null | Indicator of events associated data export | |
ixlog_part | event_assoc_data_in_db | int4 | 10 | √ | null | Existence of event associated data in database | |
ixlog_part | event_count | int8 | 19 | √ | null | Event count for the partition | |
ixlog_part | hash | varchar | 255 | √ | null | Hash value | |
ixlog_part | incidents_events_exported | int8 | 19 | √ | null | Incident events exported | |
ixlog_part | incidents_events_imported | int8 | 19 | √ | null | Incident events imported | |
ixlog_part | index_version | int4 | 10 | 0 | Version of log | ||
ixlog_part | modified_by | int4 | 10 | √ | null | User who last modified object | |
ixlog_part | name | varchar | 255 | Partition name | |||
ixlog_part | part_date | date | 13 | Partition date | |||
ixlog_part | part_id | int8 | 19 | Identifier of Index Log of partitions | |||
ixlog_part | ret_pol_id | uuid | 2147483647 | √ | null | Retention policy identifier | |
ixlog_part | state | int4 | 10 | 0 | Status of log | ||
license_record | collector_manager_id | varchar | 255 | Collector Manager id | |||
license_record | collector_plugin_id | varchar | 255 | Collector type id | |||
license_record | count | int8 | 19 | Count of data records | |||
license_record | tenant_id | varchar | 255 | Tenant name | |||
license_record | time | timestamptz | 35,6 | Timestamp of record | |||
license_record_hours | collector_manager_id | varchar | 255 | Collector Manager id | |||
license_record_hours | collector_plugin_id | varchar | 255 | Collector type id | |||
license_record_hours | count | int8 | 19 | Count of data records | |||
license_record_hours | tenant_id | varchar | 255 | Tenant name | |||
license_record_hours | time | timestamptz | 35,6 | Timestamp of record | |||
md_config | application | varchar | 255 | Application name | |||
md_config | branding | varchar | 32 | √ | null | Branding name | |
md_config | config_id | uuid | 2147483647 | md configuration identifier | |||
md_config | created_by | int4 | 10 | √ | null | User who created object | |
md_config | data | text | 2147483647 | √ | null | Md Configuration data in xml | |
md_config | date_created | timestamptz | 35,6 | Date the entry was created | |||
md_config | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
md_config | modified_by | int4 | 10 | √ | null | User who last modified object | |
md_config | typ | varchar | 100 | √ | null | Type | |
md_config | unit | varchar | 64 | √ | null | Unit name | |
md_config | usr_id | int4 | 10 | User identifier | |||
md_config | value | varchar | 255 | √ | null | Unit value | |
md_view_config | created_by | int4 | 10 | √ | null | User who created object | |
md_view_config | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
md_view_config | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
md_view_config | default_view_ind | bool | 1 | TRUE indicates | |||
md_view_config | modified_by | int4 | 10 | √ | null | User who last modified object | |
md_view_config | view_config_id | int8 | 19 | Identifier of md view | |||
md_view_config | view_data | text | 2147483647 | md view data in XML form | |||
md_view_config | view_desc | varchar | 255 | √ | null | md view description | |
md_view_config | view_name | varchar | 255 | md view name | |||
md_view_config | view_typ | varchar | 100 | md view type | |||
mssp_associations | created_by | int4 | 10 | √ | null | User who created object | |
mssp_associations | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
mssp_associations | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
mssp_associations | id1 | int8 | 19 | ID1 | |||
mssp_associations | id2 | uuid | 2147483647 | ID2 | |||
mssp_associations | modified_by | int4 | 10 | √ | null | User who last modified object | |
mssp_associations | table1 | varchar | 64 | Table name 1 | |||
mssp_associations | table2 | varchar | 64 | Table name 2 | |||
mssp_associations_v | created_by | int4 | 10 | √ | null | User who created object | |
mssp_associations_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
mssp_associations_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
mssp_associations_v | id1 | int8 | 19 | √ | null | ID1 | |
mssp_associations_v | id2 | uuid | 2147483647 | √ | null | ID2 | |
mssp_associations_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
mssp_associations_v | table1 | varchar | 64 | √ | null | Table name 1 | |
mssp_associations_v | table2 | varchar | 64 | √ | null | Table name 2 | |
network_identity_lkup | created_by | int4 | 10 | √ | null | User who created object | |
network_identity_lkup | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
network_identity_lkup | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
network_identity_lkup | modified_by | int4 | 10 | √ | null | User who last modified object | |
network_identity_lkup | network_identity_id | int8 | 19 | Unique identifier of network identity | |||
network_identity_lkup | network_identity_name | varchar | 255 | IPV6 address of the asset | |||
network_identity_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
network_identity_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
network_identity_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
network_identity_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
network_identity_rpt_v | network_identity_id | int8 | 19 | √ | null | Unique identifier of network identity | |
network_identity_rpt_v | network_identity_name | varchar | 255 | √ | null | Name of network identity | |
organization | created_by | int4 | 10 | √ | null | User who created object | |
organization | cust_id | int8 | 19 | √ | null | Customer identifier | |
organization | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
organization | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
organization | modified_by | int4 | 10 | √ | null | User who last modified object | |
organization | organization_id | uuid | 2147483647 | Organization identifier | |||
organization | organization_name | varchar | 100 | Organization name | |||
organization_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
organization_rpt_v | cust_id | int8 | 19 | √ | null | Customer identifier | |
organization_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
organization_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
organization_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
organization_rpt_v | organization_id | uuid | 2147483647 | √ | null | Organization identifier | |
organization_rpt_v | organization_name | varchar | 100 | √ | null | Organization name | |
partition_sync_info | partition_completed | bool | 1 | √ | null | This is a boolean flag indicating whether or not we are done processing this partition. | |
partition_sync_info | partition_id | int8 | 19 | This is the partition number of the partition this record is tracking. | |||
partition_sync_info | partition_read_offset | int8 | 19 | √ | null | This is the absolute offset into the event store file for this partition where we have synced to so far. | |
partition_sync_info | policy_id | varchar | 255 | This is the UUID of the corresponding data sync policy. The UUID is deliberately stored as a string to simplify cross-db platform implementation. | |||
permissions | created_by | int4 | 10 | √ | null | User who created object | |
permissions | date_created | timestamptz | 35,6 | Date the entry was created | |||
permissions | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
permissions | modified_by | int4 | 10 | √ | null | User who last modified object | |
permissions | perm_category | varchar | 255 | √ | null | Permission category | |
permissions | perm_desc | text | 2147483647 | √ | null | Description of the permission | |
permissions | perm_name | varchar | 255 | Name of the permission | |||
permissions | perm_type | varchar | 50 | √ | null | boolean | |
person | created_by | int4 | 10 | √ | null | User who created object | |
person | cust_id | int8 | 19 | √ | null | Customer Identifier | |
person | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
person | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
person | email_addr | varchar | 255 | √ | null | Email address | |
person | first_name | varchar | 255 | √ | null | First name | |
person | last_name | varchar | 255 | √ | null | Last name | |
person | modified_by | int4 | 10 | √ | null | User who last modified object | |
person | person_id | uuid | 2147483647 | Person identifier | |||
person | phone_num | varchar | 50 | √ | null | Phone number | |
person_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
person_rpt_v | cust_id | int8 | 19 | √ | null | Customer Identifier | |
person_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
person_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
person_rpt_v | email_address | varchar | 255 | √ | null | Email address | |
person_rpt_v | first_name | varchar | 255 | √ | null | First name | |
person_rpt_v | last_name | varchar | 255 | √ | null | Last name | |
person_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
person_rpt_v | person_id | uuid | 2147483647 | √ | null | Person identifier | |
person_rpt_v | phone_number | varchar | 50 | √ | null | Phone number | |
physical_asset | created_by | int4 | 10 | √ | null | User who created object | |
physical_asset | cust_id | int8 | 19 | √ | null | Customer identifier | |
physical_asset | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
physical_asset | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
physical_asset | host_name | varchar | 255 | √ | null | Host name | |
physical_asset | ip_addr | int4 | 10 | √ | null | IP address | |
physical_asset | loc_id | int8 | 19 | Location identifier | |||
physical_asset | mac_addr | varchar | 100 | √ | null | MAC address | |
physical_asset | modified_by | int4 | 10 | √ | null | User who last modified object | |
physical_asset | network_identity_id | int8 | 19 | Network identity code | |||
physical_asset | physical_asset_id | uuid | 2147483647 | Physical asset identifier | |||
physical_asset | rack_num | varchar | 50 | √ | null | Asset maintainer identity ID | |
physical_asset | room_name | varchar | 100 | √ | null | Asset owner identity ID | |
physical_asset_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
physical_asset_rpt_v | cust_id | int8 | 19 | √ | null | Customer identifier | |
physical_asset_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
physical_asset_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
physical_asset_rpt_v | host_name | varchar | 255 | √ | null | Host name | |
physical_asset_rpt_v | ip_address | int4 | 10 | √ | null | IP address | |
physical_asset_rpt_v | location_id | int8 | 19 | √ | null | Location identifier | |
physical_asset_rpt_v | mac_address | varchar | 100 | √ | null | MAC address | |
physical_asset_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
physical_asset_rpt_v | network_identity_id | int8 | 19 | √ | null | Network identity code | |
physical_asset_rpt_v | physical_asset_id | uuid | 2147483647 | √ | null | Physical asset identifier | |
physical_asset_rpt_v | rack_number | varchar | 50 | √ | null | Rack number | |
physical_asset_rpt_v | room_name | varchar | 100 | √ | null | Room name | |
prdt | created_by | int4 | 10 | √ | null | User who created object | |
prdt | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
prdt | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
prdt | modified_by | int4 | 10 | √ | null | User who last modified object | |
prdt | prdt_id | int8 | 19 | Product identifier | |||
prdt | prdt_name | varchar | 255 | √ | null | Product name | |
prdt | prdt_version | varchar | 100 | √ | null | Product version | |
prdt | vndr_id | int8 | 19 | Vendor identifier | |||
product_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
product_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
product_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
product_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
product_rpt_v | product_id | int8 | 19 | √ | null | Product identifier | |
product_rpt_v | product_name | varchar | 255 | √ | null | Product name | |
product_rpt_v | product_version | varchar | 100 | √ | null | Product version | |
product_rpt_v | vendor_id | int8 | 19 | √ | null | Vendor identifier | |
raw_data_files_info | created_by | int4 | 10 | √ | null | User who created object | |
raw_data_files_info | date_created | timestamptz | 35,6 | Date the entry was created | |||
raw_data_files_info | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
raw_data_files_info | evt_src_id | uuid | 2147483647 | Event source identifier for raw data file | |||
raw_data_files_info | evt_src_name | varchar | 256 | Event source name of raw data file | |||
raw_data_files_info | file_hash | varchar | 256 | √ | null | Hash generated for raw data file | |
raw_data_files_info | file_name | varchar | 256 | File name of raw data file | |||
raw_data_files_info | id | uuid | 2147483647 | Raw data file identifier | |||
raw_data_files_info | modified_by | int4 | 10 | √ | null | User who last modified object | |
raw_data_files_info | state | varchar | 64 | Status of raw data file | |||
role_lkup | created_by | int4 | 10 | √ | null | User who created object | |
role_lkup | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
role_lkup | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
role_lkup | modified_by | int4 | 10 | √ | null | User who last modified object | |
role_lkup | role_cd | varchar | 5 | Role code | |||
role_lkup | role_name | varchar | 255 | Role name | |||
role_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
role_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
role_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
role_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
role_rpt_v | role_code | varchar | 5 | √ | null | Role code | |
role_rpt_v | role_name | varchar | 255 | √ | null | Role name | |
scheduled_job_detail | author | varchar | 64 | √ | null | Author of scheduled job | |
scheduled_job_detail | created_by | int4 | 10 | √ | null | User who created object | |
scheduled_job_detail | date_created | timestamptz | 35,6 | Date the entry was created | |||
scheduled_job_detail | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
scheduled_job_detail | description | text | 2147483647 | √ | null | Scheduled job's description | |
scheduled_job_detail | end_time | timestamptz | 35,6 | √ | null | End time of scheduled job | |
scheduled_job_detail | error_message | text | 2147483647 | √ | null | Error message | |
scheduled_job_detail | job_id | uuid | 2147483647 | Scheduled job identifier | |||
scheduled_job_detail | job_name | varchar | 255 | Scheduled job name | |||
scheduled_job_detail | job_type | varchar | 255 | Scheduled job type, ie, hourly, daily etc. | |||
scheduled_job_detail | last_run | timestamptz | 35,6 | √ | null | Timestamp of job last executed | |
scheduled_job_detail | modified_by | int4 | 10 | √ | null | User who last modified object | |
scheduled_job_detail | params | text | 2147483647 | √ | null | Parameters of the scheduled job | |
scheduled_job_detail | schedule_time | varchar | 127 | Scheduled job time | |||
scheduled_job_detail | start_time | timestamptz | 35,6 | √ | null | Start time of scheduled job | |
sensitivity_lkup | created_by | int4 | 10 | √ | null | User who created object | |
sensitivity_lkup | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
sensitivity_lkup | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
sensitivity_lkup | modified_by | int4 | 10 | √ | null | User who last modified object | |
sensitivity_lkup | sensitivity_id | int8 | 19 | Asset sensitivity code | |||
sensitivity_lkup | sensitivity_name | varchar | 50 | Asset sensitivity name | |||
sensitivity_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
sensitivity_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
sensitivity_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
sensitivity_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
sensitivity_rpt_v | sensitivity_id | int8 | 19 | √ | null | Asset sensitivity code | |
sensitivity_rpt_v | sensitivity_name | varchar | 50 | √ | null | Asset sensitivity name | |
sentinel | created_by | int4 | 10 | √ | null | User who created object | |
sentinel | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
sentinel | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
sentinel | modified_by | int4 | 10 | √ | null | User who last modified object | |
sentinel | online_ind | bool | 1 | True indicates that the Server is online (False for Scatch Pad) | |||
sentinel | sentinel_config | text | 2147483647 | √ | null | Configuration XML | |
sentinel | sentinel_id | uuid | 2147483647 | Unique Identifier for Sentinel | |||
sentinel | sentinel_name | varchar | 255 | Name of the Server (Sentinel, Sentinel (Scratch pad) | |||
sentinel | state_ind | bool | 1 | True indicates that the Server is active | |||
sentinel_host | created_by | int4 | 10 | √ | null | User who created object | |
sentinel_host | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
sentinel_host | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
sentinel_host | host_name | varchar | 255 | √ | null | Only hostname of the Sentinel Server | |
sentinel_host | host_os | varchar | 255 | √ | null | Name of OS on which Sentinel is running | |
sentinel_host | host_os_version | varchar | 255 | √ | null | Version of OS that Sentinel is running | |
sentinel_host | ip_addr | varchar | 255 | √ | null | Only IP address of the Sentinel Server | |
sentinel_host | modified_by | int4 | 10 | √ | null | User who last modified object | |
sentinel_host | sentinel_host_id | uuid | 2147483647 | ID of the Host machine where Sentinel is running | |||
sentinel_host | sentinel_host_name | varchar | 255 | Host name and IP address of the Sentinel Server | |||
sentinel_host | sentinel_id | uuid | 2147483647 | ID of the Sentinel where Server was installed | |||
sentinel_host_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
sentinel_host_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
sentinel_host_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
sentinel_host_rpt_v | host_name | varchar | 255 | √ | null | Only hostname of the Sentinel Server | |
sentinel_host_rpt_v | host_os | varchar | 255 | √ | null | Name of OS on which Sentinel is running | |
sentinel_host_rpt_v | host_os_version | varchar | 255 | √ | null | Version of OS that Sentinel is running | |
sentinel_host_rpt_v | ip_addr | varchar | 255 | √ | null | Only IP address of the Sentinel Server | |
sentinel_host_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
sentinel_host_rpt_v | sentinel_host_id | uuid | 2147483647 | √ | null | ID of the Host machine where Sentinel is running | |
sentinel_host_rpt_v | sentinel_host_name | varchar | 255 | √ | null | Host name and IP address of the Sentinel Server | |
sentinel_host_rpt_v | sentinel_id | uuid | 2147483647 | √ | null | ID of the Sentinel where Server was installed | |
sentinel_plugin | aux_file_name | varchar | 512 | Name of the auxiliary plugin file | |||
sentinel_plugin | content_pkg | text | 2147483647 | √ | null | Content of package.xml for the plugin | |
sentinel_plugin | created_by | int4 | 10 | √ | null | User who created object | |
sentinel_plugin | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
sentinel_plugin | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
sentinel_plugin | file_hash | varchar | 255 | Hash generated for the plugin file | |||
sentinel_plugin | file_name | varchar | 512 | Name of the plugin file inside plugin_repository folder | |||
sentinel_plugin | modified_by | int4 | 10 | √ | null | User who last modified object | |
sentinel_plugin | sentinel_plugin_id | uuid | 2147483647 | ID of the Sentinel Plugin | |||
sentinel_plugin | sentinel_plugin_name | varchar | 255 | Name of the Sentinel Plugin | |||
sentinel_plugin | sentinel_plugin_type | varchar | 255 | Type of the Plugin such as COLLECTOR, INTEGRATOR etc. | |||
sentinel_plugin_rpt_v | aux_file_name | varchar | 512 | √ | null | Name of the auxiliary plugin file | |
sentinel_plugin_rpt_v | content_pkg | text | 2147483647 | √ | null | Content of package.xml for the plugin | |
sentinel_plugin_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
sentinel_plugin_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
sentinel_plugin_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
sentinel_plugin_rpt_v | file_hash | varchar | 255 | √ | null | Hash generated for the plugin file | |
sentinel_plugin_rpt_v | file_name | varchar | 512 | √ | null | Name of the plugin file inside plugin_repository folder | |
sentinel_plugin_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
sentinel_plugin_rpt_v | sentinel_plugin_id | uuid | 2147483647 | √ | null | ID of the Sentinel Plugin | |
sentinel_plugin_rpt_v | sentinel_plugin_name | varchar | 255 | √ | null | Name of the Sentinel Plugin | |
sentinel_plugin_rpt_v | sentinel_plugin_type | varchar | 255 | √ | null | Type of the Plugin such as COLLECTOR, INTEGRATOR etc. | |
sentinel_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
sentinel_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
sentinel_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
sentinel_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
sentinel_rpt_v | online_ind | bool | 1 | √ | null | True indicates that the Server is online (False for Scatch Pad) | |
sentinel_rpt_v | sentinel_config | text | 2147483647 | √ | null | Configuration XML | |
sentinel_rpt_v | sentinel_id | uuid | 2147483647 | √ | null | Unique Identifier for Sentinel | |
sentinel_rpt_v | sentinel_name | varchar | 255 | √ | null | Name of the Server (Sentinel, Sentinel (Scratch pad) | |
sentinel_rpt_v | state_ind | bool | 1 | √ | null | True indicates that the Server is active | |
states | context | varchar | 64 | √ | null | Case or Context in abbreviated form | |
states | created_by | int4 | 10 | √ | null | User who created object | |
states | date_created | timestamptz | 35,6 | Date the entry was created | |||
states | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
states | modified_by | int4 | 10 | √ | null | User who last modified object | |
states | name | varchar | 64 | √ | null | Detail of the Status of different contexts | |
states | stt_id | int4 | 10 | Unique identifier for the Status of different Contexts | |||
states | terminal_flag | varchar | 1 | √ | null | Indicates if state of incident is resolved. | |
states_rpt_v | context | varchar | 64 | √ | null | Case or Context in abbreviated form | |
states_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
states_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
states_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
states_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
states_rpt_v | name | varchar | 64 | √ | null | Detail of the Status of different contexts | |
states_rpt_v | stt_id | int4 | 10 | √ | null | Unique identifier for the Status of different Contexts | |
states_rpt_v | terminal_flag | varchar | 1 | √ | null | Indicates if state of incident is resolved. | |
tag_event_source_association | created_by | int4 | 10 | √ | null | User who created object | |
tag_event_source_association | date_created | timestamptz | 35,6 | Date the entry was created | |||
tag_event_source_association | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
tag_event_source_association | event_source_id | uuid | 2147483647 | Id of the event source | |||
tag_event_source_association | modified_by | int4 | 10 | √ | null | User who last modified object | |
tag_event_source_association | tag_name | varchar | 255 | Name of the tag for event source association | |||
tag_event_source_association_v | created_by | int4 | 10 | √ | null | User who created object | |
tag_event_source_association_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
tag_event_source_association_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
tag_event_source_association_v | event_source_id | uuid | 2147483647 | √ | null | Id of the event source | |
tag_event_source_association_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
tag_event_source_association_v | tag_name | varchar | 255 | √ | null | Name of the tag for event source association | |
tag_event_source_server_association | created_by | int4 | 10 | √ | null | User who created object | |
tag_event_source_server_association | date_created | timestamptz | 35,6 | Date the entry was created | |||
tag_event_source_server_association | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
tag_event_source_server_association | event_source_server_id | uuid | 2147483647 | Id of the event source server | |||
tag_event_source_server_association | modified_by | int4 | 10 | √ | null | User who last modified object | |
tag_event_source_server_association | tag_name | varchar | 255 | Name of the tag for event source server | |||
tag_event_source_server_association_v | created_by | int4 | 10 | √ | null | User who created object | |
tag_event_source_server_association_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
tag_event_source_server_association_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
tag_event_source_server_association_v | event_source_server_id | uuid | 2147483647 | √ | null | Id of the event source server | |
tag_event_source_server_association_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
tag_event_source_server_association_v | tag_name | varchar | 255 | √ | null | Name of the tag for event source server | |
tag_event_src_manager_association | created_by | int4 | 10 | √ | null | User who created object | |
tag_event_src_manager_association | date_created | timestamptz | 35,6 | Date the entry was created | |||
tag_event_src_manager_association | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
tag_event_src_manager_association | event_src_manager_id | uuid | 2147483647 | Id of the event source manager | |||
tag_event_src_manager_association | modified_by | int4 | 10 | √ | null | User who last modified object | |
tag_event_src_manager_association | tag_name | varchar | 255 | Name of the tag for event source manager | |||
tag_event_src_manager_association_v | created_by | int4 | 10 | √ | null | User who created object | |
tag_event_src_manager_association_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
tag_event_src_manager_association_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
tag_event_src_manager_association_v | event_src_manager_id | uuid | 2147483647 | √ | null | Id of the event source manager | |
tag_event_src_manager_association_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
tag_event_src_manager_association_v | tag_name | varchar | 255 | √ | null | Name of the tag for event source manager | |
tag_global_filter_association | created_by | int4 | 10 | √ | null | User who created object | |
tag_global_filter_association | date_created | timestamptz | 35,6 | Date the entry was created | |||
tag_global_filter_association | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
tag_global_filter_association | filter_id | uuid | 2147483647 | Unique identifier for filter | |||
tag_global_filter_association | modified_by | int4 | 10 | √ | null | User who last modified object | |
tag_global_filter_association | tag_name | varchar | 255 | Name of the tag (unique and case insensitive) | |||
tag_plugin_association | created_by | int4 | 10 | √ | null | User who created object | |
tag_plugin_association | date_created | timestamptz | 35,6 | Date the entry was created | |||
tag_plugin_association | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
tag_plugin_association | modified_by | int4 | 10 | √ | null | User who last modified object | |
tag_plugin_association | plugin_id | uuid | 2147483647 | Id of the plugin | |||
tag_plugin_association | plugin_type | varchar | 255 | Plugin type | |||
tag_plugin_association | tag_name | varchar | 255 | Name of the tag for plugin association | |||
tag_plugin_association_v | created_by | int4 | 10 | √ | null | User who created object | |
tag_plugin_association_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
tag_plugin_association_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
tag_plugin_association_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
tag_plugin_association_v | plugin_id | uuid | 2147483647 | √ | null | Id of the plugin | |
tag_plugin_association_v | plugin_type | varchar | 255 | √ | null | Plugin type | |
tag_plugin_association_v | tag_name | varchar | 255 | √ | null | Name of the tag for plugin association | |
tags | created_by | int4 | 10 | √ | null | User who created object | |
tags | date_created | timestamptz | 35,6 | Date the entry was created | |||
tags | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
tags | modified_by | int4 | 10 | √ | null | User who last modified object | |
tags | tag_description | varchar | 1024 | √ | null | Description of the tag | |
tags | tag_name | varchar | 255 | Name of the tag (unique and case insensitive) | |||
tags_v | created_by | int4 | 10 | √ | null | User who created object | |
tags_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
tags_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
tags_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
tags_v | tag_description | varchar | 1024 | √ | null | Description of the tag | |
tags_v | tag_name | varchar | 255 | √ | null | Name of the tag (unique and case insensitive) | |
target_slms | certificate | varchar | 8192 | Certificate details | |||
target_slms | created_by | int4 | 10 | √ | null | User who created object | |
target_slms | date_created | timestamptz | 35,6 | Date the entry was created | |||
target_slms | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
target_slms | display_name | varchar | 255 | Display name | |||
target_slms | is_enabled | bool | 1 | √ | null | TRUE indicates Active | |
target_slms | modified_by | int4 | 10 | √ | null | User who last modified object | |
target_slms | network_address | varchar | 255 | Network Address | |||
target_slms | port | int4 | 10 | √ | null | Port Number | |
target_slms | slm_id | uuid | 2147483647 | Sentinel Log Manager Id | |||
txnmy_node | created_by | int4 | 10 | √ | null | User who created object | |
txnmy_node | date_created | timestamptz | 35,6 | Date the entry was created | |||
txnmy_node | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
txnmy_node | modified_by | int4 | 10 | √ | null | User who last modified object | |
txnmy_node | node_desc | varchar | 1000 | √ | null | Taxanomy Node description | |
txnmy_node | node_id | varchar | 36 | Taxanomy Node identifier | |||
txnmy_node | node_name | varchar | 255 | Taxanomy Node name | |||
txnmy_node | node_owner | varchar | 255 | Taxanomy Node owner | |||
unassigned_incidents_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
unassigned_incidents_rpt_v | criticality_rating | varchar | 32 | √ | null | Reserved for future use by Novell. Use of this field for any other purpose might result in data being overwritten by future functionality. | |
unassigned_incidents_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
unassigned_incidents_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
unassigned_incidents_rpt_v | inc_cat | varchar | 255 | √ | null | Incident category | |
unassigned_incidents_rpt_v | inc_desc | varchar | 4000 | √ | null | Incident description | |
unassigned_incidents_rpt_v | inc_id | int4 | 10 | √ | null | Incident identifier - sequence number | |
unassigned_incidents_rpt_v | inc_priority | int4 | 10 | √ | null | Incident priority | |
unassigned_incidents_rpt_v | inc_res | varchar | 4000 | √ | null | Incident resolution | |
unassigned_incidents_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
unassigned_incidents_rpt_v | name | varchar | 255 | √ | null | Incident name | |
unassigned_incidents_rpt_v | severity | int4 | 10 | √ | null | Incident severity | |
unassigned_incidents_rpt_v | severity_rating | varchar | 32 | √ | null | Average of all the event severities that comprise an incident. | |
unassigned_incidents_rpt_v | stt_id | int4 | 10 | √ | null | Incident State ID | |
unassigned_incidents_rpt_v | vulnerability_rating | varchar | 32 | √ | null | Reserved for future use by Novell. Use of this field for any other purpose might result in data being overwritten by future functionality. | |
user_group_mappings | created_by | int4 | 10 | √ | null | User who created object | |
user_group_mappings | date_created | timestamptz | 35,6 | Date the entry was created | |||
user_group_mappings | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
user_group_mappings | modified_by | int4 | 10 | √ | null | User who last modified object | |
user_group_mappings | user_group_id | uuid | 2147483647 | ID of the group that the user belonging to | |||
user_group_mappings | user_id | int4 | 10 | ID of the user | |||
user_group_permissions | created_by | int4 | 10 | √ | null | User who created object | |
user_group_permissions | date_created | timestamptz | 35,6 | Date the entry was created | |||
user_group_permissions | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
user_group_permissions | modified_by | int4 | 10 | √ | null | User who last modified object | |
user_group_permissions | perm_name | varchar | 255 | Permission name coming from Permission table | |||
user_group_permissions | perm_value | text | 2147483647 | Indicate whether this permission is true (selected) or false (not selected) | |||
user_group_permissions | user_group_id | uuid | 2147483647 | Reference ID of the user_group table for which group these permissions are applicable | |||
user_group_tags | created_by | int4 | 10 | √ | null | User who created object | |
user_group_tags | date_created | timestamptz | 35,6 | Date the entry was created | |||
user_group_tags | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
user_group_tags | modified_by | int4 | 10 | √ | null | User who last modified object | |
user_group_tags | tag_name | varchar | 255 | Tag name for the user group | |||
user_group_tags | user_group_id | uuid | 2147483647 | User group identifier | |||
user_groups | allow_all_events | bool | 1 | √ | null | Indicator for allowing all the events | |
user_groups | created_by | int4 | 10 | √ | null | User who created object | |
user_groups | date_created | timestamptz | 35,6 | Date the entry was created | |||
user_groups | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
user_groups | filter | varchar | 4096 | √ | null | To see all the data or selected data as a filter | |
user_groups | group_desc | varchar | 1024 | √ | null | Description of the group | |
user_groups | group_id | uuid | 2147483647 | Unique Identifier for Group of Users | |||
user_groups | group_name | varchar | 255 | Name of the group (Role on GUI) | |||
user_groups | is_admin | bool | 1 | √ | null | True indicates that this group belongs to Admin | |
user_groups | modified_by | int4 | 10 | √ | null | User who last modified object | |
user_groups | read_only | bool | 1 | √ | null | True indicates that the user is end user so no write privileges are granted | |
user_tag_permission_rules | created_by | int4 | 10 | √ | null | User who created object | |
user_tag_permission_rules | data_canhave_tags | varchar | 1024 | √ | null | Data tags that the user can have | |
user_tag_permission_rules | data_musthave_tags | varchar | 1024 | √ | null | Data tags that the user must have | |
user_tag_permission_rules | date_created | timestamptz | 35,6 | Date the entry was created | |||
user_tag_permission_rules | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
user_tag_permission_rules | is_enabled | bool | 1 | TRUE indicates that the permission rule is enabled | |||
user_tag_permission_rules | modified_by | int4 | 10 | √ | null | User who last modified object | |
user_tag_permission_rules | rule_id | uuid | 2147483647 | Identifier of Tag Permission | |||
user_tag_permission_rules | user_canhave_tags | varchar | 1024 | √ | null | Tags that the user can have | |
user_tag_permission_rules | user_musthave_tags | varchar | 1024 | √ | null | Tags that the user must have | |
user_tag_permission_rules_v | created_by | int4 | 10 | √ | null | User who created object | |
user_tag_permission_rules_v | data_canhave_tags | varchar | 1024 | √ | null | Data tags that the user can have | |
user_tag_permission_rules_v | data_musthave_tags | varchar | 1024 | √ | null | Data tags that the user must have | |
user_tag_permission_rules_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
user_tag_permission_rules_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
user_tag_permission_rules_v | is_enabled | bool | 1 | √ | null | TRUE indicates that the permission rule is enabled | |
user_tag_permission_rules_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
user_tag_permission_rules_v | rule_id | uuid | 2147483647 | √ | null | Identifier of Tag Permission | |
user_tag_permission_rules_v | user_canhave_tags | varchar | 1024 | √ | null | Tags that the user can have | |
user_tag_permission_rules_v | user_musthave_tags | varchar | 1024 | √ | null | Tags that the user must have | |
user_tag_state | created_by | int4 | 10 | √ | null | User who created object | |
user_tag_state | date_created | timestamptz | 35,6 | Date the entry was created | |||
user_tag_state | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
user_tag_state | modified_by | int4 | 10 | √ | null | User who last modified object | |
user_tag_state | tag_name | varchar | 255 | Name of the tag for User state | |||
user_tag_state | user_id | int4 | 10 | User identifier | |||
user_tag_state_v | created_by | int4 | 10 | √ | null | User who created object | |
user_tag_state_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
user_tag_state_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
user_tag_state_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
user_tag_state_v | tag_name | varchar | 255 | √ | null | Name of the tag for User state | |
user_tag_state_v | user_id | int4 | 10 | √ | null | User identifier | |
users | auth_dn | varchar | 256 | √ | null | Authentication domain | |
users | auth_source | varchar | 32 | √ | 'DATABASE'::character varying | Authentication source | |
users | cell | varchar | 64 | √ | null | Mobile number of the user contact | |
users | created_by | int4 | 10 | √ | null | User who created object | |
users | date_created | timestamptz | 35,6 | Date the entry was created | |||
users | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
users | department | varchar | 128 | √ | null | Department that user belongs to | |
users | description | varchar | 512 | √ | null | Comments | |
users | varchar | 255 | √ | null | Emailid of the user | ||
users | given_name | varchar | 64 | √ | null | Entered user name | |
users | modified_by | int4 | 10 | √ | null | User who last modified object | |
users | name | varchar | 64 | Short name | |||
users | other | varchar | 64 | √ | null | Any extra information of the user | |
users | phone | varchar | 64 | √ | null | Contact number of the user | |
users | stt_id | int4 | 10 | Ref ID of the Status Indicator of the user | |||
users | surname | varchar | 64 | √ | null | Surname of the user | |
users | system_user | bool | 1 | √ | false | True if the user is system user | |
users | title | varchar | 128 | √ | null | Title of the user | |
users | upper_name | varchar | 64 | √ | null | User's Name in capital letter | |
users | usr_id | int4 | 10 | Id of the user 1-Admin | |||
users_rpt_v | auth_dn | varchar | 256 | √ | null | Authentication domain | |
users_rpt_v | auth_source | varchar | 32 | √ | null | Authentication source | |
users_rpt_v | cell | varchar | 64 | √ | null | Mobile number of the user contact | |
users_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
users_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
users_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
users_rpt_v | department | varchar | 128 | √ | null | Department that user belongs to | |
users_rpt_v | description | varchar | 512 | √ | null | Comments | |
users_rpt_v | varchar | 255 | √ | null | Emailid of the user | ||
users_rpt_v | given_name | varchar | 64 | √ | null | Entered user name | |
users_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
users_rpt_v | name | varchar | 64 | √ | null | Short name | |
users_rpt_v | other | varchar | 64 | √ | null | Any extra information of the user | |
users_rpt_v | phone | varchar | 64 | √ | null | Contact number of the user | |
users_rpt_v | stt_id | int4 | 10 | √ | null | Ref ID of the Status Indicator of the user | |
users_rpt_v | surname | varchar | 64 | √ | null | Surname of the user | |
users_rpt_v | system_user | bool | 1 | √ | null | True if the user is system user | |
users_rpt_v | title | varchar | 128 | √ | null | Title of the user | |
users_rpt_v | upper_name | varchar | 64 | √ | null | User's Name in capital letter | |
users_rpt_v | usr_id | int4 | 10 | √ | null | Id of the user 1-Admin | |
usr_account | account_guid | uuid | 2147483647 | √ | null | Replaced src_usr_id | |
usr_account | account_id | int8 | 19 | Account identifier | |||
usr_account | authority | varchar | 255 | User Authority, local or LDAP | |||
usr_account | begin_effective_date | timestamptz | 35,6 | √ | null | Begin effective date and time | |
usr_account | created_by | int4 | 10 | √ | null | User who created object | |
usr_account | current_f | bool | 1 | √ | null | Current flag | |
usr_account | cust_id | int8 | 19 | √ | null | Customer identifier | |
usr_account | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
usr_account | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
usr_account | end_effective_date | timestamptz | 35,6 | √ | null | End effective date and time | |
usr_account | identity_guid | uuid | 2147483647 | √ | null | Identity identifier | |
usr_account | modified_by | int4 | 10 | √ | null | User who last modified object | |
usr_account | usr_name | varchar | 255 | User name | |||
usr_account | usr_sts | varchar | 50 | √ | null | User status | |
usr_account_rpt_v | account_guid | uuid | 2147483647 | √ | null | Replaced src_usr_id | |
usr_account_rpt_v | account_id | int8 | 19 | √ | null | Account identifier | |
usr_account_rpt_v | begin_effective_date | timestamptz | 35,6 | √ | null | Begin effective date and time | |
usr_account_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
usr_account_rpt_v | current_f | bool | 1 | √ | null | Current flag | |
usr_account_rpt_v | cust_id | int8 | 19 | √ | null | Customer identifier | |
usr_account_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
usr_account_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
usr_account_rpt_v | end_effective_date | timestamptz | 35,6 | √ | null | End effective date and time | |
usr_account_rpt_v | identity_guid | uuid | 2147483647 | √ | null | Identity identifier | |
usr_account_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
usr_account_rpt_v | user_domain | varchar | 255 | √ | null | User Authority, local or LDAP | |
usr_account_rpt_v | user_name | varchar | 255 | √ | null | User name | |
usr_account_rpt_v | user_status | varchar | 50 | √ | null | User status | |
usr_account_trust | authority | varchar | 255 | Authority for user account | |||
usr_account_trust | created_by | int4 | 10 | √ | null | User who created object | |
usr_account_trust | current_state | bool | 1 | √ | null | Current Status of user account trust | |
usr_account_trust | cust_id | int8 | 19 | Customer identifier | |||
usr_account_trust | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
usr_account_trust | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
usr_account_trust | modified_by | int4 | 10 | √ | null | User who last modified object | |
usr_account_trust | src_trust_id | varchar | 255 | √ | null | Source Trust Identifier | |
usr_account_trust | trust_description | varchar | 1024 | √ | null | Trust description of user account | |
usr_account_trust | trust_id | int8 | 19 | User Account Trust identifier | |||
usr_account_trust | trust_name | varchar | 255 | Trust name of the user account | |||
usr_account_trust | trust_type_id | int4 | 10 | Trust Type identifier of user account | |||
usr_account_trust_assoc | account_id | uuid | 2147483647 | Reference to User Account Identifier | |||
usr_account_trust_assoc | created_by | int4 | 10 | √ | null | User who created object | |
usr_account_trust_assoc | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
usr_account_trust_assoc | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
usr_account_trust_assoc | modified_by | int4 | 10 | √ | null | User who last modified object | |
usr_account_trust_assoc | trust_id | int8 | 19 | Reference to Trust identifier | |||
usr_account_trust_history | account_id | uuid | 2147483647 | Reference to User Account Identifier | |||
usr_account_trust_history | begin_effective_date | timestamptz | 35,6 | √ | null | Begin effective date and time | |
usr_account_trust_history | created_by | int4 | 10 | √ | null | User who created object | |
usr_account_trust_history | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
usr_account_trust_history | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
usr_account_trust_history | end_effective_date | timestamptz | 35,6 | √ | null | End effective date and time | |
usr_account_trust_history | modified_by | int4 | 10 | √ | null | User who last modified object | |
usr_account_trust_history | trust_id | int8 | 19 | Reference to Trust identifier History | |||
usr_identity | created_by | int4 | 10 | √ | null | User who created object | |
usr_identity | cust_id | int8 | 19 | √ | null | Customer identifier | |
usr_identity | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
usr_identity | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
usr_identity | department_name | varchar | 100 | √ | null | Department Name | |
usr_identity | dn | varchar | 255 | Distinguished name | |||
usr_identity | first_name | varchar | 255 | √ | null | First name | |
usr_identity | full_name | varchar | 255 | √ | null | Full name | |
usr_identity | identity_guid | uuid | 2147483647 | Identity identifier | |||
usr_identity | job_title | varchar | 255 | √ | null | Job title | |
usr_identity | last_name | varchar | 255 | √ | null | Last name | |
usr_identity | mgr_guid | uuid | 2147483647 | √ | null | Manager identity identifier | |
usr_identity | modified_by | int4 | 10 | √ | null | User who last modified object | |
usr_identity | office_loc_cd | varchar | 100 | √ | null | Office Location Code | |
usr_identity | photo | text | 2147483647 | √ | null | Photo | |
usr_identity | primary_email | varchar | 255 | √ | null | Primary e-mail address | |
usr_identity | primary_phone | varchar | 100 | √ | null | Primary phone number | |
usr_identity | src_identity_id | varchar | 255 | √ | null | Source identity identifier | |
usr_identity | vault_name | varchar | 100 | √ | null | Identity vault name | |
usr_identity | wfid | varchar | 100 | √ | null | Workforce identifier | |
usr_identity_ext_attr | attribute_name | varchar | 255 | Attribute name | |||
usr_identity_ext_attr | attribute_value | varchar | 1024 | √ | null | Attribute value | |
usr_identity_ext_attr | identity_guid | uuid | 2147483647 | Identity identifier | |||
usr_identity_ext_attr_rpt_v | attribute_name | varchar | 255 | √ | null | Attribute name | |
usr_identity_ext_attr_rpt_v | attribute_value | varchar | 1024 | √ | null | Attribute value | |
usr_identity_ext_attr_rpt_v | identity_guid | uuid | 2147483647 | √ | null | Identity identifier | |
usr_identity_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
usr_identity_rpt_v | cust_id | int8 | 19 | √ | null | Customer identifier | |
usr_identity_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
usr_identity_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
usr_identity_rpt_v | department_name | varchar | 100 | √ | null | Department Name | |
usr_identity_rpt_v | dn | varchar | 255 | √ | null | Distinguished name | |
usr_identity_rpt_v | first_name | varchar | 255 | √ | null | First name | |
usr_identity_rpt_v | full_name | varchar | 255 | √ | null | Full name | |
usr_identity_rpt_v | identity_guid | uuid | 2147483647 | √ | null | Identity identifier | |
usr_identity_rpt_v | job_title | varchar | 255 | √ | null | Job title | |
usr_identity_rpt_v | last_name | varchar | 255 | √ | null | Last name | |
usr_identity_rpt_v | mgr_guid | uuid | 2147483647 | √ | null | Manager identity identifier | |
usr_identity_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
usr_identity_rpt_v | office_loc_cd | varchar | 100 | √ | null | Office Location Code | |
usr_identity_rpt_v | photo | text | 2147483647 | √ | null | Photo | |
usr_identity_rpt_v | primary_email | varchar | 255 | √ | null | Primary e-mail address | |
usr_identity_rpt_v | primary_phone | varchar | 100 | √ | null | Primary phone number | |
usr_identity_rpt_v | src_identity_id | varchar | 255 | √ | null | Source identity identifier | |
usr_identity_rpt_v | vault_name | varchar | 100 | √ | null | Identity vault name | |
usr_identity_rpt_v | wfid | varchar | 100 | √ | null | Workforce identifier | |
usr_trust_type | created_by | int4 | 10 | √ | null | User who created object | |
usr_trust_type | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
usr_trust_type | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
usr_trust_type | modified_by | int4 | 10 | √ | null | User who last modified object | |
usr_trust_type | trust_type_id | int4 | 10 | Trust Type Identifier | |||
usr_trust_type | trust_type_name | varchar | 255 | Trust type name | |||
vendor_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
vendor_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
vendor_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
vendor_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
vendor_rpt_v | vendor_id | int8 | 19 | √ | null | Vendor identifier | |
vendor_rpt_v | vendor_name | varchar | 255 | √ | null | Vendor name | |
vndr | created_by | int4 | 10 | √ | null | User who created object | |
vndr | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
vndr | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
vndr | modified_by | int4 | 10 | √ | null | User who last modified object | |
vndr | vndr_id | int8 | 19 | Vendor identifier | |||
vndr | vndr_name | varchar | 255 | Vendor name | |||
vuln | application_protocol | varchar | 64 | √ | null | Application Protocol | |
vuln | assigned_vuln_severity | int4 | 10 | √ | null | Vulnerability Severity assigned | |
vuln | begin_effective_date | timestamptz | 35,6 | √ | null | Date from which the entry is valid | |
vuln | computed_vuln_severity | int4 | 10 | √ | null | Vulnerability Severity computed | |
vuln | created_by | int4 | 10 | √ | null | User who created object | |
vuln | date_created | timestamptz | 35,6 | Date the entry was created | |||
vuln | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
vuln | detected_os | varchar | 64 | √ | null | Operating system of scanned machine | |
vuln | detected_os_version | varchar | 64 | √ | null | Operating system version of scanned machine | |
vuln | end_effective_date | timestamptz | 35,6 | √ | null | Date until which the entry is valid | |
vuln | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln | network_protocol | int4 | 10 | √ | null | Network Protocol | |
vuln | port_name | varchar | 64 | √ | null | Port Name | |
vuln | port_number | int4 | 10 | √ | null | Port Number | |
vuln | rsrc_id | uuid | 2147483647 | Resource identifier | |||
vuln | scanned_app | varchar | 64 | √ | null | Application scanned for vulnerability | |
vuln | scanned_app_version | varchar | 64 | √ | null | Version of Application scanned for vulnerability | |
vuln | scanner_classification | varchar | 255 | √ | null | Scanner classification | |
vuln | vuln_description | text | 2147483647 | √ | null | Vulnerability description | |
vuln | vuln_id | uuid | 2147483647 | Vulnerability identifier | |||
vuln | vuln_module | varchar | 64 | √ | null | Vulnerability Module | |
vuln | vuln_name | varchar | 300 | √ | null | Vulnerability Name | |
vuln | vuln_solution | text | 2147483647 | √ | null | Vulnerability solution | |
vuln | vuln_summary | varchar | 1000 | √ | null | Vulnerability summary | |
vuln | vuln_taxonomy | varchar | 1000 | √ | null | Vulnerability Taxanomy | |
vuln | vuln_user_domain | varchar | 64 | √ | null | Domain of user used by scanned | |
vuln | vuln_user_name | varchar | 64 | √ | null | Username used by scanner | |
vuln_calc_severity_rpt_v | assigned_vuln_severity | int4 | 10 | √ | null | Vulnerability Severity assigned | |
vuln_calc_severity_rpt_v | calc_severity | numeric | 131089 | √ | null | Severity calculation | |
vuln_calc_severity_rpt_v | criticality | int4 | 10 | √ | null | Criticality | |
vuln_calc_severity_rpt_v | host_name | text | 2147483647 | √ | null | Host name | |
vuln_calc_severity_rpt_v | ip | text | 2147483647 | √ | null | IP address | |
vuln_calc_severity_rpt_v | rsrc_id | uuid | 2147483647 | √ | null | Resource identifier | |
vuln_calc_severity_rpt_v | vuln_count | int8 | 19 | √ | null | Vulnerability count | |
vuln_code | created_by | int4 | 10 | √ | null | User who created object | |
vuln_code | date_created | timestamptz | 35,6 | Date the entry was created | |||
vuln_code | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
vuln_code | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_code | url | varchar | 512 | √ | null | Web URL | |
vuln_code | vuln_code_id | uuid | 2147483647 | Vulnerability code identifier | |||
vuln_code | vuln_code_type | varchar | 64 | √ | null | Vulnerability code type | |
vuln_code | vuln_code_value | varchar | 255 | √ | null | Vulnerability code value | |
vuln_code | vuln_id | uuid | 2147483647 | Vulnerability identifier | |||
vuln_code_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
vuln_code_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
vuln_code_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
vuln_code_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_code_rpt_v | url | varchar | 512 | √ | null | Web URL | |
vuln_code_rpt_v | vuln_code_id | uuid | 2147483647 | √ | null | Vulnerability code identifier | |
vuln_code_rpt_v | vuln_code_type | varchar | 64 | √ | null | Vulnerability code type | |
vuln_code_rpt_v | vuln_code_value | varchar | 255 | √ | null | Vulnerability code value | |
vuln_code_rpt_v | vuln_id | uuid | 2147483647 | √ | null | Vulnerability identifier | |
vuln_info | created_by | int4 | 10 | √ | null | User who created object | |
vuln_info | date_created | timestamptz | 35,6 | Date the entry was created | |||
vuln_info | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
vuln_info | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_info | vuln_id | uuid | 2147483647 | Vulnerability identifier | |||
vuln_info | vuln_info_id | uuid | 2147483647 | Vulnerability info identifier | |||
vuln_info | vuln_info_type | varchar | 36 | √ | null | Vulnerability info type | |
vuln_info | vuln_info_value | varchar | 2000 | √ | null | Vulnerability info value | |
vuln_info_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
vuln_info_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
vuln_info_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
vuln_info_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_info_rpt_v | vuln_id | uuid | 2147483647 | √ | null | Vulnerability identifier | |
vuln_info_rpt_v | vuln_info_id | uuid | 2147483647 | √ | null | Vulnerability info identifier | |
vuln_info_rpt_v | vuln_info_type | varchar | 36 | √ | null | Vulnerability info type | |
vuln_info_rpt_v | vuln_info_value | varchar | 2000 | √ | null | Vulnerability info value | |
vuln_rpt_v | application_protocol | varchar | 64 | √ | null | Application Protocol | |
vuln_rpt_v | assigned_vuln_severity | int4 | 10 | √ | null | Vulnerability Severity assigned | |
vuln_rpt_v | begin_effective_date | timestamptz | 35,6 | √ | null | Date from which the entry is valid | |
vuln_rpt_v | computed_vuln_severity | int4 | 10 | √ | null | Vulnerability Severity computed | |
vuln_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
vuln_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
vuln_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
vuln_rpt_v | detected_os | varchar | 64 | √ | null | Operating system of scanned machine | |
vuln_rpt_v | detected_os_version | varchar | 64 | √ | null | Operating system version of scanned machine | |
vuln_rpt_v | end_effective_date | timestamptz | 35,6 | √ | null | Date until which the entry is valid | |
vuln_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_rpt_v | network_protocol | int4 | 10 | √ | null | Network Protocol | |
vuln_rpt_v | port_name | varchar | 64 | √ | null | Port Name | |
vuln_rpt_v | port_number | int4 | 10 | √ | null | Port Number | |
vuln_rpt_v | rsrc_id | uuid | 2147483647 | √ | null | Resource identifier | |
vuln_rpt_v | scanned_app | varchar | 64 | √ | null | Application scanned for vulnerability | |
vuln_rpt_v | scanned_app_version | varchar | 64 | √ | null | Version of Application scanned for vulnerability | |
vuln_rpt_v | scanner_classification | varchar | 255 | √ | null | Scanner classification | |
vuln_rpt_v | vuln_description | text | 2147483647 | √ | null | Vulnerability description | |
vuln_rpt_v | vuln_id | uuid | 2147483647 | √ | null | Vulnerability identifier | |
vuln_rpt_v | vuln_module | varchar | 64 | √ | null | Vulnerability Module | |
vuln_rpt_v | vuln_name | varchar | 300 | √ | null | Vulnerability Name | |
vuln_rpt_v | vuln_solution | text | 2147483647 | √ | null | Vulnerability solution | |
vuln_rpt_v | vuln_summary | varchar | 1000 | √ | null | Vulnerability summary | |
vuln_rpt_v | vuln_taxonomy | varchar | 1000 | √ | null | Vulnerability Taxanomy | |
vuln_rpt_v | vuln_user_domain | varchar | 64 | √ | null | Domain of user used by scanned | |
vuln_rpt_v | vuln_user_name | varchar | 64 | √ | null | Username used by scanner | |
vuln_rsrc | business_system | varchar | 128 | √ | null | Business System | |
vuln_rsrc | created_by | int4 | 10 | √ | null | User who created object | |
vuln_rsrc | criticality | int4 | 10 | √ | null | Criticality | |
vuln_rsrc | date_created | timestamptz | 35,6 | Date the entry was created | |||
vuln_rsrc | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
vuln_rsrc | department | varchar | 128 | √ | null | Department Name | |
vuln_rsrc | host_name | varchar | 255 | √ | null | Host name | |
vuln_rsrc | ip | varchar | 32 | IP address | |||
vuln_rsrc | location | varchar | 128 | √ | null | Location identifier | |
vuln_rsrc | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_rsrc | operational_environment | varchar | 64 | √ | null | Operational environment | |
vuln_rsrc | regulation | varchar | 128 | √ | null | Regulation | |
vuln_rsrc | regulation_rating | varchar | 64 | √ | null | Regulation rating | |
vuln_rsrc | rsrc_id | uuid | 2147483647 | Resource identifier | |||
vuln_rsrc | scanner_id | uuid | 2147483647 | Scanner identifier | |||
vuln_rsrc_rpt_v | business_system | varchar | 128 | √ | null | Business System | |
vuln_rsrc_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
vuln_rsrc_rpt_v | criticality | int4 | 10 | √ | null | Criticality | |
vuln_rsrc_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
vuln_rsrc_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
vuln_rsrc_rpt_v | department | varchar | 128 | √ | null | Department Name | |
vuln_rsrc_rpt_v | host_name | varchar | 255 | √ | null | Host name | |
vuln_rsrc_rpt_v | ip | varchar | 32 | √ | null | IP address | |
vuln_rsrc_rpt_v | location | varchar | 128 | √ | null | Location identifier | |
vuln_rsrc_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_rsrc_rpt_v | operational_environment | varchar | 64 | √ | null | Operational environment | |
vuln_rsrc_rpt_v | regulation | varchar | 128 | √ | null | Regulation | |
vuln_rsrc_rpt_v | regulation_rating | varchar | 64 | √ | null | Regulation rating | |
vuln_rsrc_rpt_v | rsrc_id | uuid | 2147483647 | √ | null | Resource identifier | |
vuln_rsrc_rpt_v | scanner_id | uuid | 2147483647 | √ | null | Scanner identifier | |
vuln_rsrc_scan | created_by | int4 | 10 | √ | null | User who created object | |
vuln_rsrc_scan | date_created | timestamptz | 35,6 | Date the entry was created | |||
vuln_rsrc_scan | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
vuln_rsrc_scan | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_rsrc_scan | rsrc_id | uuid | 2147483647 | Resource identifier | |||
vuln_rsrc_scan | scan_id | uuid | 2147483647 | Vulnerability scan identifier | |||
vuln_rsrc_scan_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
vuln_rsrc_scan_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
vuln_rsrc_scan_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
vuln_rsrc_scan_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_rsrc_scan_rpt_v | rsrc_id | uuid | 2147483647 | √ | null | Resource identifier | |
vuln_rsrc_scan_rpt_v | scan_id | uuid | 2147483647 | √ | null | Vulnerability scan identifier | |
vuln_scan | consolidation_server | varchar | 64 | √ | null | Consolidation server | |
vuln_scan | created_by | int4 | 10 | √ | null | User who created object | |
vuln_scan | date_created | timestamptz | 35,6 | Date the entry was created | |||
vuln_scan | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
vuln_scan | load_status | varchar | 64 | √ | null | Vulnerability Load status | |
vuln_scan | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_scan | scan_end_date | timestamptz | 35,6 | √ | null | Scan end date | |
vuln_scan | scan_id | uuid | 2147483647 | Vulnerability scan identifier | |||
vuln_scan | scan_start_date | timestamptz | 35,6 | √ | null | Scan start date | |
vuln_scan | scan_type | varchar | 10 | √ | null | Vulnerability scan type | |
vuln_scan | scanner_id | uuid | 2147483647 | Vulnerability scanner identifier | |||
vuln_scan_rpt_v | consolidation_server | varchar | 64 | √ | null | Consolidation server | |
vuln_scan_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
vuln_scan_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
vuln_scan_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
vuln_scan_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_scan_rpt_v | scan_end_date | timestamptz | 35,6 | √ | null | Scan end date | |
vuln_scan_rpt_v | scan_id | uuid | 2147483647 | √ | null | Vulnerability scan identifier | |
vuln_scan_rpt_v | scan_start_date | timestamptz | 35,6 | √ | null | Scan start date | |
vuln_scan_rpt_v | scan_type | varchar | 10 | √ | null | Vulnerability scan type | |
vuln_scan_rpt_v | scanner_id | uuid | 2147483647 | √ | null | Vulnerability scanner identifier | |
vuln_scan_vuln | created_by | int4 | 10 | √ | null | User who created object | |
vuln_scan_vuln | date_created | timestamptz | 35,6 | Date the entry was created | |||
vuln_scan_vuln | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
vuln_scan_vuln | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_scan_vuln | scan_id | uuid | 2147483647 | Vulnerability scan identifier | |||
vuln_scan_vuln | vuln_id | uuid | 2147483647 | Vulnerability identifier | |||
vuln_scan_vuln_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
vuln_scan_vuln_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
vuln_scan_vuln_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
vuln_scan_vuln_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_scan_vuln_rpt_v | scan_id | uuid | 2147483647 | √ | null | Vulnerability scan identifier | |
vuln_scan_vuln_rpt_v | vuln_id | uuid | 2147483647 | √ | null | Vulnerability identifier | |
vuln_scanner | created_by | int4 | 10 | √ | null | User who created object | |
vuln_scanner | date_created | timestamptz | 35,6 | Date the entry was created | |||
vuln_scanner | date_modified | timestamptz | 35,6 | Date the entry was modified | |||
vuln_scanner | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_scanner | product_name | varchar | 100 | √ | null | Product Name | |
vuln_scanner | product_version | varchar | 64 | √ | null | Product Version | |
vuln_scanner | scanner_id | uuid | 2147483647 | Vulnerability scanner identifier | |||
vuln_scanner | scanner_instance | varchar | 64 | √ | null | Scanner Instance | |
vuln_scanner | scanner_type | varchar | 64 | √ | null | Vulnerability Scanner Type | |
vuln_scanner | vendor | varchar | 100 | √ | null | Vendor | |
vuln_scanner_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
vuln_scanner_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
vuln_scanner_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
vuln_scanner_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
vuln_scanner_rpt_v | product_name | varchar | 100 | √ | null | Product Name | |
vuln_scanner_rpt_v | product_version | varchar | 64 | √ | null | Product Version | |
vuln_scanner_rpt_v | scanner_id | uuid | 2147483647 | √ | null | Vulnerability scanner identifier | |
vuln_scanner_rpt_v | scanner_instance | varchar | 64 | √ | null | Scanner Instance | |
vuln_scanner_rpt_v | scanner_type | varchar | 64 | √ | null | Vulnerability Scanner Type | |
vuln_scanner_rpt_v | vendor | varchar | 100 | √ | null | Vendor | |
workflow_def | created_by | int4 | 10 | √ | null | User who created object | |
workflow_def | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
workflow_def | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
workflow_def | modified_by | int4 | 10 | √ | null | User who last modified object | |
workflow_def | pkg_data | text | 2147483647 | √ | null | Package data | |
workflow_def | pkg_name | varchar | 255 | Package name | |||
workflow_def_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
workflow_def_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
workflow_def_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
workflow_def_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
workflow_def_rpt_v | pkg_data | text | 2147483647 | √ | null | Package data | |
workflow_def_rpt_v | pkg_name | varchar | 255 | √ | null | Package name | |
workflow_info | created_by | int4 | 10 | √ | null | User who created object | |
workflow_info | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
workflow_info | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
workflow_info | info_id | int8 | 19 | Info identifier | |||
workflow_info | modified_by | int4 | 10 | √ | null | User who last modified object | |
workflow_info | process_def_id | varchar | 100 | √ | null | Process definition identifier | |
workflow_info | process_instance_id | varchar | 150 | √ | null | Process instance identifier | |
workflow_info_rpt_v | created_by | int4 | 10 | √ | null | User who created object | |
workflow_info_rpt_v | date_created | timestamptz | 35,6 | √ | null | Date the entry was created | |
workflow_info_rpt_v | date_modified | timestamptz | 35,6 | √ | null | Date the entry was modified | |
workflow_info_rpt_v | info_id | int8 | 19 | √ | null | Info identifier | |
workflow_info_rpt_v | modified_by | int4 | 10 | √ | null | User who last modified object | |
workflow_info_rpt_v | process_def_id | varchar | 100 | √ | null | Process definition identifier | |
workflow_info_rpt_v | process_instance_id | varchar | 150 | √ | null | Process instance identifier |