Table a7e12882.upgrade_history 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
id char 36
filename varchar 255  √  null
md5sum varchar 32  √  null
type varchar 30  √  null
status varchar 50  √  null
version varchar 64  √  null
name varchar 255  √  null
description text 65535  √  null
id_name varchar 255  √  null
manifest longtext 2147483647  √  null
patch text 65535  √  null
date_entered datetime 19  √  null
date_modified datetime 19  √  null
published_date varchar 50  √  null
uninstallable bit 1  √  1
enabled bit 1  √  1
deleted bit 1  √  0

Analyzed at Tue Jun 30 08:03 UTC 2020

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
md5sum Must be unique Asc upgrade_history_md5_uk This unique column is also nullable