Table schema_generation.salemaker_sales
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
sale_id int 11  √ 
sale_status tinyint 4 0
sale_name varchar 30
sale_deduction_value decimal 15,4 0.0000
sale_deduction_type tinyint 4 0
sale_pricerange_from decimal 15,4 0.0000
sale_pricerange_to decimal 15,4 0.0000
sale_specials_condition tinyint 4 0
sale_categories_selected varchar 255  √  null
sale_categories_all varchar 255  √  null
sale_date_start date 10 0000-00-00
sale_date_end date 10 0000-00-00
sale_date_added date 10 0000-00-00
sale_date_last_modified date 10 0000-00-00
sale_date_status_change date 10 0000-00-00

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

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