Analysis185
From Dokeos
This is the analysis of the functions and structure of the 1.8.5 dokeos
Contents |
Functions
- Users
- Personal Agenda
- Courses
- Documents
- Learning Path
- Exercises
- Assignments
- Surveys
- Links
- Agenda
- Forums
- Chat
- Announcements
- Dropbox
- Groups
- Student Publications
- Blogs
- Polls
- Quiz
- Classes
--Vanpouckesven 12:05, 18 February 2008 (CET)
Database Structure
This is the database structure with multiple databases
Static database structure
The static database structure is the collection of databases that is created when installing dokeos
- dokeos_main
- admin: Lists all the users that are administrator
- class: Lists all the classes
- class_user: Lists all the users that are connected to one or more classes
- course: Lists all the courses
- course_category: Lists all the course categories
- course_rel_class: Lists all the classes that are connected to one or more courses
- course_rel_user: Lists all the users that are connected to one or more courses
- gradebook_category: Lists all the gradebook categories
- gradebook_evaluation: Lists all the evaluation's used in one or more gradebook categories
- gradebook_link: Lists all the links used in one or more gradebook categories
- gradebook_result: Lists all the results used in one or more gradebook evaluations
- gradebook_score_display: Lists all the scores that have to be displayed
- language: Lists all the available languages
- openid_association: Lists all the associations with the OPENID authentication program (http://openid.net/)
- php_session: Lists all the php sessions
- session: Lists all the sessions (how many users, classes, courses)
- session_rel_course: Lists all the courses of a session
- session_rel_course_rel_user: Lists all the users of the courses of a session
- session_rel_user: Lists all the users of a session
- settings_current: Lists all the current settings
- settings_options: Lists all the possible options of the settings
- shared_survey: Lists all the surveys
- shared_survey_question: Lists all the questions that are connected to one or more surveys
- shared_survey_question_option: Lists all the options that are connected to one or more survey questions
- sys_announcement: Lists all the system announcements
- templates: Lists all the course templates
- user: Lists all the users
- dokeos_stats
- track_c_browsers: Keep track of all the browsers that have been used
- track_c_countries: Keep track of all the countries from where people have visited
- track_c_os: Keep track of all the OS's that have been used
- track_c_providers: Keep track of all providers
- track_c_referers: Keep track of all referrers
- track_e_access: Keep track of which users have visited what files
- track_e_attempt: Keep track of all the attempts that a user tried to fill in a certain question / exercice
- track_e_course_access: Keep track of which users have visited what courses
- track_e_default: Keep track of default events
- track_e_downloads: Keep track of all the downloads
- track_e_exercises: Keep track of all the exercises
- track_e_hotpotatoes: Keep track of all the hotpotatoes exercices (http://hotpot.uvic.ca/)
- track_e_hotspot: Keep track of all the hotspot exercices
- track_e_lastaccess: Keep track which users have accessed last
- track_e_links: Keep track of all the links
- track_e_login: Keep track of all the login (attempts)
- track_e_online: Keep track of who is online
- track_e_open: Keep track of all the agents from the users that have visited
- track_e_uploads: Keep track of all the uploads
- dokeos_user
- personal agenda: Lists all the agenda items of the users
- user_course_category: Lists all the courses to which a users is subscribed
Dynamic database structure
The dynamic database structure is the collection of databases that is created when dokeos is already running
- When a new course is created the system creates a new database with the name of the course. In this database you'll find the following tables
- announcement: Lists all the announcements
- blog: Lists all the blogs
- blog_comment: Lists all the comments of the blog posts
- blog_post: Lists all the blog posts of the blogs
- blog_rating: Lists all the ratings of the blogs
- blog_rel_user: Lists all the users of the blogs
- blog_task: Lists all the system tasks of the blogs
- blog_task_rel_user: Lists all the connections between blog tasks and users
- calendar_event: Lists all the calendar events
- chat_connected: Lists all the users that are connected to the chat
- course_description: Lists all the descriptions of the course
- course_setting: Lists all the settings of the course
- document: Lists all the documents of the course
- dropbox_category: Lists all the categories of the dropbox
- dropbox_feedback: Lists all the feedback of the dropbox
- dropbox_file: Lists all the files of the dropbox
- dropbox_person: Lists all the users of the dropbox files
- dropbox_post: Lists all the posts of the dropbox
- forum_category: Lists all the categories of the forum
- forum_forum: Lists all the forum's of the forum
- forum_mailcue: Lists all the mails that have to be sent from the forum
- forum_post: Lists all the posts of the threads
- forum_thread: Lists all the threads of the forum
- group_category: Lists all the categories of the groups
- group_info: Lists all the information of the groups
- group_rel_tutor: Lists all the tutor's of the groups
- group_rel_user: Lists all the users of the groups
- item_property: Lists all the properties of an item (document, link, announcement,...)
- link: Lists all the links
- link_category: Lists all the categories of the links
- lp: Lists all the learning paths
- lp_item: Lists all the items of the learning paths
- lp_item_view: Lists the current views of the learning path items
- lp_iv_interaction: Lists all the interactions of a student/user with the item views
- lp_iv_objective: Lists all the objectives of the item views
- lp_view: Lists the current views of the learning path
- online_connected: Lists the last connection of all the users
- online_link: Lists all the links
- permission_group: Lists all the permissions of the groups
- permission_task: Lists all the permissions of the tasks
- permission_user: Lists all the permissions of the users
- quiz: Lists all the quiz's
- quiz_answer: Lists all the answers of the quiz's
- quiz_question: Lists all the questions
- quiz_rel_question: Lists the relations between the quiz's and the questions
- resource: Lists all the resources
- role: Lists all the roles
- role_group: Lists all the roles of a group
- role_permission: List all the permissions of the roles
- role_user: Lists all the roles of the users
- student_publication: Lists all the publications of the students
- survey: Lists all the surveys
- survey_answer: Lists all the answers of the surveys
- survey_invitation: Lists all the invitations of the surveys
- survey_question: Lists all the questions of the surveys
- survey_question_option: List all the options of the questions
- tool: Lists all the tools that can be used in the course
- tool_intro: Lists all the intros for the tools
- userinfo_content: Lists the content of the userinfo
- userinfo_def: Lists the definition of the userinfo
--Vanpouckesven 15:16, 18 February 2008 (CET)
File structure
For each course that gets created a new directory is made in the courses directory with the same name as the course. For each course you have the following directory structure
- Documents: All (uploaded) documents that are in the course
- audio
- css
- flash
- hotpotatoes_files
- images
- video
- for each group a new directory is made with the name "GroupName_groupdocs" where all the group documents reside
- Other files are written directly in the documents directory
- Dropbox: All files from the dropbox from the course
- Group: non active directory, was used for group files
- Page
- Scorm: Directory that is used so the course can be exported in the SCORM format (http://en.wikipedia.org/wiki/SCORM)
- Temp: All temporary files
- Upload: All uploaded files that not belong in documents
- Blog: All uploaded files for use in blogs
- Forum: All uploaded files for use in forums
- Test: All uploaded files for test purposes
- Work: The work that the students upload in the students publications
Information/files about the user's profile can be found in the directory main/upload/user
--Vanpouckesven 16:31, 18 February 2008 (CET)
