Table zot.app 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 int 10  √ 
notify.id Implied Constraint R
app_id char 255
app_sig char 255
app_author char 255
app_name char 255
app_desc text 65535
app_url char 255
app_photo char 255
app_version char 255
app_channel int 10 0
app_addr char 255
app_price char 255
app_page char 255
app_requires char 255
app_created datetime 19 0000-00-00 00:00:00
app_edited datetime 19 0000-00-00 00:00:00

Table contained 4 rows at fr nov 06 17:11 CET 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
app_channel Performance Asc app_channel
app_created Performance Asc app_created
app_edited Performance Asc app_edited
app_id Performance Asc app_id
app_name Performance Asc app_name
app_photo Performance Asc app_photo
app_price Performance Asc app_price
app_url Performance Asc app_url
app_version Performance Asc app_version

Close relationships: