Chapter 4. Database structure 81
Figure 4-1   Application group identifier example
Table 4-3 shows the first five columns of the application group data table structure.
Table 4-3   AG_internal_id table structure
The application group data table is indexed on one or more of the user-defined fields, from 
field_1 to field_n.
Four major factors influence the amount of storage that is needed for the Content Manager 
OnDemand database:
/SM590000The number of index and filter fields
/SM590000The size of the index and filter fields
/SM590000The number of indexed items per month
/SM590000The number of months (years) Content Manager OnDemand keeps the indexes in the 
database
Column 
name
Data 
type
Size Index Description
field_1 Varies Varies N First user-defined field in the application group.
field_n Varies Varies N Last user-defined field in the application group. Y ou 
can have up to 128 index fields that are defined in 
Content Manager OnDemand.
doc-name varchar 11 Y Document name (object name).
doc_off integer 4 N Document that is offset in the object.
doc_len integer 4 N Document length.