Table descriptions

From Open Source Software Research
Jump to: navigation, search
Schemas
• January 2003 - sf0103
• November 2004 - sf1104
• December 2004 - sf1204
• February 2005 - sf0205
• March 2005 - sf0305
• April 2005 - sf0405
• May 2005 - sf0505
• June 2005 - sf0605
• July 2005 - sf0705
• August 2005 - sf0805
• September 2005 - sf0905
• October 2005 - sf1005
• November 2005 - sf1105
• December 2005 - sf1205
• January 2006 - sf0106
• February 2006 - sf0206
• March 2006 - sf0306
• April 2006 - sf0406
• May 2006 - sf0506
• June 2006 - sf0606
• July 2006 - sf0706
• August 2006 - sf0806
• September 2006 - sf0906
• October 2006 - sf1006
• November 2006 - sf1106
• December 2006 - sf1206
• January 2007 - sf0107
• February 2007 - sf0207
• March 2007 - sf0307
• April 2007 - sf0407
• May 2007 - sf0507
• June 2007 - sf0607
• July 2007 - sf0707
• August 2007 - sf0807
• September 2007 - sf0907
• October 2007 - sf1007
• November 2007 - sf1107
• December 2007 - sf1207
• January 2008 - sf0108
• February 2008 - sf0208
• March 2008 - sf0308
• April 2008 - sf0408
• May 2008 - sf0508
• June 2008 - sf0608
• July 2008 - sf0708
• August 2008 - sf0808
• September 2008 - sf0908
• October 2008 - sf1008
• November 2008 - sf1108
• December 2008 - sf1208
• January 2009 - sf0109
• February 2009 - sf0209
• March 2009 - sf0309
• April 2009 - sf0409
• May 2009 - sf0509
• June 2009 - sf0609
• July 2009 - sf0709
• August 2009 - sf0809
• September 2009 - sf0909
• October 2009 - sf1009
• November 2009 - sf1109
• December 2009 - sf1209
• January 2010 - sf0110
• February 2010 - sf0210
• March 2010 - sf0310
• April 2010 - sf0410
• May 2010 - sf0510
• June 2010 - sf0610
• July 2010 - sf0710
• August 2010 - sf0810
• September 2010 - sf0910
• October 2010 - sf1010
• November 2010 - sf1110
• December 2010 - sf1210
• January 2011 - sf0111
• February 2011 - sf0211
• March 2011 - sf0311
• April 2011 - sf0411
• May 2011 - sf0511
• June 2011 - sf0611
• July 2011 - sf0711
• August 2011 - sf0811
• September 2011 - sf0911
• October 2011 - sf1011
• November 2011 - sf1111
• December 2011 - sf1211
• December 2011 - sf1211
• January 2012 - sf0112
• February 2012 - sf0212
• March 2012 - sf0312
• April 2012 - sf0412
• May 2012 - sf0512
• June 2012 - sf0612
• July 2012 - sf0712
• August 2012 - sf0812
• September 2012 - sf0912
• October 2012 - sf1012
• November 2012 - sf1112
• December 2012 - sf1212
• January 2013 - sf0113
• February 2013 - sf0213
• August 2013 - sf0813
• September 2013 - sf0913
• October 2013 - sf1013
• November 2013 - sf1113
• December 2013 - sf1213
• January 2014 - sf0114
• February 2014 - sf0214
• March 2014 - sf0314
• May 2014 - sf0514
• June 2014 - sf0614
• July 2014 - sf0714
• August 2014 - sf0814
• September 2014 - sf0914
Through November 2007:
Table Description
*activity_log
*activity_log_old
*activity_log_old_old
*activity_log_regs
*activity_log_regs_tmp
*admin_annotations
*artifact
*artifact_canned_responses
*artifact_category
*artifact_counts_agg
*artifact_file
*artifact_ftispool
*artifact_group
*artifact_group_list
*artifact_history
*artifact_message
*artifact_monitor
*artifact_perm
*artifact_resolution
*artifact_status
*audit_trail
*audit_trail_data
*audit_trail_group
*audit_trail_group_data
*audit_trail_user
*autopurge_exempt
*autopurge_projects
*beta_members
*beta_offerings
*blocks
*cache_store
*canned_responses
*category_management
*charities
*cloudscape_answers
*cloudscape_contest
*cronjob_history
*db_images
*doc_data
*doc_groups
*doc_states
*dup_emails
*entity_charity
*external_tool_links
*filemodule_monitor
*finance_audit
*foo
*forum
*forum_agg_msg_count
*forumemail
*forum_ftispool_new
*forum_group_list
*forum_monitored_forums
*forum_saved_place
*forum_threadinfo
*foundry_data
*foundry_news
*foundry_preferred_projects
*foundry_project_downloads_agg
*foundry_project_rankings_agg
*foundry_projects
*frs_dlstats_file_agg
*frs_dlstats_filetotal_agg
*frs_dlstats_group_agg
*frs_dlstats_grouptotal_agg
*frs_file
*frs_filetype
*frs_package
*frs_platform
*frs_processor
*frs_release
*frs_snapshots
*frs_status
*group_donation_optout
*group_history
*groups
*groups_historical
*groups_moorman
*groups_registration
*group_type
*grp_fti
*imported_projects
*intel_agreement
*invalid_name
*kernel_traffic
*lucene_searchspool
*lucene_searchspool2
*mail_group_list
*massmail_queue
*mllist_subscriber
*mllist_subscriber_count
*money_in
*monitor_enable
*monitor_project
*moorman_defunct_unix_uids
*moorman_massmail_20060224
*moorman_massmail_20060511
*moorman_massmail_20060523b
*moorman_massmail_20060630
*moorman_massmail_20060630b
*moorman_massmail_20060908
*moorman_proj2
*moorman_sdmaillist
*moorman_sdmaillist2
*mypstat
*mysql_auth
*news_bytes
*ostg_contest
*payment_option
*people_job
*people_job_category
*people_job_inventory
*people_job_status
*people_skill
*people_skill_inventory
*people_skill_level
*people_skill_year
*pg72_bug
*pg_autovac_skip
*pg_stat_database_historical
*pg_ts_cfg
*pg_ts_cfgmap
*pg_ts_dict
*pg_ts_parser
*prdb_dbs
*prdb_states
*prdb_types
*project_assigned_to
*project_counts_weekly_tmp
*project_dependencies
*project_group_list
*project_history
*project_metric
*project_metric_tmp1
*project_metric_weekly_tmp1
*project_purge
*project_status
*project_sums_agg
*project_task
*project_weekly_metric
*prweb_vhost
*purge_history
*purge_queue
*ranking_tmp
*rating
*ref_timezones
*reputation
*scm_repo_trigger
*scm_trigger
*screenshots
*search_data_groups
*seller_profile_language
*seller_profile_payment_option
*service_contract
*service_listing
*service_listing_language
*service_listing_payment_option
*service_order
*session
*sfce_api_mapping
*snippet
*snippet_package
*snippet_package_item
*snippet_package_version
*snippet_version
*specialty
*stats_agg_logo_by_day
*stats_agg_logo_by_group
*stats_agg_pages_by_day
*stats_agg_site_by_group
*stats_cvs_group
*stats_cvs_user
*stats_fileid_alltime_agg
*stats_ftp_downloads
*stats_groupid_alltime_agg
*stats_group_rank
*stats_group_rank_alltime
*stats_group_rank_byday
*stats_group_rank_byday_0528
*stats_group_rank_byday_backup_050528
*stats_group_rank_byday_backup_050529
*stats_group_rank_bymonth
*stats_http_downloads
*stats_multi_rank_history_byday
*stats_outage_log
*stats_project
*stats_project_all
*stats_project_developers
*stats_project_developers_last30
*stats_project_last_30
*stats_project_metric
*stats_project_months
*stats_rank_oldformula_byday
*stats_sfweb_recent_hit
*stats_site
*stats_site_last_30
*stats_site_months
*stats_site_pages_by_day
*stats_subd_pages
*stats_toplist_week
*stats_trove_topic_activity
*subscriptions
*supported_languages
*survey_questions
*survey_question_types
*survey_rating_aggregate
*survey_rating_response
*survey_responses
*surveys
*svn_migration_log
*svn_migration_queue
*test1
*theme_prefs
*themes
*tmp_stats_fileid_alltime_agg_1118629848
*tmp_stats_fileid_alltime_agg_1140665539
*tmp_stats_fileid_alltime_agg_1142736917
*tmp_stats_fileid_alltime_agg_1145005244
*tmp_stats_fileid_alltime_agg_1147219524
*tmp_stats_fileid_alltime_agg_1151460886
*tmp_stats_fileid_alltime_agg_1155778896
*tmp_stats_fileid_alltime_agg_1156537400
*tmp_stats_fileid_alltime_agg_1158781396
*tmp_stats_groupid_alltime_agg_1117227330
*tmp_stats_group_rank_byday_1151598926
*top_group
*top_group_tmp
*trove_agg
*trove_agg_counts
*trove_agg_minix
*trove_agg_tmp
*trove_cat
*trove_cat_activity
*trove_frontpage
*trove_group_link
*trove_monitor
*trove_monitor_event_queue
*trove_ref_translation_to_iso639
*trove_treesums
*tshirt_codes
*user_auth_keys
*user_bookmarks
*user_diary
*user_diary_monitor
*user_group
*user_ip_dl_auth
*user_metric
*user_metric0
*user_metric_history
*user_perms
*user_preferences
*user_ratings
*user_role
*users
*users-bak_regs
*users_lookup
*users_registration