Database Structure
To produce valid SQL statements you will need to understand the contents of the database tables and their relationships to one another.
For more information submitting an SQL Search Type, see "Perform a Search Using an SQL Query" (page n).
PlanetPress Search database structure.
|
Tables |
Values and Relationships |
|
Table_Doc_# |
PlanetPress Search index values (INDEX_#) are associated with the page number (Page_Number) in the PDF (PDF_ID) they appear in. Each of the PlanetPress documents that generate a PDF which PlanetPress Search can query has a unique Table_Doc_# table. |
|
Table_Document |
PlanetPress documents are associated to a unique Doc_ID integer. The integer is then included in the Table_Doc_# table naming convention generated for the document. |
|
Table_Index |
Index_Id integers are associated to their labels (Index_Name) as defined in the PlanetPress documents. The integer is then included in the INDEX_# field naming convention generated for the Table_Doc_# table. |
|
Table_PDF |
PDF_ID integers are associated to a Doc_ID integer provided by the Table_Document table, and a Path_ID integer in the Table_Path table. |
|
Table_Path |
Path_ID integers are associated to the Path of each of the PDFs that are included in the database. |