|
This entity would record all the possible queries used by the user after a successful login. This entity would also record the type of query used, the Quick query or the Custom query. The query record can only use one type of query, but can store both queries. The storage of the query is in the Query and Custom Query, actual SQL is recorded. When the query type is for a quick query, it would retrieve or store the actual SQL statement from the attribute Query. Otherwise, it would retrieve or store the actual SQL statement from the Custom Query. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
Yes |
|
This attribute would record the identity of the list of queries belonging to a particular user. This is also the primary key for the AdHocQueryRec table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(150) |
|
Mandatory |
No |
|
Stores a description about the query record. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
Shows the type of query. |
|
Name |
|
|
Code |
|
|
Data Type |
char(8192) |
|
Mandatory |
No |
|
This attribute records the actual SQL query that will be executed by the program for any custom query. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
This attribute would act as a flag to separate out between security or adhoc's query. |
|
Name |
|
|
Code |
|
|
Data Type |
char(200) |
|
Mandatory |
No |
|
A custom query for the entity. |
|
|
|