1.11 data dictionary

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

• All fields called c_id always point to the course.id field.
• All fields called user_id always point to the user.id field.
• All fields called session_id always point to the session.id field.
• When fields called group_id appear in a table with a c_ prefix, they are usually referring to a course group (c_group_info.iid)

Note 1: All tables starting with a c_ are course-specific tables. They always include a reference to the course as the c_id field, and generally still hold a double identifier: iid is the new, platform-unique identifier, while the combination of id+c_id is the "old" unique identifier. Queries should use the iid field, although some have been left using id+c_id by lack of time during the transition.

Note 2: Sessions are really special, and most course resources tables include a session ID which can be either 0 or NULL (depending on the age of the table), or has a non-zero value. In case it has a (numeric) value, it means the resource is available inside the session-course and not inside the base course. If it is 0 or NULL, it means it is available inside the base course and for some resources, this means it is also visible in the session-course.

Table	Table's purpose	Field	Field's purpose
access_url	List of all URLs if using multiple URLs	id	Unique identifier
		url	URL (including protocol)
		description
		active	1 if the URL can already be used
		created_by	(FK) user.id
		tms	timestamp
		url_type	(not used yet)
access_url_rel_course	Link between the access_url table and the course table	id	Unique identifier
		c_id
		access_url_id
access_url_rel_course_category	Link between access_url and course_category	id	Unique identifier
		access_url_id
		course_category_id
access_url_rel_session	Link between access_url and session for sessions registered in a specific URL	id	Unique identifier
		access_url_id
		session_id
access_url_rel_user	Link between access_url and user for users registered in a specific URL	access_url_id	access_url id (FK)
		user_id
access_url_rel_usergroup	Link between access_url and usergroup for groups registered in a specific URL	id	Unique identifier
		access_url_id
		usergroup_id	usergroup id (FK)
admin	Contains a list of ID of user that are platform administrators. If a user ID is here, the user is a platform admin (access URLs change that behaviour slightly)	id	Unique identifier
		user_id
announcement_rel_group	Link between sys_announcement and usergroup	group_id
		announcement_id	id from sys_announcement
block	(not yet used)	id	Unique identifier
		name
		description
		path
		controller
		active
