imsld_imslds: This table is used to store all the units of +
Next, the tables necessary for Level A are draw in the form of an + E-R diagram
imsld_imslds: This table is used to store all the units of learning. This is the high level in the hierarchy. Each IMS-LD file - loaded in .LRN will generate an entrance in this table. This table + loaded in .LRN will generate a row in this table. This table contains all the different units of learning. Each unit of learning - will contain global information and also references to other tables - for having all the required information of a unit of learning
imsld_id - identifier
version - version number
uri - uri of the imsld
level - A, B or C. It is the level of the IMS-LD file that - arrive
sequence_p - sequence used, true or false. True means - simple sequencing is being used. Defaults to false
learning_objective_id - references - imsld_learning_objectives
title
method_id - references imsld_methods
prerequisite_id - references imsld_itemmodel
component_id - references imsld_components
complete_unit_of_learning_id - references - complete_unit_of_learning
imsld_complete_unit_of_learning. This tables describes the - actions to do when a unit of learning is completed
complete_unit_of_learning_id
when_property_value_is_set_id ** - references - imsld_when_property_value_is_set
imsld_prerequisites. It has all the prerequisites of a unit of - learning. These are the previous knolowdges that are required for - doing the unit of learning
prerequisite_id
prerequisite_item - references imsld_items
imsld_components: Used to store all the components of the - IMS-LD
component_id
role_id - references imsld_roles
activity_id - references imsld_activities
environment_id - references imsld_environments
property_id ** - references imsld_properties
imsld_roles. This table contains all the defined roles
role_id - references imsld_roles
role_types - references role_types_id
create_new_p - multopleoccurrences of this role may be - created during runtime?
match_n_persons - exclusively-in-roles, + will contain global information and also references to other tables, + in order to represent completely the information represented by the + unit of learning.
imsld_id - identifier
version - version number
level - A, B or C. It is the level of the IMS-LD file that + arrive
sequence_used_p - sequence used, true or false. True means + simple sequencing is being used. Defaults to false
learning_objective_itemmodel_id - references + imsld_itemmodels and contains the objectives of the unit of + learning
title
method_id - references imsld_methods
prerequisite_itemmodel_id - references imsld_itemmodels + and contains the prerequisites for the unit of learning
component_id - references imsld_components
when_property_value_is_set** - references + imsld_when_property_value_is_set. Treated with more detail in + level B
imsld_components: Used to store all the components of the + IMS-LD (which are: roles, acitivities and environments. The + activities references this table)
component_id
role_id - references imsld_roles
environment_id - references imsld_environments
property_id ** - references imsld_properties
imsld_roles. This table contains all the defined roles
role_id - references imsld_roles
role_type
create_new_p - multopleoccurrences of this role may be + created during runtime?
match_persons - exclusively-in-roles, not-exclusively
max_persons. Maximum number of persons for this role
min_persons. Minimum number of persons for this - role
role_name. The name of the role
information_id - references imsld_items
role_parent_id. The parent role. This allows a hierarchy + role
role_name. The name of the role
information_itemmodel_id - references imsld_items
parent_role_id. The parent role. This allows a hierarchy of roles. The root of the hierarchy are learner and stuff, which - has not a parent role
imsld_activities. This table defines the three types of - activities in IMS-LD: learning activities, support activities and - structure activities. These three tables references to this - table
activity_id
activity_structure_id - references - imsld_activity_structures
imsld_learning_activities. This table stores all the learning - activities of IMS-LD
learning_activity_id - references imsld_activities
title
isvisible_p - initial visibility attribute. Initial value: - true
learning_objective_id - references - imsld_learning_objectives
prerequisite_id - references imsld_itemmodel
parameter_id - references imsld_parameters
activity_description_id - references imsld_items
complete_activity_id - references - complete_activities
on_completion_id ** - references - imsld_on_completions
imsld_complete_activities. This is a table where for each - entry is specified when an activity is considered completed
complete_activity_id
user_choice - the user specifies that this activity is - completed
time_limit - references imsld_time_limits. The activity is - completed when the time is completed
when_property_value_is_set_id ** - references - imsld_when_property_value_is_set
imsld_learning_activity_environments_map This table maps - learning activities with environments
learning_activity_id - references - imsld_learning_activities
environment_id - references imsld_environments
imsld_support_activities. This table stores all the support + has not a parent role
imsld_learning_activities. This table stores all the learning + activities of IMS-LD
learning_activity_id - references imsld_activities
title
component_id - references imsld_components
isvisible_p - initial visibility attribute. Initial value: + true
learning_objective_itemmodel_id - references + imsld_itemmodels
time_limit_id - references imsld_time_limits
prerequisite_itemmodel_id - references + imsld_itemmodels
parameter_value
activity_description_itemmodel_id - references + imsld_itemmodels
on_completion_id - references imsld_on_completions
identifier - unique identifier of the activity
imsld_support_activities. This table stores all the support activities of IMS-LD
support_activity_id - references imsld_activities
component_id - references imsld_components
isvisible_p - initial visibility attribute. Initial value: - true
title. The name of the support activity
activity_description_id - references imsld_items
complete_activity_id - references - imsld_complete_activities
on_completion_id - references imsld_on_completions
imsld_support_activity_roles_map. This table maps a support - role to an activity
support_activity_id - references - imsld_support_activities
role_id - references imsld_roles
imsld_support_activity_environments_map. This table maps - support activities with environments
support_activity_id - references - imsld_support_activities
environment_id - references imsld_environments
imsld_activity_structures. This table contains all the + true
title. The name of the support activity
parameter_value
activity_description_itemmodel_id - references + imsld_itemmodels
user_choice - The user decides when the activity is + completed
time_limit_id - If user_choice is null, the activity will + be completed until the time referenced by this id has been + expired.
on_completion_id - references imsld_on_completions
identifier - unique identifier of the acrivity
imsld_activity_structures. This table contains all the activity structures of IMS-LD. Each entry is one activity - structure.
activity_structure_id - references imsld_activities
number_to_select - if not null, the activity structure is + structure.
activity_structure_id - references imsld_activities
component_id - references imsld_components
number_to_select - if not null, the activity structure is completed when the number of activities completed equals the - number set
sort - possible values: as-is, visibility-order
structure_type - sequence or selection
title. The name of the activity structure
information_id - references imsld_items
imsld_activity_structure_choices
choice_id
learning_activity_id - references - imsld_learning_activities
support_activity_id - references - imsld_support_atcivities
unit_of_learning_id - references imsld_imslds
activity_structure_id - references - imsld_activity_structures
imsld_activity_structure_choices_map
activity_structure_id - references - imsld_activity_structures
choice_id - references - imsld_activity_structure_choices
imsld_activity_structure_environments_map
activity_structure_id - references - imsld_activity_structures
environment_id - references imsld_environments
imsld_environments
environment_id
imsld_environmnent_instances
environment_id - references imsld_environments
environmen_instance_id
title
imsld_environment_instance_choices
choice_id
learning_object_id - references - imsld_learning_objects
service_id - references imsld_services
environment_id - references imsld_environments
imsld_environment_instances_environment_instance_choices_map
choice_id - references - imsld_environment_instance_choices
environment_instance_id - references - imsld_environmnent_instances
imsld_learning_objects
learning_object_id
class
isvisible_p - the user decides when the activity is - completed?
parameter_id - references imsld_parameters
type - knowledge-object, tool-object, test-object, etc. - (learning resource type from the IEEE LTSC LOM)
item_sequence_id - references - ims_leanring_object_item_sequences
schema_sequence_id - references - ims_learning_object_schema_sequences
item_id - references imsld_items
environment_id - references imsld_environments
imsld_learning_object_item_sequences: First sequence of the - learning objects
sequence_id
title
ims_learning_object_schema_sequences: Second sequence of the - learning objects
sequence_id
schema
schemaversion
imsld_learning_object_item_sequence_items_map
sequence_id - references - imsld_learning_object_item_sequences
item_id - references imsld_items
imsld_parameters: Table for holding the parameter values. This - table will possible dissapear, depending if in the development phase - there is the need of storing more information about the - parameters
parameter_id
parameter_value
imsld_services. It contains all the services
service_id
class
identifier
isvisible_p
parameter_id
email_service - (send_mail) references - imsld_email_services
conference_service_id - references - imsld_conference_services
index_search_id - refernces - imsld_index_search_services
imsld_email_services. It describes all the email - services
email_id - references imsld_services
select - all-persons-in-role, persons-in-role
title
imsld_email_data
email_data_id
role_id - references imsld_roles
email_property_id - references imsld_properties **
username_property_id - references imsld_properties - **
imsld_email_service_email_data_map
email_id - references imsld_email_services
email_data_id - references imsld_email_data
imsld_conference_services
conference_id
conference_type - synchronous, asynchronous or - announcement
title
conference_manager_id - references imsld_roles
moderator_id - references imsld_roles
item_id - references imsld_items
imsld_conference_participants_or_observers_map
conference_id - references - imsld_conference_services
role_id - references imsld_roles
imsld_index_search_services
search_service_id
title
index_class - this element selects the calss to make the + number set
sort - possible values: as-is, visibility-order
structure_type - sequence or selection
title. The name of the activity structure
information_itemmodel_id - references + imsld_itemmodels
identifier
imsld_environments. This table contains the environments of + the unit of learning. An environment consists of learning objects, + services and other environments, and it can be referentiated by some + other tables too.
environment_id
parent_environment_id
title
imsld_learning_objects
learning_object_id
class
isvisible_p - the user decides when the activity is + completed?
parameter_value
type - knowledge-object, tool-object, test-object, etc. + (learning resource type from the IEEE LTSC LOM)
environment_id - references imsld_environments
schema_version
imsld_email_services. It describes all the email + services
email_service_id
select - all-persons-in-role, persons-in-role
title
is_visible_p
imsld_email_data
sendmail_service_id - references + imsld_email_services
role_id - references imsld_roles
email_data
email_property_id - references imsld_properties **
username_property_id - references imsld_properties + **
imsld_conference_services
conference_id
conference_type - synchronous, asynchronous or + announcement
title
item_id - references imsld_items
is_visible_p
imsld_index_search_services
search_service_id
title
index_class - this element selects the calss to make the index on
index_element - this element selects the element to make - the index on
index_type_of_element - type of element to index on
search - how a user can access the indexed entities
search_type - type of search facility that is expected at + the index on
index_type_of_element - type of element to index on
search_type - type of search facility that is expected at runtime: free-text-search, index-with-reference, - index-without-reference
imsld_learning_objectives. This table contains all the - different objectives of the different unit of learning and - activities. Each entry of this table is a set of objectives. A set - of objectives is symbolized by an itemmodel_id
learning_objective_id
itemmodel_id - references imsld_itemmodels
imsld_methods
method_id
time_limit_id - references imsld_time_limits. If not null, + index-without-reference
is_visible_p
imsld_methods
method_id
time_limit_id - references imsld_time_limits. If not null, the method is completed when this time has been completed, otherwise, the method is completed when all the plays mapped to this method through the imsld_plays_to_complete_method are - completed
on_completion_id - references imsld_on_completions
condition_id ** - references imsld_conditions
imsld_plays_to_complete_method. It contains all the plays that - has a method. Each play can be selected in parallel by an user - during the delivering of a unit of learning
method_id
play_id
imsld_plays
play_id
isvisible_p - the user decides when the activity is - completed?
title
complete_play_id - references imsld_complete_play
on_completion_id - references imsld_on_completions
imsld_complete_play
complete_play_id
when_last_act_completed - references imsld_acts. The play - is completed when this act is completed
time_limit_id - references imsld_time_limits. The play is - completed when this time is completed
when_property_value_is_set_id * - references - imsld_when_property_value_is_set
imsld_method_plays_map
method_id - references imsld_methods
play_id - references imsld_plays
imsld_play_acts_map
play_id - references imsld_plays
act_id - references imsld_acts
imsld_acts
act_id
title
complete_act_id - references imsld_complete_acts
on_completion_id - references on_completion
when_condition_true ** - references - imsld_when_condition_true
imsld_complete_acts
complete_act_id
time_limit_id - references imsld_complete_acts. When not - null, the act is completed when this time has been completed, - otherwise, the act is completed until all role parts mapped to - this complete_act_id trhoug the imsld_act_role_parts are - completed
when_property_value_is_set_id ** - references - imsld_when_property_value_is_set
imsld_act_role_parts
complete_act_id - references imsld_acts
role_part_id - references imsld_part_id
imsld_act_role_parts_map
role_part_id - references imsld_role_parts
act_id - references imsld_acts
imsld_role_part_choices
choice_id
learning_activity_id - references - imsld_learning_activities
support_activity_id - references - imsld_support_activities
unit_of_learning_id - references imsld_imslds
activity_structure_id - references - imsld_activity_structures
environment_id - references imsld_environments
imsld_role_parts - mapping table between acts and roles
role_part_id
title
role_id - references imsld_roles
choice_id - references imsld_role_part_choices
imsld_on_completion
on_completion_id
feedback_description_id - references + completed
on_completion_id - references imsld_on_completions
condition_id ** - references imsld_conditions
imsld_plays
play_id
method_id - references imsld_methods
is_visible_p - the user decides when the activity is + completed?
title
when_last_act_completed the play is completed until the + act referenced by this field is completed
time_limit_id - references time_limits. If + when_last_act_completed is null, the play is completed when the + time indicated here has been completed
on_completion_id - references imsld_on_completions
imsld_acts
act_id
play_id - references imsld_plays
title
time_limit_id - if there are no role_parts mapped to this + act throug the mapping table (explained later), the act is + completed until the the time indicated here has been + completed
on_completion_id - references on_completion
when_property_value_is_set ** - references + imsld_when_property_value_is_set
imsld_role_parts
role_part_id - references imsld_part_id
act_id - references imsld_acts
role_id
unit_of_learning_id - references imsld_imslds
environment_id - references imsld_environments
imsld_on_completion
on_completion_id
feedback_description_id - references imsld_itemmodels
change_property_value_id ** - references imsld_change_property_value
notification_id - references imsld_notifications ***
imsld_itemmodels. This is a table that contains a text and an id. In conjunction with the tables imsld_itemmodel and imsld_itemmodel_items_map allow to associate several items to the - same itemmodel.
title
itemmodel_id
imsld_itemmodel_items_map
item_id - references imsld_items
itemmodel_id - references imsld_itemmodels
imsld_items. Items are used for multiple purposes in other + same itemmodel.
title
itemmodel_id
imsld_items. Items are used for multiple purposes in other tables. For example it can describe objectives, prerequisites, - references to files, etc.
item_id
identifier. Unique identifier for the IMS-LD
identifierref. It references the IMS CP
isvisible_p.
parameter_id
title: A text that can represent a prerequisite, an - objective, the name of a file, etc.
parent_item - references imsld_items. An item can - reference to another item, which is a sub-item or child of the - one referencing it.
imsld_time_limits
time_limit_id
time_limit - amount of time in a specific format
property_id ** - references imsld_properties
Next, the tables necessary for Level A are draw in the - form of an E-R diagram