Run Tables
Prev | Chapter 4. Data Model | Next

## Run Tables

The previous tables are referred to the IMS-LD specifications level A, B and C. They have all the information necessary to map an XML compliant IMS-LD document to the tables in the .LRN platform. But also, for the ims-ld package to interact with real users, we need additional tables. These new tables are necessary for the execution of the player where the information is sequenced to the student. These tables are described in this Section. Next is shown the E-R diagram for these tables

- imsld_party_roles_map. This table maps parties of a .LRN course to the roles defined in the IMS-LD document. A party can be either a user or a group. One party can belong to several roles.

  - party_id references parties

  - role_id references imsld_roles

- imsld_parties_property_values_map. This table maps parties of a .LRN course to the properties defined in the IMS-LD document. One party can have several property values to establish. The properties can be local or global.

  - party_id references parties

  - property_id references imsld_properties

  - property_value. This is the value of the property for the party in a current moment. The value can change during the delivering of the unit of learning

- imsld_roles_property_values_map. This table maps roles of the IMS-LD document to the properties of the IMS-LD document. One role can have several property values to establish. The properties can only be local.

  - roles_id references imsld_roles

  - property_id references imsld_properties

  - property_value. This is the value of the property for the role in a current moment. The value can change during the delivering of the unit of learning

- imsld_property_values. This table stores the values of the properties that are common for all the users of the the IMS-LD document. There can be several property values to establish. The properties can be local or global.

  - property_id references imsld_properties

  - property_value. This is the value of the property for the role in a current moment. The value can change during the delivering of the unit of learning

- imsld_parties_activities_audit. This table stores all the .LRN parties information about the IMS-LD delivering that is of interest. related to activities At present we have defined only a little information, but in the future this information may be expanded. Each entry of the table has an activity that has been realized by a party.

  - party_id references parties

  - activity_id references imsld_activity

  - delivering_order. It represents the order of visualization of the activity in the sequence of activities

  - selected_p. It is true if the party select by himself the activity. It is false if the activity was sequenced to the party

  - start_time. The start time of the activity

  - end_time. The end time of the activity

  - done_p. It is true if the activity is complete

  - act_id references ismld_parties_acts_audit

- imsld_parties_acts_audit. This table stores all the .LRN parties information about the IMS-LD delivering that is of interest related to acts. At present we have defined only a little information, but in the future this information may be expanded. Each entry of the table has an act that has been realized by a party.

  - party_id references parties

  - act_id references imsld_acts

  - start_time. The start time of the act

  - end_time. The end time of the activity

  - done_p. It is true if the act is complete

- imsld_parties_plays_audit. This table stores all the .LRN parties information about the IMS-LD delivering that is of interest related to plays. At present we have defined only a little information, but in the future this information may be expanded. Each entry of the table has an act that has been realized by a party.

  - party_id references parties

  - play_id references imsld_plays

  - start_time.The start time of the act

  - end_time. The end time of the activity

  - done_p. It is true if the act is complete

Prev | Up | Next
Level C | Home | Chapter 5. Architectural Model