branch_sync	(not in use yet) Allows for the synchronisation of Chamilo portals between themselves (not used yet)	id	Unique identifier
branch_transaction	(not in use yet) Allows for the registration of transactions (pending or executed) from another system, to be executed in Chamilo
branch_transaction_status	(not Dictionary of status terms for branch_transaction
c_announcement	Contains the announcements in the corresponding course tool	iid	Unique identifier
		id	deprecated
		c_id
		title
		content
		end_date
		display_order
		email_sent
		session_id
c_announcement_attachment	Contains the attachments (files) of c_announcement	iid	Unique identifier
		id	deprecated
		c_id
		path
		comment
		size
		announcement_id	id from c_announcement
		filename
c_attendance	Contains one attendance "resource". Courses can contain several attendance resources, which can each be evaluated in the gradebook. Each contains dates (c_attendance_calendar), which contain attendance records (see c_attendance_sheet)	iid	Unique identifier
		c_id
		id	deprecated
		name
		description
		active
		attendance_qualify_title
		attendance_qualify_max
		attendance_weight
		session_id
		locked
c_attendance_calendar	Each attendance datetime is registered here separately.	iid	Unique identifier
		id	deprecated
		c_id
		attendance_id	id from c_attendance
		date_time
		done_attendance
c_attendance_calendar_rel_group	If an attendance date is specific to a users group in a course, this links the date to the c_group	iid	Unique identifier
		id	deprecated
		c_id
		group_id
		calendar_id
c_attendance_result	The global attendance "rate" of a user in an attendance resource	iid	Unique identifier
		id	deprecated
		c_id
		user_id
		attendance_id
		score
c_attendance_sheet	Registers the attendance or lack thereof of a user to a specific calendar datetime	iid	Unique identifier
		c_id
		presence
		user_id
		attendance_calendar_id
c_attendance_sheet_log	Log table for changes in the c_attendance_sheet	iid	Unique identifier
		id	deprecated
		c_id
		attendance_id
		lastedit_date
		lastedit_type
		lastedit_user_id
		calendar_date_value
c_blog	Entries for each blog created in a course	iid	Unique identifier
		c_id
		blog_id
		blog_name
		blog_subtitle
		date_creation
		visibility
		session_id
c_blog_attachment	File attachments to blog posts	iid	Unique identifier
		id	deprecated
		c_id
		path
		comment
		size
		post_id
		filename
		blog_id
		comment_id
c_blog_comment	Comments on blog posts	iid	Unique identifier
		comment_id	deprecated
		c_id
		title
		comment
		author_id
		date_creation
		blog_id
		post_id
		task_id
		parent_comment_id
c_blog_post	Messages posted in blogs	iid	Unique identifier
		blog_id
		c_id
		title
		full_text
		date_creation
		author_id
		post_id
c_blog_rating	Ratings given to blog posts	iid	Unique identifier
		rating_id
		c_id
		blog_id
		rating_type
		item_id
		user_id
		rating
c_blog_rel_user	Link between c_blog and user	iid	Unique identifier
		c_id
		blog_id
		user_id
c_blog_task	Tasks that can be configured inside a blog	iid	Unique identifier
		task_id
		c_id
		blog_id
		title
		description
		color
		system_task
c_blog_task_rel_user	Assignation of tasks (c_blog_task) to users (user)	iid	Unique identifier
		c_id
		blog_id
		target_date
		user_id
		task_id
c_calendar_event	Events of the calendar	iid	Unique identifier
		room_id	(not used yet)
		id
		c_id
		title
		content
		start_date
		end_date
		parent_event_id
		session_id
		all_day
		comment
		color
c_calendar_event_attachment	Attachment (files) to the c_calendar_event records	iid	Unique identifier
		id
		c_id
		path
		comment
		size
		agenda_id
		filename
c_calendar_event_repeat	Definition of repetitions for existing events	iid	Unique identifier
		cal_id
		c_id
		cal_type
		cal_end
		cal_frequency
		cal_days
c_calendar_event_repeat_not	Definition of exclusions/exceptions in repetitions for existing events	iid	Unique identifier
		c_id
		cal_id
		cal_date
c_chat_connected	Logs when a user is active in the course chat	iid	Unique identifier
		id
		c_id
		session_id
		to_group_id
		user_id
		last_connection
c_course_description	The sections available in the course description tool	iid	Unique identifier
		id
		c_id
		title
		content
		session_id
		description_type
		progress
c_course_setting	Settings of the course (whether to send e-mails, when, etc) that can be access through the Settings tool inside the course	iid	Unique identifier
		id
		c_id
		variable
		subkey
		type
		category
		value
		title
		comment
		subkeytext
c_document	The list of documents and folders of the documents tool	iid	Unique identifier
		id
		c_id
		path
		comment
		title
		filetype
		size
		readonly
		session_id
c_dropbox_category	Folders inside the dropbox	iid	Unique identifier
		c_id
		cat_id
		cat_name
		received
		sent
		user_id
		session_id
c_dropbox_feedback	Feedback sent by users on files in the dropbox	iid	Unique identifier
		c_id
		feedback_id
		file_id
		author_user_id
		feedback
		feedback_date
c_dropbox_file	A file dropped in the dropbox	iid	Unique identifier
		id
		c_id
		uploader_id
		filename
		filesize
		title
		description
		author
		upload_date
		last_upload_date
		cat_id
		session_id
c_dropbox_person	The relationships between files (c_dropbox_file) and whom they are sent to (user)	iid	Unique identifier
		c_id
		file_id
		user_id
c_dropbox_post	A message posted on a file (c_dropbox_file)	iid	Unique identifier
		feedback_date
		feedback
		cat_id
		session_id
		c_id
		file_id
		dest_user_id
c_exercise_category	Optional table created by manual action documented in configuration.php	iid	Unique identifier
		c_id
		name
		description
		created_at
		updated_at
		position
c_forum_attachment	File attachments to c_forum_post records	iid	Unique identifier
		id
		c_id
		path
		comment
		size
		post_id
		filename
c_forum_category	Forum categories (which include forums)	iid	Unique identifier
		c_id
		cat_title
		cat_comment
		cat_order
		locked
		session_id
		cat_id
c_forum_forum	Forums (which include threads)	iid	Unique identifier
		c_id
		forum_id
		forum_title
		forum_comment
		forum_threads
		forum_posts
		forum_last_post
		forum_category
		allow_anonymous
		allow_edit
		approval_direct_post
		allow_attachments
		allow_new_threads
		default_view
		forum_of_group
		forum_group_public_private
		forum_order
		locked
		session_id
		forum_image
		start_time
		end_time
		lp_id
		moderated
c_forum_mailcue	When a user marks a thread or post for update notifications, it is kept here	iid	Unique identifier
		c_id
		id
		thread_id
		user_id
		post_id
c_forum_notification	...	iid	Unique identifier
		c_id
		id
		user_id
		forum_id
		thread_id
		post_id
c_forum_post	Forum posts (in response to a thread)	iid	Unique identifier
		c_id
		post_id
		post_title
		post_text
		thread_id
		forum_id
		poster_id
		poster_name
		post_date
		post_notification
		post_parent_id
		visible
		status
c_forum_thread	Forum threads (which give birth to posts and have more properties than posts)	iid	Unique identifier
		c_id
		thread_id
		thread_title
		forum_id
		thread_replies
		thread_poster_id
		thread_poster_name
		thread_views
		thread_last_post
		thread_date
		thread_sticky
		locked
		session_id
		thread_title_qualify
		thread_qualify_max
		thread_close_date
		thread_weight
		thread_peer_qualify
		lp_item_id
c_forum_thread_qualify	If a thread can be scored, the scores given by teachers or other users are stored here	iid	Unique identifier
		c_id
		id
		user_id
		thread_id
		qualify
		qualify_user_id
		qualify_time
		session_id
c_forum_thread_qualify_log	A log table of all the changes in the forum threads scores	iid	Unique identifier
		...
c_glossary	Terms from the course glossary	iid	Unique identifier
		c_id
		glossary_id
		name
		description
		display_order
		session_id
c_group_category	Categories of course groups (c_group_info)	iid	Unique identifier
		c_id
		id
		title
		description
		doc_state
		calendar_state
		work_state
		announcements_state
		forum_state
		wiki_state
		chat_state
		max_student
		self_reg_allowed
		self_unreg_allowed
		groups_per_user
		display_order
c_group_info	Course groups and their description	iid	Unique identifier
		id
		c_id
		name
		status
		category_id
		description
		max_student
		doc_state
		calendar_state
		work_state
		announcements_state
		forum_state
		wiki_state
		chat_state
		secret_directory
		self_registration_allowed
		self_unregistration_allowed
		session_id
c_group_rel_tutor	Tutors assigned to course groups (c_group_info)	iid	Unique identifier
		c_id
		id
		user_id
		group_id
c_group_rel_user	Users registered in course groups (c_group_info)	iid	Unique identifier
		c_id
		id	deprecated
		user_id
		group_id
		status
		role
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	iid	Unique identifier
		c_id
		to_group_id
		to_user_id
		insert_user_id
		session_id
		id	deprecated
		tool	a string with the name of the tool (document, link, etc)
		insert_date
		lastedit_date
		ref	the iid of the item in its own table
		lastedit_type
		lastedit_user_id
		visibility
		start_visible
		end_visible
c_link	Course links	iid	Unique identifier
		c_id
		id
		url
		title
		description
		category_id
		display_order
		on_homepage
		target
		session_id
c_link_category	Categories of course links (c_link)	iid	Unique identifier
		c_id
		id	deprecated
		category_title
		description
		display_order
		session_id
c_lp	Course learning paths	iid	Unique identifier
		c_id
		id	deprecated
		lp_type
		name
		ref
		description
		path
		force_commit
		default_view_mod
		default_encoding	Mostly for very old imported content not in UTF-8 (usually in UTF-8 in all recent content)
		display_order
		content_maker	just a label
		content_local
		content_license
		prevent_reinit
		js_lib
		debug	feature only available to platform admins
		theme
		preview_image
		author
		session_id
		prerequisite	for dependencies on other learning paths
		hide_toc_frame
		seriousgame_mode
		use_max_score
		autolaunch
		category_id
		max_attempts
		subscribe_users
		created_on
		modified_on
		publicated_on
		expired_on
		accumulate_scorm_time
c_lp_category	Categories for courses learning paths	iid	Unique identifier
		c_id
		name
		position
c_lp_category_user	Access specifications for specific users to specific learning paths categories	iid	Unique identifier
		category_id
		user_id
c_lp_item	Documents inside a learning path	iid	Unique identifier
		c_id
		id	deprecated (almost)
		lp_id
		item_type	tool used (document, link, etc) or in the case of SCORM: asset, sco, etc
		ref	iid of the item if document, quiz, link, etc
		title
		description
		path
		min_score
		max_score
		mastery_score
		parent_item_id
		previous_item_id
		next_item_id
		display_order
		prerequisite
		parameters
		launch_data
		max_time_allowed
		terms
		search_did
		audio
		prerequisite_min_score
		prerequisite_max_score
c_lp_item_view	Each visualization by a user (user) of one document (c_lp_item) inside the learning path (c_lp). Belongs to a c_lp_view entry	iid	Unique identifier
		c_id
		id
		lp_item_id
		lp_view_id
		view_count
		start_time
		total_time
		score
		status
		suspend_data
		lesson_location
		core_exit
		max_score
c_lp_iv_interaction	SCORM interactions for one specific c_lp_item_view	iid	Unique identifier
		c_id
		id	deprecated
		order_id
		lp_iv_id
		interaction_id
		interaction_type
		weighting
		completion_time
		correct_responses
		student_response
		result
		latency
c_lp_iv_objective	SCORM objectives for one specific c_lp_item_view	iid	Unique identifier
		c_id
		id	deprecated
		lp_iv_id
		order_id
		objective_id
		score_raw
		score_max
		score_min
		status
c_lp_view	View of a learning path (c_lp) by a user. Contains many c_lp_view_item	iid	Unique identifier
		c_id
		id	deprecated
		lp_id
		user_id
		view_count
		last_item
		progress	the current progress of the user in this learning path's view, in percentage (0-100)
		session_id
c_notebook	Posts in the notebook tool in the course (personal notes)	iid	Unique identifier
		c_id
		notebook_id
		user_id
		course	deprecated
		session_id
		title
		description
		creation_date	datetime
		update_date	datetime
		status
c_online_connected	...	iid	Unique identifier
		c_id
		last_connection
		user_id
c_online_link	...	iid	Unique identifier
		c_id
		id	deprecated
		name
		url
c_permission_group	Blog-related user permissions ...	iid	Unique identifier
		...
c_permission_task	Blog-releated user permissions in tasks ...	iid	Unique identifier
		...
c_permission_user	Blog-related user permissions ...	iid	Unique identifier
		...
c_quiz	List of exercises in courses	iid	Unique identifier
		c_id
		id	deprecated
		title
		description
		sound
		type
		random
		random_answers
		active
		results_disabled
		access_condition
		max_attempt
		start_time
		end_time
		feedback_time
		expired_time
		session_id
		propagate_neg
		save_correct_answers
		review_answers
		random_by_category
		text_when_finished
		display_category_name
		pass_percentage
		question_selection_type
		hide_question_title
		autolaunch
		exercise_category_id
		prevent_backwards
c_quiz_answer	List of possible answers to a question (c_quiz_question) in a c_quiz	iid	Unique identifier
		id_auto
		c_id
		id	deprecated
		question_id	the c_quiz_question iid it relates to
		answer	the text of this answer
		correct	0 if incorrect, 1 if the correct answer to the question
		comment	feedback if this answer was picked
		ponderation	Not the ponderation (bad naming) but the score obtained for selecting this answer
		position
		hotspot_coordinates
		hotspot_type
		destination
		answer_code
c_quiz_question	List of questions in the exercises tool. As questions can be shared between c_quiz, the real link between questions and quizzes is through the c_quiz_rel_question table	iid	Unique identifier
		c_id
		id	deprecated
		question	question title
		description	question (longer) description, if any
		ponderation	max score for this question (usually calculated from the sum of scores from the answers)
		position
		type	one of ~20 question types. Defined by constants in main/inc/lib/api.lib.php (search for "Question types" constants)
		picture	in the case of a hotspot question, path to the image
		level	level of difficulty. Only a string. Does not imply any logic change.
		extra
		question_code	special code that can be added to each question
c_quiz_question_category	Categories of questions in quizzes	iid	Unique identifier
		c_id
		id	deprecated
		title
		description
c_quiz_question_option	...	iid	Unique identifier
		c_id
		id	deprecated
		question_id
		name
		position
c_quiz_question_rel_category	Relationship between a c_quiz_question and a c_quiz_question_category	iid	Unique identifier
		c_id
		category_id
		question_id
c_quiz_rel_category	Relationship between a c_quiz and a quiz category (see c_exercise_category)	iid	Unique identifier
		c_id
		category_id
		exercise_id	FK to c_quiz iid
		count_question
c_quiz_rel_question	Relationship between a question (c_quiz_question) and a specific quiz (c_quiz)	iid	Unique identifier
		c_id
		question_order
		question_id
		exercice_id
c_resource	...	iid	Unique identifier
		c_id
		id	deprecated
		source_type
		source_id
		resource_type
		resource_id
c_role	Blog-related roles	iid	Unique identifier
		...
c_role_group	Blog-related roles	iid	Unique identifier
		...
c_role_permissions	Blog-related roles	iid	Unique identifier
		...
c_role_user	Blog-related roles	iid	Unique identifier
		...
c_student_publication	An assignment handed over by a student	iid	Unique identifier
		session_id
		c_id
		id	deprecated
		url
		url_correction
		title
		title_correction
		description
		author
		active
		accepted
		post_group_id
		sent_date
		filetype
		has_properties
		view_properties
		qualification
		date_of_qualification
		parent_id
		qualificator_id
		weight
		user_id
		allow_text_assignment
		contains_file
		document_id
c_student_publication_assignment	Assigments definition (tasks/works)	iid	Unique identifier
		c_id
		id	deprecated
		expires_on
		ends_on
		add_to_calendar
		enable_qualification
		publication_id	FK to c_student_publication iid
c_student_publication_comment	Comments on c_student_publication	iid	Unique identifier
		c_id
		id	deprecated
		work_id	FK to c_student_publication iid
		comment
		file
		user_id
		sent_at
c_student_publication_rel_document	Link between a document (c_document) that serves as a template to the assignments	iid	Unique identifier
		c_id
		id	deprecated
		work_id	FK to c_student_publication iid
		document_id	FK to c_document iid
c_student_publication_rel_user	Link between users and assignments (to assign specific assignments to a reduced number of users)	iid	Unique identifier
		id
		c_id
		work_id
		user_id
c_survey	Surveys	iid	Unique identifier
		c_id
		survey_id
		code
		title
		subtitle
		author
		lang
		avail_from
		avail_till
		is_shared
		template
		intro
		surveythanks
		creation_date
		invited
		answered
		invite_mail
		reminder_mail
		mail_subject
		anonymous
		access_condition
		shuffle
		one_question_per_page
		survey_version
		parent_id
		survey_type
		show_form_profile
		form_fields
		session_id
		visible_results
c_survey_answer	Possible answers to survey questions (c_survey_question)	iid	Unique identifier
		c_id
		answer_id
		survey_id
		question_id
		option_id
		value
		user
c_survey_group	...	iid	Unique identifier
		c_id
		id	deprecated
		name
		description
		survey_id
c_survey_invitation	Invitations of users to surveys	iid	Unique identifier
		c_id
		survey_invitation_id
		survey_code
		user
		invitation_code
		invitation_date
		reminder_date
		answered
		session_id
		group_id	FK to c_group_info iid
c_survey_question	Survey questions	iid	Unique identifier
		c_id
		question_id
		survey_id
		survey_question
		survey_question_comment
		type
		display
		sort
		shared_question_id
		max_value
		survey_group_pri
		survey_group_sec1
		survey_group_sec2
		is_required	Whether this is a mandatory survey (1) or not (0)
c_survey_question_option	Options on survey questions	iid	Unique identifier
		c_id
		question_option_id
		question_id
		survey_id
		option_text
		sort
		value
c_thematic	Highest level of thematic progress categorization	iid	Unique identifier
		c_id
		id	deprecated
		title
		content
		display_order
		active
		session_id
c_thematic_advance	Dates related to the progress in a thematic plan	iid	Unique identifier
		room_id
		c_id
		id	deprecated
		thematic_id
		attendance_id
		content
		start_date
		duration
		done_advance
c_thematic_plan	Second level of thematic progress	iid	Unique identifier
		c_id
		id	deprecated
		thematic_id
		title
		description
		description_type
c_tool	Entries of available tools on the course homepage	iid	Unique identifier
		id	deprecated
		c_id
		name	internal name (translated through language files to show the name of the tool to the user)
		link	URL to the tool's home
		image	icon (_na.png is added when the tool is disabled)
		visibility
		admin
		address
		added_tool
		target
		category
		session_id
		description
		custom_icon	If a custom icon is uploaded by the teacher, where to find it
c_tool_intro	Introduction sections. On the course homepage but also (if enabled) in each tool.	iid	Unique identifier
		c_id
		id	deprecated
		intro_text	longtext with the HTML intro to the tool
		session_id
c_userinfo_content	Deprecated: Values for user fields in courses	iid	Unique identifier
		c_id
		id	deprecated
		user_id
		definition_id
		editor_ip
		edition_time
		content
c_userinfo_def	Deprecated: User fields in courses	iid	Unique identifier
		c_id
		id	deprecated
		title
		comment
		line_count
		rank
c_wiki	Wiki pages in course	iid	Unique identifier
		c_id
		id	deprecated
		page_id
		reflink
		title
		content
		user_id
		group_id	FK to c_group_info iid
		dtime
		addlock
		editlock
		visibility
		addlock_disc
		visibility_disc
		ratinglock_disc
		assignment
		comment
		progress
		score
		version
		is_editing
		time_edit
		hits
		linksto
		tag
		user_ip
		session_id
c_wiki_conf	Wiki configuration in a course	iid	Unique identifier
		c_id
		page_id
		task
		feedback1
		feedback2
		feedback3
		fprogress1
		fprogress2
		fprogress3
		max_size
		max_text
		max_version
		startdate_assig
		enddate_assig
		delayedsubmit
c_wiki_discuss	Conversations on each wiki page	iid	Unique identifier
		c_id
		id	deprecated
		publication_id
		userc_id
		comment
		p_score
		dtime
c_wiki_mailcue	...	iid	Unique identifier
		c_id
		id	deprecated
		type
		group_id
		session_id
		user_id
career	Careers (admin panel)	id	Unique identifier
		name
		description
		status
		created_at
		updated_at
chat	Chat sessions	id	Unique identifier
		from_user
		to_user
		message
		sent
		recd
chat_video	Videochat sessions (temporarily deprecated)	id	Unique identifier
		from_user
		to_user
		room_name
		datetime
class_item	...	id	Unique identifier
		code
		name
class_user	Link between classes and users	class_id
		user_id
course	Courses	id	Unique identified (referenced by c_id everywhere else)
		room_id	not yet used
		title
		code
		directory
		course_language
		description
		category_code
		visibility
		show_score
		tutor_name
		visual_code
		department_name
		department_url
		disk_quota
		last_visit
		last_edit
		creation_date
		expiration_date
		subscribe
		unsubscribe
		registration_code
		legal
		activate_legal	0 if no particular legal terms. 1 to enable legal terms confirmation
		add_teachers_to_sessions_courses
		course_type_id
course_category	Courses categories	id	Unique identifier
		name
		code
		parent_id
		tree_pos
		children_count
		auth_course_child
		auth_cat_child
course_module	...	id	Unique identifier
		name
		link
		image
		row
		column
		position
course_rel_class	Relationship between course and usergroup	course_code	FK to course.code! (to be changed to id in the future)
		class_id
course_rel_user	Subscription of users to courses (if not using sessions)	id	Unique identifier
		user_id
		c_id
		relation_type
		status
		is_tutor
		sort
		user_course_cat
		legal_agreement
course_rel_user_catalogue	Special accesses to catalogue by specific users	id	Unique identifier
		user_id
		c_id
		visible
course_request	Requests for courses by users (if the course requests feature is enabled)	id	Unique identifier
		code
		user_id
		directory
		db_name
		course_language
		title
		description
		category_code
		tutor_name
		visual_code
		request_date
		objetives	(note the spelling mistake here)
		target_audience
		status
		info
		exemplary_content
course_type	...	id	Unique identifier
		name
		translation_var
		description
		props
event_email_template	...	id	Unique identifier
		message
		subject
		event_type_name
		activated
		language_id
event_sent	...	id	Unique identifier
		user_from
		user_to
		event_type_name
extra_field	Extra fields definition. Also defines which type of resource it applies to (users, courses, quizzes, etc)	id	Unique identifier
		extra_field_type
		field_type
		variable
		display_text
		default_value
		field_order
		visible_to_self
		visible_to_others
		changeable
		filter
		created_at
extra_field_option_rel_field_option	...	id	Unique identifier
		field_option_id
		related_field_option_id
		role_id
		field_id
extra_field_options	Possible values for extra_field_values	id	Unique identifier
		field_id
		option_value
		display_text
		priority
		priority_message
		option_order
extra_field_rel_tag	Tags on extra fields	id	Unique identifier
		field_id
		tag_id
		item_id
extra_field_saved_search	...	id	Unique identifier
		field_id
		user_id
		value
		created_at
		updated_at
extra_field_values	Values stored for specific resources in specific extra fields
		field_id
		value
		item_id
		created_at
		updated_at
		comment
grade_components	...	id	Unique identifier
		percentage
		title
		acronym
		grade_model_id
grade_model	...	id	Unique identifier
		name
		description
		default_lowest_eval_exclude
		default_external_eval
		default_external_eval_prefix
gradebook_category	Highest level of the gradebook structure (attributing certificates and skills)	id	Unique identifier
		name
		description
		user_id
		course_code
		parent_id
		weight
		visible
		certif_min_score
		session_id
		document_id
		locked
		default_lowest_eval_exclude
		generate_certificates
		grade_model_id
		is_requirement
gradebook_certificate	Generated certificates	id	Unique identifier
		cat_id
		user_id
		score_certificate
		created_at
		path_certificate
gradebook_evaluation	External evaluation scored in the gradebook	id	Unique identifier
		name
		description
		user_id
		course_code	Course code. Will be moved to c_id in the future
		category_id
		created_at
		weight
		max
		visible
		type
		locked
gradebook_link	Internal evaluation (Chamilo resources) scored in the gradebook	id	Unique identifier
		type
		ref_id
		user_id
		course_code
		category_id
		created_at
		weight
		visible
		locked
gradebook_linkeval_log	...
		...
gradebook_result	Results of users on gradebook_link or gradebook_evaluation
		...
gradebook_result_log	...
		...
gradebook_score_display	...
		...
gradebook_score_log	...
		...
hook_call	Internal hooks definition
		...
hook_event	Internal hooks definition
		...
hook_observer	Internal hooks definition
		...
language	The language supported for the user interface, and sublanguages
		...
legal	Terms and conditions
		...
mail_template	...
		...
message	User messages on the social network + all messages sent by the system by e-mail and saved for the local inbox
		...
message_attachment	File attachments for message
		...
message_likes	Likes given to messages on the social network
		...
notification	...
		...
openid_association	...
		...
personal_agenda	Personal events stored in the agenda
		...
personal_agenda_repeat	Repetition on personal_agenda
		...
personal_agenda_repeat_not	Repetition exclusions on personal_agenda_repeat
		...
plugin_*	All plugin tables (see plugin documentation)
		...
promotion	Promotions are contained in careers and contain sessions.
		...
room	Rooms are an item for a future feature in Chamilo allowing you to define a physical or virtual room for a synchronous lesson.
		...
scheduled_announcements	If the scheduled announcements for sessions are enabled, contains the messages scheduled to be sent at specific dates to session users
		...
search_engine_ref	Internal data on indexer with Xapian
		...
sequence	Sequences for course/session access
		...
sequence_condition	Conditions for sequence
		...
sequence_formula	Formula for sequence
		...
sequence_method	Method for sequence
		...
sequence_resource	Method for resource
		...
sequence_row_entity	...
		...
sequence_rule	Rules for sequence
		...
sequence_rule_condition	...
		...
sequence_rule_method	...
		...
sequence_type_entity	...
		...
sequence_valid	...
		...
sequence_value	...
		...
sequence_variable	...
		...
session	Course sessions definitions	id	Unique identifier
		...
session_category	Categories of sessions
		...
session_rel_course	Relationship between sessions and courses (which courses are contained in which sessions)
		...
session_rel_course_rel_user	Subscription of users to a course in a session
		...
session_rel_user	Subscription of users in a session
		...
settings_current	Platform settings
		...
settings_options	Platform settings' possible option
		...
shared_survey	...
		...
shared_survey_question	...
		...
shared_survey_question_option	...
		...
skill	Skills
		...
skill_level	Possible levels for a skill
		...
skill_profile	Groups of skills levels (level profiles)
		...
skill_rel_gradebook	Linking betweek gradebooks (gradebook_category)
		...
skill_rel_profile	Linking of skill with skill_profile
		...
skill_rel_skill	Hierarchy of skills between themselves
		...
skill_rel_user	When a user gets a skill, this table registers it
		...
skill_rel_user_comment	Users having obtained skills can get feedback from other users. They are stored here.
		...
specific_field	...
		...
specific_field_values	...
		...
sys_announcement	Global announcements
		...
sys_calendar	Global agenda events (not repetition possible)
		...
system_template	Global document templates
		...
tag	Tags
		...
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	Ranking based on score voted by users on courses
		...
track_e_access	Log of all accesses to courses, tools and sessions in the platform. It does not track all actions, though. Only "entering" each course and tool
		...
track_e_attempt	Log of all attempts (answers to questions) in quizzes (c_quiz). These are sub-elements of track_e_exercises.
		...
track_e_attempt_coeff	...
		...
track_e_attempt_recording	(experimental) Log of historical changes to answers. This is not working properly yet in 1.11.x
		...
track_e_course_access	Logs all login/logout actions to courses. This can be confusing when users open tabs to different courses at the same time.	course_access_id	unique ID
		c_id
		user_id
		login_course_date	datetime field for when the user logged in
		logout_course_date	datetime field for when the user logged out
		counter	number of actions the user took in this course between login and logout
		session_id
		user_ip	IP address (v4 or v6) of the user when logged in
track_e_default	Log of important actions in the system. This can be considered an audit table, as it records actions like user/course/session creations/deletions
		...
track_e_downloads	Log of all documents downloads (only logs documents that exist in the c_document table)
		...
track_e_exercises	Log of all quiz (c_quiz) attempts by a user. For the detail of each answer, check track_e_attempt
		...
track_e_hotpotatoes	Log of scores at quizzes of type HotPotatoes
		...
track_e_hotspot	Log of additional data regarding questions of HotSpot type (questions on images).	hotspot_id	unique id
		hotspot_user_id	User ID
		hotspot_course_code	Course code (not ID)
		c_id	Course ID
		hotspot_exe_id
		hotspot_question_id
		hotspot_answer_id
		hotspot_correct
		hotspot_coordinate
track_e_item_property	Log of changes in the c_item_property table	id	Unique ID
		course_id
		item_property_id	ID in the c_item_property table (FK)
		title
		content
		progress
		lastedit_date	datetime
		lastedit_user_id	User ID
		session_id
track_e_lastaccess	Log of accesses to tools in courses	access_id	unique ID
		access_user_id	User ID
		access_date	datetime (in UTC)
		c_id	Course ID
		access_tool	name of the tool
		access_session_id	Session ID
track_e_links	Log of accesses to links in the course's links tool (c_link)	links_id	unique id
		links_user_id	User Id
		links_date	datetime
		c_id
		links_link_id	iid from c_link (FK)
		links_session_id
track_e_login	Log all login and logout actions, with no differentiation of what the user did (see track_e_lastaccess for that)	login_id	unique ID
		login_user_id	User ID
		login_date	datetime
		user_ip	IP address (v4 or v6)
		logout_date	datetime
track_e_online	Log online presence of users. Used to tell if the user is online by applying a difference to the current datetime	login_id	unique ID
		login_user_id	User ID (FK)
		login_date	datetime
		user_ip	IP address (v4 or v6)
		c_id
		session_id	Session ID
		access_url_id	ID from access_url
track_e_open	deprecated
		...
track_e_uploads	Log uploads	upload_id	unique ID
		upload_user_id	User ID (FK)
		upload_date	datetime
		upload_cours_id	deprecated
		c_id
		upload_work_id	iid from c_student_publication
		upload_session_id	Session ID (FK)
track_stored_values	deprecated
		...
track_stored_values_stack	deprecated
		...
user	Users of the system	id	Unique ID
		user_id	deprecaed
		username	The username used to login
		username_canonical	a cleaned version of the username
		email_canonical	a cleaned version of the email
		email	the user e-mail
		locked	1 if the user account has been locked from the system
		enabled	1 if the user account has been enabled
		expired	1 if the user account has expired
		credentials_expired	(not yet used) 1 if the user's credentials have expired
		credentials_expire_at	(not yet used) expiry datetime for the credentials
		expires_at	(not used yet) datetime at which the user account expires - see expiration_date field below
		lastname	User's lastname
		firstname	User's firstname
		password	Password (hashed/encrypted following the method defined by $_configuration['password_encryption'] in app/config/configuration.php
		phone	Phone number
		address	(not yet used) Address
		salt	Value used to encrypt the password if the corresponding encryption method requires it
		last_login	The datetime of the last login for this user
		created_at	(not used yet) The datetime of creation - see registration_date field below
		updated_at	The datetime of last update of the user account
		confirmation_token	String used for the password change confirmation
		password_requested_at	Datetime at which the password regen was requested
		roles	an internal array with some information. Not really used at this point.
		profile_completed	1 if the profile has been completed
		auth_source	'platform' by default. If using LDAP or other authentication methods, this will vary based on the system used.
		status	User default role. 1 if the user is a teacher, 5 if the user is a student. Check main/inc/lib/api.lib.php for more roles
		official_code	Optional code
		picture_uri	URL of the user picture
		creator_id	The user ID of the person who created this user
		competences	Part of portfolio fields
		diplomas	Part of portfolio fields
		openarea	Part of portfolio fields
		teach	Part of portfolio fields
		productions	Part of portfolio fields
		language	Interface language for this user (this is a string but references a language in the language table)
		registration_date	Registration datetime
		expiration_date	Expiration datetime
		active	1 if the user account is active, 0 otherwise. An inactive user will not be able to connect to the platform.
		openid	A token if using early versions of the OpenID implementation in Chamilo
		theme	Default theme
		hr_dept_id	deprecated
user_api_key	API keys for users (for external systems)
		...
user_course_category	Courses categories defined by users in "sort my courses" feature
		...
user_friend_relation_type	Dictionary table for the types of social relation types
		...
user_rel_course_vote	Link between users and courses to register user's vote on the course	id	unique ID
		c_id
		user_id
		session_id
		url_id	Id of access_url (FK)
		vote	int value (usually 0-5)
user_rel_event_type	...
		...
user_rel_tag	link between user and tag
		...
user_rel_user	links between users
		...
usergroup	User groups (global groups) (see classes and social groups in the administration)
		...
usergroup_rel_course	Link between usergroup and course
		...
usergroup_rel_question	Link between usergroup and c_quiz_question
		...
usergroup_rel_session	Link between usergroup and session
		...
usergroup_rel_user	Link between usergroup and user
		...
usergroup_rel_usergroup	Link between usergroup and itself
		...