Table ossmole_merged.projects
InnoDB free: 59653120 kB

Generated by
SchemaSpy
Implied relationships 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
proj_unixname varchar 100
forge_id int 11 0
url varchar 255  √ 
real_url varchar 255  √  null
date_registered datetime 19  √  0000-00-00 00:00:00
proj_long_name varchar 255  √ 
proj_description varchar 255  √ 
proj_id_num int unsigned 10  √  0
added_by_script varchar 100  √ 
dev_count int unsigned 10  √  null
lifespan int unsigned 10  √  null
downloads_all_time bigint unsigned 15  √  null
pageviews_all_time bigint unsigned 15  √  null
date_collected datetime 19 0000-00-00 00:00:00
datasource_id int 11 0
datasources.datasource_id Implied Constraint

Table contained 1,576,300 rows at Mon Apr 30 12:51 EDT 2007

Indexes:
Column(s) Type Sort Constraint Name
datasource_id + forge_id + proj_unixname Primary key Asc/Asc/Asc PRIMARY
dev_count Performance Asc dev_count
proj_unixname Performance Asc proj_unixname

Close relationships: