Table studip30.banner_ads Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_id varchar 32
banner_path varchar 255
description varchar 255  √  null
alttext varchar 255  √  null
target_type enum 7 url
target varchar 255
startdate int 10 0
enddate int 10 0
priority int 10 0
views int 10 0
clicks int 10 0
mkdate int 10 0
chdate int 10 0

Table contained 0 rows at Do Aug 02 15:05 GMT+01:00 2018

Indexes:
Column(s) Type Sort Constraint Name
ad_id Primary key Asc PRIMARY