Table ossmole_merged.developer_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
dev_loginname varchar 100
proj_unixname varchar 100
is_admin int 1  √  null
position varchar 100  √  null
date_collected datetime 19 0000-00-00 00:00:00
datasource_id int 11 0
datasources.datasource_id Implied Constraint

Table contained 3,044,741 rows at Mon Apr 30 12:51 EDT 2007

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

Close relationships: