Thread: [Logicampus-svn] SF.net SVN: logicampus:[1291] logicampus/trunk/src/pbdo/logicampus_pbdo.xml
Brought to you by:
trilexcom
Menu
▾
▴
logicampus-cvs
|
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.
|
|
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.
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X