Level B extends the table email_data and add: username_property_id and email_property_id (**) Next is shown the E-R diagram for these tables
imsld_properties (add a reference to properties from imsld_components and time_limits **)
property_id
imsld_loc_locpers_locrole_properties: Combined table for the loc, locpers and locrole properties
property_id - references imsld_properties
title. The name of the property
datatype - references imsld_datatypes
initial_value
imsld_globpers_glob_property: Combined table for the glob and globpers properties
property_id - references imsld_properties
global_definition_id - references imsld_global_definitions
existing
imsld_global_definitions
property_id - references imsld_properties
uri
title
global_definition
datatype_id
initial_value
imsld_property_groups
property_group_id
property_id - references imsld_properties
title
imsld_group_property_choices
choice_id
property_id - references imsld_properties
proerty_group_id - references imsld_property_groups
imsld_restrictions
restriction_id
restriction_type - minExclusive, minInclusive, maxExclusive, maxInclusive, totalDigits, fractionDigits, length, minLength, maxLength, enumeration, whiteSpace, pattern
restriction
imsld_property_restrictions_map
restriction_id - references imsld_restrictions
property_id - references imsld_properties
imsld_datatypes
datatype_id
datatype - string, boolean, integer, uri, datetime, file, real, tet, duration, other
imsld_when_property_value_is_set (add a reference to this table from the tables: complete_activities, complete_act, complete_play and complete_unit_of_learning **)
when_property_value_is_set_id
property_id - references imsld_properties
property_value_id - references property_values
imsld_property_values
property_value_id
langstring
calculate_id - references imsld_calculates
property_id - references imsld_properties
imsld_change_property_values: A reference to this table must be added from the imsld_on_completion table in level A
change_property_value_id
property_id - references imsld_properties
property_value_id - references property_values
imsld_monitors
monitor_id
service_id - references imsld_services
monitor_choice_id - references imsld_monitor_choices
imsld_monitor_choices
choice_id
role_id - references imsld_roles
self - references imsld_roles
imsld_conditions: A reference to this table must be added from the table imsld_methods in level A
condition_id
title
imsld_sequences
sequence_id
condition_id - references imsld_conditions
sequence_sort - to know how to evaluate the condition
if_id - references imsld_ifs
imsld_then_model
then_model_id
show_id - references imsld_show_hide
hide_id - references imsld_show_hide
change_property_value
imsld_ifs
if_id
expression_id - references imsld_expressions
true_thenmodel_id - 'then', evaluated if the expression is true. References imsld_then_model
false_thenmodel_id - 'else', evaluated if the expression is false. References imsld_then_model
imsld_expressions - table holding the expressions. Instead of making a table for each type of expression, we store the expression_type and according to that value we know what other attributes in the table have to be stored in order to use them
expression_id
expression_type - is-member-of-role, is, is-not, and, or, sum, subtract, multiply, divide, greater-than, less-than, users-in-role, no-value, time-unit-of-learning-started, datetime-activity-started, current-datetime, complete, not
expression_id - references imsld_expressions
calculate_id - references imsld_calculates
expression_one_id - references imsld_expressions
expression_two_id - references imsld_expressions
role_id - references imsld_roles
property_id - references imsld_properties
time_unit_of_learning_started
datetime_activity_started
current_datetime
imsld_calculates
calculate_id
right_operand - references imsld_operands
left_operand - references imsld_operands
imsld_operands
operand_id
property_id - references imsld_properties
property_value - references imsld_property_values
expression_id - references imsld_expressions
imsld_when_condition_true (add a reference from the imsld_complete_acts table **)
when_condition_true_id
role_id - references imsld_roles
expression_id - references imsld_expressions
imsld_show_hide
show_hide_id
class
item_id - references imsld_items
environment_id - references imsld_environments
learning_activity_id - references imsld_learning_activities
support_activity_id - references imsld_support_activities
activity_structure_id - references imsld_activity_structures
play_id - references imsld_plays
unit_of_learning_id - references imsld_imslds
imsld_global_elements
global_element_id
view_set_property_id - references view_set_properties
imsld_view_set_properties
view_set_property_id
type - view-property, view-property-group, set-property, set-property-group
href
property_of - self or supporter-person
ref
view - value or title-value
max_transactions
transaction_type
notification_id - references imsld_notifications ***