1.11 data dictionary

This page is an (incomplete) documentation of the data structure in Chamilo 1.11.

Table	Table's purpose	Field	Field's purpose
access_url	List of all URLs if using multiple URLs	id	Unique identifier
		url
		...
access_url_rel_course	Link between the access_url table and the course table
		...
access_url_rel_course_category	Link between access_url and course_category
		...
access_url_rel_session
		...
access_url_rel_user
		...
access_url_rel_usergroup
		...
admin	Contains a list of ID of user that are platform administrators
		...
announcement_rel_group
		...
block
		...
branch_sync
		...
branch_transaction
		...
branch_transaction_status
		...
c_announcement
		...
c_announcement_attachment
		...
c_attendance
		...
c_attendance_calendar
		...
c_attendance_calendar_rel_group
		...
c_attendance_result
		...
c_attendance_sheet
		...
c_attendance_sheet_log
		...
c_blog
		...
c_blog_attachment
		...
c_blog_comment
		...
c_blog_post
		...
c_blog_rating
		...
c_blog_rel_user
		...
c_blog_task
		...
c_blog_task_rel_user
		...
c_calendar_event
		...
c_calendar_event_attachment
		...
c_calendar_event_repeat
		...
c_calendar_event_repeat_not
		...
c_chat_connected
		...
c_course_description
		...
c_course_setting
		...
c_document
		...
c_dropbox_category
		...
c_dropbox_feedback
		...
c_dropbox_file
		...
c_dropbox_person
		...
c_dropbox_post
		...
c_exercise_category
		...
c_forum_attachment
		...
c_forum_category
		...
c_forum_forum
		...
c_forum_thread
		...
c_forum_thread_qualify
		...
c_forum_thread_qualify_log
		...
c_glossary
		...
c_group_category
		...
c_group_info
		...
c_group_rel_tutor
		...
c_group_rel_user
		...
c_item_property	This gathers the definition, visibility and changelog of most learning objects in Chamilo. It is a central piece of the database structure in 1.11
		...
c_link
		...
c_link_category
		...
c_lp
		...
c_lp_category
		...
c_lp_category_user
		...
c_lp_item
		...
c_lp_item_view
		...
c_lp_iv_interaction
		...
c_lp_iv_objective
		...
c_lp_view
		...
c_notebook
		...
c_online_connected
		...
c_online_link
		...
c_permission_group
		...
c_permission_task
		...
c_permission_user
		...
c_quiz
		...
c_quiz_answer
		...
c_quiz_question
		...
c_quiz_question_category
		...
c_quiz_question_option
		...
c_quiz_question_rel_category
		...
c_quiz_rel_category
		...
c_quiz_rel_question
		...
c_resource
		...
c_role
		...
c_role_group
		...
c_role_permissions
		...
c_role_user
		...
c_student_publication
		...
c_student_publication_assignment
		...
c_student_publication_comment
		...
c_student_publication_rel_document
		...
c_student_publication_rel_user
		...
c_survey
		...
c_survey_answer
		...
c_survey_group
		...
c_survey_invitation
		...
c_survey_question
		...
c_survey_question_option
		...
c_thematic
		...
c_thematic_advance
		...
c_thematic_plan
		...
c_tool
		...
c_tool_intro
		...
c_userinfo_content
		...
c_userinfo_def
		...
c_wiki
		...
c_wiki_conf
		...
c_wiki_discuss
		...
c_wiki_mailcue
		...
career
		...
chat
		...
chat_video
		...
class_item
		...
class_user
		...
course
		...
course_category
		...
course_module
		...
course_rel_class
		...
course_rel_user
		...
course_rel_user_catalogue
		...
course_request
		...
course_type
		...
event_email_template
		...
event_sent
		...
extra_field
		...
extra_field_option_rel_field_option
		...
extra_field_options
		...
extra_field_rel_tag
		...
extra_field_saved_search
		...
extra_field_values
		...
grade_components
		...
grade_model
		...
gradebook_category
		...
gradebook_certificate
		...
gradebook_evaluation
		...
gradebook_link
		...
gradebook_linkeval_log
		...
gradebook_result
		...
gradebook_result_log
		...
gradebook_score_display
		...
gradebook_score_log
		...
hook_call
		...
hook_event
		...
hook_observer
		...
language
		...
legal
		...
mail_template
		...
message
		...
message_attachment
		...
message_likes
		...
notification
		...
openid_association
		...
personal_agenda
		...
personal_agenda_repeat
		...
personal_agenda_repeat_not
		...
plugin_*	All plugin tables (see plugin documentation)
		...
promotion
		...
room
		...
scheduled_announcements
		...
search_engine_ref
		...
sequence
		...
sequence_condition
		...
sequence_formula
		...
sequence_method
		...
sequence_resource
		...
sequence_row_entity
		...
sequence_rule
		...
sequence_rule_condition
		...
sequence_rule_method
		...
sequence_type_entity
		...
sequence_valid
		...
sequence_value
		...
sequence_variable
		...
session
		...
session_category
		...
session_rel_course
		...
session_rel_course_rel_user
		...
session_rel_user
		...
settings_current
		...
settings_options
		...
shared_survey
		...
shared_survey_question
		...
shared_survey_question_option
		...
skill
		...
skill_level
		...
skill_profile
		...
skill_rel_gradebook
		...
skill_rel_profile
		...
skill_rel_skill
		...
skill_rel_user
		...
skill_rel_user_comment
		...
specific_field
		...
specific_field_values
		...
sys_announcement
		...
sys_calendar
		...
system_template
		...
tag
		...
templates
		...
ticket_assigned_log
		...
ticket_category
		...
ticket_category_rel_user
		...
ticket_message
		...
ticket_message_attachments
		...
ticket_priority
		...
ticket_project
		...
ticket_status
		...
ticket_ticket
		...
track_course_ranking
		...
track_e_access
		...
track_e_attempt
		...
track_e_attempt_coeff
		...
track_e_attempt_recording
		...
track_e_course_access
		...
track_e_default
		...
track_e_downloads
		...
track_e_exercises
		...
track_e_hotpotatoes
		...
track_e_hotspot
		...
track_e_item_property
		...
track_e_lastaccess
		...
track_e_links
		...
track_e_login
		...
track_e_online
		...
track_e_open
		...
track_e_uploads
		...
track_stored_values
		...
track_stored_values_stack
		...
user
		...
user_api_key
		...
user_course_category
		...
user_friend_relation_type
		...
user_rel_course_vote
		...
user_rel_event_type
		...
user_rel_tag
		...
user_rel_user
		...
usergroup
		...
usergroup_rel_course
		...
usergroup_rel_question
		...
usergroup_rel_session
		...
usergroup_rel_user
		...
usergroup_rel_usergroup
		...