Database Dictionary

This document provides Back-End administrators with a list of the table fields, which have been used in the Back-End database. A brief description is provided for each table field.

articleSections

This table is used to store all article section and category information.

Field Type Length Attributes Null Default Extra
             
articleSectionID bigint 21 UNSIGNED No   auto_increment
urlName varchar 255        
name varchar 255        
underarticleSectionID bigint 21        
template varchar 55        
showCategories bigint 21        
showArticles bigint 21        
content blob          
alt_name varchar 255        
alt_content blob          
alt_template varchar 55        
meta_keywords varchar 255        
meta_description varchar 255        

articles

This table is used to store all article information, one or more articles are associated with an article section and a specific user.

Field Type Length Attributes Null Default Extra
             
articleID bigint 21 UNSIGNED No   auto_increment
articleSectionID bigint 21        
uid bigint 21        
title bigint 21        
content blob          
image_suffix varchar 4        
date bigint 21        
alt_title varchar 255        
alt_content blob          
meta_keywords varchar 255        
meta_description varchar 255        

guestbook

This table is used to store the guest book information.

Field Type Length Attributes Null Default Extra
             
id int 4   No   auto_increment
name varchar 50   No    
email varchar 50   No    
homepage varchar 200   No    
gb_subject varchar 200   No    
comment blob     No    
date date     yes 0000-00-00  
timestamp timestamp 14   yes    

images

This table is used to store uploaded image information.

Field Type Length Attributes Null Default Extra
             
id int 4 UNSIGNED No   auto_increment
name varchar 50        
description varchar 50        

linkSections

This table is used to store the link section information.

Field Type Length Attributes Null Default Extra
             
linkSectionID bigint 21 UNSIGNED No   auto_increment
name varchar 255        
priority bigint 21   No 0  
alt_name varchar 255        

links

This table is used to store the links information, one or more links are associated with a link section.

Field Type Length Attributes Null Default Extra
             
linkID bigint 21 UNSIGNED No   auto_increment
name varchar 255        
priority bigint 21 UNSIGNED   0  
linkSectionID bigint 21        
link varchar 255        
description varchar 255        
alt_name varchar 255        
alt_description varchar 255        

navigation

This table is used to store the site navigation information.

Field Type Length Attributes Null Default Extra
             
id int 4   No   auto_increment
navID bigint 21 UNSIGNED No 0  
nav varchar 50        
link varchar 100        
alt_nav varchar 50        

user

This table is used to store all user account information.

Field Type Length Attributes Null Default Extra
             
uid bigint 21 UNSIGNED No   auto_increment
session varchar 50     0  
login varchar 50        
user_password varchar 50        
email varchar 50   No    
type enum          
display_name varchar 50        
visit bigint 21 UNSIGNED      
history timestamp 14