share_pass |
activated |
bool |
1 |
|
|
|
qti_assessment_item |
adaptive |
bool |
1 |
√ |
|
null |
workflow_node |
allow_editing |
bool |
1 |
√ |
|
null |
store_front |
allow_free |
bool |
1 |
|
|
|
store_front |
allow_purchase |
bool |
1 |
|
|
|
store_front |
allow_subscription |
bool |
1 |
|
|
|
drm_settings |
allow_sum |
bool |
1 |
√ |
|
null |
bookmark |
always_latest |
bool |
1 |
|
|
|
comments |
anonymous |
bool |
1 |
|
|
|
drm_settings |
aoo |
bool |
1 |
√ |
|
null |
history_event |
applies |
bool |
1 |
|
|
|
workflow_node |
auto_action |
bool |
1 |
√ |
|
null |
notification |
batched |
bool |
1 |
|
|
|
catalogue_assignment |
blacklisted |
bool |
1 |
|
|
|
migration_log |
can_retry |
bool |
1 |
|
|
|
portlet |
closeable |
bool |
1 |
|
|
|
portlet_preference |
closed |
bool |
1 |
|
|
|
purchased_content |
deleted |
bool |
1 |
√ |
|
null |
moderation_status |
deleted_moderating |
bool |
1 |
√ |
|
null |
item_definition |
deny_direct_contribution |
bool |
1 |
|
|
|
base_entity |
disabled |
bool |
1 |
|
|
|
access_expression |
dynamic |
bool |
1 |
|
|
|
drm_settings |
ea |
bool |
1 |
√ |
|
null |
harvester_profile |
enabled |
bool |
1 |
√ |
|
null |
institution |
enabled |
bool |
1 |
|
|
|
kaltura_server |
enabled |
bool |
1 |
|
|
|
portlet |
enabled |
bool |
1 |
|
|
|
price |
enabled |
bool |
1 |
|
|
|
workflow_node |
escalate |
bool |
1 |
√ |
|
null |
pricing_tier_assignment |
free_item |
bool |
1 |
|
|
|
report |
hide_report |
bool |
1 |
√ |
|
null |
hierarchy_topic |
hide_subtopics_with_no_result |
bool |
1 |
√ |
|
null |
drm_settings |
hlfo |
bool |
1 |
√ |
|
null |
cal_section |
illustration |
bool |
1 |
√ |
|
null |
cla_section |
illustration |
bool |
1 |
√ |
|
null |
hierarchy_topic |
inherit_freetext |
bool |
1 |
|
|
|
portlet |
institutional |
bool |
1 |
|
|
|
audit_log_lms |
latest |
bool |
1 |
|
|
|
item |
manual_navigation |
bool |
1 |
|
|
|
portlet |
minimisable |
bool |
1 |
|
|
|
portlet_preference |
minimised |
bool |
1 |
|
|
|
item |
moderating |
bool |
1 |
|
|
|
workflow |
movelive |
bool |
1 |
|
|
|
workflow_node |
movelive |
bool |
1 |
√ |
|
null |
workflow_node |
movelive_accept |
bool |
1 |
√ |
|
null |
migration_log |
must_exist |
bool |
1 |
|
|
|
moderation_status |
needs_reset |
bool |
1 |
|
|
|
harvester_profile |
new_version_on_harvest |
bool |
1 |
√ |
|
null |
drm_settings |
oma |
bool |
1 |
√ |
|
null |
sys_database_schema |
online |
bool |
1 |
√ |
|
null |
cal_holding |
out_of_print |
bool |
1 |
|
|
|
cla_holding |
out_of_print |
bool |
1 |
|
|
|
workflow_node_status |
overdue |
bool |
1 |
√ |
|
null |
drm_settings |
pa |
bool |
1 |
√ |
|
null |
purchase |
paid |
bool |
1 |
|
|
|
order_item |
per_user |
bool |
1 |
√ |
|
null |
attachment |
preview |
bool |
1 |
|
|
|
notification |
processed |
bool |
1 |
|
|
|
pricing_tier |
purchase |
bool |
1 |
|
|
|
thumbnail_request |
recreate |
bool |
1 |
√ |
|
null |
catalogue |
region_restricted |
bool |
1 |
|
|
|
workflow_node |
reject_point |
bool |
1 |
|
|
|
oauth_client |
requires_approval |
bool |
1 |
|
|
|
attachment |
restricted |
bool |
1 |
|
|
|
moderation_status |
resume_moderating |
bool |
1 |
√ |
|
null |
drm_settings |
rts |
bool |
1 |
√ |
|
null |
external_tool |
share_email |
bool |
1 |
√ |
|
null |
external_tool |
share_name |
bool |
1 |
√ |
|
null |
hierarchy_topic |
show_results |
bool |
1 |
|
|
|
item |
show_split_option |
bool |
1 |
√ |
|
null |
drm_settings |
slc |
bool |
1 |
√ |
|
null |
drm_settings |
smaiic |
bool |
1 |
√ |
|
null |
referencedurl |
success |
bool |
1 |
|
|
|
base_entity |
system_type |
bool |
1 |
|
|
|
qti_assessment_item |
time_dependent |
bool |
1 |
√ |
|
null |
workflow_node |
unanimousacceptance |
bool |
1 |
√ |
|
null |
moderation_status |
unarchive_moderating |
bool |
1 |
√ |
|
null |
connector |
use_logged_in_username |
bool |
1 |
|
|
|
sys_database_schema |
use_system |
bool |
1 |
|
|
|
cla_portion |
artistic_works |
bpchar |
1 |
√ |
|
null |
course_info |
course_type |
bpchar |
1 |
√ |
|
null |
access_entry |
grant_revoke |
bpchar |
1 |
|
|
|
cla_portion |
reason |
bpchar |
1 |
√ |
|
null |
cla_portion |
source |
bpchar |
1 |
√ |
|
null |
workflow_node_status |
status |
bpchar |
1 |
|
|
|
audit_log_lms |
type |
bpchar |
1 |
|
|
|
workflow_message |
type |
bpchar |
1 |
|
|
|
workflow_node |
type |
bpchar |
1 |
|
|
|
tomcat_sessions |
valid |
bpchar |
1 |
|
|
|
tomcat_sessions |
data |
bytea |
2147483647 |
|
|
|
item |
rating |
float4 |
8,8 |
|
|
|
qti_item_variable |
normal_maximum |
float8 |
17,17 |
√ |
|
null |
qti_item_variable |
normal_minimum |
float8 |
17,17 |
√ |
|
null |
institution |
quota |
float8 |
17,17 |
√ |
|
null |
access_entry |
acl_order |
int4 |
10 |
|
|
|
access_entry |
acl_priority |
int4 |
10 |
|
|
|
workflow_node |
action_days |
int4 |
10 |
√ |
|
null |
portlet_recent_contrib |
age_days |
int4 |
10 |
|
|
|
pss_callback_log |
attempt_number |
int4 |
10 |
|
|
|
attachment |
attindex |
int4 |
10 |
|
|
|
workflow_node |
child_index |
int4 |
10 |
|
|
|
drm_settings |
cuc |
int4 |
10 |
√ |
|
null |
subscription_period |
duration |
int4 |
10 |
|
|
|
subscription_period |
duration_unit |
int4 |
10 |
|
|
|
workflow_node |
escalationdays |
int4 |
10 |
√ |
|
null |
item_history |
histindex |
int4 |
10 |
|
|
|
order_history |
histindex |
int4 |
10 |
|
|
|
item_navigation_node |
index |
int4 |
10 |
√ |
|
null |
order_item |
item_version |
int4 |
10 |
|
|
|
purchased_content |
item_version |
int4 |
10 |
|
|
|
sale_item |
item_version |
int4 |
10 |
|
|
|
thumbnail_request |
item_version |
int4 |
10 |
√ |
|
null |
kaltura_server |
kdp_ui_conf_id |
int4 |
10 |
|
|
|
term |
lft |
int4 |
10 |
√ |
|
null |
hierarchy_topic |
list_position |
int4 |
10 |
|
|
|
hierarchy_topic_all_parents |
list_position |
int4 |
10 |
|
|
|
qti_assessment_item_ref |
list_position |
int4 |
10 |
|
|
|
tlegroup_all_parents |
list_position |
int4 |
10 |
|
|
|
tomcat_sessions |
maxinactive |
int4 |
10 |
|
|
|
drm_settings |
muc |
int4 |
10 |
√ |
|
null |
qti_assessment_test |
navigation_mode |
int4 |
10 |
|
|
|
custom_link |
order |
int4 |
10 |
|
|
|
portlet_preference |
order |
int4 |
10 |
|
|
|
order_item |
orderitempos |
int4 |
10 |
|
|
|
order_store_part |
paid |
int4 |
10 |
|
|
|
sale |
paid_status |
int4 |
10 |
|
|
|
kaltura_server |
partner_id |
int4 |
10 |
|
|
|
portlet_preference |
position |
int4 |
10 |
|
|
|
language_string |
priority |
int4 |
10 |
|
|
|
workflow_node |
priority |
int4 |
10 |
√ |
|
null |
purchase_item |
purchitempos |
int4 |
10 |
|
|
|
sale_item |
quantity |
int4 |
10 |
|
|
|
comments |
rating |
int4 |
10 |
|
|
|
qti_item_result |
resindex |
int4 |
10 |
|
|
|
item_definition |
reviewperiod |
int4 |
10 |
|
|
|
term |
rht |
int4 |
10 |
√ |
|
null |
sale_item |
saleitempos |
int4 |
10 |
|
|
|
qti_item_result |
sequence_index |
int4 |
10 |
√ |
|
null |
qti_abstract_result |
session_status |
int4 |
10 |
|
|
|
purchase_item |
source_item_version |
int4 |
10 |
|
|
|
purchased_content |
source_item_version |
int4 |
10 |
|
|
|
activate_request |
status |
int4 |
10 |
|
|
|
migration_log |
status |
int4 |
10 |
|
|
|
order |
status |
int4 |
10 |
|
|
|
order_history |
status |
int4 |
10 |
|
|
|
referencedurl |
status |
int4 |
10 |
|
|
|
course_info |
students |
int4 |
10 |
|
|
|
kaltura_server |
sub_partner_id |
int4 |
10 |
|
|
|
qti_assessment_test |
submission_mode |
int4 |
10 |
|
|
|
item_navigation_tab |
tabindex |
int4 |
10 |
|
|
|
thumbnail_request |
thumbnail_types |
int4 |
10 |
|
|
|
federated_search |
timeout |
int4 |
10 |
|
|
|
pss_callback_log |
tracking_number |
int4 |
10 |
|
|
|
referencedurl |
tries |
int4 |
10 |
|
|
|
lti_consumer |
unknown_user |
int4 |
10 |
√ |
|
null |
order_item |
users |
int4 |
10 |
|
|
|
purchase_item |
users |
int4 |
10 |
|
|
|
qti_item_variable |
variable_type |
int4 |
10 |
|
|
|
qti_item_variable |
varindex |
int4 |
10 |
|
|
|
audit_log_lms |
version |
int4 |
10 |
|
|
|
hierarchy_topic_dynamic_key_re |
version |
int4 |
10 |
|
|
|
item |
version |
int4 |
10 |
|
|
|
store_harvest_info |
version |
int4 |
10 |
|
|
|
access_expression_expression_p |
access_expression_id |
int8 |
19 |
|
|
|
hierarchy_topic |
advanced_search_id |
int8 |
19 |
√ |
|
null |
hierarchy_topic_all_parents |
all_parents_id |
int8 |
19 |
|
|
|
tlegroup_all_parents |
all_parents_id |
int8 |
19 |
|
|
|
qti_item_result |
assessment_result_id |
int8 |
19 |
|
|
|
item_navigation_tab |
attachment_id |
int8 |
19 |
√ |
|
null |
base_entity_attributes |
base_entity_id |
int8 |
19 |
|
|
|
bookmark_keywords |
bookmark_id |
int8 |
19 |
|
|
|
language_string |
bundle_id |
int8 |
19 |
|
|
|
cal_holding_authors |
cal_holding_id |
int8 |
19 |
|
|
|
cal_holding_ids |
cal_holding_id |
int8 |
19 |
|
|
|
cal_portion_authors |
cal_portion_id |
int8 |
19 |
|
|
|
cal_portion_topics |
cal_portion_id |
int8 |
19 |
|
|
|
catalogue_assignment |
catalogue_id |
int8 |
19 |
|
|
|
catalogue_regions |
catalogue_id |
int8 |
19 |
|
|
|
price |
catalogue_id |
int8 |
19 |
√ |
|
null |
workflow_node_status |
cause_id |
int8 |
19 |
√ |
|
null |
cla_holding_authors |
cla_holding_id |
int8 |
19 |
|
|
|
cla_holding_ids |
cla_holding_id |
int8 |
19 |
|
|
|
cla_portion_authors |
cla_portion_id |
int8 |
19 |
|
|
|
cla_portion_topics |
cla_portion_id |
int8 |
19 |
|
|
|
oauth_token |
client_id |
int8 |
19 |
|
|
|
store_front |
client_id |
int8 |
19 |
|
|
|
portlet_recent_contrib_collect |
collections_id |
int8 |
19 |
|
|
|
activate_request |
course_info_id |
int8 |
19 |
|
|
|
base_entity |
description_id |
int8 |
19 |
√ |
|
null |
item |
description_id |
int8 |
19 |
√ |
|
null |
workflow_node |
description_id |
int8 |
19 |
√ |
|
null |
item |
drm_settings_id |
int8 |
19 |
√ |
|
null |
dyna_collection_item_defs |
dyna_collection_id |
int8 |
19 |
|
|
|
dyna_collection_schemas |
dyna_collection_id |
int8 |
19 |
|
|
|
dyna_collection_usage_ids |
dyna_collection_id |
int8 |
19 |
|
|
|
catalogue |
dynamic_collection_id |
int8 |
19 |
√ |
|
null |
hierarchy_topic_key_resources |
element |
int8 |
19 |
|
|
|
dyna_collection_item_defs |
entity_id |
int8 |
19 |
|
|
|
dyna_collection_schemas |
entity_id |
int8 |
19 |
|
|
|
entity_lock |
entity_id |
int8 |
19 |
√ |
|
null |
hierarchy_topic_add_idefs |
entity_id |
int8 |
19 |
|
|
|
hierarchy_topic_add_schemas |
entity_id |
int8 |
19 |
|
|
|
hierarchy_topic_inh_idefs |
entity_id |
int8 |
19 |
|
|
|
hierarchy_topic_inh_schemas |
entity_id |
int8 |
19 |
|
|
|
access_entry |
expression_id |
int8 |
19 |
|
|
|
relation |
first_item_id |
int8 |
19 |
|
|
|
hierarchy_topic_add_idefs |
hierarchy_topic_id |
int8 |
19 |
|
|
|
hierarchy_topic_add_schemas |
hierarchy_topic_id |
int8 |
19 |
|
|
|
hierarchy_topic_all_parents |
hierarchy_topic_id |
int8 |
19 |
|
|
|
hierarchy_topic_attributes |
hierarchy_topic_id |
int8 |
19 |
|
|
|
hierarchy_topic_inh_idefs |
hierarchy_topic_id |
int8 |
19 |
|
|
|
hierarchy_topic_inh_schemas |
hierarchy_topic_id |
int8 |
19 |
|
|
|
hierarchy_topic_key_resources |
hierarchy_topic_id |
int8 |
19 |
|
|
|
item_history |
history_id |
int8 |
19 |
|
|
|
cal_portion |
holding_id |
int8 |
19 |
√ |
|
null |
cla_portion |
holding_id |
int8 |
19 |
√ |
|
null |
access_entry |
id |
int8 |
19 |
|
|
|
access_expression |
id |
int8 |
19 |
|
|
|
activate_request |
id |
int8 |
19 |
|
|
|
attachment |
id |
int8 |
19 |
|
|
|
audit_log_entry |
id |
int8 |
19 |
|
|
|
audit_log_lms |
id |
int8 |
19 |
|
|
|
base_entity |
id |
int8 |
19 |
|
|
|
bookmark |
id |
int8 |
19 |
|
|
|
cached_value |
id |
int8 |
19 |
|
|
|
cal_holding |
id |
int8 |
19 |
|
|
|
cal_portion |
id |
int8 |
19 |
|
|
|
cal_section |
id |
int8 |
19 |
|
|
|
catalogue |
id |
int8 |
19 |
|
|
|
catalogue_assignment |
id |
int8 |
19 |
|
|
|
cla_holding |
id |
int8 |
19 |
|
|
|
cla_portion |
id |
int8 |
19 |
|
|
|
cla_section |
id |
int8 |
19 |
|
|
|
comments |
id |
int8 |
19 |
|
|
|
connector |
id |
int8 |
19 |
|
|
|
course_info |
id |
int8 |
19 |
|
|
|
custom_link |
id |
int8 |
19 |
|
|
|
drm_acceptance |
id |
int8 |
19 |
|
|
|
drm_settings |
id |
int8 |
19 |
|
|
|
dyna_collection |
id |
int8 |
19 |
|
|
|
echo_server |
id |
int8 |
19 |
|
|
|
entity_lock |
id |
int8 |
19 |
|
|
|
external_tool |
id |
int8 |
19 |
|
|
|
favourite_search |
id |
int8 |
19 |
|
|
|
federated_search |
id |
int8 |
19 |
|
|
|
harvester_profile |
id |
int8 |
19 |
|
|
|
hierarchy_topic |
id |
int8 |
19 |
|
|
|
hierarchy_topic_dynamic_key_re |
id |
int8 |
19 |
|
|
|
history_event |
id |
int8 |
19 |
|
|
|
html_editor_plugin |
id |
int8 |
19 |
|
|
|
institution |
id |
int8 |
19 |
|
|
|
item |
id |
int8 |
19 |
|
|
|
item_definition |
id |
int8 |
19 |
|
|
|
item_lock |
id |
int8 |
19 |
|
|
|
item_navigation_node |
id |
int8 |
19 |
|
|
|
item_navigation_tab |
id |
int8 |
19 |
|
|
|
item_xml |
id |
int8 |
19 |
|
|
|
itemdef_blobs |
id |
int8 |
19 |
|
|
|
kaltura_server |
id |
int8 |
19 |
|
|
|
language |
id |
int8 |
19 |
|
|
|
language_bundle |
id |
int8 |
19 |
|
|
|
language_string |
id |
int8 |
19 |
|
|
|
lti_consumer |
id |
int8 |
19 |
|
|
|
lti_consumer_custom_role |
id |
int8 |
19 |
|
|
|
mime_entry |
id |
int8 |
19 |
|
|
|
moderation_status |
id |
int8 |
19 |
|
|
|
notification |
id |
int8 |
19 |
|
|
|
oauth_client |
id |
int8 |
19 |
|
|
|
oauth_token |
id |
int8 |
19 |
|
|
|
order |
id |
int8 |
19 |
|
|
|
order_history |
id |
int8 |
19 |
|
|
|
order_item |
id |
int8 |
19 |
|
|
|
order_store_part |
id |
int8 |
19 |
|
|
|
payment_gateway |
id |
int8 |
19 |
|
|
|
portlet |
id |
int8 |
19 |
|
|
|
portlet_preference |
id |
int8 |
19 |
|
|
|
portlet_recent_contrib |
id |
int8 |
19 |
|
|
|
power_search |
id |
int8 |
19 |
|
|
|
price |
id |
int8 |
19 |
|
|
|
pricing_tier |
id |
int8 |
19 |
|
|
|
pricing_tier_assignment |
id |
int8 |
19 |
|
|
|
pss_callback_log |
id |
int8 |
19 |
|
|
|
purchase |
id |
int8 |
19 |
|
|
|
purchase_item |
id |
int8 |
19 |
|
|
|
purchased_content |
id |
int8 |
19 |
|
|
|
qti_abstract_result |
id |
int8 |
19 |
|
|
|
qti_assessment_item |
id |
int8 |
19 |
|
|
|
qti_assessment_item_ref |
id |
int8 |
19 |
|
|
|
qti_assessment_result |
id |
int8 |
19 |
|
|
|
qti_assessment_test |
id |
int8 |
19 |
|
|
|
qti_item_result |
id |
int8 |
19 |
|
|
|
qti_item_variable |
id |
int8 |
19 |
|
|
|
referencedurl |
id |
int8 |
19 |
|
|
|
region |
id |
int8 |
19 |
|
|
|
relation |
id |
int8 |
19 |
|
|
|
report |
id |
int8 |
19 |
|
|
|
sale |
id |
int8 |
19 |
|
|
|
sale_item |
id |
int8 |
19 |
|
|
|
store |
id |
int8 |
19 |
|
|
|
store_front |
id |
int8 |
19 |
|
|
|
store_harvest_info |
id |
int8 |
19 |
|
|
|
subscription_period |
id |
int8 |
19 |
|
|
|
sys_database_schema |
id |
int8 |
19 |
|
|
|
task_history |
id |
int8 |
19 |
|
|
|
tax_type |
id |
int8 |
19 |
|
|
|
taxonomy |
id |
int8 |
19 |
|
|
|
term |
id |
int8 |
19 |
|
|
|
term_attributes |
id |
int8 |
19 |
|
|
|
thumbnail_request |
id |
int8 |
19 |
|
|
|
tlegroup |
id |
int8 |
19 |
|
|
|
tleschemas |
id |
int8 |
19 |
|
|
|
tleuser |
id |
int8 |
19 |
|
|
|
user_script |
id |
int8 |
19 |
|
|
|
workflow |
id |
int8 |
19 |
|
|
|
workflow_message |
id |
int8 |
19 |
|
|
|
workflow_node |
id |
int8 |
19 |
|
|
|
workflow_node_status |
id |
int8 |
19 |
|
|
|
user_preference |
institution |
int8 |
19 |
|
|
|
access_entry |
institution_id |
int8 |
19 |
|
|
|
audit_log_entry |
institution_id |
int8 |
19 |
√ |
|
null |
audit_log_lms |
institution_id |
int8 |
19 |
√ |
|
null |
base_entity |
institution_id |
int8 |
19 |
|
|
|
bookmark |
institution_id |
int8 |
19 |
|
|
|
cached_value |
institution_id |
int8 |
19 |
|
|
|
configuration_property |
institution_id |
int8 |
19 |
|
|
|
entity_lock |
institution_id |
int8 |
19 |
√ |
|
null |
favourite_search |
institution_id |
int8 |
19 |
|
|
|
hierarchy_topic |
institution_id |
int8 |
19 |
|
|
|
hierarchy_topic_dynamic_key_re |
institution_id |
int8 |
19 |
|
|
|
item |
institution_id |
int8 |
19 |
|
|
|
item_lock |
institution_id |
int8 |
19 |
√ |
|
null |
language |
institution_id |
int8 |
19 |
|
|
|
mime_entry |
institution_id |
int8 |
19 |
|
|
|
notification |
institution_id |
int8 |
19 |
|
|
|
oauth_token |
institution_id |
int8 |
19 |
|
|
|
order |
institution_id |
int8 |
19 |
|
|
|
pss_callback_log |
institution_id |
int8 |
19 |
|
|
|
purchase |
institution_id |
int8 |
19 |
|
|
|
purchased_content |
institution_id |
int8 |
19 |
|
|
|
qti_assessment_item |
institution_id |
int8 |
19 |
|
|
|
qti_assessment_test |
institution_id |
int8 |
19 |
|
|
|
sale |
institution_id |
int8 |
19 |
|
|
|
share_pass |
institution_id |
int8 |
19 |
|
|
|
subscription_period |
institution_id |
int8 |
19 |
|
|
|
thumbnail_request |
institution_id |
int8 |
19 |
|
|
|
tlegroup |
institution_id |
int8 |
19 |
|
|
|
tleuser |
institution_id |
int8 |
19 |
|
|
|
item |
item_definition_id |
int8 |
19 |
|
|
|
activate_request |
item_id |
int8 |
19 |
|
|
|
attachment |
item_id |
int8 |
19 |
|
|
|
bookmark |
item_id |
int8 |
19 |
|
|
|
cal_holding |
item_id |
int8 |
19 |
√ |
|
null |
cal_portion |
item_id |
int8 |
19 |
|
|
|
catalogue_assignment |
item_id |
int8 |
19 |
|
|
|
cla_holding |
item_id |
int8 |
19 |
√ |
|
null |
cla_portion |
item_id |
int8 |
19 |
|
|
|
comments |
item_id |
int8 |
19 |
|
|
|
drm_acceptance |
item_id |
int8 |
19 |
|
|
|
item_collaborators |
item_id |
int8 |
19 |
|
|
|
item_history |
item_id |
int8 |
19 |
|
|
|
item_lock |
item_id |
int8 |
19 |
√ |
|
null |
item_navigation_node |
item_id |
int8 |
19 |
|
|
|
item_notifications |
item_id |
int8 |
19 |
|
|
|
item_referenced_urls |
item_id |
int8 |
19 |
|
|
|
pricing_tier_assignment |
item_id |
int8 |
19 |
|
|
|
pss_callback_log |
item_id |
int8 |
19 |
√ |
|
null |
qti_assessment_test |
item_id |
int8 |
19 |
|
|
|
share_pass |
item_id |
int8 |
19 |
|
|
|
task_history |
item_id |
int8 |
19 |
√ |
|
null |
qti_item_result |
item_ref_id |
int8 |
19 |
|
|
|
item |
item_xml_id |
int8 |
19 |
|
|
|
power_search_itemdefs |
itemdefs_id |
int8 |
19 |
|
|
|
tomcat_sessions |
lastaccess |
int8 |
19 |
|
|
|
hierarchy_topic |
long_description_id |
int8 |
19 |
√ |
|
null |
lti_consumer_custom_role |
lti_consumer_id |
int8 |
19 |
√ |
|
null |
lti_consumer_instructor_roles |
lti_consumer_id |
int8 |
19 |
|
|
|
lti_consumer_other_roles |
lti_consumer_id |
int8 |
19 |
|
|
|
lti_consumer_unknown_groups |
lti_consumer_id |
int8 |
19 |
|
|
|
subscription_period |
magnitude |
int8 |
19 |
|
|
|
mime_entry_attributes |
mime_entry_id |
int8 |
19 |
|
|
|
mime_entry_extensions |
mime_entry_id |
int8 |
19 |
|
|
|
workflow_node_status |
mod_status_id |
int8 |
19 |
|
|
|
item |
moderation_id |
int8 |
19 |
√ |
|
null |
base_entity |
name_id |
int8 |
19 |
√ |
|
null |
hierarchy_topic |
name_id |
int8 |
19 |
√ |
|
null |
item |
name_id |
int8 |
19 |
√ |
|
null |
subscription_period |
name_id |
int8 |
19 |
√ |
|
null |
workflow_node |
name_id |
int8 |
19 |
√ |
|
null |
item_navigation_tab |
node_id |
int8 |
19 |
|
|
|
workflow_message |
node_id |
int8 |
19 |
|
|
|
oauth_client_permissions |
oauth_client_id |
int8 |
19 |
|
|
|
oauth_token_permissions |
oauth_token_id |
int8 |
19 |
|
|
|
order_history |
order_id |
int8 |
19 |
|
|
|
order_store_part |
order_id |
int8 |
19 |
|
|
|
order_item |
order_store_part_id |
int8 |
19 |
|
|
|
hierarchy_topic |
parent_id |
int8 |
19 |
√ |
|
null |
item_navigation_node |
parent_id |
int8 |
19 |
√ |
|
null |
term |
parent_id |
int8 |
19 |
√ |
|
null |
tlegroup |
parent_id |
int8 |
19 |
√ |
|
null |
workflow_node |
parent_id |
int8 |
19 |
√ |
|
null |
payment_gateway_regions |
payment_gateway_id |
int8 |
19 |
|
|
|
price |
period_id |
int8 |
19 |
√ |
|
null |
sale_item |
period_id |
int8 |
19 |
√ |
|
null |
cal_section |
portion_id |
int8 |
19 |
|
|
|
cla_section |
portion_id |
int8 |
19 |
|
|
|
portlet_preference |
portlet_id |
int8 |
19 |
|
|
|
portlet_recent_contrib |
portlet_id |
int8 |
19 |
|
|
|
portlet_recent_contrib_collect |
portlet_recent_contrib_id |
int8 |
19 |
|
|
|
power_search_itemdefs |
power_search_id |
int8 |
19 |
|
|
|
order_item |
price |
int8 |
19 |
|
|
|
order_store_part |
price |
int8 |
19 |
|
|
|
purchase |
price |
int8 |
19 |
|
|
|
purchase_item |
price |
int8 |
19 |
|
|
|
sale |
price |
int8 |
19 |
|
|
|
sale_item |
price |
int8 |
19 |
|
|
|
purchase_item |
purchase_id |
int8 |
19 |
|
|
|
pricing_tier_assignment |
purchase_pricing_tier_id |
int8 |
19 |
√ |
|
null |
qti_item_variable_value |
qti_item_variable_id |
int8 |
19 |
|
|
|
qti_assessment_item_ref |
question_id |
int8 |
19 |
|
|
|
item_referenced_urls |
referenced_urls_id |
int8 |
19 |
|
|
|
price |
region_id |
int8 |
19 |
√ |
|
null |
region_countries |
region_id |
int8 |
19 |
|
|
|
catalogue_regions |
regions_id |
int8 |
19 |
|
|
|
payment_gateway_regions |
regions_id |
int8 |
19 |
|
|
|
qti_item_variable |
result_id |
int8 |
19 |
|
|
|
hierarchy_topic |
results_section_name_id |
int8 |
19 |
√ |
|
null |
sale_item |
sale_id |
int8 |
19 |
|
|
|
store_harvest_info |
sale_id |
int8 |
19 |
|
|
|
item_definition |
schema_id |
int8 |
19 |
√ |
|
null |
power_search |
schema_id |
int8 |
19 |
√ |
|
null |
schema_citations |
schema_id |
int8 |
19 |
|
|
|
schema_exp_transforms |
schema_id |
int8 |
19 |
|
|
|
schema_imp_transforms |
schema_id |
int8 |
19 |
|
|
|
relation |
second_item_id |
int8 |
19 |
|
|
|
hierarchy_topic |
short_description_id |
int8 |
19 |
√ |
|
null |
item_definition |
slow_id |
int8 |
19 |
√ |
|
null |
order_store_part |
store_id |
int8 |
19 |
√ |
|
null |
purchase |
store_id |
int8 |
19 |
|
|
|
purchased_content |
store_id |
int8 |
19 |
√ |
|
null |
sale |
storefront_id |
int8 |
19 |
|
|
|
pricing_tier_assignment |
subscription_pricing_tier_id |
int8 |
19 |
√ |
|
null |
hierarchy_topic |
subtopics_section_name_id |
int8 |
19 |
√ |
|
null |
task_history |
task_id |
int8 |
19 |
√ |
|
null |
order_item |
tax |
int8 |
19 |
|
|
|
order_store_part |
tax |
int8 |
19 |
|
|
|
purchase |
tax |
int8 |
19 |
|
|
|
purchase_item |
tax |
int8 |
19 |
|
|
|
sale |
tax |
int8 |
19 |
|
|
|
sale_item |
tax |
int8 |
19 |
|
|
|
store_front |
tax_type_id |
int8 |
19 |
√ |
|
null |
term |
taxonomy_id |
int8 |
19 |
|
|
|
term_attributes |
term_id |
int8 |
19 |
|
|
|
qti_assessment_item_ref |
test_id |
int8 |
19 |
|
|
|
qti_assessment_result |
test_id |
int8 |
19 |
|
|
|
price |
tier_id |
int8 |
19 |
|
|
|
tlegroup_all_parents |
tlegroup_id |
int8 |
19 |
|
|
|
tlegroup_users |
tlegroup_id |
int8 |
19 |
|
|
|
item |
total_file_size |
int8 |
19 |
|
|
|
institution |
unique_id |
int8 |
19 |
|
|
|
order_item |
unit_price |
int8 |
19 |
|
|
|
purchase_item |
unit_price |
int8 |
19 |
|
|
|
sale_item |
unit_price |
int8 |
19 |
|
|
|
order_item |
unit_tax |
int8 |
19 |
|
|
|
sale_item |
unit_tax |
int8 |
19 |
|
|
|
price |
value |
int8 |
19 |
|
|
|
workflow_node_status |
wnode_id |
int8 |
19 |
|
|
|
item_definition |
workflow_id |
int8 |
19 |
√ |
|
null |
workflow_node |
workflow_id |
int8 |
19 |
|
|
|
workflow_node_auto_assigns |
workflow_node_id |
int8 |
19 |
|
|
|
workflow_node_groups |
workflow_node_id |
int8 |
19 |
|
|
|
workflow_node_roles |
workflow_node_id |
int8 |
19 |
|
|
|
workflow_node_users |
workflow_node_id |
int8 |
19 |
|
|
|
workflow_node_status_accepted |
workflow_node_status_id |
int8 |
19 |
|
|
|
tax_type |
pct |
numeric |
9,4 |
|
|
|
sale |
tax_percent |
numeric |
9,4 |
√ |
|
null |
federated_search |
advanced_search_fields |
text |
2147483647 |
√ |
|
null |
cal_holding |
author_list |
text |
2147483647 |
√ |
|
null |
cal_portion |
author_list |
text |
2147483647 |
√ |
|
null |
cla_holding |
author_list |
text |
2147483647 |
√ |
|
null |
cla_portion |
author_list |
text |
2147483647 |
√ |
|
null |
external_tool |
baseurl |
text |
2147483647 |
√ |
|
null |
html_editor_plugin |
buttons |
text |
2147483647 |
√ |
|
null |
qti_item_result |
candidate_comment |
text |
2147483647 |
√ |
|
null |
html_editor_plugin |
client_js |
text |
2147483647 |
√ |
|
null |
comments |
comment |
text |
2147483647 |
√ |
|
null |
history_event |
comment |
text |
2147483647 |
√ |
|
null |
order_history |
comment |
text |
2147483647 |
√ |
|
null |
cal_holding |
comments |
text |
2147483647 |
√ |
|
null |
cla_holding |
comments |
text |
2147483647 |
√ |
|
null |
html_editor_plugin |
config |
text |
2147483647 |
√ |
|
null |
portlet |
config |
text |
2147483647 |
√ |
|
null |
drm_settings |
content_owners |
text |
2147483647 |
√ |
|
null |
favourite_search |
criteria |
text |
2147483647 |
√ |
|
null |
item |
curricula |
text |
2147483647 |
√ |
|
null |
external_tool |
custom_params |
text |
2147483647 |
√ |
|
null |
attachment |
data |
text |
2147483647 |
√ |
|
null |
sale |
data |
text |
2147483647 |
√ |
|
null |
user_preference |
data |
text |
2147483647 |
√ |
|
null |
audit_log_entry |
data4 |
text |
2147483647 |
√ |
|
null |
activate_request |
description |
text |
2147483647 |
√ |
|
null |
cal_holding |
description |
text |
2147483647 |
√ |
|
null |
cla_holding |
description |
text |
2147483647 |
√ |
|
null |
sys_database_schema |
description |
text |
2147483647 |
√ |
|
null |
tlegroup |
description |
text |
2147483647 |
√ |
|
null |
itemdef_blobs |
dynamic_metadata_rules |
text |
2147483647 |
√ |
|
null |
mime_entry_attributes |
element |
text |
2147483647 |
|
|
|
migration_log |
error_message |
text |
2147483647 |
√ |
|
null |
html_editor_plugin |
extra |
text |
2147483647 |
√ |
|
null |
thumbnail_request |
filename |
text |
2147483647 |
|
|
|
cal_holding |
id_list |
text |
2147483647 |
√ |
|
null |
cla_holding |
id_list |
text |
2147483647 |
√ |
|
null |
qti_assessment_item |
item_body |
text |
2147483647 |
√ |
|
null |
itemdef_blobs |
item_metadata_rules |
text |
2147483647 |
√ |
|
null |
itemdef_blobs |
item_summary_sections |
text |
2147483647 |
√ |
|
null |
migration_log |
message |
text |
2147483647 |
√ |
|
null |
pss_callback_log |
message |
text |
2147483647 |
√ |
|
null |
workflow_message |
message |
text |
2147483647 |
|
|
|
itemdef_blobs |
metadata_mapping |
text |
2147483647 |
√ |
|
null |
item_navigation_node |
name |
text |
2147483647 |
√ |
|
null |
item_navigation_tab |
name |
text |
2147483647 |
√ |
|
null |
order_item |
name |
text |
2147483647 |
√ |
|
null |
activate_request |
override_reason |
text |
2147483647 |
√ |
|
null |
cal_holding |
publisher |
text |
2147483647 |
√ |
|
null |
cla_holding |
publisher |
text |
2147483647 |
√ |
|
null |
drm_settings |
raf |
text |
2147483647 |
√ |
|
null |
moderation_status |
rejected_message |
text |
2147483647 |
√ |
|
null |
drm_settings |
rtodates |
text |
2147483647 |
√ |
|
null |
drm_settings |
rtoips |
text |
2147483647 |
√ |
|
null |
drm_settings |
rtorecip |
text |
2147483647 |
√ |
|
null |
dyna_collection_item_defs |
script |
text |
2147483647 |
√ |
|
null |
dyna_collection_schemas |
script |
text |
2147483647 |
√ |
|
null |
hierarchy_topic_add_idefs |
script |
text |
2147483647 |
√ |
|
null |
hierarchy_topic_add_schemas |
script |
text |
2147483647 |
√ |
|
null |
hierarchy_topic_inh_idefs |
script |
text |
2147483647 |
√ |
|
null |
hierarchy_topic_inh_schemas |
script |
text |
2147483647 |
√ |
|
null |
user_script |
script |
text |
2147483647 |
√ |
|
null |
workflow_node |
script |
text |
2147483647 |
√ |
|
null |
item |
search_details |
text |
2147483647 |
√ |
|
null |
itemdef_blobs |
search_details |
text |
2147483647 |
√ |
|
null |
tleschemas |
serialised_definition |
text |
2147483647 |
√ |
|
null |
html_editor_plugin |
server_js |
text |
2147483647 |
√ |
|
null |
pss_callback_log |
status |
text |
2147483647 |
√ |
|
null |
drm_settings |
terms |
text |
2147483647 |
√ |
|
null |
qti_assessment_result |
test_session_state |
text |
2147483647 |
√ |
|
null |
language_string |
text |
text |
2147483647 |
√ |
|
null |
cal_holding |
title |
text |
2147483647 |
√ |
|
null |
cal_portion |
title |
text |
2147483647 |
√ |
|
null |
cla_holding |
title |
text |
2147483647 |
√ |
|
null |
cla_portion |
title |
text |
2147483647 |
√ |
|
null |
qti_assessment_item |
title |
text |
2147483647 |
|
|
|
qti_assessment_test |
title |
text |
2147483647 |
|
|
|
custom_link |
url |
text |
2147483647 |
|
|
|
favourite_search |
url |
text |
2147483647 |
|
|
|
referencedurl |
url |
text |
2147483647 |
√ |
|
null |
connector |
username_script |
text |
2147483647 |
√ |
|
null |
cached_value |
value |
text |
2147483647 |
√ |
|
null |
configuration_property |
value |
text |
2147483647 |
√ |
|
null |
sys_system_config |
value |
text |
2147483647 |
√ |
|
null |
term_attributes |
value |
text |
2147483647 |
√ |
|
null |
itemdef_blobs |
wizard |
text |
2147483647 |
√ |
|
null |
power_search |
wizard |
text |
2147483647 |
√ |
|
null |
item_xml |
xml |
text |
2147483647 |
|
|
|
order_item |
added_date |
timestamp |
29,6 |
√ |
|
null |
purchase |
checkout_date |
timestamp |
29,6 |
|
|
|
oauth_token |
created |
timestamp |
29,6 |
|
|
|
order |
created_date |
timestamp |
29,6 |
√ |
|
null |
sale |
creation_date |
timestamp |
29,6 |
|
|
|
drm_acceptance |
date |
timestamp |
29,6 |
√ |
|
null |
history_event |
date |
timestamp |
29,6 |
√ |
|
null |
notification |
date |
timestamp |
29,6 |
|
|
|
order_history |
date |
timestamp |
29,6 |
|
|
|
store_harvest_info |
date |
timestamp |
29,6 |
|
|
|
workflow_message |
date |
timestamp |
29,6 |
|
|
|
base_entity |
date_created |
timestamp |
29,6 |
|
|
|
comments |
date_created |
timestamp |
29,6 |
√ |
|
null |
hierarchy_topic_dynamic_key_re |
date_created |
timestamp |
29,6 |
|
|
|
item |
date_created |
timestamp |
29,6 |
|
|
|
workflow_node_status |
date_due |
timestamp |
29,6 |
√ |
|
null |
item |
date_for_index |
timestamp |
29,6 |
|
|
|
base_entity |
date_modified |
timestamp |
29,6 |
|
|
|
bookmark |
date_modified |
timestamp |
29,6 |
√ |
|
null |
favourite_search |
date_modified |
timestamp |
29,6 |
|
|
|
item |
date_modified |
timestamp |
29,6 |
|
|
|
thumbnail_request |
date_requested |
timestamp |
29,6 |
|
|
|
qti_abstract_result |
datestamp |
timestamp |
29,6 |
|
|
|
task_history |
entry_date |
timestamp |
29,6 |
√ |
|
null |
migration_log |
executed |
timestamp |
29,6 |
|
|
|
task_history |
exit_date |
timestamp |
29,6 |
√ |
|
null |
access_entry |
expiry |
timestamp |
29,6 |
√ |
|
null |
oauth_token |
expiry |
timestamp |
29,6 |
√ |
|
null |
share_pass |
expiry |
timestamp |
29,6 |
√ |
|
null |
activate_request |
from |
timestamp |
29,6 |
√ |
|
null |
course_info |
from |
timestamp |
29,6 |
√ |
|
null |
cal_holding |
issue_date |
timestamp |
29,6 |
√ |
|
null |
cla_holding |
issue_date |
timestamp |
29,6 |
√ |
|
null |
moderation_status |
last_action |
timestamp |
29,6 |
√ |
|
null |
order |
last_action_date |
timestamp |
29,6 |
√ |
|
null |
notification |
last_attempt |
timestamp |
29,6 |
√ |
|
null |
pss_callback_log |
last_attempt |
timestamp |
29,6 |
|
|
|
referencedurl |
last_checked |
timestamp |
29,6 |
|
|
|
store |
last_harvest |
timestamp |
29,6 |
√ |
|
null |
referencedurl |
last_indexed |
timestamp |
29,6 |
|
|
|
harvester_profile |
last_run |
timestamp |
29,6 |
√ |
|
null |
moderation_status |
live_approval_date |
timestamp |
29,6 |
√ |
|
null |
order_store_part |
paid_date |
timestamp |
29,6 |
√ |
|
null |
purchase |
paid_date |
timestamp |
29,6 |
√ |
|
null |
sale |
paid_date |
timestamp |
29,6 |
√ |
|
null |
moderation_status |
review_date |
timestamp |
29,6 |
√ |
|
null |
moderation_status |
start |
timestamp |
29,6 |
√ |
|
null |
share_pass |
started |
timestamp |
29,6 |
√ |
|
null |
workflow_node_status |
started |
timestamp |
29,6 |
√ |
|
null |
purchase_item |
subscription_end_date |
timestamp |
29,6 |
√ |
|
null |
sale_item |
subscription_end_date |
timestamp |
29,6 |
√ |
|
null |
order_item |
subscription_start_date |
timestamp |
29,6 |
√ |
|
null |
purchase_item |
subscription_start_date |
timestamp |
29,6 |
√ |
|
null |
sale_item |
subscription_start_date |
timestamp |
29,6 |
√ |
|
null |
activate_request |
time |
timestamp |
29,6 |
√ |
|
null |
audit_log_entry |
timestamp |
timestamp |
29,6 |
√ |
|
null |
audit_log_lms |
timestamp |
timestamp |
29,6 |
√ |
|
null |
cached_value |
ttl |
timestamp |
29,6 |
√ |
|
null |
activate_request |
until |
timestamp |
29,6 |
√ |
|
null |
course_info |
until |
timestamp |
29,6 |
√ |
|
null |
store_front |
country |
varchar |
4 |
|
|
|
notification |
reason |
varchar |
8 |
|
|
|
activate_request |
type |
varchar |
8 |
|
|
|
tax_type |
code |
varchar |
10 |
|
|
|
order_item |
currency |
varchar |
10 |
√ |
|
null |
order_store_part |
currency |
varchar |
10 |
√ |
|
null |
price |
currency |
varchar |
10 |
|
|
|
purchase |
currency |
varchar |
10 |
|
|
|
sale |
currency |
varchar |
10 |
|
|
|
qti_assessment_item |
lang |
varchar |
10 |
√ |
|
null |
order_item |
tax_code |
varchar |
10 |
√ |
|
null |
order_store_part |
tax_code |
varchar |
10 |
√ |
|
null |
purchase |
tax_code |
varchar |
10 |
√ |
|
null |
purchase_item |
tax_code |
varchar |
10 |
√ |
|
null |
sale |
tax_code |
varchar |
10 |
√ |
|
null |
sale_item |
tax_code |
varchar |
10 |
√ |
|
null |
access_entry |
aggregate_ordering |
varchar |
12 |
|
|
|
language |
country |
varchar |
15 |
|
|
|
language |
language |
varchar |
15 |
|
|
|
language |
variant |
varchar |
15 |
|
|
|
payment_gateway |
gateway_type |
varchar |
16 |
|
|
|
connector |
lms_type |
varchar |
16 |
|
|
|
user_script |
script_type |
varchar |
16 |
|
|
|
item |
status |
varchar |
16 |
√ |
|
null |
portlet |
type |
varchar |
16 |
|
|
|
mime_entry_extensions |
element |
varchar |
20 |
√ |
|
null |
audit_log_entry |
event_category |
varchar |
20 |
√ |
|
null |
audit_log_entry |
event_type |
varchar |
20 |
√ |
|
null |
language_string |
locale |
varchar |
20 |
|
|
|
share_pass |
privilege |
varchar |
20 |
|
|
|
cal_holding |
pub_date |
varchar |
20 |
√ |
|
null |
cla_holding |
pub_date |
varchar |
20 |
√ |
|
null |
cla_section |
range_end |
varchar |
20 |
√ |
|
null |
cla_section |
range_start |
varchar |
20 |
√ |
|
null |
institution |
short_name |
varchar |
20 |
|
|
|
institution |
time_zone |
varchar |
20 |
√ |
|
null |
cal_holding |
type |
varchar |
20 |
√ |
|
null |
cla_holding |
type |
varchar |
20 |
√ |
|
null |
html_editor_plugin |
type |
varchar |
20 |
|
|
|
item_definition |
scorm_packaging_transformat |
varchar |
25 |
√ |
|
null |
history_event |
state |
varchar |
25 |
√ |
|
null |
history_event |
type |
varchar |
25 |
√ |
|
null |
store_front |
contact_phone |
varchar |
30 |
√ |
|
null |
share_pass |
password |
varchar |
30 |
√ |
|
null |
access_entry |
privilege |
varchar |
30 |
√ |
|
null |
course_info |
version_selection |
varchar |
30 |
√ |
|
null |
workflow_node_status |
acttype |
varchar |
31 |
|
|
|
attachment |
type |
varchar |
31 |
|
|
|
attachment |
md5sum |
varchar |
32 |
√ |
|
null |
referencedurl |
url_hash |
varchar |
32 |
√ |
|
null |
term |
value_hash |
varchar |
32 |
√ |
|
null |
notification |
attempt_id |
varchar |
36 |
√ |
|
null |
workflow_node_status |
assigned_to |
varchar |
40 |
√ |
|
null |
cal_section |
attachment |
varchar |
40 |
√ |
|
null |
cla_section |
attachment |
varchar |
40 |
√ |
|
null |
store_harvest_info |
attachment_uuid |
varchar |
40 |
√ |
|
null |
workflow_node |
auto_assign_schema_uuid |
varchar |
40 |
√ |
|
null |
order_item |
cat_uuid |
varchar |
40 |
|
|
|
purchase_item |
catalogue_uuid |
varchar |
40 |
|
|
|
sale_item |
catalogue_uuid |
varchar |
40 |
|
|
|
order_store_part |
checkout_uuid |
varchar |
40 |
√ |
|
null |
oauth_token |
code |
varchar |
40 |
√ |
|
null |
workflow_node |
collection_uuid |
varchar |
40 |
√ |
|
null |
sale |
customer_reference |
varchar |
40 |
|
|
|
drm_settings |
drm_page_uuid |
varchar |
40 |
|
|
|
workflow_node |
due_date_schema_uuid |
varchar |
40 |
√ |
|
null |
share_pass |
id |
varchar |
40 |
|
|
|
order_item |
item_uuid |
varchar |
40 |
|
|
|
purchased_content |
item_uuid |
varchar |
40 |
|
|
|
sale_item |
item_uuid |
varchar |
40 |
|
|
|
store_harvest_info |
item_uuid |
varchar |
40 |
|
|
|
order |
original_order_uuid |
varchar |
40 |
√ |
|
null |
sale |
payment_gateway_uuid |
varchar |
40 |
√ |
|
null |
order_item |
period_uuid |
varchar |
40 |
√ |
|
null |
user_preference |
preferenceid |
varchar |
40 |
|
|
|
sale_item |
pricing_tier_uuid |
varchar |
40 |
√ |
|
null |
order_item |
purchase_tier_uuid |
varchar |
40 |
√ |
|
null |
moderation_status |
rejected_step |
varchar |
40 |
√ |
|
null |
relation |
relation_type |
varchar |
40 |
√ |
|
null |
audit_log_entry |
session_id |
varchar |
40 |
√ |
|
null |
audit_log_lms |
session_id |
varchar |
40 |
√ |
|
null |
purchase_item |
source_item_uuid |
varchar |
40 |
|
|
|
purchased_content |
source_item_uuid |
varchar |
40 |
|
|
|
staging |
stagingid |
varchar |
40 |
|
|
|
history_event |
step |
varchar |
40 |
√ |
|
null |
order_item |
subscription_tier_uuid |
varchar |
40 |
√ |
|
null |
workflow_node_auto_assigns |
task |
varchar |
40 |
√ |
|
null |
history_event |
to_step |
varchar |
40 |
√ |
|
null |
portlet_preference |
user_id |
varchar |
40 |
|
|
|
workflow_node |
user_schema_uuid |
varchar |
40 |
√ |
|
null |
entity_lock |
user_session |
varchar |
40 |
√ |
|
null |
item_lock |
user_session |
varchar |
40 |
√ |
|
null |
staging |
user_session |
varchar |
40 |
√ |
|
null |
activate_request |
uuid |
varchar |
40 |
|
|
|
attachment |
uuid |
varchar |
40 |
|
|
|
audit_log_lms |
uuid |
varchar |
40 |
√ |
|
null |
base_entity |
uuid |
varchar |
40 |
|
|
|
comments |
uuid |
varchar |
40 |
|
|
|
hierarchy_topic |
uuid |
varchar |
40 |
|
|
|
hierarchy_topic_dynamic_key_re |
uuid |
varchar |
40 |
√ |
|
null |
item |
uuid |
varchar |
40 |
√ |
|
null |
item_navigation_node |
uuid |
varchar |
40 |
√ |
|
null |
order |
uuid |
varchar |
40 |
|
|
|
order_item |
uuid |
varchar |
40 |
|
|
|
order_store_part |
uuid |
varchar |
40 |
|
|
|
purchase |
uuid |
varchar |
40 |
|
|
|
purchase_item |
uuid |
varchar |
40 |
|
|
|
qti_assessment_item |
uuid |
varchar |
40 |
|
|
|
qti_assessment_item_ref |
uuid |
varchar |
40 |
|
|
|
qti_assessment_test |
uuid |
varchar |
40 |
|
|
|
sale |
uuid |
varchar |
40 |
|
|
|
sale_item |
uuid |
varchar |
40 |
|
|
|
subscription_period |
uuid |
varchar |
40 |
|
|
|
sys_schema_id |
uuid |
varchar |
40 |
|
|
|
term |
uuid |
varchar |
40 |
|
|
|
thumbnail_request |
uuid |
varchar |
40 |
|
|
|
tlegroup |
uuid |
varchar |
40 |
|
|
|
tleuser |
uuid |
varchar |
40 |
|
|
|
workflow_node |
uuid |
varchar |
40 |
|
|
|
activate_request |
attachment |
varchar |
45 |
|
|
|
qti_item_variable |
base_type |
varchar |
50 |
√ |
|
null |
qti_item_variable |
cardinality |
varchar |
50 |
|
|
|
notification |
itemid_only |
varchar |
50 |
|
|
|
lti_consumer |
postfix |
varchar |
50 |
√ |
|
null |
lti_consumer |
prefix |
varchar |
50 |
√ |
|
null |
external_tool |
consumer_key |
varchar |
64 |
√ |
|
null |
base_entity_attributes |
key |
varchar |
64 |
|
|
|
hierarchy_topic_attributes |
key |
varchar |
64 |
|
|
|
term_attributes |
key |
varchar |
64 |
|
|
|
user_script |
module_name |
varchar |
64 |
√ |
|
null |
sys_database_schema |
password |
varchar |
64 |
√ |
|
null |
store_front |
product_version |
varchar |
64 |
|
|
|
sys_database_schema |
reporting_password |
varchar |
64 |
√ |
|
null |
sys_database_schema |
reporting_username |
varchar |
64 |
√ |
|
null |
external_tool |
shared_secret |
varchar |
64 |
√ |
|
null |
federated_search |
type |
varchar |
64 |
√ |
|
null |
harvester_profile |
type |
varchar |
64 |
√ |
|
null |
sys_database_schema |
username |
varchar |
64 |
√ |
|
null |
drm_settings |
usages |
varchar |
70 |
√ |
|
null |
access_entry |
target_object |
varchar |
80 |
√ |
|
null |
thumbnail_request |
task_id |
varchar |
80 |
√ |
|
null |
oauth_client |
client_id |
varchar |
100 |
|
|
|
store |
client_id |
varchar |
100 |
|
|
|
oauth_client |
client_secret |
varchar |
100 |
|
|
|
taxonomy |
data_source_plugin_id |
varchar |
100 |
√ |
|
null |
thumbnail_request |
filename_hash |
varchar |
100 |
|
|
|
hierarchy_topic |
freetext |
varchar |
100 |
√ |
|
null |
dyna_collection |
freetext_query |
varchar |
100 |
√ |
|
null |
item_navigation_node |
icon |
varchar |
100 |
√ |
|
null |
tomcat_sessions |
id |
varchar |
100 |
|
|
|
mime_entry_attributes |
mapkey |
varchar |
100 |
|
|
|
institution |
name |
varchar |
100 |
|
|
|
tlegroup |
name |
varchar |
100 |
√ |
|
null |
html_editor_plugin |
plugin_id |
varchar |
100 |
|
|
|
history_event |
step_name |
varchar |
100 |
√ |
|
null |
history_event |
to_step_name |
varchar |
100 |
√ |
|
null |
mime_entry |
type |
varchar |
100 |
|
|
|
institution |
url |
varchar |
100 |
√ |
|
null |
item_navigation_tab |
viewer |
varchar |
100 |
√ |
|
null |
dyna_collection |
virtualisation_id |
varchar |
100 |
√ |
|
null |
hierarchy_topic |
virtualisation_id |
varchar |
100 |
√ |
|
null |
item_definition |
wizardcategory |
varchar |
100 |
√ |
|
null |
audit_log_lms |
content_type |
varchar |
120 |
√ |
|
null |
activate_request |
citation |
varchar |
128 |
√ |
|
null |
course_info |
code |
varchar |
128 |
√ |
|
null |
share_pass |
email_address |
varchar |
150 |
|
|
|
cal_portion |
chapter |
varchar |
200 |
√ |
|
null |
cla_portion |
chapter |
varchar |
200 |
√ |
|
null |
item_navigation_node |
identifier |
varchar |
200 |
√ |
|
null |
institution |
admin_password |
varchar |
255 |
|
|
|
kaltura_server |
admin_secret |
varchar |
255 |
√ |
|
null |
lti_consumer |
allowed_expression |
varchar |
255 |
√ |
|
null |
tomcat_sessions |
app |
varchar |
255 |
|
|
|
echo_server |
application_url |
varchar |
255 |
√ |
|
null |
order |
approvers_expression |
varchar |
255 |
√ |
|
null |
html_editor_plugin |
author |
varchar |
255 |
√ |
|
null |
cached_value |
cache_id |
varchar |
255 |
√ |
|
null |
purchase |
checkout_by |
varchar |
255 |
|
|
|
course_info |
citation |
varchar |
255 |
√ |
|
null |
federated_search |
collection_uuid |
varchar |
255 |
√ |
|
null |
echo_server |
consumer_key |
varchar |
255 |
√ |
|
null |
lti_consumer |
consumer_key |
varchar |
255 |
|
|
|
echo_server |
consumer_secret |
varchar |
255 |
√ |
|
null |
lti_consumer |
consumer_secret |
varchar |
255 |
|
|
|
echo_server |
content_url |
varchar |
255 |
√ |
|
null |
cal_section |
copyright_status |
varchar |
255 |
√ |
|
null |
cla_section |
copyright_status |
varchar |
255 |
√ |
|
null |
region_countries |
countries |
varchar |
255 |
√ |
|
null |
order |
created_by |
varchar |
255 |
|
|
|
share_pass |
creator |
varchar |
255 |
|
|
|
audit_log_entry |
data1 |
varchar |
255 |
√ |
|
null |
audit_log_entry |
data2 |
varchar |
255 |
√ |
|
null |
audit_log_entry |
data3 |
varchar |
255 |
√ |
|
null |
moderation_status |
deleted_status2 |
varchar |
255 |
√ |
|
null |
echo_server |
echo_systemid |
varchar |
255 |
√ |
|
null |
access_expression_expression_p |
element |
varchar |
255 |
√ |
|
null |
bookmark_keywords |
element |
varchar |
255 |
√ |
|
null |
cal_holding_authors |
element |
varchar |
255 |
√ |
|
null |
cal_holding_ids |
element |
varchar |
255 |
√ |
|
null |
cal_portion_authors |
element |
varchar |
255 |
√ |
|
null |
cal_portion_topics |
element |
varchar |
255 |
√ |
|
null |
cla_holding_authors |
element |
varchar |
255 |
√ |
|
null |
cla_holding_ids |
element |
varchar |
255 |
√ |
|
null |
cla_portion_authors |
element |
varchar |
255 |
√ |
|
null |
cla_portion_topics |
element |
varchar |
255 |
√ |
|
null |
dyna_collection_usage_ids |
element |
varchar |
255 |
√ |
|
null |
item_collaborators |
element |
varchar |
255 |
√ |
|
null |
item_notifications |
element |
varchar |
255 |
√ |
|
null |
tlegroup_users |
element |
varchar |
255 |
√ |
|
null |
tleuser |
email_address |
varchar |
255 |
√ |
|
null |
lti_consumer_custom_role |
equella_role |
varchar |
255 |
√ |
|
null |
schema_exp_transforms |
fil |
varchar |
255 |
√ |
|
null |
schema_imp_transforms |
fil |
varchar |
255 |
√ |
|
null |
report |
filename |
varchar |
255 |
√ |
|
null |
tleuser |
first_name |
varchar |
255 |
|
|
|
relation |
first_resource |
varchar |
255 |
√ |
|
null |
thumbnail_request |
global_task_id |
varchar |
255 |
√ |
|
null |
workflow_node_groups |
group |
varchar |
255 |
√ |
|
null |
thumbnail_request |
handle |
varchar |
255 |
|
|
|
qti_assessment_item_ref |
identifier |
varchar |
255 |
|
|
|
qti_item_variable |
identifier |
varchar |
255 |
|
|
|
lti_consumer_instructor_roles |
instructor_roles |
varchar |
255 |
√ |
|
null |
tleschemas |
item_description_path |
varchar |
255 |
√ |
|
null |
tleschemas |
item_name_path |
varchar |
255 |
√ |
|
null |
thumbnail_request |
item_uuid |
varchar |
255 |
|
|
|
notification |
itemid |
varchar |
255 |
|
|
|
cached_value |
key |
varchar |
255 |
√ |
|
null |
sys_system_config |
key |
varchar |
255 |
|
|
|
order |
last_action_user |
varchar |
255 |
√ |
|
null |
tleuser |
last_name |
varchar |
255 |
|
|
|
qti_assessment_result |
lms_instance_id |
varchar |
255 |
√ |
|
null |
course_info |
lmsid |
varchar |
255 |
√ |
|
null |
lti_consumer_custom_role |
lti_role |
varchar |
255 |
√ |
|
null |
referencedurl |
message |
varchar |
255 |
√ |
|
null |
migration_log |
migration_id |
varchar |
255 |
|
|
|
favourite_search |
name |
varchar |
255 |
|
|
|
schema_citations |
name |
varchar |
255 |
√ |
|
null |
lti_consumer_other_roles |
other_roles |
varchar |
255 |
√ |
|
null |
base_entity |
owner |
varchar |
255 |
√ |
|
null |
bookmark |
owner |
varchar |
255 |
|
|
|
comments |
owner |
varchar |
255 |
√ |
|
null |
favourite_search |
owner |
varchar |
255 |
|
|
|
item |
owner |
varchar |
255 |
|
|
|
purchase |
paid_for_by |
varchar |
255 |
√ |
|
null |
tleuser |
password |
varchar |
255 |
|
|
|
order |
payers_expression |
varchar |
255 |
√ |
|
null |
oauth_client_permissions |
permissions |
varchar |
255 |
√ |
|
null |
oauth_token_permissions |
permissions |
varchar |
255 |
√ |
|
null |
configuration_property |
property |
varchar |
255 |
|
|
|
portlet_recent_contrib |
query |
varchar |
255 |
√ |
|
null |
cal_section |
range |
varchar |
255 |
√ |
|
null |
cla_section |
range |
varchar |
255 |
√ |
|
null |
purchase |
receipt |
varchar |
255 |
√ |
|
null |
sale |
receipt |
varchar |
255 |
√ |
|
null |
moderation_status |
rejected_by |
varchar |
255 |
√ |
|
null |
moderation_status |
resume_status2 |
varchar |
255 |
√ |
|
null |
workflow_node_roles |
role |
varchar |
255 |
√ |
|
null |
relation |
second_resource |
varchar |
255 |
√ |
|
null |
audit_log_lms |
selected |
varchar |
255 |
√ |
|
null |
cla_portion |
source_institution |
varchar |
255 |
√ |
|
null |
oauth_token |
token |
varchar |
255 |
|
|
|
store |
token |
varchar |
255 |
√ |
|
null |
purchase |
transaction_uuid |
varchar |
255 |
|
|
|
schema_citations |
transfo |
varchar |
255 |
√ |
|
null |
schema_exp_transforms |
typ |
varchar |
255 |
√ |
|
null |
schema_imp_transforms |
typ |
varchar |
255 |
√ |
|
null |
lti_consumer_unknown_groups |
unknown_groups |
varchar |
255 |
√ |
|
null |
drm_acceptance |
user |
varchar |
255 |
√ |
|
null |
history_event |
user |
varchar |
255 |
√ |
|
null |
workflow_message |
user |
varchar |
255 |
|
|
|
workflow_node_status_accepted |
user |
varchar |
255 |
√ |
|
null |
workflow_node_users |
user |
varchar |
255 |
√ |
|
null |
audit_log_entry |
user_id |
varchar |
255 |
|
|
|
audit_log_lms |
user_id |
varchar |
255 |
|
|
|
oauth_client |
user_id |
varchar |
255 |
√ |
|
null |
oauth_token |
user_id |
varchar |
255 |
|
|
|
order_history |
user_id |
varchar |
255 |
|
|
|
portlet_recent_contrib |
user_id |
varchar |
255 |
√ |
|
null |
qti_assessment_result |
user_id |
varchar |
255 |
|
|
|
kaltura_server |
user_secret |
varchar |
255 |
√ |
|
null |
notification |
user_to |
varchar |
255 |
|
|
|
entity_lock |
userid |
varchar |
255 |
√ |
|
null |
item_lock |
userid |
varchar |
255 |
√ |
|
null |
user_preference |
userid |
varchar |
255 |
|
|
|
tleuser |
username |
varchar |
255 |
|
|
|
qti_item_variable_value |
value |
varchar |
255 |
√ |
|
null |
attachment |
viewer |
varchar |
255 |
√ |
|
null |
dyna_collection |
virtualisation_path |
varchar |
255 |
√ |
|
null |
hierarchy_topic |
virtualisation_path |
varchar |
255 |
√ |
|
null |
cal_holding |
issue_number |
varchar |
256 |
√ |
|
null |
cla_holding |
issue_number |
varchar |
256 |
√ |
|
null |
qti_assessment_item |
label |
varchar |
256 |
√ |
|
null |
activate_request |
location_id |
varchar |
256 |
√ |
|
null |
activate_request |
location_name |
varchar |
256 |
√ |
|
null |
qti_assessment_test |
test_part_identifier |
varchar |
256 |
|
|
|
activate_request |
user |
varchar |
256 |
√ |
|
null |
cal_holding |
volume |
varchar |
256 |
√ |
|
null |
cla_holding |
volume |
varchar |
256 |
√ |
|
null |
store |
store_url |
varchar |
500 |
|
|
|
workflow_node |
auto_assign_node |
varchar |
512 |
√ |
|
null |
course_info |
department_name |
varchar |
512 |
√ |
|
null |
mime_entry |
description |
varchar |
512 |
√ |
|
null |
workflow_node |
due_date_path |
varchar |
512 |
√ |
|
null |
cal_holding |
length |
varchar |
512 |
√ |
|
null |
cla_holding |
length |
varchar |
512 |
√ |
|
null |
item |
metadata_security_targets |
varchar |
512 |
√ |
|
null |
favourite_search |
query |
varchar |
512 |
√ |
|
null |
sys_database_schema |
reporting_url |
varchar |
512 |
√ |
|
null |
audit_log_lms |
resource |
varchar |
512 |
√ |
|
null |
item |
thumb |
varchar |
512 |
|
|
|
attachment |
thumbnail |
varchar |
512 |
√ |
|
null |
sys_database_schema |
url |
varchar |
512 |
√ |
|
null |
workflow_node |
user_path |
varchar |
512 |
√ |
|
null |
favourite_search |
within |
varchar |
512 |
√ |
|
null |
qti_assessment_item_ref |
category |
varchar |
1024 |
√ |
|
null |
qti_item_variable |
choice_sequence |
varchar |
1024 |
√ |
|
null |
attachment |
description |
varchar |
1024 |
√ |
|
null |
hierarchy_topic_dynamic_key_re |
dynamic_hierarchy_id |
varchar |
1024 |
√ |
|
null |
kaltura_server |
end_point |
varchar |
1024 |
|
|
|
access_expression |
expression |
varchar |
1024 |
√ |
|
null |
qti_assessment_item |
identifier |
varchar |
1024 |
|
|
|
qti_assessment_test |
identifier |
varchar |
1024 |
|
|
|
store_front |
product |
varchar |
1024 |
|
|
|
oauth_client |
redirect_url |
varchar |
1024 |
|
|
|
qti_assessment_result |
resource_link_id |
varchar |
1024 |
|
|
|
connector |
server_url |
varchar |
1024 |
|
|
|
attachment |
url |
varchar |
1024 |
√ |
|
null |
oauth_token |
username |
varchar |
1024 |
|
|
|
base_entity_attributes |
value |
varchar |
1024 |
√ |
|
null |
hierarchy_topic_attributes |
value |
varchar |
1024 |
√ |
|
null |
term |
value |
varchar |
1024 |
|
|
|
attachment |
value1 |
varchar |
1024 |
√ |
|
null |
attachment |
value2 |
varchar |
1024 |
√ |
|
null |
attachment |
value3 |
varchar |
1024 |
√ |
|
null |
qti_assessment_item_ref |
xml_path |
varchar |
1024 |
|
|
|
qti_assessment_test |
xml_path |
varchar |
1024 |
|
|
|
term |
full_value |
varchar |
4000 |
√ |
|
null |