Resources

Top Links • Query the Archive • Schema Browser • Research Data • Making Queries • Resources • Papers • Contact • FAQ • Schemas • All tables • Finding data • ER diagrams

Data Warehouse Table Definitions

• Data Warehouse Table Definitions (May 2005)
• Data Warehouse Table Definitions (September 2005)
  • Note: SourceForge.net implemented a large number of schema changes between August 2005 and September 2005. The September 2005 definitions should be comprehensive, but the May definitions file is provided as a historic record.
• Data Warehouse Table Definitions for schema sf0106 (Janauary 2006)
  • Note: See news item about the Autopurge Service from SourceForge.net News - Feb. 24, 2006

Deprecated Tables and Relations

• Table "SCHEMA.audit_trail_group_data" - Deprecated, Dec. 2004
• Table "SCHEMA.people_skill" - Deprecated, Nov. 2004
• View "SCHEMA.artifact_file_user_vw" - Deprecated, Aug. 2005
• View "SCHEMA.artifact_history_user_vw" - Deprecated, Aug. 2005
• View "SCHEMA.artifactperm_artgrouplist_vw" - Deprecated, Aug. 2005
• View "SCHEMA.artifactperm_user_vw" - Deprecated, Aug. 2005
• Table "SCHEMA.audit_trail_group_data" - Deprecated, Dec. 2004
• Table "SCHEMA.foundry_data" - Deprecated, Aug. 2005
• Table "SCHEMA.foundry_news" - Deprecated, Aug. 2005
• Table "SCHEMA.foundry_preferred_projects" - Deprecated, Aug. 2005
• Table "SCHEMA.foundry_project_downloads_agg" - Deprecated, Aug. 2005
• Table "SCHEMA.foundry_project_rankings_agg" - Deprecated, Aug. 2005
• Table "SCHEMA.foundry_projects" - Deprecated, Aug. 2005
• Table "SCHEMA.frs_dlstats_file_agg" - Deprecated, Aug. 2005
• Table "SCHEMA.frs_dlstats_filetotal_agg" - Deprecated, Aug. 2005
• Table "SCHEMA.frs_dlstats_group_agg" - Deprecated, Aug. 2005
• Table "SCHEMA.frs_dlstats_grouptotal_agg" - Deprecated, Aug. 2005
• Table "SCHEMA.groups_moorman" - Deprecated, Aug. 2005
• Table "SCHEMA.pgstattuple_type" - Deprecated, Aug. 2005
• Table "SCHEMA.project_metric" - Deprecated, Aug. 2005
• Table "SCHEMA.project_weekly_metric" - Deprecated, Aug. 2005
• Table "SCHEMA.search_data_groups" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_agg_logo_by_day" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_agg_logo_by_group" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_agg_pages_by_day" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_agg_site_by_group" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_ftp_downloads" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_http_downloads" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_project" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_project_developers" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_project_developers_last30" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_project_last_30" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_project_metric" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_project_months" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_site" - Deprecated, Aug. 2005
• View "SCHEMA.stats_site_all" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_site_last_30" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_site_months" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_site_pages_by_day" - Deprecated, Aug. 2005
• View "SCHEMA.stats_site_pages_by_month" - Deprecated, Aug. 2005
• Table "SCHEMA.stats_subd_pages" - Deprecated, Aug. 2005
• Table "SCHEMA.tsdebug" - Deprecated, Aug. 2005

(Not a comprehensive list)

SourceForge.net ER-Diagram

• SourceForge.net ER-Diagram (multi-page format)
• SourceForge.net ER-Diagram (single-page format)

Schemas Currently Available

January 2003 (sf0103) - present

Schemas follow the format sfmmyy.

See the schema browser for detailed information on each schema and its tables.

See Schemas for a comprehensive list of all available schemas.