Which gtrep database tables are used for storing a reservation

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Which gtrep database tables are used for recording a reservation. 

Environment

Release : 4.9 and above

Component : Web Portal - Find & Reserve

Resolution

The main table in the gtrep database that has the userid, start date, end date, project and version is test_data_reservation.
The objects that are reserved are stored in the gtrep table test_data_reservation_lob
In test_data_reservation_lob there is one record for all objects reserved in the reservation.
If Data Prefetch is set to off, there is also a table <column>_reservations in the same database that has the data.
For example dept_reservations if the main column for the reservation is dept.
It has one record for each dept key that has a reservation.

Additional Information

In Find & Reserve confirm that there is a model available in the project being used.
The 'version' of the model should be 'new' and not 'legacy' for the reservation tables in gtrep to be used. 
The tables defined in the model content should have a primary key for good performance when making a reservation.

Note that Remove prefetched data from gtrep database shows that the following tables are used for prefetch:
test_data_model;
data_view_property;
data_view_instance;
data_view;
schema_version_find_reserve;    
dvid_%