Table schema_generation.template
InnoDB free: 7168 kB

Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
template_id int 11  √ 
infobox_configuration.template_id infobox_configuration_ibfk_1
template_name varchar 64  √  0
date_added datetime 19  √  null
last_modified datetime 19  √  null
template_image varchar 64  √  null
template_cellpadding_main char 3 0
template_cellpadding_sub char 3 0
template_cellpadding_left char 3 0
template_cellpadding_right char 3 0
site_width varchar 5 100%
include_column_left varchar 64 yes
include_column_right varchar 64 yes
box_width_left varchar 4 125
box_width_right varchar 4 125
main_table_border varchar 6 no
active char 1 1
show_heading_title_original varchar 6 yes
languages_in_header char 3  √  no
cart_in_header char 3 no
show_header_link_buttons char 3 no
module_one varchar 64
module_two varchar 64
module_three varchar 64
module_four varchar 64
module_five varchar 64
module_six varchar 64
customer_greeting char 3 yes
edit_customer_greeting_personal text 65535
edit_customer_greeting_personal_relogon text 65535
edit_greeting_guest text 65535
side_box_left_width int 10  √  1
side_box_right_width int 10  √  1

Table contained 0 rows at Mon Jun 18 16:54 CDT 2007

Indexes:
Column(s) Type Sort Constraint Name
template_id Primary key Asc PRIMARY
template_name Performance Asc IDX_TEMPLATE_NAME

Close relationships  within one two degrees of separation :