How does Retain store the data? [All editions]
Return to Introduction Previous Topic Next page

Planner, Standard, Notes, DBI and Client-Server

Most versions of Retain store the core data in 5 files or tables:

ResRes – stores the resource information     
ResTask – stores the job information  
ResBook – stores the booking information  
ResComp – stores the component information  
ResChrg – stores charge rate information  

In Retain Standard these are FoxPro files (.dbf files), in Retain for Notes they are Notes datafiles (.nsf files), and in Retain Planner, the DataBase Independent version (DBI), the Client-Server version, these become tables in the database.    

Enterprise

In the Retain Enterprise edition the core tables have different names, and the structure is a little more complicated, but the fundamental structure is similar, the RES tables stores resource information, the JOB tables stores job information and the BKG table stores booking information.