ER diagrams

From Open Source Software Research

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

These are implicit, not enforced foreign keys. Most of the primary keys are explicit. These are not "complete" diagrams because some historical tables may implicitly link to one of the tables in a given diagram. Those shown are the "core" tables for a particular category of tables. All diagrams are courtesy of Scott Christley.

Contents 1 Artifact 2 Doc 3 Forum 4 Frs 5 Job 6 Task

Artifact

• artifact
• artifact_category
• artifact_file
• artifact_group
• artifact_group_list
• artifact_history
• artifact_message
• artifact_perm
• artifact_resolution
• artifact_status
• users
• groups

Doc

• doc_data
• doc_groups
• doc_states
• groups
• supported_languages
• users

Forum

• forum
• forum_group_list
• groups
• users

Frs

• frs_file
• frs_filetype
• frs_package
• frs_processor
• frs_release
• frs_status
• groups
• users

Job

• groups
• people_job
• people_job_category
• people_job_inventory
• people_job_status
• people_skill_level
• people_skill_year
• users

Task

• groups
• project_assigned_to
• project_dependencies
• project_group_list
• project_history
• project_status
• project_task
• users