This quick reference will explain all the database tables used in Projectfork. You can pull any information from the database with either the Joomla database object, or the Projectfork database object (which is just a wrapper for the J db). For information on how to work with these classes, please visit the Joomla documentation page.

Getting the Joomla database object:

$db = &Factory::getDBO();

Getting the Projectfork database object:

Use this object for max. compatibility in future PF releases.

$db = &$pf_core->get('_db');

Tables used in Projectfork

• jos_pf_access_flags - Stores all user flags
• jos_pf_access_levels - Stores all user access levels
• jos_pf_comments - Stores all text comments (eg. on tasks or notes)
• jos_pf_events - Stores all calendar events
• jos_pf_files - Stores upload information for the file manager
• jos_pf_folders - Stores all folders for the file manager
• jos_pf_folder_tree - Maps folder parent/child relations
• jos_pf_groups - Stores all groups
• jos_pf_group_permissions - Stores all group permissions
• jos_pf_group_users - Maps users to groups
• jos_pf_languages - Stores all installed language packs
• jos_pf_milestones - Stores all task milestones
• jos_pf_mods - Stores all installed mods
• jos_pf_mod_data - Maps files to mods
• jos_pf_notes - Stores all notes from the file manager
• jos_pf_panels - Stores all installed panels
• jos_pf_processes - Stores all installed processes
• jos_pf_projects - Stores all project information
• jos_pf_project_invitations - Stores all project invitations
• jos_pf_project_members - Maps users to projects
• jos_pf_sections - Stores information about all installed sections
• jos_pf_section_tasks - Stores all valid tasks for each section
• jos_pf_settings - Stores all settings in PF
• jos_pf_tasks - Stores all project tasks information
• jos_pf_task_attachments - Maps attachments (folder, notes, files) to tasks
• jos_pf_task_users - Maps assigned users to tasks
• jos_pf_themes - Stores information about all installed themes
• jos_pf_topics - Stores all board topics
• jos_pf_topic_replies - Stores all topic replies
• jos_pf_topic_subscriptions - Stores all topic subscriptions
• jos_pf_user_access_level - Stores the access level for each user per project
• jos_pf_user_profile - Stores the user profile settings

Related items

• File structure