Index: lams_common/db/model/lams_11.clay
===================================================================
diff -u -rcdba68bf24f26a1ae8d8fbac9e15e531a42a39b6 -r4206c2b9c81db55b984029d55c41bef5abcb4788
--- lams_common/db/model/lams_11.clay	(.../lams_11.clay)	(revision cdba68bf24f26a1ae8d8fbac9e15e531a42a39b6)
+++ lams_common/db/model/lams_11.clay	(.../lams_11.clay)	(revision 4206c2b9c81db55b984029d55c41bef5abcb4788)
@@ -9,7 +9,7 @@
 <table-list>
 <table name="lams_authentication_method" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="922" y="137" width="-1" height="-1"/>
+<table-figure-bounds x="942" y="97" width="-1" height="-1"/>
 <column-list>
 <column name="authentication_method_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -77,7 +77,7 @@
 </table>
 <table name="lams_authentication_method_type" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="767" y="7" width="-1" height="-1"/>
+<table-figure-bounds x="940" y="10" width="-1" height="-1"/>
 <column-list>
 <column name="authentication_method_type_id" alias="" remarks="" mandatory="true" column-size="3" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -115,7 +115,7 @@
 </table>
 <table name="lams_gate_activity_level" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="1050" y="1103" width="-1" height="-1"/>
+<table-figure-bounds x="1520" y="1519" width="-1" height="-1"/>
 <column-list>
 <column name="gate_activity_level_id" alias="" remarks="" mandatory="true" column-size="11" decimal-digits="0" default-value="0" auto-increment="false">
 <column-description/>
@@ -153,7 +153,7 @@
 </table>
 <table name="lams_grouping_type" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="167" y="1408" width="-1" height="-1"/>
+<table-figure-bounds x="954" y="780" width="-1" height="-1"/>
 <column-list>
 <column name="grouping_type_id" alias="" remarks="" mandatory="true" column-size="11" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -191,7 +191,7 @@
 </table>
 <table name="lams_learning_activity" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="558" y="1225" width="-1" height="-1"/>
+<table-figure-bounds x="613" y="1146" width="-1" height="-1"/>
 <column-list>
 <column name="activity_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -426,18 +426,6 @@
 <variant type-name-pattern="TINYINT ZEROFILL"/>
 </data-type>
 </column>
-<column name="offline_instructions" alias="" remarks="" mandatory="false" column-size="0" decimal-digits="0" default-value="" auto-increment="false">
-<column-description/>
-<data-type name="TEXT" jdbc-type="-1" selected-variant-pattern="TEXT" literal-prefix="'" literal-suffix="'">
-<variant type-name-pattern="TEXT"/>
-</data-type>
-</column>
-<column name="online_instructions" alias="" remarks="" mandatory="false" column-size="0" decimal-digits="0" default-value="" auto-increment="false">
-<column-description/>
-<data-type name="TEXT" jdbc-type="-1" selected-variant-pattern="TEXT" literal-prefix="'" literal-suffix="'">
-<variant type-name-pattern="TEXT"/>
-</data-type>
-</column>
 <column name="max_number_of_options" alias="" remarks="" mandatory="false" column-size="5" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
 <data-type name="INT" jdbc-type="4" selected-variant-pattern="INT(%n)">
@@ -733,7 +721,7 @@
 </table>
 <table name="lams_learning_activity_type" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="710" y="1086" width="-1" height="-1"/>
+<table-figure-bounds x="492" y="1065" width="-1" height="-1"/>
 <column-list>
 <column name="learning_activity_type_id" alias="" remarks="" mandatory="true" column-size="11" decimal-digits="0" default-value="0" auto-increment="false">
 <column-description/>
@@ -771,7 +759,7 @@
 </table>
 <table name="lams_learning_design" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="-5" y="1005" width="-1" height="-1"/>
+<table-figure-bounds x="-69" y="1221" width="-1" height="-1"/>
 <column-list>
 <column name="learning_design_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -889,6 +877,18 @@
 <variant type-name-pattern="TEXT"/>
 </data-type>
 </column>
+<column name="online_instructions" alias="" remarks="" mandatory="false" column-size="0" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="TEXT" jdbc-type="-1" selected-variant-pattern="TEXT" literal-prefix="'" literal-suffix="'">
+<variant type-name-pattern="TEXT"/>
+</data-type>
+</column>
+<column name="offline_instructions" alias="" remarks="" mandatory="false" column-size="0" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="TEXT" jdbc-type="-1" selected-variant-pattern="TEXT" literal-prefix="'" literal-suffix="'">
+<variant type-name-pattern="TEXT"/>
+</data-type>
+</column>
 <column name="copy_type_id" alias="" remarks="" mandatory="true" column-size="4" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
 <data-type name="TINYINT" jdbc-type="-6" selected-variant-pattern="TINYINT(%n)">
