Automation Example: Documentation Page

The following sections describe the schema of the database created through the SQL backend.

Table STRINGS

Strings in the code.

Field name Field type Value description
FIDINTEGERFile key (references FILES)
FOFFSETINTEGEROffset within the file
STRINGCHARACTER VARYINGThe string, including its delimiters

Table LINEPOS

Line number offsets within each file.

Field name Field type Value description
FIDINTEGERFile key (references FILES)
FOFFSETINTEGEROffset within the file
LNUMINTEGERLine number (starts at 1)

Table PROJECTS

Project details.

Field name Field type Value description
PIDINTEGERUnique project key
NAMECHARACTER VARYINGProject name

Table FCALLS

Function calls.

Field name Field type Value description
SOURCEIDINTEGERCalling function identifier key (references FUNCTIONS)
DESTIDINTEGERCalled function identifier key (references FUNCTIONS)

Creative Commons License  Last change: Wednesday, August 23, 2006 3:54 pm
 Unless otherwise expressly stated, all original material on this page created by Diomidis Spinellis is licensed under a Creative Commons Attribution-Share Alike 3.0 Greece License.