Level B
Prev | Chapter 4. Data Model | Next

## Level B

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 ***

Prev | Up | Next
Level A | Home | Level C