@@ -1089,7 +1089,7 @@
 </table>
 <table name="lams_group" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="205" y="1576" width="-1" height="-1"/>
+<table-figure-bounds x="1142" y="698" width="-1" height="-1"/>
 <column-list>
 <column name="group_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -1158,7 +1158,7 @@
 </table>
 <table name="lams_grouping" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="268" y="1090" width="-1" height="-1"/>
+<table-figure-bounds x="1045" y="956" width="-1" height="-1"/>
 <column-list>
 <column name="grouping_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -1279,7 +1279,7 @@
 </table>
 <table name="lams_learning_library" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="951" y="1628" width="-1" height="-1"/>
+<table-figure-bounds x="810" y="1895" width="-1" height="-1"/>
 <column-list>
 <column name="learning_library_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -1342,7 +1342,7 @@
 </table>
 <table name="lams_learning_transition" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="-68" y="1556" width="-1" height="-1"/>
+<table-figure-bounds x="300" y="1508" width="-1" height="-1"/>
 <column-list>
 <column name="transition_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -1504,7 +1504,7 @@
 </table>
 <table name="lams_organisation" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="198" y="15" width="-1" height="-1"/>
+<table-figure-bounds x="216" y="149" width="-1" height="-1"/>
 <column-list>
 <column name="organisation_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -1628,7 +1628,7 @@
 </table>
 <table name="lams_organisation_type" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="663" y="189" width="-1" height="-1"/>
+<table-figure-bounds x="245" y="20" width="-1" height="-1"/>
 <column-list>
 <column name="organisation_type_id" alias="" remarks="" mandatory="true" column-size="3" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -1677,7 +1677,7 @@
 </table>
 <table name="lams_role" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="337" y="934" width="-1" height="-1"/>
+<table-figure-bounds x="486" y="9" width="-1" height="-1"/>
 <column-list>
 <column name="role_id" alias="" remarks="" mandatory="true" column-size="6" decimal-digits="0" default-value="0" auto-increment="false">
 <column-description/>
@@ -1731,7 +1731,7 @@
 </table>
 <table name="lams_user" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="1116" y="290" width="-1" height="-1"/>
+<table-figure-bounds x="1544" y="303" width="-1" height="-1"/>
 <column-list>
 <column name="user_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -1916,6 +1916,35 @@
 <variant type-name-pattern="BIGINT ZEROFILL"/>
 </data-type>
 </column>
+<column name="locale_language" alias="" remarks="ISO 639-1 Language Code (2 letter version) Java only supports 2 letter properly, not the 3 letter codes." mandatory="true" column-size="2" decimal-digits="0" default-value="en" auto-increment="false">
+<column-description/>
+<data-type name="CHAR" jdbc-type="1" selected-variant-pattern="CHAR(%n)" literal-prefix="'" literal-suffix="'">
+<variant type-name-pattern="CHAR(%n)" precision-variable="%n" precision-min="0" precision-max="255"/>
+<variant type-name-pattern="CHAR"/>
+<variant type-name-pattern="CHAR(%n) BINARY" precision-variable="%n" precision-min="0" precision-max="255"/>
+</data-type>
+</column>
+<column name="locale_country" alias="" remarks="ISO 3166 Country Code" mandatory="false" column-size="2" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="CHAR" jdbc-type="1" selected-variant-pattern="CHAR(%n)" literal-prefix="'" literal-suffix="'">
+<variant type-name-pattern="CHAR(%n)" precision-variable="%n" precision-min="0" precision-max="255"/>
+<variant type-name-pattern="CHAR"/>
+<variant type-name-pattern="CHAR(%n) BINARY" precision-variable="%n" precision-min="0" precision-max="255"/>
+</data-type>
+</column>
+<column name="theme_id" alias="" remarks="" mandatory="false" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="BIGINT" jdbc-type="-5" selected-variant-pattern="BIGINT(%n)">
+<variant type-name-pattern="BIGINT(%n)" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT UNSIGNED"/>
+<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="BIGINT ZEROFILL"/>
+</data-type>
+</column>
 </column-list>
 <primary-key name="PRIMARY" alias="" remarks="">
 <primary-key-description/>
@@ -1944,6 +1973,13 @@
 </foreign-key-figure>
 <foreign-key-column column-name="base_organisation_id" referenced-key-column-name="organisation_id"/>
 </foreign-key>
+<foreign-key name="FK_lams_user_4" alias="" remarks="" referenced-table-schema="DEFAULT_SCHEMA" referenced-table="lams_css_theme_ve" referenced-key="PK_LAMS_CSS_THEME_VE" on-update="NO ACTION" on-delete="NO ACTION" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
+<foreign-key-description/>
+<foreign-key-figure>
+<fk-fig-bendpoint-list/>
+</foreign-key-figure>
+<foreign-key-column column-name="theme_id" referenced-key-column-name="theme_ve_id"/>
+</foreign-key>
 </foreign-key-list>
 <index-list>
 <index name="PRIMARY" alias="" remarks="" unique="true">
@@ -1970,7 +2006,7 @@
 </table>
 <table name="lams_user_organisation" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="343" y="668" width="-1" height="-1"/>
+<table-figure-bounds x="483" y="112" width="-1" height="-1"/>
 <column-list>
 <column name="user_organisation_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -2050,7 +2086,7 @@
 </table>
 <table name="lams_user_organisation_role" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="305" y="830" width="-1" height="-1"/>
+<table-figure-bounds x="715" y="20" width="-1" height="-1"/>
 <column-list>
 <column name="user_organisation_role_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -2130,7 +2166,7 @@
 </table>
 <table name="lams_workspace" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="726" y="306" width="-1" height="-1"/>
+<table-figure-bounds x="470" y="319" width="-1" height="-1"/>
 <column-list>
 <column name="workspace_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -2193,7 +2229,7 @@
 </table>
 <table name="lams_workspace_folder" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="465" y="459" width="-1" height="-1"/>
+<table-figure-bounds x="149" y="683" width="-1" height="-1"/>
 <column-list>
 <column name="workspace_folder_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -2314,7 +2350,7 @@
 </table>
 <table name="lams_lesson" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="23" y="491" width="-1" height="-1"/>
+<table-figure-bounds x="-85" y="371" width="-1" height="-1"/>
 <column-list>
 <column name="lesson_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -2484,7 +2520,7 @@
 </table>
 <table name="lams_learner_progress" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="977" y="723" width="-1" height="-1"/>
+<table-figure-bounds x="1471" y="1055" width="-1" height="-1"/>
 <column-list>
 <column name="learner_progress_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -2662,7 +2698,7 @@
 </table>
 <table name="lams_tool" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="1272" y="1337" width="-1" height="-1"/>
+<table-figure-bounds x="1174" y="1657" width="-1" height="-1"/>
 <column-list>
 <column name="tool_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -2678,7 +2714,7 @@
 </data-type>
 </column>
 <column name="tool_signature" alias="" remarks="" mandatory="true" column-size="64" decimal-digits="0" default-value="" auto-increment="false">
-<column-description/>
+<column-description>Unique signature for each version of a tool. &lt;organisation&gt;&lt;tool&gt;&lt;version&gt;</column-description>
 <data-type name="VARCHAR" jdbc-type="12" selected-variant-pattern="VARCHAR(%n)" literal-prefix="'" literal-suffix="'">
 <variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="255"/>
 <variant type-name-pattern="VARCHAR(%n) BINARY" precision-variable="%n" precision-min="1" precision-max="255"/>
@@ -2704,6 +2740,21 @@
 <variant type-name-pattern="TEXT"/>
 </data-type>
 </column>
+<column name="tool_identifier" alias="" remarks="" mandatory="true" column-size="64" decimal-digits="0" default-value="" auto-increment="false">
+<column-description>Unique identifier for the tool. This should remain the same for every version of the tool. &#13;
+It will be used for the IMS LD import/export.</column-description>
+<data-type name="VARCHAR" jdbc-type="12" selected-variant-pattern="VARCHAR(%n)" literal-prefix="'" literal-suffix="'">
+<variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="255"/>
+<variant type-name-pattern="VARCHAR(%n) BINARY" precision-variable="%n" precision-min="1" precision-max="255"/>
+</data-type>
+</column>
+<column name="tool_version" alias="" remarks="" mandatory="true" column-size="10" decimal-digits="0" default-value="" auto-increment="false">
+<column-description>Version of tool. Expected to be in format [major version.minor version] eg 1.2</column-description>
+<data-type name="VARCHAR" jdbc-type="12" selected-variant-pattern="VARCHAR(%n)" literal-prefix="'" literal-suffix="'">
+<variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="255"/>
+<variant type-name-pattern="VARCHAR(%n) BINARY" precision-variable="%n" precision-min="1" precision-max="255"/>
+</data-type>
+</column>
 <column name="learning_library_id" alias="" remarks="" mandatory="false" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
 <data-type name="BIGINT" jdbc-type="-5" selected-variant-pattern="BIGINT(%n)">
@@ -2891,7 +2942,7 @@
 </table>
 <table name="lams_tool_session" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="838" y="1767" width="-1" height="-1"/>
+<table-figure-bounds x="1352" y="763" width="-1" height="-1"/>
 <column-list>
 <column name="tool_session_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -3009,27 +3060,13 @@
 </unique-key>
 </unique-key-list>
 <foreign-key-list>
-<foreign-key name="FK_lams_tool_session_1" alias="" remarks="" referenced-table-schema="DEFAULT_SCHEMA" referenced-table="lams_group" referenced-key="PRIMARY" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
-<foreign-key-description/>
-<foreign-key-figure>
-<fk-fig-bendpoint-list/>
-</foreign-key-figure>
-<foreign-key-column column-name="group_id" referenced-key-column-name="group_id"/>
-</foreign-key>
 <foreign-key name="FK_lams_tool_session_4" alias="" remarks="" referenced-table-schema="DEFAULT_SCHEMA" referenced-table="lams_tool_session_state" referenced-key="PK_LAMS_TOOL_SESSION_STATE" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
 <foreign-key-description/>
 <foreign-key-figure>
 <fk-fig-bendpoint-list/>
 </foreign-key-figure>
 <foreign-key-column column-name="tool_session_state_id" referenced-key-column-name="tool_session_state_id"/>
 </foreign-key>
-<foreign-key name="FK_lams_tool_session_3" alias="" remarks="" referenced-table-schema="DEFAULT_SCHEMA" referenced-table="lams_group" referenced-key="PRIMARY" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
-<foreign-key-description/>
-<foreign-key-figure>
-<fk-fig-bendpoint-list/>
-</foreign-key-figure>
-<foreign-key-column column-name="group_id" referenced-key-column-name="group_id"/>
-</foreign-key>
 <foreign-key name="FK_lams_tool_session_5" alias="" remarks="" referenced-table-schema="DEFAULT_SCHEMA" referenced-table="lams_user" referenced-key="PRIMARY" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
 <foreign-key-description/>
 <foreign-key-figure>
@@ -3051,12 +3088,19 @@
 </foreign-key-figure>
 <foreign-key-column column-name="activity_id" referenced-key-column-name="activity_id"/>
 </foreign-key>
+<foreign-key name="FK_lams_tool_session_1" alias="" remarks="" referenced-table-schema="DEFAULT_SCHEMA" referenced-table="lams_group" referenced-key="PRIMARY" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
+<foreign-key-description/>
+<foreign-key-figure>
+<fk-fig-bendpoint-list/>
+</foreign-key-figure>
+<foreign-key-column column-name="group_id" referenced-key-column-name="group_id"/>
+</foreign-key>
 </foreign-key-list>
 <index-list/>
 </table>
 <table name="lams_progress_completed" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="1034" y="977" width="-1" height="-1"/>
+<table-figure-bounds x="1383" y="1355" width="-1" height="-1"/>
 <column-list>
 <column name="learner_progress_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -3111,7 +3155,7 @@
 </table>
 <table name="lams_progress_attempted" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="1327" y="979" width="-1" height="-1"/>
+<table-figure-bounds x="1563" y="1413" width="-1" height="-1"/>
 <column-list>
 <column name="learner_progress_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -3166,7 +3210,7 @@
 </table>
 <table name="lams_tool_session_state" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="1153" y="1825" width="-1" height="-1"/>
+<table-figure-bounds x="1372" y="970" width="-1" height="-1"/>
 <column-list>
 <column name="tool_session_state_id" alias="" remarks="" mandatory="true" column-size="3" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -3199,7 +3243,7 @@
 </table>
 <table name="lams_user_group" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="628" y="716" width="-1" height="-1"/>
+<table-figure-bounds x="936" y="601" width="-1" height="-1"/>
 <column-list>
 <column name="user_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -3254,7 +3298,7 @@
 </table>
 <table name="lams_lesson_state" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="-12" y="159" width="-1" height="-1"/>
+<table-figure-bounds x="-63" y="210" width="-1" height="-1"/>
 <column-list>
 <column name="lesson_state_id" alias="" remarks="" mandatory="true" column-size="3" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -3287,7 +3331,7 @@
 </table>
 <table name="lams_tool_content" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="1248" y="1710" width="-1" height="-1"/>
+<table-figure-bounds x="975" y="1783" width="-1" height="-1"/>
 <column-list>
 <column name="tool_content_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -3334,7 +3378,7 @@
 </table>
 <table name="lams_activity_learners" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="738" y="921" width="-1" height="-1"/>
+<table-figure-bounds x="668" y="544" width="-1" height="-1"/>
 <column-list>
 <column name="user_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="0" auto-increment="false">
 <column-description/>
@@ -3387,7 +3431,7 @@
 </table>
 <table name="lams_lesson_learner" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="136" y="262" width="-1" height="-1"/>
+<table-figure-bounds x="278" y="408" width="-1" height="-1"/>
 <column-list>
 <column name="lesson_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -3440,7 +3484,7 @@
 </table>
 <table name="lams_tool_session_type" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="772" y="1988" width="-1" height="-1"/>
+<table-figure-bounds x="1265" y="628" width="-1" height="-1"/>
 <column-list>
 <column name="tool_session_type_id" alias="" remarks="" mandatory="true" column-size="3" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -3473,7 +3517,7 @@
 </table>
 <table name="lams_license" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="-41" y="767" width="-1" height="-1"/>
+<table-figure-bounds x="253" y="1165" width="-1" height="-1"/>
 <column-list>
 <column name="license_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -3540,7 +3584,7 @@
 </table>
 <table name="lams_copy_type" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="-58" y="1440" width="-1" height="-1"/>
+<table-figure-bounds x="95" y="1618" width="-1" height="-1"/>
 <column-list>
 <column name="copy_type_id" alias="" remarks="" mandatory="true" column-size="4" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -3573,7 +3617,7 @@
 </table>
 <table name="lams_activity_category" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="951" y="1519" width="-1" height="-1"/>
+<table-figure-bounds x="516" y="1731" width="-1" height="-1"/>
 <column-list>
 <column name="activity_category_id" alias="" remarks="" mandatory="true" column-size="3" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -3609,7 +3653,7 @@
 &#13;
 The main lookup is done on name, but given the small number of rows a complete table scan &#13;
 should be fine. A name index would probably be about the same size as the table anyway.</table-description>
-<table-figure-bounds x="-83" y="1786" width="-1" height="-1"/>
+<table-figure-bounds x="-89" y="1825" width="-1" height="-1"/>
 <column-list>
 <column name="workspace_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -3644,7 +3688,7 @@
 <table-description>Like lams_cr_workspace, there will usually be 0 or 1 workspace for each tool in LAMS, so this should be a pretty small table.&#13;
 &#13;
 The main lookup is done on name, but given the small number of rows a complete table scan should be fine. </table-description>
-<table-figure-bounds x="-4" y="1956" width="-1" height="-1"/>
+<table-figure-bounds x="-10" y="2015" width="-1" height="-1"/>
 <column-list>
 <column name="credential_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -3673,19 +3717,6 @@
 <variant type-name-pattern="VARCHAR(%n) BINARY" precision-variable="%n" precision-min="1" precision-max="255"/>
 </data-type>
 </column>
-<column name="wc_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
-<column-description/>
-<data-type name="BIGINT" jdbc-type="-5" selected-variant-pattern="BIGINT(%n) UNSIGNED">
-<variant type-name-pattern="BIGINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="19"/>
-<variant type-name-pattern="BIGINT"/>
-<variant type-name-pattern="BIGINT(%n)" precision-variable="%n" precision-min="0" precision-max="19"/>
-<variant type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
-<variant type-name-pattern="BIGINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
-<variant type-name-pattern="BIGINT UNSIGNED"/>
-<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
-<variant type-name-pattern="BIGINT ZEROFILL"/>
-</data-type>
-</column>
 </column-list>
 <primary-key name="PK_LAMS_CR_CREDENTIAL" alias="" remarks="">
 <primary-key-description/>
@@ -3697,7 +3728,7 @@
 </table>
 <table name="lams_cr_workspace_credential" alias="" remarks="Maps tools access to workspaces">
 <table-description/>
-<table-figure-bounds x="-67" y="1880" width="-1" height="-1"/>
+<table-figure-bounds x="-73" y="1919" width="-1" height="-1"/>
 <column-list>
 <column name="wc_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -3767,7 +3798,7 @@
 &#13;
 It is the node_id and version_id combination that is the "real" key for this table.&#13;
 </table-description>
-<table-figure-bounds x="223" y="1953" width="-1" height="-1"/>
+<table-figure-bounds x="217" y="1992" width="-1" height="-1"/>
 <column-list>
 <column name="nv_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -3846,7 +3877,7 @@
 </table>
 <table name="lams_cr_node_version_property" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="499" y="1951" width="-1" height="-1"/>
+<table-figure-bounds x="493" y="1990" width="-1" height="-1"/>
 <column-list>
 <column name="id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -3920,7 +3951,7 @@
 </table>
 <table name="lams_cr_node" alias="" remarks="The main table containing the node definition">
 <table-description>A node can only belong to one parent - so each time a new version of a package is created, all the nodes are recreated.</table-description>
-<table-figure-bounds x="228" y="1777" width="-1" height="-1"/>
+<table-figure-bounds x="222" y="1816" width="-1" height="-1"/>
 <column-list>
 <column name="node_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -4026,7 +4057,7 @@
 </table>
 <table name="lams_workspace_folder_type" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="381" y="314" width="-1" height="-1"/>
+<table-figure-bounds x="59" y="586" width="-1" height="-1"/>
 <column-list>
 <column name="lams_workspace_folder_type_id" alias="" remarks="" mandatory="true" column-size="3" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -4059,7 +4090,7 @@
 </table>
 <table name="lams_grouping_support_type" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="1154" y="1242" width="-1" height="-1"/>
+<table-figure-bounds x="1041" y="1566" width="-1" height="-1"/>
 <column-list>
 <column name="grouping_support_type_id" alias="" remarks="" mandatory="true" column-size="3" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -4092,7 +4123,7 @@
 </table>
 <table name="lams_log_event" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="1106" y="1978" width="-1" height="-1"/>
+<table-figure-bounds x="1519" y="1837" width="-1" height="-1"/>
 <column-list>
 <column name="log_event_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -4178,7 +4209,7 @@
 </table>
 <table name="lams_log_event_type" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="1370" y="1970" width="-1" height="-1"/>
+<table-figure-bounds x="1516" y="1704" width="-1" height="-1"/>
 <column-list>
 <column name="log_event_type_id" alias="" remarks="" mandatory="true" column-size="5" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -4211,7 +4242,7 @@
 </table>
 <table name="lams_workspace_folder_content" alias="lams_workspace_folder_content" remarks="">
 <table-description/>
-<table-figure-bounds x="867" y="586" width="-1" height="-1"/>
+<table-figure-bounds x="300" y="869" width="-1" height="-1"/>
 <column-list>
 <column name="folder_content_id" alias="folder_content_id" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -4316,7 +4347,20 @@
 <primary-key-description/>
 <primary-key-column name="folder_content_id"/>
 </primary-key>
-<unique-key-list/>
+<unique-key-list>
+<unique-key name="unique_content_name" alias="" remarks="">
+<unique-key-description/>
+<unique-key-column name="name"/>
+<unique-key-column name="workspace_folder_id"/>
+<unique-key-column name="mime_type"/>
+</unique-key>
+<unique-key name="unique_node_version" alias="" remarks="">
+<unique-key-description/>
+<unique-key-column name="workspace_folder_id"/>
+<unique-key-column name="uuid"/>
+<unique-key-column name="version_id"/>
+</unique-key>
+</unique-key-list>
 <foreign-key-list>
 <foreign-key name="FK_lams_workspace_folder_content_1" alias="" remarks="" referenced-table-schema="DEFAULT_SCHEMA" referenced-table="lams_workspace_folder" referenced-key="PRIMARY" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
 <foreign-key-description/>
@@ -4337,7 +4381,7 @@
 </table>
 <table name="lams_workspace_folder_content_type" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="392" y="172" width="-1" height="-1"/>
+<table-figure-bounds x="271" y="1081" width="-1" height="-1"/>
 <column-list>
 <column name="content_type_id" alias="" remarks="" mandatory="true" column-size="3" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -4368,6 +4412,210 @@
 <foreign-key-list/>
 <index-list/>
 </table>
+<table name="lams_css_theme_ve" alias="" remarks="Stores both the Flash theme and visual element">
+<table-description/>
+<table-figure-bounds x="1588" y="18" width="-1" height="-1"/>
+<column-list>
+<column name="theme_ve_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
+<column-description/>
+<data-type name="BIGINT" jdbc-type="-5" selected-variant-pattern="BIGINT(%n)">
+<variant type-name-pattern="BIGINT"/>
+<variant type-name-pattern="BIGINT(%n)" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT UNSIGNED"/>
+<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="BIGINT ZEROFILL"/>
+</data-type>
+</column>
+<column name="name" alias="" remarks="" mandatory="true" column-size="100" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="VARCHAR" jdbc-type="12" selected-variant-pattern="VARCHAR(%n)" literal-prefix="'" literal-suffix="'">
+<variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="255"/>
+<variant type-name-pattern="VARCHAR(%n) BINARY" precision-variable="%n" precision-min="1" precision-max="255"/>
+</data-type>
+</column>
+<column name="description" alias="" remarks="" mandatory="false" column-size="100" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="VARCHAR" jdbc-type="12" selected-variant-pattern="VARCHAR(%n)" literal-prefix="'" literal-suffix="'">
+<variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="255"/>
+<variant type-name-pattern="VARCHAR(%n) BINARY" precision-variable="%n" precision-min="1" precision-max="255"/>
+</data-type>
+</column>
+<column name="parent_id" alias="" remarks="Parent theme" mandatory="false" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="BIGINT" jdbc-type="-5" selected-variant-pattern="BIGINT(%n)">
+<variant type-name-pattern="BIGINT"/>
+<variant type-name-pattern="BIGINT(%n)" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT UNSIGNED"/>
+<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="BIGINT ZEROFILL"/>
+</data-type>
+</column>
+<column name="theme_flag" alias="" remarks="" mandatory="true" column-size="1" decimal-digits="0" default-value="0" auto-increment="false">
+<column-description/>
+<data-type name="TINYINT" jdbc-type="-6" selected-variant-pattern="TINYINT(%n)">
+<variant type-name-pattern="TINYINT"/>
+<variant type-name-pattern="TINYINT(%n)" precision-variable="%n" precision-min="0" precision-max="1"/>
+<variant type-name-pattern="TINYINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="1"/>
+<variant type-name-pattern="TINYINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="1"/>
+<variant type-name-pattern="TINYINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="1"/>
+<variant type-name-pattern="TINYINT UNSIGNED"/>
+<variant type-name-pattern="TINYINT UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="TINYINT ZEROFILL"/>
+</data-type>
+</column>
+</column-list>
+<primary-key name="PK_LAMS_CSS_THEME_VE" alias="" remarks="">
+<primary-key-description/>
+<primary-key-column name="theme_ve_id"/>
+</primary-key>
+<unique-key-list/>
+<foreign-key-list>
+<foreign-key name="FK_lams_css_theme_ve_2" alias="" remarks="" referenced-table-schema="DEFAULT_SCHEMA" referenced-table="lams_css_theme_ve" referenced-key="PK_LAMS_CSS_THEME_VE" on-update="NO ACTION" on-delete="NO ACTION" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
+<foreign-key-description/>
+<foreign-key-figure>
+<fk-fig-bendpoint-list/>
+</foreign-key-figure>
+<foreign-key-column column-name="parent_id" referenced-key-column-name="theme_ve_id"/>
+</foreign-key>
+</foreign-key-list>
+<index-list/>
+</table>
+<table name="lams_css_property" alias="" remarks="">
+<table-description/>
+<table-figure-bounds x="1347" y="154" width="-1" height="-1"/>
+<column-list>
+<column name="property_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
+<column-description/>
+<data-type name="BIGINT" jdbc-type="-5" selected-variant-pattern="BIGINT(%n)">
+<variant type-name-pattern="BIGINT(%n)" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT UNSIGNED"/>
+<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="BIGINT ZEROFILL"/>
+</data-type>
+</column>
+<column name="style_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="BIGINT" jdbc-type="-5" selected-variant-pattern="BIGINT(%n)">
+<variant type-name-pattern="BIGINT(%n)" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT UNSIGNED"/>
+<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="BIGINT ZEROFILL"/>
+</data-type>
+</column>
+<column name="name" alias="" remarks="" mandatory="true" column-size="255" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="VARCHAR" jdbc-type="12" selected-variant-pattern="VARCHAR(%n)" literal-prefix="'" literal-suffix="'">
+<variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="255"/>
+<variant type-name-pattern="VARCHAR(%n) BINARY" precision-variable="%n" precision-min="1" precision-max="255"/>
+</data-type>
+</column>
+<column name="value" alias="" remarks="" mandatory="true" column-size="100" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="VARCHAR" jdbc-type="12" selected-variant-pattern="VARCHAR(%n)" literal-prefix="'" literal-suffix="'">
+<variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="255"/>
+<variant type-name-pattern="VARCHAR(%n) BINARY" precision-variable="%n" precision-min="1" precision-max="255"/>
+</data-type>
+</column>
+<column name="style_subset" alias="" remarks="e.g. &quot;_tf&quot;" mandatory="false" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="VARCHAR" jdbc-type="12" selected-variant-pattern="VARCHAR(%n)" literal-prefix="'" literal-suffix="'">
+<variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="255"/>
+<variant type-name-pattern="VARCHAR(%n) BINARY" precision-variable="%n" precision-min="1" precision-max="255"/>
+</data-type>
+</column>
+<column name="type" alias="" remarks="String, Boolean, etc" mandatory="true" column-size="0" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="TINYINT" jdbc-type="-6" selected-variant-pattern="TINYINT">
+<variant type-name-pattern="TINYINT"/>
+<variant type-name-pattern="TINYINT(%n)" precision-variable="%n" precision-min="0" precision-max="1"/>
+<variant type-name-pattern="TINYINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="1"/>
+<variant type-name-pattern="TINYINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="1"/>
+<variant type-name-pattern="TINYINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="1"/>
+<variant type-name-pattern="TINYINT UNSIGNED"/>
+<variant type-name-pattern="TINYINT UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="TINYINT ZEROFILL"/>
+</data-type>
+</column>
+</column-list>
+<primary-key name="PK_LAMS_CSS_PROPERTY" alias="" remarks="">
+<primary-key-description/>
+<primary-key-column name="property_id"/>
+</primary-key>
+<unique-key-list/>
+<foreign-key-list>
+<foreign-key name="FK_lams_css_property_1" alias="" remarks="" referenced-table-schema="DEFAULT_SCHEMA" referenced-table="lams_css_style" referenced-key="PK_LAMS_CSS_STYLE" on-update="NO ACTION" on-delete="NO ACTION" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
+<foreign-key-description/>
+<foreign-key-figure>
+<fk-fig-bendpoint-list/>
+</foreign-key-figure>
+<foreign-key-column column-name="style_id" referenced-key-column-name="style_id"/>
+</foreign-key>
+</foreign-key-list>
+<index-list/>
+</table>
+<table name="lams_css_style" alias="" remarks="Groups lams_css_property into a CSSStyleDeclaration.">
+<table-description>All the lams_css_property values matching this lams_css_style make up the CSSStyleDeclaration for this &#13;
+style. It may be a "base" style for  a theme, or it may be for a named visual element. &#13;
+Each style may have a subset of properties, such as "_tf"</table-description>
+<table-figure-bounds x="1351" y="36" width="-1" height="-1"/>
+<column-list>
+<column name="style_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
+<column-description/>
+<data-type name="BIGINT" jdbc-type="-5" selected-variant-pattern="BIGINT(%n)">
+<variant type-name-pattern="BIGINT(%n)" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT UNSIGNED"/>
+<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="BIGINT ZEROFILL"/>
+</data-type>
+</column>
+<column name="theme_ve_id" alias="" remarks="Theme or visual element that has this style" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="BIGINT" jdbc-type="-5" selected-variant-pattern="BIGINT(%n)">
+<variant type-name-pattern="BIGINT"/>
+<variant type-name-pattern="BIGINT(%n)" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT UNSIGNED"/>
+<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="BIGINT ZEROFILL"/>
+</data-type>
+</column>
+</column-list>
+<primary-key name="PK_LAMS_CSS_STYLE" alias="" remarks="">
+<primary-key-description/>
+<primary-key-column name="style_id"/>
+</primary-key>
+<unique-key-list/>
+<foreign-key-list>
+<foreign-key name="FK_lams_css_style_1" alias="" remarks="1-1 relationship between theme or visual element and style. Link column is in style class to make it easier to do cascades in hibernate" referenced-table-schema="DEFAULT_SCHEMA" referenced-table="lams_css_theme_ve" referenced-key="PK_LAMS_CSS_THEME_VE" on-update="NO ACTION" on-delete="NO ACTION" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
+<foreign-key-description/>
+<foreign-key-figure>
+<fk-fig-bendpoint-list/>
+</foreign-key-figure>
+<foreign-key-column column-name="theme_ve_id" referenced-key-column-name="theme_ve_id"/>
+</foreign-key>
+</foreign-key-list>
+<index-list/>
+</table>
 </table-list>
 </schema>
 </schema-list>