[Logicampus-svn] SF.net SVN: logicampus:[1291] logicampus/trunk/src/pbdo/logicampus_pbdo.xml
Brought to you by:
trilexcom
|
From: <fah...@us...> - 2009-02-27 11:50:07
|
Revision: 1291
http://logicampus.svn.sourceforge.net/logicampus/?rev=1291&view=rev
Author: faheemkhan
Date: 2009-02-27 11:50:01 +0000 (Fri, 27 Feb 2009)
Log Message:
-----------
Removed Paths:
-------------
logicampus/trunk/src/pbdo/logicampus_pbdo.xml
Deleted: logicampus/trunk/src/pbdo/logicampus_pbdo.xml
===================================================================
--- logicampus/trunk/src/pbdo/logicampus_pbdo.xml 2009-02-27 11:44:02 UTC (rev 1290)
+++ logicampus/trunk/src/pbdo/logicampus_pbdo.xml 2009-02-27 11:50:01 UTC (rev 1291)
@@ -1,817 +0,0 @@
-<?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="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>
- </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.
|