Database & Structure
A complete list of SQL tables, fields and a description of their function.
Updated:
Tue, Apr 20, 2010
Best Viewed with . . .
. . . your computer will thank you!
. . . your computer will thank you!
SQL TABLES OVERVIEW:
Documents:
Primary table for all pages. A number of fields to support various functions of the code base, but the primary thing to remember about this table is the it stores the main content, title and description text for each web page. Each page has its own record and ID value in this table.
Categories:
Used primarily for navigation, the table contains the titles and link URLs for the left hand navigation elements.
Database table and fields reference details:
Documents:
`DocID` int(11),
`CatID` int(11),
`TitleShort` varchar(45),
`SEOKeyWords` varchar(128),
`SEODescription` varchar(255),
`TitleLong` varchar(255),
`DocText` longtext,
`DateCreate` datetime,
`DateMod` timestamp,
`UserCreate` varchar(45),
`UserMod` varchar(45),
`PgStatus` tinyint(4)
Categories:
`CatID` smallint(6),
`CategoryName` varchar(40),
`CategoryDesc` varchar(255)