[Logicampus-svn] SF.net SVN: logicampus:[1292] logicampus/trunk/src/pbdo/logicampus_pbdo.xml
Brought to you by:
trilexcom
Menu
▾
▴
[Logicampus-svn] SF.net SVN: logicampus:[1292] logicampus/trunk/src/pbdo/logicampus_pbdo.xml
|
From: <fah...@us...> - 2009-02-27 11:52:27
|
Revision: 1292
http://logicampus.svn.sourceforge.net/logicampus/?rev=1292&view=rev
Author: faheemkhan
Date: 2009-02-27 11:52:19 +0000 (Fri, 27 Feb 2009)
Log Message:
-----------
new xml for PU Tasks: Image Lob
Added Paths:
-----------
logicampus/trunk/src/pbdo/logicampus_pbdo.xml
Added: logicampus/trunk/src/pbdo/logicampus_pbdo.xml
===================================================================
--- logicampus/trunk/src/pbdo/logicampus_pbdo.xml (rev 0)
+++ logicampus/trunk/src/pbdo/logicampus_pbdo.xml 2009-02-27 11:52:19 UTC (rev 1292)
@@ -0,0 +1,828 @@
+<?xml version="1.0"?>
+<project
+ name="logicampus">
+
+ <entity name="lc_action_log" description="log important actions">
+ <attribute
+ name = "lc_action_log_id"
+ type = "int"
+ size = "11"
+ primaryKey = "true" />
+ <attribute
+ name = "lc_action_log_type_id"
+ type = "int"
+ size = "11" />
+ <attribute
+ name = "action_datetime"
+ type = "int"
+ size = "11" />
+ <attribute
+ name = "agent_ip"
+ type = "varchar"
+ size = "32" />
+ <attribute
+ name = "agent_url"
+ type = "varchar"
+ size = "32" />
+ <attribute
+ name = "file"
+ type = "varchar"
+ size = "255" />
+ <attribute
+ name = "line"
+ type = "varchar"
+ size = "32" />
+ <attribute
+ name = "agent_username"
+ type = "varchar"
+ size = "32" />
+ <attribute
+ name = "message"
+ type = "blob"
+ size = "32" />
+ <attribute
+ name = "class_id"
+ type = "int"
+ size = "11" />
+ <attribute
+ name = "semester_id"
+ type = "int"
+ size = "11" />
+ <key
+ attribute="lc_action_log_type_id"
+ name="lc_action_log_type_idx"/>
+ <key
+ attribute="class_id"
+ name="class_idx"/>
+ <key
+ attribute="semester_id"
+ name="semester_idx"/>
+ <key
+ attribute="action_datetime"
+ name="action_datetime_idx"/>
+ </entity>
+ <entity name="lc_action_log_type" description="types of actions that can be logged">
+ <attribute
+ name = "lc_action_log_type_id"
+ type = "int"
+ size = "11"
+ primaryKey = "true" />
+ <attribute
+ name = "action_code"
+ type = "varchar"
+ size = "32" />
+ <attribute
+ name = "display_name"
+ type = "varchar"
+ size = "255" />
+ </entity>
+ <entity name="lc_event">
+ <attribute
+ name = "lc_event_id"
+ type = "int"
+ size = "11"
+ extra = "unsigned"
+ primaryKey = "true" />
+ <attribute
+ name = "calendar_type"
+ type = "varchar"
+ size = "255" />
+ <attribute
+ name = "username"
+ type = "varchar"
+ size = "15" />
+ <attribute
+ name = "title"
+ type = "varchar"
+ size = "255" />
+ <attribute
+ name = "description"
+ type = "text"/>
+ <attribute
+ name = "location"
+ type = "varchar"
+ size = "255" />
+ <attribute
+ name = "start_date"
+ type = "int"
+ size = "11" />
+ <attribute
+ name = "end_date"
+ type = "int"
+ size = "11" />
+ <attribute
+ name = "groups"
+ type = "text"/>
+ <attribute
+ name = "notgroups"
+ type = "text"/>
+ <attribute
+ name = "last_modified"
+ type = "timestamp"
+ size = "11" />
+ <attribute
+ name = "repeat_type"
+ type = "int"
+ size = "11" />
+ <attribute
+ name = "repeat_count"
+ type = "int"
+ size = "11"
+ extra = "unsigned" />
+ <attribute
+ name = "repeat_mask"
+ type = "int"
+ size = "11"
+ extra = "unsigned" />
+ <attribute
+ name = "repeat_exclude"
+ type = "text"
+ size = "11" />
+ <attribute
+ name = "class_id"
+ type = "int"
+ size = "11"
+ extra = "unsigned" />
+ <key
+ attribute="class_id"
+ name="class_idx"/>
+ <key
+ attribute="start_date"
+ name="start_date_idx"/>
+ <key
+ attribute="end_date"
+ name="end_date_idx"/>
+ </entity>
+ <entity name="class_enrollment" description="hold enrollment info for one student in one class and section">
+ <attribute
+ name = "class_enrollment_id"
+ type = "int"
+ size = "11"
+ primaryKey = "true" />
+ <attribute
+ name = "student_id"
+ type = "int"
+ size = "11" />
+ <attribute
+ name = "semester_id"
+ type = "int"
+ size = "11" />
+ <attribute
+ name = "class_id"
+ type = "int"
+ size = "11" />
+ <attribute
+ name = "section_number"
+ type = "int"
+ size = "11" />
+ <attribute
+ name = "enrolled_on"
+ type = "int"
+ size = "11" />
+ <attribute
+ name = "active"
+ type = "int"
+ size = "11" />
+ <attribute
+ name = "withdrew_on"
+ type = "int"
+ size = "11" />
+ <key
+ attribute="student_id"
+ name="student_idx"/>
+ <key
+ attribute="semester_id"
+ name="semester_idx"/>
+ <key
+ attribute="class_id"
+ name="class_idx"/>
+ <key
+ attribute="active"
+ name="active_idx"/>
+ </entity>
+ <entity name="class_syllabus">
+ <attribute name="class_syllabus_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="class_id"
+ required="true"
+ default="0"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="section_title"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="section_content"
+ required="true"
+ size=""
+ type="LONGVARCHAR"/>
+ <attribute name="rank"
+ required="true"
+ default="0"
+ size="11"
+ type="INTEGER"/>
+
+ <key
+ attribute="rank"
+ name="rank_idx"/>
+ </entity>
+
+ <entity name="class_lesson_sequence">
+ <attribute name="class_lesson_sequence_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lesson_id"
+ required="true"
+ default="0"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="class_id"
+ required="true"
+ default="0"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_class_repo_id"
+ required="true"
+ default="0"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_type"
+ required="true"
+ size="100"
+ type="VARCHAR"/>
+ <attribute name="lob_sub_type"
+ required="true"
+ size="100"
+ type="VARCHAR"/>
+ <attribute name="lob_mime"
+ required="true"
+ size="100"
+ type="VARCHAR"/>
+ <attribute name="lob_title"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="link_text"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="not_before_seq_id"
+ required="false"
+ size="11"
+ type="int"/>
+ <attribute name="start_offset"
+ required="false"
+ size="11"
+ type="int"/>
+ <attribute name="start_time"
+ required="false"
+ size="5"
+ extra="unsigned"
+ type="mediumint"/>
+ <attribute name="end_offset"
+ required="false"
+ size="11"
+ type="int"/>
+ <attribute name="end_time"
+ required="false"
+ size="5"
+ extra="unsigned"
+ type="mediumint"/>
+ <attribute name="due_offset"
+ required="false"
+ size="11"
+ type="int"/>
+ <attribute name="due_time"
+ required="false"
+ size="5"
+ extra="unsigned"
+ type="mediumint"/>
+ <attribute name="grace_period_days"
+ required="false"
+ size="11"
+ type="int"/>
+ <attribute name="rank"
+ required="true"
+ default="0"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="hide_until_start"
+ required="true"
+ size="2"
+ default="0"
+ type="int"/>
+ <attribute name="hide_after_end"
+ required="true"
+ size="2"
+ default="0"
+ type="int"/>
+ <key
+ attribute="class_id"
+ name="class_idx"/>
+ <key
+ attribute="lesson_id"
+ name="lesson_idx"/>
+ <key
+ attribute="lob_class_repo_id"
+ name="lob_class_repo_idx"/>
+ <key
+ attribute="rank"
+ name="rank_idx"/>
+ <key
+ attribute="link_text"
+ name="link_text_idx"/>
+ </entity>
+
+ <entity name="lob_repo_entry">
+ <attribute name="lob_repo_entry_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_guid"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="lob_title"
+ required="true"
+ default=""
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="lob_type"
+ required="true"
+ size="100"
+ type="VARCHAR"/>
+ <attribute name="lob_sub_type"
+ required="true"
+ size="100"
+ type="VARCHAR"/>
+ <attribute name="lob_mime"
+ required="true"
+ size="100"
+ type="VARCHAR"/>
+ <attribute name="lob_description"
+ required="false"
+ type="TEXT"/>
+ <attribute name="lob_notes"
+ required="false"
+ type="LONGTEXT"/>
+ <attribute name="lob_urltitle"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="lob_version"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_bytes"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <key
+ attribute="lob_guid"
+ name="lob_guid_idx"/>
+ </entity>
+
+ <entity name="lob_content">
+ <attribute name="lob_content_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_text"
+ required="false"
+ type="LONGTEXT"/>
+ <attribute name="lob_binary"
+ required="false"
+ type="LONGBLOB"/>
+ <attribute name="lob_filename"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="lob_caption"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="lob_repo_entry_id"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <key
+ attribute="lob_repo_entry_id"
+ name="lob_repo_entry_idx"/>
+ <foreign-key foreignTable="lob_repo_entry">
+ <reference
+ local="lob_repo_entry_id"
+ foreign="lob_repo_entry_id"/>
+ </foreign-key>
+ </entity>
+
+
+ <entity name="lob_test">
+ <attribute name="lob_test_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+
+ <attribute name="lob_repo_entry_id"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="num_retry"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="is_practice"
+ required="true"
+ size="2"
+ type="TINYINT"/>
+ <key
+ attribute="lob_repo_entry_id"
+ name="lob_repo_entry_idx"/>
+ <foreign-key foreignTable="lob_repo_entry">
+ <reference
+ local="lob_repo_entry_id"
+ foreign="lob_repo_entry_id"/>
+ </foreign-key>
+ </entity>
+
+ <entity name="lob_test_qst">
+ <attribute name="lob_test_qst_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+
+ <attribute name="lob_test_id"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+
+ <attribute name="image_content_id"
+ required="false"
+ size="11"
+ type="INTEGER"/>
+
+ <attribute name="qst_text"
+ required="true"
+ default=""
+ type="TEXT"/>
+
+ <attribute name="qst_choices"
+ required="true"
+ default=""
+ type="TEXT"/>
+
+ <attribute name="question_type_id"
+ required="true"
+ default=""
+ type="tinyint"/>
+
+ <attribute name="qst_points"
+ required="true"
+ default=""
+ type="tinyint"/>
+
+ <key
+ attribute="lob_test_id"
+ name="lob_test_idx"/>
+ <foreign-key foreignTable="lob_test">
+ <reference
+ local="lob_test_id"
+ foreign="lob_test_id"/>
+ </foreign-key>
+
+ <foreign-key foreignTable="lob_repo_entry">
+ <reference
+ local="image_content_id"
+ foreign="lob_repo_entry_id"/>
+ </foreign-key>
+ </entity>
+
+ <entity name="lob_activity">
+ <attribute name="lob_activity_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+
+ <attribute name="lob_repo_entry_id"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="response_type_id"
+ required="true"
+ size="4"
+ type="TINYINT"/>
+ <key
+ attribute="lob_repo_entry_id"
+ name="lob_repo_entry_idx"/>
+ <foreign-key foreignTable="lob_repo_entry">
+ <reference
+ local="lob_repo_entry_id"
+ foreign="lob_repo_entry_id"/>
+ </foreign-key>
+ </entity>
+
+ <entity name="lob_metadata">
+ <attribute name="lob_metadata_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_repo_entry_id"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="subject"
+ required="true"
+ default=""
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="subdisc"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="author"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="source"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="copyright"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="license"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="user_version"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="status"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="updated_on"
+ required="true"
+ size="11"
+ type="integer"/>
+ <attribute name="created_on"
+ required="true"
+ size="11"
+ type="integer"/>
+ <key
+ attribute="lob_repo_entry_id"
+ name="lob_repo_entry_idx"/>
+ </entity>
+
+ <entity name="lob_user_link">
+ <attribute name="lob_user_link_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_repo_entry_id"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="user_id"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="is_owner"
+ required="false"
+ size="11"
+ type="INTEGER"/>
+ <key
+ attribute="lob_repo_entry_id"
+ name="lob_repo_entry_idx"/>
+ <key
+ attribute="user_id"
+ name="user_id"/>
+ <key
+ attribute="is_owner"
+ name="is_owner_idx"/>
+ </entity>
+
+ <entity name="lob_class_repo">
+ <attribute name="lob_class_repo_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="class_id"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_repo_entry_id"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_guid"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="lob_title"
+ required="true"
+ default=""
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="lob_urltitle"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="lob_copy_style"
+ required="true"
+ size="1"
+ type="CHAR"/>
+ <attribute name="lob_type"
+ required="true"
+ size="100"
+ type="VARCHAR"/>
+ <attribute name="lob_sub_type"
+ required="true"
+ size="100"
+ type="VARCHAR"/>
+ <attribute name="lob_mime"
+ required="true"
+ size="100"
+ type="VARCHAR"/>
+ <attribute name="lob_description"
+ required="false"
+ type="TEXT"/>
+ <attribute name="lob_version"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_bytes"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <key
+ attribute="lob_version"
+ name="lob_version_idx"/>
+ <key
+ attribute="lob_repo_entry_id"
+ name="lob_repo_entry_idx"/>
+ <key
+ attribute="lob_type"
+ name="lob_type_idx"/>
+ <key
+ attribute="class_id"
+ name="class_idx"/>
+ <key
+ attribute="lob_guid"
+ name="lob_guid_idx"/>
+ </entity>
+
+ <entity name="lob_class_metadata">
+ <attribute name="lob_class_metadata_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_class_repo_id"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="subject"
+ required="true"
+ default=""
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="subdisc"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="author"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="source"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="copyright"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="license"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="user_version"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="status"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="updated_on"
+ required="true"
+ size="11"
+ type="integer"/>
+ <attribute name="created_on"
+ required="true"
+ size="11"
+ type="integer"/>
+ <key
+ attribute="lob_class_repo_id"
+ name="lob_class_repo_idx"/>
+ </entity>
+
+ <entity name="lob_class_content">
+ <attribute name="lob_class_content_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_class_repo_id"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_text"
+ required="false"
+ type="LONGTEXT"/>
+ <attribute name="lob_binary"
+ required="false"
+ type="LONGBLOB"/>
+ <attribute name="lob_filename"
+ required="true"
+ size="255"
+ type="VARCHAR"/>
+ <attribute name="lob_caption"
+ size="255"
+ type="VARCHAR"/>
+ <key
+ attribute="lob_class_repo_id"
+ name="lob_class_repo_idx"/>
+ <foreign-key foreignTable="lob_class_repo">
+ <reference
+ local="lob_class_repo_id"
+ foreign="lob_class_repo_id"/>
+ </foreign-key>
+ </entity>
+
+ <entity name="lob_class_activity">
+ <attribute name="lob_class_activity_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_class_repo_id"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="response_type_id"
+ required="true"
+ size="4"
+ type="TINYINT"/>
+ <key
+ attribute="lob_class_repo_id"
+ name="lob_class_repo_idx"/>
+ <foreign-key foreignTable="lob_class_repo">
+ <reference
+ local="lob_class_repo_id"
+ foreign="lob_class_repo_id"/>
+ </foreign-key>
+ </entity>
+
+ <entity name="lob_class_test">
+ <attribute name="lob_class_test_id"
+ required="true"
+ primaryKey="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="lob_class_repo_id"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="num_retry"
+ required="true"
+ size="11"
+ type="INTEGER"/>
+ <attribute name="is_practice"
+ required="true"
+ size="2"
+ type="TINYINT"/>
+ <key
+ attribute="lob_class_repo_id"
+ name="lob_class_repo_idx"/>
+ <foreign-key foreignTable="lob_class_repo">
+ <reference
+ local="lob_class_repo_id"
+ foreign="lob_class_repo_id"/>
+ </foreign-key>
+ </entity>
+</project>
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
