Database – Special Report Entity (special_report_entity)
Holds information for custom queries.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
name | varchar(100) | Entity name | ||
description | varchar(250) | The description of the entity instance | ||
query | text | Query used to select entities to process | ||
query_filters | text | Filters used to refine results | ||
template | text | report template | ||
format | char(3) | report format | ||
separator | char(1) | report separator | ||
headers | tinyint(1) | Whether or not to include headers | 1 - yes, 0 - no | |
summary_file | tinyint(1) | Whether or not is summary file | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |