<?xml version="1.0"?>
<!-- $Revision: 1.15 $ -->
<tables>
<table sinceMajor="2" sinceMinor="4">
<name>UP_VERSIONS</name>
<desc>Holds version numbers of the portal and any channels that wish to register their versions</desc>
<columns>
<column>
<name>FNAME</name>
<type>VARCHAR</type>
<desc>The functional name of the entity.</desc>
<param>255</param>
<key>PK</key>
</column>
<column>
<name>MAJOR</name>
<type>INTEGER</type>
<desc>The entity's major portion of the version number which is currently installed in the portal</desc>
</column>
<column>
<name>MINOR</name>
<type>INTEGER</type>
<desc>The entity's minor portion of the version number which is currently installed in the portal</desc>
</column>
<column>
<name>MICRO</name>
<type>INTEGER</type>
<desc>The entity's micro portion of the version number which is currently installed in the portal</desc>
</column>
<column>
<name>DESCRIPTION</name>
<type>VARCHAR</type>
<desc>A description of the code represented by the functional name</desc>
<param>255</param>
</column>
</columns>
<primary-key>FNAME</primary-key>
</table>
<table sinceMajor="2" sinceMinor="4">
<name>UP_PORTLET_DEFINITION_PREFS</name>
<desc>Definition level portlet preferences</desc>
<columns>
<column>
<name>CHAN_ID</name>
<type>INTEGER</type>
<desc>Foreign key from up_channel</desc>
</column>
<column>
<name>PORTLET_PREF_NAME</name>
<type>LONGVARCHAR</type>
<desc>The name of the preference</desc>
</column>
<column>
<name>PORTLET_PREF_READONLY</name>
<type>VARCHAR</type>
<param>1</param>
<desc>Y/N Toggle on to see if the preference is read only</desc>
</column>
<column>
<name>PREF_ID</name>
<type>INTEGER</type>
<desc>Preference key foreign key for UP_PORTLET_PREF_VALUES</desc>
</column>
</columns>
<primary-key>CHAN_ID</primary-key>
<primary-key>PREF_ID</primary-key>
<not-null>PORTLET_PREF_NAME</not-null>
</table>
<table sinceMajor="2" sinceMinor="4">
<name>UP_PORTLET_ENTITY_PREFS</name>
<desc>Enitity level portlet preferences</desc>
<columns>
<column>
<name>USER_ID</name>
<type>INTEGER</type>
<desc>Foreign key user_id of table up_user</desc>
</column>
<column>
<name>LAYOUT_ID</name>
<type>INTEGER</type>
<desc>Foreign key layout_id of table up_user_layout and compound key</desc>
</column>
<column>
<name>CHAN_DESC_ID</name>
<type>VARCHAR</type>
<param>255</param>
<desc>Foreign key of table UP_LAYOUT_STRUCT and compound key or key from aggregated layout</desc>
</column>
<column>
<name>PORTLET_PREF_NAME</name>
<type>LONGVARCHAR</type>
<desc>The name of the preference</desc>
</column>
<column>
<name>PREF_ID</name>
<type>INTEGER</type>
<desc>Preference key foreign key for UP_PORTLET_PREF_VALUES</desc>
</column>
</columns>
<primary-key>USER_ID</primary-key>
<primary-key>LAYOUT_ID</primary-key>
<primary-key>CHAN_DESC_ID</primary-key>
<primary-key>PREF_ID</primary-key>
<not-null>PORTLET_PREF_NAME</not-null>
</table>
<table sinceMajor="2" sinceMinor="4">
<name>UP_PORTLET_PREF_VALUES</name>
<desc>Portlet preference values</desc>
<columns>
<column>
<name>PREF_ID</name>
<type>INTEGER</type>
<desc>Foreign key pref_id of tables UP_PORTLET_ENTITY_PREFS or UP_PORTLET_DEFINITION_PREFS</desc>
</column>
<column>
<name>PORTLET_PREF_VALUE</name>
<type>LONGVARCHAR</type>
<desc>The value of the preference</desc>
</column>
</columns>
<not-null>PREF_ID</not-null>
</table>
<table sinceMajor="2" sinceMinor="2">
<name>UP_LAYOUT_RESTRICTIONS</name>
<desc>The layout restrictions</desc>
<columns>
<column> <name>LAYOUT_ID</name> <type>INTEGER</type>
<desc>Layout ID is not unique to the portal but unique for a given user. It links to up_layout_struct</desc>
<key>CK</key>
</column>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Foreign key user_id of table up_user</desc>
<key>CK</key>
</column>
<column> <name>NODE_ID</name> <type>INTEGER</type>
<desc>NODE ID is an unique node identifier</desc>
<key>FK</key>
</column>
<column> <name>RESTRICTION_NAME</name> <type>VARCHAR</type> <param>128</param>
<desc>RESTRICTION NAME is an unique restriction name</desc>
<key>CK</key>
</column>
<column> <name>RESTRICTION_VALUE</name> <type>VARCHAR</type> <param>128</param>
<desc>RESTRICTION VALUE is a restriction value</desc>
</column>
<column> <name>RESTRICTION_TREE_PATH</name> <type>VARCHAR</type> <param>128</param>
<desc>RESTRICTION_TREE_PATH is an related tree path to a node which this restriction is applied for</desc>
<key>CK</key>
</column>
</columns>
<primary-key>LAYOUT_ID</primary-key>
<primary-key>USER_ID</primary-key>
<primary-key>NODE_ID</primary-key>
<primary-key>RESTRICTION_NAME</primary-key>
<primary-key>RESTRICTION_TREE_PATH</primary-key>
</table>
<table sinceMajor="2" sinceMinor="2">
<name>UP_FRAGMENT_RESTRICTIONS</name>
<desc>The fragment restrictions</desc>
<columns>
<column> <name>FRAGMENT_ID</name> <type>INTEGER</type>
<desc>Fragment ID</desc>
<key>CK</key>
</column>
<column> <name>NODE_ID</name> <type>INTEGER</type>
<desc>NODE ID is a foreign key</desc>
<key>CK</key>
</column>
<column> <name>RESTRICTION_NAME</name> <type>VARCHAR</type> <param>128</param>
<desc>RESTRICTION NAME is an unique restriction name</desc>
<key>CK</key>
</column>
<column> <name>RESTRICTION_VALUE</name> <type>VARCHAR</type> <param>128</param>
<desc>RESTRICTION VALUE is a restriction value</desc>
</column>
<column> <name>RESTRICTION_TREE_PATH</name> <type>VARCHAR</type> <param>128</param>
<desc>RESTRICTION_TREE_PATH is an related tree path to a node which this restriction is applied for</desc>
<key>CK</key>
</column>
</columns>
<primary-key>FRAGMENT_ID</primary-key>
<primary-key>NODE_ID</primary-key>
<primary-key>RESTRICTION_NAME</primary-key>
<primary-key>RESTRICTION_TREE_PATH</primary-key>
</table>
<table sinceMajor="2" sinceMinor="2">
<name>UP_FRAGMENTS</name>
<desc>Layout Fragments</desc>
<columns>
<column> <name>FRAGMENT_ID</name> <type>INTEGER</type>
<desc>The fragment id</desc>
<key>CK</key>
</column>
<column> <name>NODE_ID</name> <type>INTEGER</type>
<desc>Node ID is a unique number for a given user and is used by the portal for a given component (channel, column, etc) - primary key Given by next_struct_id in table up_user</desc>
<key>CK</key>
</column>
<column> <name>NEXT_NODE_ID</name> <type>INTEGER</type>
<desc>Node ID that follows this ID in a list</desc>
</column>
<column> <name>PREV_NODE_ID</name> <type>INTEGER</type>
<desc>Node ID that follows by this ID in a list</desc>
</column>
<column> <name>CHLD_NODE_ID</name> <type>INTEGER</type>
<desc>Node ID that is a child to this ID</desc>
</column>
<column> <name>PRNT_NODE_ID</name> <type>INTEGER</type>
<desc>Node ID that is a parent to this ID</desc>
</column>
<column> <name>EXTERNAL_ID</name> <type>VARCHAR</type><param>64</param>
<desc>External ID that channel can store key for resources used by a channel instance for a user</desc>
</column>
<column> <name>CHAN_ID</name> <type>INTEGER</type>
<desc>Channel ID if the current Node_ID entry is a channel, then this is set to the channel id subscribed to and located at this position in the layout</desc>
</column>
<column> <name>NAME</name> <type>VARCHAR</type> <param>128</param>
<desc>Name of this struct entry, name of tab, column, header or footer, etc</desc>
</column>
<column> <name>GROUP_KEY</name> <type>VARCHAR</type> <param>35</param>
<desc>Group ID which the given node belongs to</desc>
</column>
<column> <name>TYPE</name> <type>VARCHAR</type> <param>35</param>
<desc>Used by portal to render framework channels - distinguishes structure components like tab and columns from footers, headers and channels</desc>
</column>
<column> <name>HIDDEN</name> <type>VARCHAR</type> <param>1</param>
<desc>Set to Y if folder or channel is hidden</desc>
</column>
<column> <name>IMMUTABLE</name> <type>VARCHAR</type> <param>1</param>
<desc>Set to Y if folder or channel cannot be moved in layout</desc>
</column>
<column> <name>UNREMOVABLE</name> <type>VARCHAR</type> <param>1</param>
<desc>Set to Y if folder or channel cannot be unsubscribed to or removed by user</desc>
</column>
<column><name>PRIORITY</name> <type>INTEGER</type>
<desc>The priority of a node</desc>
</column>
</columns>
<primary-key>FRAGMENT_ID</primary-key>
<primary-key>NODE_ID</primary-key>
</table>
<table sinceMajor="2" sinceMinor="2">
<name>UP_FRAGMENT_PARAM</name>
<desc>Holds the parameters of fragments</desc>
<columns>
<column> <name>PARAM_NAME</name> <type>VARCHAR</type> <param>128</param>
<desc>The parameter name</desc>
<key>CK</key>
</column>
<column> <name>FRAGMENT_ID</name> <type>INTEGER</type>
<desc>Fragment ID</desc>
<key>CK</key>
</column>
<column> <name>NODE_ID</name> <type>INTEGER</type>
<desc>Node ID</desc>
</column>
<column> <name>PARAM_VALUE</name> <type>VARCHAR</type> <param>255</param>
<desc>Parameter name</desc>
</column>
</columns>
<primary-key>PARAM_NAME</primary-key>
<primary-key>NODE_ID</primary-key>
<primary-key>FRAGMENT_ID</primary-key>
</table>
<table sinceMajor="2" sinceMinor="2">
<name>UP_USER_LAYOUT_AGGR</name>
<desc>For a given user, a layout is created giving it an id and title, basing it on an initial node id</desc>
<columns>
<column> <name>LAYOUT_ID</name> <type>INTEGER</type>
<desc>Layout ID is not unique to the portal but unique for a given user. It links to up_layout_struct</desc>
<key>CK</key>
</column>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Foreign key user_id of table up_user</desc>
<key>CK</key>
</column>
<column> <name>LAYOUT_TITLE</name> <type>VARCHAR</type> <param>255</param>
<desc>Layout title - the name of the layout in text</desc>
</column>
<column> <name>INIT_NODE_ID</name> <type>INTEGER</type>
<desc>Initial node ID - Points to the first channel/folder in the users layout and sets the start of the document tree</desc>
<key>FK</key>
</column>
</columns>
<primary-key>LAYOUT_ID</primary-key>
<primary-key>USER_ID</primary-key>
</table>
<table sinceMajor="2" sinceMinor="2">
<name>UP_LAYOUT_STRUCT_AGGR</name>
<desc>Holds the order of a user's layout structure - the order in the user layout of channels subscribed to, the order of layout components (columns for example)</desc>
<columns>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Foreign key user_id of table up_user</desc>
<key>FK</key>
</column>
<column> <name>LAYOUT_ID</name> <type>INTEGER</type>
<desc>Foreign key layout_id of table up_user_layout and compound key</desc>
<key>FK</key>
</column>
<column> <name>NODE_ID</name> <type>INTEGER</type>
<desc>Struct ID is a unique number for a given user and is used by the portal for a given component </desc>
<key>FK</key>
</column>
<column> <name>FRAGMENT_ID</name> <type>INTEGER</type>
<desc>Fragment ID is a ID from the up_owner_fragments</desc>
<key>FK</key>
</column>
<column> <name>NEXT_NODE_ID</name> <type>INTEGER</type>
<desc>Struct ID that follows this ID in a list</desc>
</column>
<column> <name>PREV_NODE_ID</name> <type>INTEGER</type>
<desc>Struct ID that follows by this ID in a list</desc>
</column>
<column> <name>CHLD_NODE_ID</name> <type>INTEGER</type>
<desc>Struct ID that is a child to this ID</desc>
</column>
<column> <name>PRNT_NODE_ID</name> <type>INTEGER</type>
<desc>Node ID that is a parent to this ID</desc>
</column>
<column> <name>EXTERNAL_ID</name> <type>VARCHAR</type><param>64</param>
<desc>External ID that channel can store key for resources used by a channel instance for a user</desc>
</column>
<column> <name>CHAN_ID</name> <type>INTEGER</type>
<desc>Channel ID if the current Struct_ID entry is a channel, then this is set to the channel id subscribed to and located at this position in the layout</desc>
</column>
<column> <name>NAME</name> <type>VARCHAR</type> <param>128</param>
<desc>Name of this struct entry, name of tab, column, header or footer, etc</desc>
</column>
<column> <name>GROUP_KEY</name> <type>VARCHAR</type> <param>35</param>
<desc>Group ID name which the given node belongs to</desc>
</column>
<column> <name>TYPE</name> <type>VARCHAR</type> <param>35</param>
<desc>Used by portal to render framework channels - distinguishes structure components like tab and columns from footers, headers and channels</desc>
</column>
<column> <name>HIDDEN</name> <type>VARCHAR</type> <param>1</param>
<desc>Set to Y if folder or channel is hidden</desc>
</column>
<column> <name>IMMUTABLE</name> <type>VARCHAR</type> <param>1</param>
<desc>Set to Y if folder or channel cannot be moved in layout</desc>
</column>
<column> <name>UNREMOVABLE</name> <type>VARCHAR</type> <param>1</param>
<desc>Set to Y if folder or channel cannot be unsubscribed to or removed by user</desc>
</column>
<column><name>PRIORITY</name> <type>INTEGER</type>
<desc>The priority of a node</desc>
</column>
<column><name>FRAGMENT_NODE_ID</name> <type>INTEGER</type>
<desc>The fragment node id from up_fragments table</desc>
</column>
</columns>
<primary-key>LAYOUT_ID</primary-key>
<primary-key>USER_ID</primary-key>
<primary-key>NODE_ID</primary-key>
</table>
<table sinceMajor="2" sinceMinor="2">
<name>UP_OWNER_FRAGMENT</name>
<desc>Holds the parameters of fragments</desc>
<columns>
<column> <name>FRAGMENT_ID</name> <type>INTEGER</type>
<desc>Fragment ID - primary key</desc>
<key>PK</key>
</column>
<column> <name>FRAGMENT_ROOT_ID</name> <type>INTEGER</type>
<desc>Fragment root ID</desc>
</column>
<column> <name>OWNER_ID</name> <type>INTEGER</type>
<desc>Node ID</desc>
</column>
<column> <name>FRAGMENT_NAME</name> <type>VARCHAR</type> <param>128</param>
<desc>Fragment name</desc>
</column>
<column> <name>FRAGMENT_DESCRIPTION</name> <type>VARCHAR</type> <param>255</param>
<desc>Fragment description</desc>
</column>
<column> <name>PUSHED_FRAGMENT</name> <type>VARCHAR</type> <param>1</param>
<desc>This values shows if a fragment has been pushed into the database</desc>
</column>
</columns>
<primary-key>FRAGMENT_ID</primary-key>
</table>
<table sinceMajor="2" sinceMinor="2">
<name>UP_GROUP_FRAGMENT</name>
<desc>Holds group assignment for fragments that are being pushed</desc>
<columns>
<column><name>FRAGMENT_ID</name><type>INTEGER</type>
<desc>Fragment ID - primary key</desc>
<key>CK</key>
</column>
<column> <name>GROUP_KEY</name> <type>VARCHAR</type> <param>64</param>
<desc>Group Key</desc>
<key>CK</key>
</column>
</columns>
<primary-key>FRAGMENT_ID</primary-key>
<primary-key>GROUP_KEY</primary-key>
</table>
<table sinceMajor="2" sinceMinor="2">
<name>UP_GROUP_PRIORITY_RANGE</name>
<desc>Holds priority range assignment for user groups</desc>
<columns>
<column><name>GROUP_KEY</name><type>VARCHAR</type><param>64</param>
<desc>Group key</desc>
<key>PK</key>
</column>
<column> <name>MIN_PRIORITY</name> <type>INTEGER</type>
<desc>Min priority value</desc>
</column>
<column> <name>MAX_PRIORITY</name> <type>INTEGER</type>
<desc>Max priority value</desc>
</column>
</columns>
<primary-key>GROUP_KEY</primary-key>
</table>
<table sinceMajor="2" sinceMinor="0">
<name>UP_USER</name>
<desc>Entries that uniquely identify a portal session for a particular user</desc>
<columns>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Internal sequence id of a user's portal information - unique user identifier - primary key, see UP_SEQUENCE</desc>
<key>PK</key>
</column>
<column> <name>USER_NAME</name> <type>VARCHAR</type> <param>35</param>
<desc>Authentication prinicipal - Foreign key to up_person_dir</desc>
</column>
<column> <name>USER_DFLT_USR_ID</name> <type>INTEGER</type>
<desc>use the information from this user id as a default, that is a backup to revert to if user makes mistakes changing content or profile, and the initial layout for a user.</desc>
</column>
<column> <name>USER_DFLT_LAY_ID</name> <type>INTEGER</type>
<desc>Portal uses the layout from this layout ID to revert back to, and the initial layout for a user.</desc>
</column>
<column> <name>NEXT_STRUCT_ID</name> <type>INTEGER</type>
<desc>NEXT_STRUCT_ID used by the user in layout - found in up_layout_struct based on user. Each user has a seperate, unique, sequence of struct_ids</desc>
</column>
<column> <name>LST_CHAN_UPDT_DT</name> <type>TIMESTAMP</type>
<desc>Date time of last time channels were updated - It is set when a user adds a channel to his or her layout. The channel manager will be able to (not yet) present a list of channels added since the last time the user checked.</desc>
</column>
</columns>
<primary-key>USER_ID</primary-key>
</table>
<table sinceMajor="2" sinceMinor="0">
<name>UP_USER_PARAM</name>
<desc>Not used</desc>
<columns>
<column> <name>USER_ID</name> <type>INTEGER</type>
</column>
<column> <name>USER_PARAM_NAME</name> <type>VARCHAR</type> <param>35</param>
</column>
<column> <name>USER_PARAM_VALUE</name> <type>VARCHAR</type> <param>255</param>
</column>
</columns>
<not-null>USER_ID</not-null>
</table>
<table sinceMajor="2" sinceMinor="2">
<name>UP_USER_LOCALE</name>
<desc>Locale preferences for a user</desc>
<columns>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Internal sequence id of a user's portal information - unique user identifier - primary key, see UP_SEQUENCE</desc>
<key>PK</key>
</column>
<column> <name>LOCALE</name> <type>VARCHAR</type> <param>64</param>
<desc>User's locale preference</desc>
<key>PK</key>
</column>
<column> <name>PRIORITY</name> <type>INTEGER</type>
<desc>The order of preference for this locale</desc>
</column>
</columns>
<primary-key>USER_ID</primary-key>
<primary-key>LOCALE</primary-key>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_PERSON_DIR</name>
<desc>Directory information for a given person, including the MD5 password. Emulates a simple external authentication service, like LDAP.</desc>
<columns>
<column> <name>USER_NAME</name> <type>VARCHAR</type> <param>35</param>
<desc>Authentication prinicipal - Primary key and foreign key foreign key to external authentication system (which is what up_person_dir emulates)</desc>
<key>PK</key>
</column>
<column> <name>ENCRPTD_PSWD</name> <type>VARCHAR</type> <param>64</param>
<desc>MD5 authentication credential - or user's password</desc>
</column>
<column> <name>LST_PSWD_CGH_DT</name> <type>TIMESTAMP</type>
<desc>Date of last password change</desc>
</column>
<column> <name>FIRST_NAME</name> <type>VARCHAR</type> <param>15</param>
<desc>Person's first name</desc>
</column>
<column> <name>LAST_NAME</name> <type>VARCHAR</type> <param>15</param>
<desc>Person's last name</desc>
</column>
<column> <name>EMAIL</name> <type>VARCHAR</type> <param>60</param>
<desc>Person's e-mail address</desc>
</column>
</columns>
<primary-key>USER_NAME</primary-key>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_PERMISSION</name>
<desc>Permission access to framework channels</desc>
<columns>
<column> <name>OWNER</name> <type>VARCHAR</type> <param>255</param>
<desc>Framework entity owner - UP_FRAMEWORK, UP_ERROR_CHAN</desc>
</column>
<column><name>PRINCIPAL_TYPE</name> <type>INTEGER</type>
<desc>**** Numeric value foreign key ENTITY_TYPE_ID of table UP_ENTITY_TYPE</desc>
</column>
<column><name>PRINCIPAL_KEY</name> <type>VARCHAR</type> <param>255</param>
<desc>**** The key of the entity represented by the principal</desc>
</column>
<column><name>ACTIVITY</name> <type>VARCHAR</type> <param>255</param>
<desc>Allowable activities, ex. VIEW, PUBLISH, SUBSCRIBE</desc>
</column>
<column><name>TARGET</name> <type>VARCHAR</type> <param>255</param>
<desc>Gives parameter name and value separated by period or text depending up owner's use</desc>
</column>
<column><name>PERMISSION_TYPE</name> <type>VARCHAR</type> <param>255</param>
<desc>GRANT or REVOKE (no example yet)</desc>
</column>
<column><name>EFFECTIVE</name> <type>TIMESTAMP</type>
<desc></desc>
</column>
<column><name>EXPIRES</name> <type>TIMESTAMP</type>
<desc></desc>
</column>
</columns>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_USER_LAYOUT</name>
<desc>For a given user, a layout is created giving it an id and title, basing it on an initial structure id - for example a tab column versus a nested structure</desc>
<columns>
<column> <name>LAYOUT_ID</name> <type>INTEGER</type>
<desc>Layout ID is not unique to the portal but unique for a given user. It links to up_layout_struct</desc>
<key>CK</key>
</column>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Foreign key user_id of table up_user</desc>
<key>CK</key>
</column>
<column> <name>LAYOUT_TITLE</name> <type>VARCHAR</type> <param>15</param>
<desc>Layout title - the name of the layout in text</desc>
</column>
<column> <name>INIT_STRUCT_ID</name> <type>INTEGER</type>
<desc>Initial structure ID - Points to the first channel/folder in the users layout and sets the start of the document tree</desc>
<key>FK</key>
</column>
</columns>
<primary-key>LAYOUT_ID</primary-key>
<primary-key>USER_ID</primary-key>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_LAYOUT_STRUCT</name>
<desc>Holds the order of a user's layout structure - the order in the user layout of channels subscribed to, the order of layout components (columns for example)</desc>
<columns>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Foreign key user_id of table up_user</desc>
<key>CK</key>
</column>
<column> <name>LAYOUT_ID</name> <type>INTEGER</type>
<desc>Foreign key layout_id of table up_user_layout and compound key</desc>
<key>CK</key>
</column>
<column> <name>STRUCT_ID</name> <type>INTEGER</type>
<desc>Struct ID is a unique number for a given user and is used by the portal for a given component (channel, column, etc) - primary key Given by next_struct_id in table up_user</desc>
<key>CK</key>
</column>
<column> <name>NEXT_STRUCT_ID</name> <type>INTEGER</type>
<desc>Struct ID that follows this ID in a list</desc>
</column>
<column> <name>CHLD_STRUCT_ID</name> <type>INTEGER</type>
<desc>Struct ID that is a child to this ID</desc>
</column>
<column> <name>EXTERNAL_ID</name> <type>VARCHAR</type><param>64</param>
<desc>External ID that channel can store key for resources used by a channel instance for a user</desc>
</column>
<column> <name>CHAN_ID</name> <type>INTEGER</type>
<desc>Channel ID if the current Struct_ID entry is a channel, then this is set to the channel id subscribed to and located at this position in the layout</desc>
</column>
<column> <name>NAME</name> <type>VARCHAR</type> <param>35</param>
<desc>Name of this struct entry, name of tab, column, header or footer, etc</desc>
</column>
<column> <name>TYPE</name> <type>VARCHAR</type> <param>35</param>
<desc>Used by portal to render framework channels - distinguishes structure components like tab and columns from footers, headers and channels</desc>
</column>
<column> <name>HIDDEN</name> <type>VARCHAR</type> <param>1</param>
<desc>Set to Y if folder or channel is hidden</desc>
</column>
<column> <name>IMMUTABLE</name> <type>VARCHAR</type> <param>1</param>
<desc>Set to Y if folder or channel cannot be moved in layout</desc>
</column>
<column> <name>UNREMOVABLE</name> <type>VARCHAR</type> <param>1</param>
<desc>Set to Y if folder or channel cannot be unsubscribed to or removed by user</desc>
</column>
</columns>
<primary-key>LAYOUT_ID</primary-key>
<primary-key>USER_ID</primary-key>
<primary-key>STRUCT_ID</primary-key>
</table>
<table sinceMajor="2" sinceMinor="2">
<name>UP_LAYOUT_STRUCT_LOCALE</name>
<desc>Locale preferences for a layout struct node</desc>
<columns>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Internal sequence id of a user's portal information - unique user identifier - primary key, see UP_SEQUENCE</desc>
<key>PK</key>
</column>
<column> <name>LAYOUT_ID</name> <type>INTEGER</type>
<desc>Identifies a user's layout</desc>
<key>PK</key>
</column>
<column> <name>NODE_ID</name> <type>INTEGER</type>
<desc>Identifies a node in a user's layout</desc>
<key>PK</key>
</column>
<column> <name>LOCALE</name> <type>VARCHAR</type> <param>64</param>
<desc>User's locale preference</desc>
<key>PK</key>
</column>
<column> <name>PRIORITY</name> <type>INTEGER</type>
<desc>The order of preference for this locale</desc>
</column>
</columns>
<primary-key>USER_ID</primary-key>
<primary-key>LAYOUT_ID</primary-key>
<primary-key>NODE_ID</primary-key>
<primary-key>LOCALE</primary-key>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_LAYOUT_PARAM</name>
<desc>Parameters set by the user at publish time based upon the Channel Publishing Document of a channel class, see UP_CHAN_TYPE table. Optionally set at subscription time according to the values stored in table up_channel_param</desc>
<columns>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Foreign key user_id of table up_user</desc>
<key>CK</key>
</column>
<column> <name>LAYOUT_ID</name> <type>INTEGER</type>
<desc>Foreign key layout_id of table up_user_layout and compound key</desc>
<key>CK</key>
</column>
<column> <name>STRUCT_ID</name> <type>INTEGER</type>
<desc>Foreign key of table UP_LAYOUT_STRUCT and compound key</desc>
<key>CK</key>
</column>
<column> <name>STRUCT_PARM_NM</name> <type>VARCHAR</type> <param>35</param>
<desc>Struct parameter name - holds the parameter name as given in the CPD - foreign key of table UP_CHANNEL_PARAM</desc>
<key>CK</key>
</column>
<column> <name>STRUCT_PARM_VAL</name> <type>LONGVARCHAR</type>
<desc>Struct parameter value - holds the parameter value as entered by the user</desc>
</column>
</columns>
<not-null>LAYOUT_ID</not-null>
<not-null>USER_ID</not-null>
<not-null>STRUCT_ID</not-null>
<not-null>STRUCT_PARM_NM</not-null>
<not-null>STRUCT_PARM_VAL</not-null>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_CHANNEL</name>
<desc>Channels - this table holds the major elements of a channel used as a default for all users</desc>
<columns>
<column> <name>CHAN_ID</name> <type>INTEGER</type>
<desc>Channel ID is a unique sequence number generated by the portal - primary key, see UP_SEQUENCE</desc>
<key>PK</key>
</column>
<column> <name>CHAN_TITLE</name> <type>VARCHAR</type> <param>128</param>
<desc>Channel title - it appears at the top title bar of the channel</desc>
</column>
<column> <name>CHAN_NAME</name> <type>VARCHAR</type> <param>128</param>
<desc>Channel name - used for display name of channel for subscribe, usually the same as title</desc>
</column>
<column> <name>CHAN_DESC</name> <type>VARCHAR</type> <param>255</param>
<desc>Channel description - provides additional information to the user about the channel to help him or her select a channel to subscribe to</desc>
</column>
<column> <name>CHAN_CLASS</name> <type>VARCHAR</type> <param>100</param>
<desc>Channel class - the java class used to render this type of channel - foreign key to type in table up_chan_types</desc>
<key>FK</key>
</column>
<column> <name>CHAN_TYPE_ID</name> <type>INTEGER</type>
<desc>Channel type id - the id of the java class used to render this type of channel - entity type_id from table up_chan_types</desc>
<key>FK</key>
</column>
<column> <name>CHAN_PUBL_ID</name> <type>INTEGER</type>
<desc>Channel publisher id - user_id of channel publisher - foreign key user_id of up_user</desc>
<key>FK</key>
</column>
<column> <name>CHAN_PUBL_DT</name> <type>TIMESTAMP</type>
<desc>Date channel published</desc>
</column>
<column> <name>CHAN_APVL_ID</name> <type>INTEGER</type>
<desc>Channel approver id - from user_id of up_user</desc>
</column>
<column> <name>CHAN_APVL_DT</name> <type>TIMESTAMP</type>
<desc>Date channel approved for use</desc>
</column>
<column> <name>CHAN_TIMEOUT</name> <type>INTEGER</type>
<desc>Channel timeout (msec) - the amount of time for an individual channel thread to render prior to being aborted, that is not cached and rendered with an error message</desc>
</column>
<column> <name>CHAN_EDITABLE</name> <type>VARCHAR</type> <param>1</param>
<desc>Is the channel editable, that is can channel parameters be changed by a user ****</desc>
</column>
<column> <name>CHAN_HAS_HELP</name> <type>VARCHAR</type> <param>1</param>
<desc>Does the channel have on-line help</desc>
</column>
<column> <name>CHAN_HAS_ABOUT</name> <type>VARCHAR</type> <param>1</param>
<desc>Does the channel have on-line about information - example information about the developers</desc>
</column>
<column> <name>CHAN_FNAME</name> <type>VARCHAR</type> <param>255</param>
<desc>Channel functional name. It is used to find a channel in a user's layout via JNDI. It is an optional channel attribute.</desc>
</column>
<column sinceMajor="2" sinceMinor="2"> <name>CHAN_SECURE</name> <type>VARCHAR</type> <param>1</param>
<desc>Is the channel secure, meaning is it to be rendered using a secure protocol (i.e. https)? Supported values are 'Y' and 'N'.</desc>
</column>
</columns>
<primary-key>CHAN_ID</primary-key>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_CHANNEL_PARAM</name>
<desc>Channel parameters - holds channel parameters shared for all users who subscribe to this channel</desc>
<columns>
<column> <name>CHAN_ID</name> <type>INTEGER</type>
<desc>Foreign key from up_channel</desc>
<key>FK</key>
</column>
<column> <name>CHAN_PARM_NM</name> <type>VARCHAR</type> <param>35</param>
<desc>Channel parameter name - a short name for a particular channel ID</desc>
</column>
<column> <name>CHAN_PARM_DESC</name> <type>VARCHAR</type> <param>255</param>
<desc>Channel parameter description - text string that describes parameter</desc>
</column>
<column> <name>CHAN_PARM_VAL</name> <type>VARCHAR</type> <param>255</param>
<desc>Channel parameter value - contains a parameter's value</desc>
</column>
<column> <name>CHAN_PARM_OVRD</name> <type>VARCHAR</type> <param>1</param>
<desc>Channel parameter override - Either "Y" or "N". "Y" or yes allows a user to override default channel parameters with his/her own</desc>
</column>
</columns>
<not-null>CHAN_ID</not-null>
<not-null>CHAN_PARM_NM</not-null>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_CHAN_TYPE</name>
<desc>Information about a java channel class, including the class to execute and it's Channel Publishing Document, used at publish</desc>
<columns>
<column> <name>TYPE_ID</name> <type>INTEGER</type>
<desc>Type ID is a unique sequence number generated by the portal - primary key</desc>
<key>PK</key>
</column>
<column> <name>TYPE</name> <type>VARCHAR</type> <param>128</param>
<desc>Type holds the name of the java class - eg, org.jasig.portal.channels.CImage</desc>
</column>
<column> <name>TYPE_NAME</name> <type>VARCHAR</type> <param>70</param>
<desc>Type name is a short description of the java class displayed during publish</desc>
</column>
<column> <name>TYPE_DESCR</name> <type>LONGVARCHAR</type>
<desc>Type description of the java class</desc>
</column>
<column> <name>TYPE_DEF_URI</name> <type>VARCHAR</type> <param>255</param>
<desc>URI or location of the Channel Publishing Document - CPD</desc>
</column>
</columns>
<primary-key>TYPE_ID</primary-key>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_SEQUENCE</name>
<desc>Emulates auto-increment/sequence values for the the various uPortal tables primary keys. Not used by DBLoader.</desc>
<columns>
<column> <name>SEQUENCE_NAME</name> <type>VARCHAR</type> <param>255</param>
<key>PK</key>
<desc>Name of sequence, corresponds to table name</desc>
</column>
<column> <name>SEQUENCE_VALUE</name> <type>INTEGER</type>
<desc>Next available number</desc>
</column>
</columns>
<primary-key>SEQUENCE_NAME</primary-key>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_USER_UA_MAP</name>
<desc>For a given user and layout combination, a list of reasonable browsers stored in user_agent</desc>
<columns>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Foreign key user_id of table up_user</desc>
<key>CK</key>
</column>
<column> <name>USER_AGENT</name> <type>VARCHAR</type> <param>255</param>
<desc>User agent string identifying a particular browser and version</desc>
</column>
<column> <name>PROFILE_ID</name> <type>INTEGER</type>
<desc>Foreign key of table UP_USER_PROFILE and compound key</desc>
<key>CK</key>
</column>
</columns>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_USER_PROFILE</name>
<columns>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Foreign key USER_ID of table up_user</desc>
<key>CK</key>
</column>
<column> <name>PROFILE_ID</name> <type>INTEGER</type>
<desc>Internal sequence id of a profile id - primary key, see UP_SEQUENCE</desc>
<key>PK</key>
</column>
<column> <name>PROFILE_NAME</name> <type>VARCHAR</type> <param>50</param>
<desc>Short name of profile</desc>
</column>
<column> <name>DESCRIPTION</name> <type>VARCHAR</type> <param>100</param>
<desc>Long description of profile</desc>
</column>
<column> <name>LAYOUT_ID</name> <type>INTEGER</type>
</column>
<column> <name>STRUCTURE_SS_ID</name> <type>INTEGER</type>
</column>
<column> <name>THEME_SS_ID</name> <type>INTEGER</type>
</column>
</columns>
<primary-key>USER_ID</primary-key>
<primary-key>PROFILE_ID</primary-key>
</table>
<table sinceMajor="2" sinceMinor="2">
<name>UP_USER_PROFILE_LOCALE</name>
<desc>Locale preferences for a user profile</desc>
<columns>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Internal sequence id of a user's portal information - unique user identifier - primary key, see UP_SEQUENCE</desc>
<key>PK</key>
</column>
<column> <name>PROFILE_ID</name> <type>INTEGER</type>
<desc>Internal sequence id of a user's profile</desc>
<key>PK</key>
</column>
<column> <name>LOCALE</name> <type>VARCHAR</type> <param>64</param>
<desc>User's locale preference</desc>
<key>PK</key>
</column>
<column> <name>PRIORITY</name> <type>INTEGER</type>
<desc>The order of preference for this locale</desc>
</column>
</columns>
<primary-key>USER_ID</primary-key>
<primary-key>PROFILE_ID</primary-key>
<primary-key>LOCALE</primary-key>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_SS_USER_PARM</name>
<desc>Holds a user's parameters according to user's structure style sheet - stored in a given user profile (ex. active tab and skin selection) (see up_ss_struct and up_ss_struct_par) based on ss_id</desc>
<columns>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Foreign key USER_ID of table UP_USER</desc>
<key>CK</key>
</column>
<column> <name>PROFILE_ID</name> <type>INTEGER</type>
<desc>Foreign key of table UP_USER_PROFILE and compound key</desc>
<key>CK</key>
</column>
<column> <name>SS_ID</name> <type>INTEGER</type>
<desc>Foreign key of table UP_SS_STRUCT_PARM and compound key</desc>
<key>CK</key>
</column>
<column> <name>SS_TYPE</name> <type>INTEGER</type>
<desc>Foreign key TYPE of table UP_SS_STRUCT_PARM</desc>
</column>
<column> <name>PARAM_NAME</name> <type>VARCHAR</type> <param>100</param>
<desc>Short description of parameter foreign key PARAM_NAME of table UP_SS_STRUCT_PARM</desc>
</column>
<column> <name>PARAM_VAL</name> <type>VARCHAR</type> <param>255</param>
<desc>Parameter value (ex. 1 for active tab)</desc>
</column>
</columns>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_SS_USER_ATTS</name>
<desc>Holds a user's parameters according to user's theme style sheet - stored in a given user profile (ex. column width) (see up_ss_struct and up_ss_struct_par) based on ss_id</desc>
<columns>
<column> <name>USER_ID</name> <type>INTEGER</type>
<desc>Foreign key USER_ID of table UP_USER</desc>
</column>
<column> <name>PROFILE_ID</name> <type>INTEGER</type>
<desc>Foreign key of table UP_USER_PROFILE and compound key</desc>
<key>CK</key>
</column>
<column> <name>SS_ID</name> <type>INTEGER</type>
<desc>Foreign key of table UP_SS_STRUCT_PARM and compound key</desc>
<key>CK</key>
</column>
<column> <name>SS_TYPE</name> <type>INTEGER</type>
<desc>Foreign key TYPE of table UP_SS_STRUCT_PARM</desc>
</column>
<column> <name>STRUCT_ID</name> <type>INTEGER</type>
<desc>Foreign key ss_id of table UP_SS_STRUCT</desc>
</column>
<column> <name>PARAM_NAME</name> <type>VARCHAR</type> <param>100</param>
<desc>Short description of parameter foreign key PARAM_NAME of table UP_SS_STRUCT_PARM</desc>
</column>
<column> <name>PARAM_TYPE</name> <type>INTEGER</type>
<desc>Foreign key TYPE of table UP_SS_STRUCT_PARM</desc>
</column>
<column> <name>PARAM_VAL</name> <type>VARCHAR</type> <param>255</param>
<desc>Parameter value (ex. 100% for column width)</desc>
</column>
</columns>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_SS_THEME</name>
<desc>Theme style sheet information - holds device, mime, serializer and class module information to render a given structured style sheet (see up_ss_struct) (ex. Nested tables or Deck of cards) parameters held in up_ss_theme_parm. Initialized when portal registers a NEW theme stylesheet with the database, adding theme stylesheet description</desc>
<columns>
<column> <name>SS_ID</name> <type>INTEGER</type>
<desc>Style sheet ID is a unique sequence number used by the portal - primary key, see UP_SEQUENCE</desc>
<key>PK</key>
</column>
<column> <name>SS_NAME</name> <type>VARCHAR</type> <param>255</param>
<desc>Theme style sheet name, displayed to the user - (ex. Nested tables or Deck of cards)</desc>
</column>
<column> <name>SS_URI</name> <type>VARCHAR</type> <param>255</param>
<desc>URI to locate style sheet used for this transformation</desc>
</column>
<column> <name>SS_DESCRIPTION_URI</name> <type>VARCHAR</type> <param>255</param>
<desc>URI to locate style sheet description file</desc>
</column>
<column> <name>SS_DESCRIPTION_TEXT</name> <type>LONGVARCHAR</type>
<desc>Long description of the results of this rendering for a device</desc>
</column>
<column> <name>STRUCT_SS_ID</name> <type>INTEGER</type>
<desc>Foreign key SS_ID of UP_SS_STRUCT - indicates a corresponding structure style sheet for this device</desc>
<key>FK</key>
</column>
<column> <name>SAMPLE_ICON_URI</name> <type>VARCHAR</type> <param>255</param>
<desc>URI locating the graphic for a sample icon representation of this theme</desc>
</column>
<column> <name>SAMPLE_URI</name> <type>VARCHAR</type> <param>255</param>
<desc>URI locating the full size graphic for a sample representation of this theme (ex. cellphone or workstation)</desc>
</column>
<column> <name>MIME_TYPE</name> <type>VARCHAR</type> <param>30</param>
<desc>Foreign key MIME_TYPE of table UP_MIME_TYPE - copied from MIME_TYPE of UP_MIME_TYPE</desc>
</column>
<column> <name>DEVICE_TYPE</name> <type>VARCHAR</type> <param>30</param>
<desc>Description of device (ex. cellphone)</desc>
</column>
<column> <name>SERIALIZER_NAME</name> <type>VARCHAR</type> <param>255</param>
<desc>Type of serializer to use for this device</desc>
</column>
<column> <name>UP_MODULE_CLASS</name> <type>VARCHAR</type> <param>255</param>
<desc>Module used to set preferences (see UP_SS_THEME_PARM)</desc>
</column>
</columns>
<primary-key>SS_ID</primary-key>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_SS_THEME_PARM</name>
<desc>Used when portal registers and manages theme stylesheets with parameters</desc>
<columns>
<column> <name>SS_ID</name> <type>INTEGER</type>
<desc>Foreign key SS_ID of UP_SS_THEME</desc>
<key>FK</key>
</column>
<column> <name>PARAM_NAME</name> <type>VARCHAR</type> <param>100</param>
<desc>Short description of parameter</desc>
<key>CK</key>
</column>
<column> <name>PARAM_DEFAULT_VAL</name> <type>VARCHAR</type> <param>255</param>
<desc>When first assigning this to a new theme style sheet, parameter is set to this default value</desc>
</column>
<column> <name>PARAM_DESCRIPT</name> <type>VARCHAR</type> <param>255</param>
<desc>Long description of the parameter - used for internal documentation</desc>
</column>
<column> <name>TYPE</name> <type>INTEGER</type>
<desc>1 - parameter, 2 - folder attributes are not allowed here, 3 - channel attribute (see RDBMUserLayoutStore)</desc>
</column>
</columns>
<primary-key>SS_ID</primary-key>
<primary-key>PARAM_NAME</primary-key>
<primary-key>TYPE</primary-key>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_SS_STRUCT</name>
<desc>Structure style sheet information - holds information to change the layout components for a user (ex. tabs and columns or nested categories) parameters held in up_ss_struct_par</desc>
<columns>
<column> <name>SS_ID</name> <type>INTEGER</type>
<desc>Style sheet ID is a unique sequence number used by the portal - primary key, see UP_SEQUENCE</desc>
<key>PK</key>
</column>
<column> <name>SS_NAME</name> <type>VARCHAR</type> <param>255</param>
<desc>Structured style sheet name, displayed to the user - (ex. Tabs and columns, Nested categories)</desc>
</column>
<column> <name>SS_URI</name> <type>VARCHAR</type> <param>255</param>
<desc>URI to locate style sheet used for this transformation</desc>
</column>
<column> <name>SS_DESCRIPTION_URI</name> <type>VARCHAR</type> <param>255</param>
<desc>URI to locate style sheet description file</desc>
</column>
<column> <name>SS_DESCRIPTION_TEXT</name> <type>LONGVARCHAR</type>
<desc>Long description of the results of this transformation</desc>
</column>
</columns>
<primary-key>SS_ID</primary-key>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_SS_STRUCT_PAR</name>
<desc>Structure style parameters associated with style sheet entities defined in up_ss_struct table</desc>
<columns>
<column> <name>SS_ID</name> <type>INTEGER</type>
<desc>Foreign key SS_ID of table UP_SS_STRUCT</desc>
<key>CK</key>
</column>
<column> <name>PARAM_NAME</name> <type>VARCHAR</type> <param>100</param>
<desc>Short description of parameter</desc>
<key>CK</key>
</column>
<column> <name>PARAM_DEFAULT_VAL</name> <type>VARCHAR</type> <param>255</param> <desc>When first assigning this style sheet parameter is set to this default value</desc>
</column>
<column> <name>PARAM_DESCRIPT</name> <type>VARCHAR</type> <param>255</param> <desc>Long description of the parameter - used to display to user (ex. Width of the column)</desc>
</column>
<column> <name>TYPE</name> <type>INTEGER</type>
<desc>Used by portal to distinguishes between structure components like width and active tab. 1 - parameter, 2 - folder attribute, 3 - channel attribute</desc>
<key>CK</key>
</column>
</columns>
<primary-key>SS_ID</primary-key>
<primary-key>PARAM_NAME</primary-key>
<primary-key>TYPE</primary-key>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_SS_MAP</name>
<desc>Reasonable combinations of themes and structures for a given mime type</desc>
<columns>
<column> <name>THEME_SS_ID</name> <type>INTEGER</type>
<desc>Foreign key SS_ID of table UP_SS_THEME</desc>
<key>FK</key>
</column>
<column> <name>STRUCT_SS_ID</name> <type>INTEGER</type>
<desc>Foreign key SS_ID of table UP_SS_STRUCT</desc>
<key>FK</key>
</column>
<column> <name>MIME_TYPE</name> <type>VARCHAR</type> <param>30</param>
<desc>Foreign key MIME_TYPE of table UP_MIME-TYPE - copied from MIME_TYPE of UP_MIME_TYPE</desc>
</column>
</columns>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_MIME_TYPE</name>
<desc>Mime types known by the portal</desc>
<columns>
<column> <name>MIME_TYPE</name> <type>VARCHAR</type> <param>30</param>
<desc>A known mime type (ex. text/html)</desc>
<key>PK</key>
</column>
<column> <name>MIME_TYPE_DESCRIPTION</name> <type>LONGVARCHAR</type>
<desc>Mime type description (ex. HTML mime type is the one that most desktop browsers use for text)</desc>
</column>
</columns>
<primary-key>MIME_TYPE</primary-key>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_GROUP</name>
<desc>Entries that uniquely identify a uPortal group</desc>
<columns>
<column> <name>GROUP_ID</name> <type>VARCHAR</type> <param>240</param>
<desc>Group ID is a unique sequence number used by the portal - primary key, see UP_SEQUENCE</desc>
<key>PK</key>
</column>
<column> <name>CREATOR_ID</name> <type>VARCHAR</type> <param>240</param>
<desc>Who created this group, foreign key USER_ID of table UP_USER</desc>
<key>FK</key>
</column>
<column> <name>ENTITY_TYPE_ID</name> <type>INTEGER</type>
<desc>The entity to be called when a member of this group, foreign key ENTITY_TYPE_ID of table UP_ENTITY_TYPE</desc>
<key>FK</key>
</column>
<column> <name>GROUP_NAME</name> <type>VARCHAR</type> <param>255</param>
<desc>Short textual name of the group for finding group</desc>
</column>
<column> <name>DESCRIPTION</name> <type>VARCHAR</type> <param>255</param>
<desc>Longer textual description of group to view a brief description of group</desc>
</column>
</columns>
<primary-key>GROUP_ID</primary-key>
<not-null>CREATOR_ID</not-null>
<not-null>ENTITY_TYPE_ID</not-null>
<not-null>GROUP_NAME</not-null>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_ENTITY_TYPE</name>
<desc>Holds known IBasicEntity types, associating an Integer code with the name of a class.</desc>
<columns>
<column> <name>ENTITY_TYPE_ID</name> <type>INTEGER</type>
<desc>Entity type ID is an unique identifying sequence number used by the portal - primary key, see UP_SEQUENCE</desc>
</column>
<column> <name>ENTITY_TYPE_NAME</name> <type>VARCHAR</type> <param>255</param>
<desc>Class name of entity (ex. org.jasig.portal.security.IPerson)</desc>
<key>PK</key>
</column>
<column> <name>DESCRIPTIVE_NAME</name> <type>VARCHAR</type> <param>255</param>
<desc>A name for display to end users (ex. Person)</desc>
</column>
</columns>
<primary-key>ENTITY_TYPE_NAME</primary-key>
<not-null>ENTITY_TYPE_ID</not-null>
</table>
<table sinceMajor="2" sinceMinor="1">
<name>UP_GROUP_MEMBERSHIP</name>
<desc>Mapping of member (that is, portal entity or group) to its containing group and flag if it is a group</desc>
<columns>
<column> <name>GROUP_ID</name> <type>VARCHAR</type> <param>200</param>
<desc>Unique group id number, key to GROUP_ID in UP_GROUP</desc>
<key>CK</key>
</column>
<column> <name>MEMBER_SERVICE</name> <type>VARCHAR</type> <param>80</param>
<desc>For a group, the name of the service of origin. For an entity, the name of this service.</desc>
<key>CK</key>
</column>
<column> <name>MEMBER_KEY</name> <type>VARCHAR</type> <param>200</param>
<desc>Key to either the entity or group, e.g., GROUP_ID in UP_GROUP, USER_NAME in UP_USER, etc.</desc>
<key>CK</key>
</column>
<column> <name>MEMBER_IS_GROUP</name> <type>VARCHAR</type> <param>1</param>
<desc>Is this member a group? T for true, F for false</desc>
</column>
</columns>
<primary-key>GROUP_ID</primary-key>
<primary-key>MEMBER_SERVICE</primary-key>
<primary-key>MEMBER_KEY</primary-key>
<primary-key>MEMBER_IS_GROUP</primary-key>
</table>
<!-- A table that is used by CPermissionsManager, distributed from the JA-SIG Clearinghouse -->
<table sinceMajor="2" sinceMinor="1">
<name>UPC_PERM_MGR</name>
<desc>A table that is used by CPermissionsManager, distributed from the JA-SIG Clearinghouse</desc>
<columns>
<column> <name>IPERMISSIBLE_CLASS</name> <type>LONGVARCHAR</type>
<desc>Holds name of permissions manager class that permits channels to be available for publish/subscribe</desc>
</column>
</columns>
<not-null>IPERMISSIBLE_CLASS</not-null>
</table>
<!-- Used by the EntityCachingService to synchronize caches on multiple servers. -->
<table sinceMajor="2" sinceMinor="1">
<name>UP_ENTITY_CACHE_INVALIDATION</name>
<desc>Each row indicates an entity that has been updated or deleted and whose cache entry is now invalid.</desc>
<columns>
<column> <name>ENTITY_TYPE_ID</name> <type>INTEGER</type>
<desc>The ID indicating the class of entity, foreign key ENTITY_TYPE_ID of table UP_ENTITY_TYPE</desc>
<key>CK</key>
</column>
<column> <name>ENTITY_KEY</name> <type>VARCHAR</type> <param>240</param>
<desc>The unique key of the entity.</desc>
<key>CK</key>
</column>
<column> <name>INVALIDATION_TIME</name> <type>TIMESTAMP</type>
<desc>The time the entity was invalidated.</desc>
</column>
<column sinceMajor="2" sinceMinor="2"> <name>ENTITY_CACHE_ID</name> <type>INTEGER</type>
<desc>The unique ID of the cache instance that wrote this invalidation.</desc>
</column>
</columns>
<primary-key>ENTITY_TYPE_ID</primary-key>
<primary-key>ENTITY_KEY</primary-key>
<not-null>INVALIDATION_TIME</not-null>
<not-null>ENTITY_CACHE_ID</not-null>
</table>
<!-- Used by the EntityLockService to share locks among multiple servers. -->
<table sinceMajor="2" sinceMinor="1">
<name>UP_ENTITY_LOCK</name>
<desc>Each row represents a lock held on a portal entity on behalf of an owner.</desc>
<columns>
<column> <name>ENTITY_TYPE_ID</name> <type>INTEGER</type>
<desc>The ID indicating the class of entity, foreign key ENTITY_TYPE_ID of table UP_ENTITY_TYPE</desc>
<key>CK</key>
</column>
<column> <name>ENTITY_KEY</name> <type>VARCHAR</type> <param>240</param>
<desc>The unique key of the entity being locked.</desc>
<key>CK</key>
</column>
<column> <name>LOCK_TYPE</name> <type>INTEGER</type>
<desc>Either READ (0) or WRITE (1)</desc>
</column>
<column> <name>EXPIRATION_TIME</name> <type>TIMESTAMP</type>
<desc>The time the lock expires.</desc>
</column>
<column> <name>LOCK_OWNER</name> <type>VARCHAR</type> <param>240</param>
<desc>The owner of the lock.</desc>
<key>CK</key>
</column>
</columns>
<primary-key>ENTITY_TYPE_ID</primary-key>
<primary-key>ENTITY_KEY</primary-key>
<primary-key>LOCK_OWNER</primary-key>
<primary-key>EXPIRATION_TIME</primary-key>
<not-null>LOCK_TYPE</not-null>
</table>
<!-- Used by the EntityPropertyRegistry to store aribtrary properties. -->
<table sinceMajor="2" sinceMinor="1">
<name>UP_ENTITY_PROP</name>
<desc>Each row represents a property of a portal entity.</desc>
<columns>
<column> <name>ENTITY_TYPE_ID</name> <type>INTEGER</type>
<desc>The ID indicating the class of entity, foreign key ENTITY_TYPE_ID of table UP_ENTITY_TYPE</desc>
</column>
<column> <name>ENTITY_KEY</name> <type>VARCHAR</type> <param>255</param>
<desc>The unique key of the entity.</desc>
</column>
<column> <name>PROPERTY_NAME</name> <type>VARCHAR</type> <param>150</param>
<desc>The name or key for the property</desc>
</column>
<column> <name>PROPERTY_VALUE</name> <type>VARCHAR</type> <param>255</param>
<desc>The value of the property</desc>
</column>
<column> <name>LAST_MODIFIED</name> <type>TIMESTAMP</type>
<desc>The last time this property was modified.</desc>
</column>
</columns>
<primary-key>ENTITY_TYPE_ID</primary-key>
<primary-key>ENTITY_KEY</primary-key>
<primary-key>PROPERTY_NAME</primary-key>
<not-null>PROPERTY_NAME</not-null>
<not-null>LAST_MODIFIED</not-null>
</table>
</tables>
Manage space
Manage content
Integrations