From KnowledgeTree Community

Contents 1 DATABASE SCHEMA 1.1 TABLE: active_sessions 1.1.1 Fields 1.1.2 Primary Key 1.1.3 Foreign Keys 1.1.4 Indexes 1.2 TABLE: archive_restoration_request 1.2.1 Fields 1.2.2 Primary Key 1.2.3 Foreign Keys 1.2.4 Indexes 1.3 TABLE: archiving_settings 1.3.1 Fields 1.3.2 Primary Key 1.3.3 Foreign Keys 1.3.4 Indexes 1.4 TABLE: archiving_type_lookup 1.4.1 Fields 1.4.2 Primary Key 1.4.3 Foreign Keys 1.4.4 Indexes 1.5 TABLE: authentication_sources 1.5.1 Fields 1.5.2 Primary Key 1.5.3 Foreign Keys 1.5.4 Indexes 1.6 TABLE: column_entries 1.6.1 Fields 1.6.2 Primary Key 1.6.3 Foreign Keys 1.6.4 Indexes 1.7 TABLE: comment_searchable_text 1.7.1 Fields 1.7.2 Primary Key 1.7.3 Foreign Keys 1.7.4 Indexes 1.8 TABLE: dashlet_disables 1.8.1 Fields 1.8.2 Primary Key 1.8.3 Foreign Keys 1.8.4 Indexes 1.9 TABLE: data_types 1.9.1 Fields 1.9.2 Primary Key 1.9.3 Foreign Keys 1.9.4 Indexes 1.10 TABLE: discussion_comments 1.10.1 Fields 1.10.2 Primary Key 1.10.3 Foreign Keys 1.10.4 Indexes 1.11 TABLE: discussion_threads 1.11.1 Fields 1.11.2 Primary Key 1.11.3 Foreign Keys 1.11.4 Indexes 1.12 TABLE: document_archiving_link 1.12.1 Fields 1.12.2 Primary Key 1.12.3 Foreign Keys 1.12.4 Indexes 1.13 TABLE: document_content_version 1.13.1 Fields 1.13.2 Primary Key 1.13.3 Foreign Keys 1.13.4 Indexes 1.14 TABLE: document_fields 1.14.1 Fields 1.14.2 Primary Key 1.14.3 Foreign Keys 1.14.4 Indexes 1.15 TABLE: document_fields_link 1.15.1 Fields 1.15.2 Primary Key 1.15.3 Foreign Keys 1.15.4 Indexes 1.16 TABLE: document_incomplete 1.16.1 Fields 1.16.2 Primary Key 1.16.3 Foreign Keys 1.16.4 Indexes 1.17 TABLE: document_link 1.17.1 Fields 1.17.2 Primary Key 1.17.3 Foreign Keys 1.17.4 Indexes 1.18 TABLE: document_link_types 1.18.1 Fields 1.18.2 Primary Key 1.18.3 Foreign Keys 1.18.4 Indexes 1.19 TABLE: document_metadata_version 1.19.1 Fields 1.19.2 Primary Key 1.19.3 Foreign Keys 1.19.4 Indexes 1.20 TABLE: document_role_allocations 1.20.1 Fields 1.20.2 Primary Key 1.20.3 Foreign Keys 1.20.4 Indexes 1.21 TABLE: document_searchable_text 1.21.1 Fields 1.21.2 Primary Key 1.21.3 Foreign Keys 1.21.4 Indexes 1.22 TABLE: document_subscriptions 1.22.1 Fields 1.22.2 Primary Key 1.22.3 Foreign Keys 1.22.4 Indexes 1.23 TABLE: document_text 1.23.1 Fields 1.23.2 Primary Key 1.23.3 Foreign Keys 1.23.4 Indexes 1.24 TABLE: document_transaction_text 1.24.1 Fields 1.24.2 Primary Key 1.24.3 Foreign Keys 1.24.4 Indexes 1.25 TABLE: document_transaction_types_lookup 1.25.1 Fields 1.25.2 Primary Key 1.25.3 Foreign Keys 1.25.4 Indexes 1.26 TABLE: document_transactions 1.26.1 Fields 1.26.2 Primary Key 1.26.3 Foreign Keys 1.26.4 Indexes 1.27 TABLE: document_type_fields_link 1.27.1 Fields 1.27.2 Primary Key 1.27.3 Foreign Keys 1.27.4 Indexes 1.28 TABLE: document_type_fieldsets_link 1.28.1 Fields 1.28.2 Primary Key 1.28.3 Foreign Keys 1.28.4 Indexes 1.29 TABLE: document_types_lookup 1.29.1 Fields 1.29.2 Primary Key 1.29.3 Foreign Keys 1.29.4 Indexes 1.30 TABLE: documents 1.30.1 Fields 1.30.2 Primary Key 1.30.3 Foreign Keys 1.30.4 Indexes 1.31 TABLE: field_behaviour_options 1.31.1 Fields 1.31.2 Primary Key 1.31.3 Foreign Keys 1.31.4 Indexes 1.32 TABLE: field_behaviours 1.32.1 Fields 1.32.2 Primary Key 1.32.3 Foreign Keys 1.32.4 Indexes 1.33 TABLE: field_orders 1.33.1 Fields 1.33.2 Primary Key 1.33.3 Foreign Keys 1.33.4 Indexes 1.34 TABLE: field_value_instances 1.34.1 Fields 1.34.2 Primary Key 1.34.3 Foreign Keys 1.34.4 Indexes 1.35 TABLE: fieldsets 1.35.1 Fields 1.35.2 Primary Key 1.35.3 Foreign Keys 1.35.4 Indexes 1.36 TABLE: folder_doctypes_link 1.36.1 Fields 1.36.2 Primary Key 1.36.3 Foreign Keys 1.36.4 Indexes 1.37 TABLE: folder_searchable_text 1.37.1 Fields 1.37.2 Primary Key 1.37.3 Foreign Keys 1.37.4 Indexes 1.38 TABLE: folder_subscriptions 1.38.1 Fields 1.38.2 Primary Key 1.38.3 Foreign Keys 1.38.4 Indexes 1.39 TABLE: folder_transactions 1.39.1 Fields 1.39.2 Primary Key 1.39.3 Foreign Keys 1.39.4 Indexes 1.40 TABLE: folder_workflow_map 1.40.1 Fields 1.40.2 Primary Key 1.40.3 Foreign Keys 1.40.4 Indexes 1.41 TABLE: folders 1.41.1 Fields 1.41.2 Primary Key 1.41.3 Foreign Keys 1.41.4 Indexes 1.42 TABLE: folders_users_roles_link 1.42.1 Fields 1.42.2 Primary Key 1.42.3 Foreign Keys 1.42.4 Indexes 1.43 TABLE: groups_groups_link 1.43.1 Fields 1.43.2 Primary Key 1.43.3 Foreign Keys 1.43.4 Indexes 1.44 TABLE: groups_lookup 1.44.1 Fields 1.44.2 Primary Key 1.44.3 Foreign Keys 1.44.4 Indexes 1.45 TABLE: help 1.45.1 Fields 1.45.2 Primary Key 1.45.3 Foreign Keys 1.45.4 Indexes 1.46 TABLE: help_replacement 1.46.1 Fields 1.46.2 Primary Key 1.46.3 Foreign Keys 1.46.4 Indexes 1.47 TABLE: links 1.47.1 Fields 1.47.2 Primary Key 1.47.3 Foreign Keys 1.47.4 Indexes 1.48 TABLE: metadata_lookup 1.48.1 Fields 1.48.2 Primary Key 1.48.3 Foreign Keys 1.48.4 Indexes 1.49 TABLE: metadata_lookup_tree 1.49.1 Fields 1.49.2 Primary Key 1.49.3 Foreign Keys 1.49.4 Indexes 1.50 TABLE: mime_types 1.50.1 Fields 1.50.2 Primary Key 1.50.3 Foreign Keys 1.50.4 Indexes 1.51 TABLE: news 1.51.1 Fields 1.51.2 Primary Key 1.51.3 Foreign Keys 1.51.4 Indexes 1.52 TABLE: notifications 1.52.1 Fields 1.52.2 Primary Key 1.52.3 Foreign Keys 1.52.4 Indexes 1.53 TABLE: organisations_lookup 1.53.1 Fields 1.53.2 Primary Key 1.53.3 Foreign Keys 1.53.4 Indexes 1.54 TABLE: permission_assignments 1.54.1 Fields 1.54.2 Primary Key 1.54.3 Foreign Keys 1.54.4 Indexes 1.55 TABLE: permission_descriptor_groups 1.55.1 Fields 1.55.2 Primary Key 1.55.3 Foreign Keys 1.55.4 Indexes 1.56 TABLE: permission_descriptor_roles 1.56.1 Fields 1.56.2 Primary Key 1.56.3 Foreign Keys 1.56.4 Indexes 1.57 TABLE: permission_descriptor_users 1.57.1 Fields 1.57.2 Primary Key 1.57.3 Foreign Keys 1.57.4 Indexes 1.58 TABLE: permission_descriptors 1.58.1 Fields 1.58.2 Primary Key 1.58.3 Foreign Keys 1.58.4 Indexes 1.59 TABLE: permission_dynamic_assignments 1.59.1 Fields 1.59.2 Primary Key 1.59.3 Foreign Keys 1.59.4 Indexes 1.60 TABLE: permission_dynamic_conditions 1.60.1 Fields 1.60.2 Primary Key 1.60.3 Foreign Keys 1.60.4 Indexes 1.61 TABLE: permission_lookup_assignments 1.61.1 Fields 1.61.2 Primary Key 1.61.3 Foreign Keys 1.61.4 Indexes 1.62 TABLE: permission_lookups 1.62.1 Fields 1.62.2 Primary Key 1.62.3 Foreign Keys 1.62.4 Indexes 1.63 TABLE: permission_objects 1.63.1 Fields 1.63.2 Primary Key 1.63.3 Foreign Keys 1.63.4 Indexes 1.64 TABLE: permissions 1.64.1 Fields 1.64.2 Primary Key 1.64.3 Foreign Keys 1.64.4 Indexes 1.65 TABLE: plugins 1.65.1 Fields 1.65.2 Primary Key 1.65.3 Foreign Keys 1.65.4 Indexes 1.66 TABLE: role_allocations 1.66.1 Fields 1.66.2 Primary Key 1.66.3 Foreign Keys 1.66.4 Indexes 1.67 TABLE: roles 1.67.1 Fields 1.67.2 Primary Key 1.67.3 Foreign Keys 1.67.4 Indexes 1.68 TABLE: saved_searches 1.68.1 Fields 1.68.2 Primary Key 1.68.3 Foreign Keys 1.68.4 Indexes 1.69 TABLE: search_document_user_link 1.69.1 Fields 1.69.2 Primary Key 1.69.3 Foreign Keys 1.69.4 Indexes 1.70 TABLE: status_lookup 1.70.1 Fields 1.70.2 Primary Key 1.70.3 Foreign Keys 1.70.4 Indexes 1.71 TABLE: system_settings 1.71.1 Fields 1.71.2 Primary Key 1.71.3 Foreign Keys 1.71.4 Indexes 1.72 TABLE: time_period 1.72.1 Fields 1.72.2 Primary Key 1.72.3 Foreign Keys 1.72.4 Indexes 1.73 TABLE: time_unit_lookup 1.73.1 Fields 1.73.2 Primary Key 1.73.3 Foreign Keys 1.73.4 Indexes 1.74 TABLE: trigger_selection 1.74.1 Fields 1.74.2 Primary Key 1.74.3 Foreign Keys 1.74.4 Indexes 1.75 TABLE: type_workflow_map 1.75.1 Fields 1.75.2 Primary Key 1.75.3 Foreign Keys 1.75.4 Indexes 1.76 TABLE: units_lookup 1.76.1 Fields 1.76.2 Primary Key 1.76.3 Foreign Keys 1.76.4 Indexes 1.77 TABLE: units_organisations_link 1.77.1 Fields 1.77.2 Primary Key 1.77.3 Foreign Keys 1.77.4 Indexes 1.78 TABLE: upgrades 1.78.1 Fields 1.78.2 Primary Key 1.78.3 Foreign Keys 1.78.4 Indexes 1.79 TABLE: user_history 1.79.1 Fields 1.79.2 Primary Key 1.79.3 Foreign Keys 1.79.4 Indexes 1.80 TABLE: users 1.80.1 Fields 1.80.2 Primary Key 1.80.3 Foreign Keys 1.80.4 Indexes 1.81 TABLE: users_groups_link 1.81.1 Fields 1.81.2 Primary Key 1.81.3 Foreign Keys 1.81.4 Indexes 1.82 TABLE: workflow_actions 1.82.1 Fields 1.82.2 Primary Key 1.82.3 Foreign Keys 1.82.4 Indexes 1.83 TABLE: workflow_documents 1.83.1 Fields 1.83.2 Primary Key 1.83.3 Foreign Keys 1.83.4 Indexes 1.84 TABLE: workflow_state_actions 1.84.1 Fields 1.84.2 Primary Key 1.84.3 Foreign Keys 1.84.4 Indexes 1.85 TABLE: workflow_state_permission_assignments 1.85.1 Fields 1.85.2 Primary Key 1.85.3 Foreign Keys 1.85.4 Indexes 1.86 TABLE: workflow_state_transitions 1.86.1 Fields 1.86.2 Primary Key 1.86.3 Foreign Keys 1.86.4 Indexes 1.87 TABLE: workflow_states 1.87.1 Fields 1.87.2 Primary Key 1.87.3 Foreign Keys 1.87.4 Indexes 1.88 TABLE: workflow_transitions 1.88.1 Fields 1.88.2 Primary Key 1.88.3 Foreign Keys 1.88.4 Indexes 1.89 TABLE: workflow_trigger_instances 1.89.1 Fields 1.89.2 Primary Key 1.89.3 Foreign Keys 1.89.4 Indexes 1.90 TABLE: workflows 1.90.1 Fields 1.90.2 Primary Key 1.90.3 Foreign Keys 1.90.4 Indexes

DATABASE SCHEMA

This page is auto generated - do not edit this directly - please mail an administrator.

TABLE: active_sessions

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
user_id	int
session_id	char(255)
lastused	datetime
ip	char(30)

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
active_sessions_ibfk_1	user_id	users (id)

Indexes

Index Name	Type	Fields
session_id_idx	key	session_id
active_sessions_ibfk_1	key	user_id

TABLE: archive_restoration_request

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
document_id	int	Yes	'0'
request_user_id	int	Yes	'0'
admin_user_id	int	Yes	'0'
datetime	datetime	Yes	'0000-00-00 00:00:00'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
archive_restoration_request_ibfk_1	document_id	documents (id)
archive_restoration_request_ibfk_2	request_user_id	users (id)
archive_restoration_request_ibfk_3	admin_user_id	users (id)

Indexes

Index Name	Type	Fields
archive_restoration_request_ibfk_1	key	document_id
archive_restoration_request_ibfk_2	key	request_user_id
archive_restoration_request_ibfk_3	key	admin_user_id

TABLE: archiving_settings

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
archiving_type_id	int	Yes	'0'
expiration_date	date
document_transaction_id	int
time_period_id	int

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
archiving_settings_ibfk_1	archiving_type_id	archiving_type_lookup (id)
archiving_settings_ibfk_2	document_transaction_id	document_transactions (id)
archiving_settings_ibfk_3	time_period_id	time_period (id)

Indexes

Index Name	Type	Fields
archiving_settings_ibfk_1	key	archiving_type_id
archiving_settings_ibfk_2	key	document_transaction_id
archiving_settings_ibfk_3	key	time_period_id

TABLE: archiving_type_lookup

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(100)

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: authentication_sources

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	varchar(50)	Yes
namespace	varchar(255)	Yes
authentication_provider	varchar(255)	Yes
config	text	Yes
is_user_source	tinyint	Yes	'0'
is_group_source	tinyint	Yes	'0'

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: column_entries

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
column_namespace	varchar(255)	Yes
view_namespace	varchar(255)	Yes
config_array	text	Yes
position	int	Yes	'0'
required	tinyint	Yes	'0'

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: comment_searchable_text

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
comment_id	int	Yes	'0'
body	text
document_id	int	Yes	'0'

Primary Key

comment_id

Foreign Keys

Field Name	Field	Mapping
comment_searchable_text_ibfk_1	comment_id	discussion_comments (id)
comment_searchable_text_ibfk_2	document_id	documents (id)

Indexes

Index Name	Type	Fields
comment_search_text	fulltext	body
comment_searchable_text_ibfk_1	key	comment_id
comment_searchable_text_ibfk_2	key	document_id

TABLE: dashlet_disables

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
user_id	int	Yes	'0'
dashlet_namespace	varchar(255)	Yes

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
dashlet_disables_ibfk_1	user_id	users (id)

Indexes

Index Name	Type	Fields
user_id	key	user_id
dashlet_namespace	key	dashlet_namespace
dashlet_disables_ibfk_1	key	user_id

TABLE: data_types

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(255)	Yes

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: discussion_comments

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
thread_id	int	Yes	'0'
in_reply_to	int
user_id	int	Yes	'0'
subject	text
body	text
date	datetime

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
discussion_comments_ibfk_1	thread_id	discussion_threads (id)
discussion_comments_ibfk_2	user_id	users (id)

Indexes

Index Name	Type	Fields
discussion_comments_ibfk_1	key	thread_id
discussion_comments_ibfk_2	key	user_id

TABLE: discussion_threads

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
document_id	int	Yes	'0'
first_comment_id	int	Yes	'0'
last_comment_id	int	Yes	'0'
views	int	Yes	'0'
replies	int	Yes	'0'
creator_id	int	Yes	'0'
close_reason	text	Yes
close_metadata_version	int	Yes	'0'
state	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
discussion_threads_ibfk_1	document_id	documents (id)
discussion_threads_ibfk_2	first_comment_id	discussion_comments (id)
discussion_threads_ibfk_3	last_comment_id	discussion_comments (id)
discussion_threads_ibfk_4	creator_id	users (id)

Indexes

Index Name	Type	Fields
discussion_threads_ibfk_1	key	document_id
discussion_threads_ibfk_2	key	first_comment_id
discussion_threads_ibfk_3	key	last_comment_id
discussion_threads_ibfk_4	key	creator_id

TABLE: document_archiving_link

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
document_id	int	Yes	'0'
archiving_settings_id	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
document_archiving_link_ibfk_1	document_id	documents (id)
document_archiving_link_ibfk_2	archiving_settings_id	archiving_settings (id)

Indexes

Index Name	Type	Fields
document_archiving_link_ibfk_1	key	document_id
document_archiving_link_ibfk_2	key	archiving_settings_id

TABLE: document_content_version

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
document_id	int	Yes	'0'
filename	text	Yes
size	bigint	Yes	'0'
mime_id	int	Yes	'0'
major_version	int	Yes	'0'
minor_version	int	Yes	'0'
storage_path	varchar(250)

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
document_content_version_ibfk_1	document_id	documents (id)
document_content_version_ibfk_2	mime_id	mime_types (id)

Indexes

Index Name	Type	Fields
storage_path	key	storage_path
document_id	key	document_id
document_content_version_ibfk_1	key	document_id
document_content_version_ibfk_2	key	mime_id

TABLE: document_fields

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	varchar(255)	Yes
data_type	varchar(100)	Yes
is_generic	tinyint
has_lookup	tinyint
has_lookuptree	tinyint
parent_fieldset	int
is_mandatory	tinyint	Yes	'0'
description	text	Yes

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
document_fields_ibfk_1	parent_fieldset	fieldsets (id)

Indexes

Index Name	Type	Fields
parent_fieldset	key	parent_fieldset

TABLE: document_fields_link

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
document_field_id	int	Yes	'0'
value	char(255)	Yes
metadata_version_id	int

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
document_fields_link_ibfk_2	document_field_id	document_fields (id)
document_fields_link_ibfk_1	metadata_version_id	document_metadata_version (id)

Indexes

Index Name	Type	Fields
document_field_id	key	document_field_id
metadata_version_id	key	metadata_version_id
document_fields_link_ibfk_1	key	metadata_version_id

TABLE: document_incomplete

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int UNSIGNED	Yes	'0'
contents	tinyint UNSIGNED	Yes	'0'
metadata	tinyint UNSIGNED	Yes	'0'

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: document_link

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
parent_document_id	int	Yes	'0'
child_document_id	int	Yes	'0'
link_type_id	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
document_link_ibfk_1	parent_document_id	documents (id)
document_link_ibfk_2	child_document_id	documents (id)
document_link_ibfk_3	link_type_id	document_link_types (id)

Indexes

Index Name	Type	Fields
document_link_ibfk_1	key	parent_document_id
document_link_ibfk_2	key	child_document_id
document_link_ibfk_3	key	link_type_id

TABLE: document_link_types

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(100)	Yes
reverse_name	char(100)	Yes
description	char(255)	Yes

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: document_metadata_version

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
document_id	int	Yes	'0'
content_version_id	int	Yes	'0'
document_type_id	int	Yes	'0'
name	text	Yes
description	varchar(200)	Yes
status_id	int
metadata_version	int	Yes	'0'
version_created	datetime	Yes	'0000-00-00 00:00:00'
version_creator_id	int	Yes	'0'
workflow_id	int
workflow_state_id	int

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
document_metadata_version_ibfk_4	document_id	documents (id)
document_metadata_version_ibfk_5	document_type_id	document_types_lookup (id)
document_metadata_version_ibfk_6	status_id	status_lookup (id)
document_metadata_version_ibfk_7	version_creator_id	users (id)
document_metadata_version_ibfk_8	workflow_id	workflows (id)
document_metadata_version_ibfk_9	workflow_state_id	workflow_states (id)
document_metadata_version_ibfk_1	content_version_id	document_content_version (id)

Indexes

Index Name	Type	Fields
fk_document_type_id	key	document_type_id
fk_status_id	key	status_id
document_id	key	document_id
version_created	key	version_created
version_creator_id	key	version_creator_id
content_version_id	key	content_version_id
workflow_id	key	workflow_id
workflow_state_id	key	workflow_state_id
document_metadata_version_ibfk_1	key	content_version_id

TABLE: document_role_allocations

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
document_id	int	Yes	'0'
role_id	int	Yes	'0'
permission_descriptor_id	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
document_role_allocations_ibfk_1	document_id	documents (id)
document_role_allocations_ibfk_2	role_id	roles (id)
document_role_allocations_ibfk_3	permission_descriptor_id	permission_descriptors (id)

Indexes

Index Name	Type	Fields
document_id	key	document_id
document_role_allocations_ibfk_1	key	document_id
document_role_allocations_ibfk_2	key	role_id
document_role_allocations_ibfk_3	key	permission_descriptor_id

TABLE: document_searchable_text

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
document_id	int
document_text	text

Primary Key

Nothing specified.

Foreign Keys

Field Name	Field	Mapping
document_searchable_text_ibfk_1	document_id	documents (id)

Indexes

Index Name	Type	Fields
document_text_document_id_indx	key	document_id
document_text	fulltext	document_text
document_searchable_text_ibfk_1	key	document_id

TABLE: document_subscriptions

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
user_id	int	Yes	'0'
document_id	int	Yes	'0'
is_alerted	tinyint

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
document_subscriptions_ibfk_1	user_id	users (id)
document_subscriptions_ibfk_2	document_id	documents (id)

Indexes

Index Name	Type	Fields
document_subscriptions_ibfk_1	key	user_id
document_subscriptions_ibfk_2	key	document_id

TABLE: document_text

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
document_id	int
document_text	text

Primary Key

Nothing specified.

Foreign Keys

Field Name	Field	Mapping
document_text_ibfk_1	document_id	documents (id)

Indexes

Index Name	Type	Fields
document_text_document_id_indx	key	document_id
document_text	fulltext	document_text
document_text_ibfk_1	key	document_id

TABLE: document_transaction_text

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
document_id	int
document_text	text

Primary Key

Nothing specified.

Foreign Keys

Field Name	Field	Mapping
document_transaction_text_ibfk_1	document_id	documents (id)

Indexes

Index Name	Type	Fields
document_text_document_id_indx	key	document_id
document_text	fulltext	document_text
document_transaction_text_ibfk_1	key	document_id

TABLE: document_transaction_types_lookup

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	varchar(100)	Yes
namespace	varchar(250)	Yes

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: document_transactions

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
document_id	int	Yes	'0'
version	char(50)
user_id	int	Yes	'0'
datetime	datetime	Yes	'0000-00-00 00:00:00'
ip	char(30)
filename	char(255)	Yes
comment	char(255)	Yes
transaction_namespace	char(255)	Yes	'ktcore.transactions.event'
session_id	int
admin_mode	tinyint	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
document_transactions_ibfk_1	document_id	documents (id)
document_transactions_ibfk_2	user_id	users (id)

Indexes

Index Name	Type	Fields
fk_document_id	key	document_id
fk_user_id	key	user_id
session_id	key	session_id
document_transactions_ibfk_1	key	document_id
document_transactions_ibfk_2	key	user_id

TABLE: document_type_fields_link

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
document_type_id	int	Yes	'0'
field_id	int	Yes	'0'
is_mandatory	tinyint	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
document_type_fields_link_ibfk_1	document_type_id	document_types_lookup (id)
document_type_fields_link_ibfk_2	field_id	document_fields (id)

Indexes

Index Name	Type	Fields
document_type_fields_link_ibfk_1	key	document_type_id
document_type_fields_link_ibfk_2	key	field_id

TABLE: document_type_fieldsets_link

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
document_type_id	int	Yes	'0'
fieldset_id	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
document_type_fieldsets_link_ibfk_1	document_type_id	document_types_lookup (id)
document_type_fieldsets_link_ibfk_2	fieldset_id	fieldsets (id)

Indexes

Index Name	Type	Fields
document_type_id	key	document_type_id
fieldset_id	key	fieldset_id

TABLE: document_types_lookup

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(100)
disabled	tinyint	Yes	'0'

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: documents

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
creator_id	int	Yes	'0'
modified	datetime	Yes	'0000-00-00 00:00:00'
folder_id	int
is_checked_out	tinyint	Yes	'0'
parent_folder_ids	text
full_path	text
checked_out_user_id	int
status_id	int
created	datetime	Yes	'0000-00-00 00:00:00'
permission_object_id	int
permission_lookup_id	int
metadata_version	int	Yes	'0'
modified_user_id	int	Yes	'0'
metadata_version_id	int
owner_id	int	Yes	'0'
immutable	tinyint	Yes	'0'
restore_folder_id	int
restore_folder_path	text

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
documents_ibfk_1	creator_id	users (id)
documents_ibfk_2	folder_id	folders (id)
documents_ibfk_3	checked_out_user_id	users (id)
documents_ibfk_4	status_id	status_lookup (id)
documents_ibfk_5	permission_object_id	permission_objects (id)
documents_ibfk_6	permission_lookup_id	permission_lookups (id)
documents_ibfk_7	modified_user_id	users (id)
documents_ibfk_8	metadata_version_id	document_metadata_version (id)
documents_ibfk_9	owner_id	users (id)

Indexes

Index Name	Type	Fields
fk_creator_id	key	creator_id
fk_folder_id	key	folder_id
fk_checked_out_user_id	key	checked_out_user_id
fk_status_id	key	status_id
created	key	created
permission_object_id	key	permission_object_id
permission_lookup_id	key	permission_lookup_id
modified_user_id	key	modified_user_id
metadata_version_id	key	metadata_version_id
documents_ibfk_1	key	creator_id
documents_ibfk_2	key	folder_id
documents_ibfk_3	key	checked_out_user_id
documents_ibfk_4	key	status_id
documents_ibfk_5	key	permission_object_id
documents_ibfk_6	key	permission_lookup_id
documents_ibfk_7	key	modified_user_id
documents_ibfk_8	key	metadata_version_id
documents_ibfk_9	key	owner_id

TABLE: field_behaviour_options

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
behaviour_id	int	Yes	'0'
field_id	int	Yes	'0'
instance_id	int	Yes	'0'

Primary Key

Nothing specified.

Foreign Keys

Field Name	Field	Mapping
field_behaviour_options_ibfk_1	behaviour_id	field_behaviours (id)
field_behaviour_options_ibfk_2	field_id	document_fields (id)
field_behaviour_options_ibfk_3	instance_id	field_value_instances (id)
field_behaviour_options_ibfk_4	instance_id	mime_types (id)

Indexes

Index Name	Type	Fields
behaviour_id	key	behaviour_id
field_id	key	field_id
instance_id	key	instance_id
field_behaviour_options_ibfk_4	key	instance_id

TABLE: field_behaviours

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(255)	Yes
human_name	char(100)	Yes
field_id	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
field_behaviours_ibfk_1	field_id	document_fields (id)

Indexes

Index Name	Type	Fields
field_id	key	field_id
name	key	name

TABLE: field_orders

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
parent_field_id	int	Yes	'0'
child_field_id	int	Yes	'0'
fieldset_id	int	Yes	'0'

Primary Key

child_field_id

Foreign Keys

Field Name	Field	Mapping
field_orders_ibfk_1	parent_field_id	document_fields (id)
field_orders_ibfk_2	child_field_id	document_fields (id)
field_orders_ibfk_3	fieldset_id	fieldsets (id)

Indexes

Index Name	Type	Fields
parent_field	key	parent_field_id
fieldset_id	key	fieldset_id

TABLE: field_value_instances

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
field_id	int	Yes	'0'
field_value_id	int	Yes	'0'
behaviour_id	int		'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
field_value_instances_ibfk_1	field_id	document_fields (id)
field_value_instances_ibfk_2	field_value_id	metadata_lookup (id)
field_value_instances_ibfk_3	behaviour_id	field_behaviours (id)
field_value_instances_ibfk_4	field_value_id	metadata_lookup_tree (id)

Indexes

Index Name	Type	Fields
field_id	key	field_id
field_value_id	key	field_value_id
behaviour_id	key	behaviour_id
field_value_instances_ibfk_4	key	field_value_id

TABLE: fieldsets

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	varchar(255)	Yes
namespace	varchar(255)	Yes
mandatory	tinyint	Yes	'0'
is_conditional	tinyint	Yes	'0'
master_field	int
is_generic	tinyint	Yes	'0'
is_complex	tinyint	Yes	'0'
is_complete	tinyint	Yes	'1'
is_system	tinyint UNSIGNED	Yes	'0'
description	text	Yes

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
fieldsets_ibfk_1	master_field	document_fields (id)

Indexes

Index Name	Type	Fields
is_generic	key	is_generic
is_complete	key	is_complete
is_system	key	is_system
master_field	key	master_field

TABLE: folder_doctypes_link

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
folder_id	int	Yes	'0'
document_type_id	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
folder_doctypes_link_ibfk_1	folder_id	folders (id)
folder_doctypes_link_ibfk_2	document_type_id	document_types_lookup (id)

Indexes

Index Name	Type	Fields
fk_folder_id	key	folder_id
fk_document_type_id	key	document_type_id
folder_doctypes_link_ibfk_1	key	folder_id
folder_doctypes_link_ibfk_2	key	document_type_id

TABLE: folder_searchable_text

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
folder_id	int	Yes	'0'
folder_text	text

Primary Key

folder_id

Foreign Keys

Field Name	Field	Mapping
folder_searchable_text_ibfk_1	folder_id	folders (id)

Indexes

Index Name	Type	Fields
folder_searchable_text_folder_indx	key	folder_id
folder_text	fulltext	folder_text
folder_searchable_text_ibfk_1	key	folder_id

TABLE: folder_subscriptions

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
user_id	int	Yes	'0'
folder_id	int	Yes	'0'
is_alerted	tinyint

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
folder_subscriptions_ibfk_1	user_id	users (id)
folder_subscriptions_ibfk_2	folder_id	folders (id)

Indexes

Index Name	Type	Fields
folder_subscriptions_ibfk_1	key	user_id
folder_subscriptions_ibfk_2	key	folder_id

TABLE: folder_transactions

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
folder_id	int	Yes	'0'
user_id	int	Yes	'0'
datetime	datetime	Yes	'0000-00-00 00:00:00'
ip	char(30)
comment	char(255)	Yes
transaction_namespace	char(255)	Yes	'ktcore.transactions.event'
session_id	int
admin_mode	tinyint	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
folder_transactions_ibfk_1	folder_id	folders (id)
folder_transactions_ibfk_2	user_id	users (id)

Indexes

Index Name	Type	Fields
folder_id	key	folder_id
user_id	key	user_id
session_id	key	session_id

TABLE: folder_workflow_map

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
folder_id	int	Yes	'0'
workflow_id	int

Primary Key

folder_id

Foreign Keys

Field Name	Field	Mapping
folder_workflow_map_ibfk_1	folder_id	folders (id)
folder_workflow_map_ibfk_2	workflow_id	workflows (id)

Indexes

Index Name	Type	Fields
folder_id	unique	folder_id
folder_workflow_map_ibfk_1	key	folder_id
folder_workflow_map_ibfk_2	key	workflow_id

TABLE: folders

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	varchar(255)
description	varchar(255)
parent_id	int
creator_id	int
is_public	tinyint	Yes	'0'
parent_folder_ids	text
full_path	text
permission_object_id	int
permission_lookup_id	int
restrict_document_types	tinyint	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
folders_ibfk_1	parent_id	folders (id)
folders_ibfk_2	creator_id	users (id)
folders_ibfk_3	permission_object_id	permission_objects (id)
folders_ibfk_4	permission_lookup_id	permission_lookups (id)

Indexes

Index Name	Type	Fields
fk_parent_id	key	parent_id
fk_creator_id	key	creator_id
permission_object_id	key	permission_object_id
permission_lookup_id	key	permission_lookup_id
folders_ibfk_1	key	parent_id
folders_ibfk_2	key	creator_id
folders_ibfk_3	key	permission_object_id
folders_ibfk_4	key	permission_lookup_id

TABLE: folders_users_roles_link

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
group_folder_approval_id	int	Yes	'0'
user_id	int	Yes	'0'
document_id	int	Yes	'0'
datetime	datetime
done	tinyint
active	tinyint
dependant_documents_created	tinyint

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
folders_users_roles_link_ibfk_1	group_folder_approval_id	mime_types (id)
folders_users_roles_link_ibfk_2	user_id	users (id)
folders_users_roles_link_ibfk_3	document_id	documents (id)

Indexes

Index Name	Type	Fields
folders_users_roles_link_ibfk_1	key	group_folder_approval_id
folders_users_roles_link_ibfk_2	key	user_id
folders_users_roles_link_ibfk_3	key	document_id

TABLE: groups_groups_link

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
parent_group_id	int	Yes	'0'
member_group_id	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
groups_groups_link_ibfk_1	parent_group_id	groups_lookup (id)
groups_groups_link_ibfk_2	member_group_id	groups_lookup (id)

Indexes

Index Name	Type	Fields
groups_groups_link_ibfk_1	key	parent_group_id
groups_groups_link_ibfk_2	key	member_group_id

TABLE: groups_lookup

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	varchar(100)	Yes
is_sys_admin	tinyint	Yes	'0'
is_unit_admin	tinyint	Yes	'0'
unit_id	int
authentication_details_s2	varchar(255)
authentication_details_s1	varchar(255)
authentication_source_id	int

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
groups_lookup_ibfk_1	unit_id	units_lookup (id)
groups_lookup_ibfk_2	authentication_source_id	authentication_sources (id)

Indexes

Index Name	Type	Fields
name	unique	name
unit_id	key	unit_id
authentication_details_s1	key	authentication_details_s1
authentication_source_id	key	authentication_source_id
groups_lookup_ibfk_2	key	authentication_source_id

TABLE: help

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
fsection	varchar(100)	Yes
help_info	text	Yes

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: help_replacement

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	varchar(255)	Yes
description	text	Yes
title	varchar(255)	Yes

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: links

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(100)	Yes
url	char(100)	Yes
rank	int	Yes	'0'

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: metadata_lookup

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
document_field_id	int	Yes	'0'
name	char(255)
treeorg_parent	int
disabled	tinyint UNSIGNED	Yes	'0'
is_stuck	tinyint	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
metadata_lookup_ibfk_1	document_field_id	document_fields (id)

Indexes

Index Name	Type	Fields
disabled	key	disabled
is_stuck	key	is_stuck
metadata_lookup_ibfk_1	key	document_field_id

TABLE: metadata_lookup_tree

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
document_field_id	int	Yes	'0'
name	char(255)
metadata_lookup_tree_parent	int

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
metadata_lookup_tree_ibfk_1	document_field_id	document_fields (id)

Indexes

Index Name	Type	Fields
metadata_lookup_tree_parent	key	metadata_lookup_tree_parent
document_field_id	key	document_field_id
metadata_lookup_tree_ibfk_1	key	document_field_id

TABLE: mime_types

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
filetypes	char(100)	Yes
mimetypes	char(100)	Yes
icon_path	char(255)
friendly_name	char(255)

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: news

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
synopsis	varchar(255)	Yes
body	text
rank	int
image	text
image_size	int
image_mime_type_id	int
active	tinyint

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
news_ibfk_1	image_mime_type_id	mime_types (id)

Indexes

Index Name	Type	Fields
news_ibfk_1	key	image_mime_type_id

TABLE: notifications

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
user_id	int	Yes	'0'
label	varchar(255)	Yes
type	varchar(255)	Yes
creation_date	datetime	Yes	'0000-00-00 00:00:00'
data_int_1	int
data_int_2	int
data_str_1	varchar(255)
data_str_2	varchar(255)
data_text_1	text

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
notifications_ibfk_1	user_id	users (id)

Indexes

Index Name	Type	Fields
type	key	type
user_id	key	user_id
notifications_ibfk_1	key	user_id

TABLE: organisations_lookup

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(100)	Yes

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: permission_assignments

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
permission_id	int	Yes	'0'
permission_object_id	int	Yes	'0'
permission_descriptor_id	int

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
permission_assignments_ibfk_1	permission_id	permissions (id)
permission_assignments_ibfk_2	permission_object_id	permission_objects (id)
permission_assignments_ibfk_3	permission_descriptor_id	permission_descriptors (id)

Indexes

Index Name	Type	Fields
permission_id	key	permission_id
permission_object_id	key	permission_object_id
permission_descriptor_id	key	permission_descriptor_id

TABLE: permission_descriptor_groups

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
descriptor_id	int	Yes	'0'
group_id	int	Yes	'0'

Primary Key

Nothing specified.

Foreign Keys

Field Name	Field	Mapping
permission_descriptor_groups_ibfk_1	descriptor_id	permission_descriptors (id)
permission_descriptor_groups_ibfk_2	group_id	groups_lookup (id)

Indexes

Index Name	Type	Fields
descriptor_id_2	key	descriptor_id
group_id	key	group_id

TABLE: permission_descriptor_roles

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
descriptor_id	int	Yes	'0'
role_id	int	Yes	'0'

Primary Key

Nothing specified.

Foreign Keys

Field Name	Field	Mapping
permission_descriptor_roles_ibfk_1	descriptor_id	permission_descriptors (id)
permission_descriptor_roles_ibfk_2	role_id	roles (id)

Indexes

Index Name	Type	Fields
descriptor_id_2	key	descriptor_id
role_id	key	role_id

TABLE: permission_descriptor_users

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
descriptor_id	int	Yes	'0'
user_id	int	Yes	'0'

Primary Key

Nothing specified.

Foreign Keys

Field Name	Field	Mapping
permission_descriptor_users_ibfk_1	descriptor_id	permission_descriptors (id)
permission_descriptor_users_ibfk_2	user_id	users (id)

Indexes

Index Name	Type	Fields
descriptor_id_2	key	descriptor_id
user_id	key	user_id

TABLE: permission_descriptors

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
descriptor	varchar(32)	Yes
descriptor_text	text	Yes

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: permission_dynamic_assignments

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
dynamic_condition_id	int	Yes	'0'
permission_id	int	Yes	'0'

Primary Key

Nothing specified.

Foreign Keys

Field Name	Field	Mapping
permission_dynamic_assignments_ibfk_2	dynamic_condition_id	permission_dynamic_conditions (id)
permission_dynamic_assignments_ibfk_3	permission_id	permissions (id)
permission_dynamic_assignments_ibfk_1	dynamic_condition_id	saved_searches (id)

Indexes

Index Name	Type	Fields
dynamic_conditiond_id	key	dynamic_condition_id
permission_id	key	permission_id
permission_dynamic_assignments_ibfk_1	key	dynamic_condition_id

TABLE: permission_dynamic_conditions

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
permission_object_id	int	Yes	'0'
group_id	int	Yes	'0'
condition_id	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
permission_dynamic_conditions_ibfk_1	permission_object_id	permission_objects (id)
permission_dynamic_conditions_ibfk_2	group_id	groups_lookup (id)
permission_dynamic_conditions_ibfk_3	condition_id	saved_searches (id)

Indexes

Index Name	Type	Fields
permission_object_id	key	permission_object_id
group_id	key	group_id
condition_id	key	condition_id

TABLE: permission_lookup_assignments

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
permission_id	int	Yes	'0'
permission_lookup_id	int	Yes	'0'
permission_descriptor_id	int

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
permission_lookup_assignments_ibfk_1	permission_id	permissions (id)
permission_lookup_assignments_ibfk_2	permission_lookup_id	permission_lookups (id)
permission_lookup_assignments_ibfk_3	permission_descriptor_id	permission_descriptors (id)

Indexes

Index Name	Type	Fields
permission_id	key	permission_id
permission_lookup_id	key	permission_lookup_id
permission_descriptor_id	key	permission_descriptor_id

TABLE: permission_lookups

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: permission_objects

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: permissions

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(100)	Yes
human_name	char(100)	Yes
built_in	tinyint	Yes	'0'

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: plugins

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
namespace	varchar(255)	Yes
path	varchar(255)	Yes
version	int	Yes	'0'
disabled	tinyint	Yes	'0'
data	text
unavailable	tinyint	Yes	'0'
friendly_name	varchar(255)

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: role_allocations

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
folder_id	int	Yes	'0'
role_id	int	Yes	'0'
permission_descriptor_id	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
role_allocations_ibfk_1	folder_id	folders (id)
role_allocations_ibfk_2	role_id	roles (id)
role_allocations_ibfk_3	permission_descriptor_id	permission_descriptors (id)

Indexes

Index Name	Type	Fields
folder_id	key	folder_id
role_allocations_ibfk_1	key	folder_id
role_allocations_ibfk_2	key	role_id
role_allocations_ibfk_3	key	permission_descriptor_id

TABLE: roles

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(255)	Yes

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: saved_searches

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	varchar(50)	Yes
namespace	varchar(250)	Yes
is_condition	tinyint	Yes	'0'
is_complete	tinyint	Yes	'0'
user_id	int
search	text	Yes

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
saved_searches_ibfk_1	user_id	users (id)

Indexes

Index Name	Type	Fields
namespace	key	namespace
is_condition	key	is_condition
is_complete	key	is_complete
user_id	key	user_id

TABLE: search_document_user_link

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
document_id	int
user_id	int

Primary Key

Nothing specified.

Foreign Keys

Field Name	Field	Mapping
search_document_user_link_ibfk_1	document_id	documents (id)
search_document_user_link_ibfk_2	user_id	users (id)

Indexes

Index Name	Type	Fields
fk_user_id	key	user_id
fk_document_ids	key	document_id
search_document_user_link_ibfk_1	key	document_id
search_document_user_link_ibfk_2	key	user_id

TABLE: status_lookup

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(255)

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: system_settings

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(255)	Yes
value	char(255)	Yes

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: time_period

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
time_unit_id	int
units	int

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
time_period_ibfk_1	time_unit_id	time_unit_lookup (id)

Indexes

Index Name	Type	Fields
time_period_ibfk_1	key	time_unit_id

TABLE: time_unit_lookup

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(100)

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: trigger_selection

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
event_ns	varchar(255)	Yes
selection_ns	varchar(255)	Yes

Primary Key

event_ns

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: type_workflow_map

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
document_type_id	int	Yes	'0'
workflow_id	int UNSIGNED

Primary Key

document_type_id

Foreign Keys

Field Name	Field	Mapping
type_workflow_map_ibfk_1	document_type_id	document_types_lookup (id)
type_workflow_map_ibfk_2	workflow_id	workflows (id)

Indexes

Index Name	Type	Fields
document_type_id	unique	document_type_id
type_workflow_map_ibfk_1	key	document_type_id
type_workflow_map_ibfk_2	key	workflow_id

TABLE: units_lookup

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(100)	Yes
folder_id	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
units_lookup_ibfk_1	folder_id	folders (id)

Indexes

Index Name	Type	Fields
name	unique	name
folder_id	unique	folder_id
units_lookup_ibfk_1	key	folder_id

TABLE: units_organisations_link

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
unit_id	int	Yes	'0'
organisation_id	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
units_organisations_link_ibfk_1	unit_id	units_lookup (id)
units_organisations_link_ibfk_2	organisation_id	organisations_lookup (id)

Indexes

Index Name	Type	Fields
fk_unit_id	key	unit_id
fk_organisation_id	key	organisation_id
units_organisations_link_ibfk_1	key	unit_id
units_organisations_link_ibfk_2	key	organisation_id

TABLE: upgrades

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int UNSIGNED	Yes	'0'
descriptor	char(100)	Yes
description	char(255)	Yes
date_performed	datetime	Yes	'0000-00-00 00:00:00'
result	tinyint	Yes	'0'
parent	char(40)

Primary Key

id

Foreign Keys

None are defined.

Indexes

None are defined.

TABLE: user_history

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes
datetime	datetime	Yes
user_id	int	Yes
action_namespace	varchar(255)	Yes
comments	text
session_id	int

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
user_history_ibfk_1	user_id	users (id)

Indexes

Index Name	Type	Fields
user_id	key	user_id
action_namespace	key	action_namespace
datetime	key	datetime
session_id	key	session_id

TABLE: users

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
username	varchar(255)	Yes
name	varchar(255)	Yes
password	varchar(255)	Yes
quota_max	int	Yes	'0'
quota_current	int	Yes	'0'
email	varchar(255)
mobile	varchar(255)
email_notification	tinyint	Yes	'0'
sms_notification	tinyint	Yes	'0'
authentication_details_s1	varchar(255)
max_sessions	int
language_id	int
authentication_details_s2	varchar(255)
authentication_source_id	int
authentication_details_b1	tinyint
authentication_details_i2	int
authentication_details_d1	datetime
authentication_details_i1	int
authentication_details_d2	datetime
authentication_details_b2	tinyint
last_login	datetime

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
users_ibfk_1	authentication_source_id	authentication_sources (id)

Indexes

Index Name	Type	Fields
username	unique	username
authentication_source	key	authentication_source_id
authentication_details_b1	key	authentication_details_b1
authentication_details_b2	key	authentication_details_b2
last_login	key	last_login

TABLE: users_groups_link

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
user_id	int	Yes	'0'
group_id	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
users_groups_link_ibfk_1	user_id	users (id)
users_groups_link_ibfk_2	group_id	groups_lookup (id)

Indexes

Index Name	Type	Fields
fk_user_id	key	user_id
fk_group_id	key	group_id
users_groups_link_ibfk_1	key	user_id
users_groups_link_ibfk_2	key	group_id

TABLE: workflow_actions

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
workflow_id	int	Yes	'0'
action_name	char(255)	Yes

Primary Key

Nothing specified.

Foreign Keys

Field Name	Field	Mapping
workflow_actions_ibfk_1	workflow_id	workflows (id)

Indexes

Index Name	Type	Fields
workflow_id	key	workflow_id
action_name	key	action_name
workflow_actions_ibfk_1	key	workflow_id

TABLE: workflow_documents

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
document_id	int	Yes	'0'
workflow_id	int	Yes	'0'
state_id	int	Yes	'0'

Primary Key

document_id

Foreign Keys

Field Name	Field	Mapping
workflow_documents_ibfk_1	document_id	documents (id)
workflow_documents_ibfk_2	workflow_id	workflows (id)
workflow_documents_ibfk_3	state_id	workflow_states (id)

Indexes

Index Name	Type	Fields
workflow_id	key	workflow_id
state_id	key	state_id
workflow_documents_ibfk_1	key	document_id
workflow_documents_ibfk_2	key	workflow_id
workflow_documents_ibfk_3	key	state_id

TABLE: workflow_state_actions

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
state_id	int	Yes	'0'
action_name	char(255)	Yes	'0'

Primary Key

Nothing specified.

Foreign Keys

Field Name	Field	Mapping
workflow_state_actions_ibfk_1	state_id	workflow_states (id)

Indexes

Index Name	Type	Fields
state_id	key	state_id
action_name	key	action_name
workflow_state_actions_ibfk_1	key	state_id

TABLE: workflow_state_permission_assignments

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
workflow_state_id	int	Yes	'0'
permission_id	int	Yes	'0'
permission_descriptor_id	int	Yes	'0'

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
workflow_state_permission_assignments_ibfk_7	permission_id	permissions (id)
workflow_state_permission_assignments_ibfk_8	permission_descriptor_id	permission_descriptors (id)
workflow_state_permission_assignments_ibfk_1	workflow_state_id	workflow_states (id)

Indexes

Index Name	Type	Fields
permission_id	key	permission_id
permission_descriptor_id	key	permission_descriptor_id
workflow_state_id	key	workflow_state_id
workflow_state_permission_assignments_ibfk_1	key	workflow_state_id

TABLE: workflow_state_transitions

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
state_id	int	Yes	'0'
transition_id	int	Yes	'0'

Primary Key

Nothing specified.

Foreign Keys

Field Name	Field	Mapping
workflow_state_transitions_ibfk_1	state_id	workflow_states (id)
workflow_state_transitions_ibfk_2	transition_id	workflow_transitions (id)

Indexes

Index Name	Type	Fields
workflow_state_transitions_ibfk_1	key	state_id
workflow_state_transitions_ibfk_2	key	transition_id

TABLE: workflow_states

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
workflow_id	int	Yes	'0'
name	char(255)	Yes
human_name	char(100)	Yes
inform_descriptor_id	int

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
workflow_states_ibfk_1	workflow_id	workflows (id)
workflow_states_ibfk_2	inform_descriptor_id	permission_descriptors (id)

Indexes

Index Name	Type	Fields
workflow_id	key	workflow_id
name	key	name
inform_descriptor_id	key	inform_descriptor_id

TABLE: workflow_transitions

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
workflow_id	int	Yes	'0'
name	char(255)	Yes
human_name	char(100)	Yes
target_state_id	int	Yes	'0'
guard_permission_id	int		'0'
guard_group_id	int		'0'
guard_role_id	int		'0'
guard_condition_id	int

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
workflow_transitions_ibfk_45	workflow_id	workflows (id)
workflow_transitions_ibfk_46	target_state_id	workflow_states (id)
workflow_transitions_ibfk_47	guard_permission_id	permissions (id)
workflow_transitions_ibfk_48	guard_group_id	groups_lookup (id)
workflow_transitions_ibfk_49	guard_role_id	roles (id)
workflow_transitions_ibfk_50	guard_condition_id	saved_searches (id)

Indexes

Index Name	Type	Fields
workflow_id	key	workflow_id
name	key	name
target_state_id	key	target_state_id
guard_permission_id	key	guard_permission_id
guard_condition	key	guard_condition_id
guard_group_id	key	guard_group_id
guard_role_id	key	guard_role_id

TABLE: workflow_trigger_instances

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int UNSIGNED	Yes	'0'
workflow_transition_id	int	Yes	'0'
namespace	char(255)	Yes
config_array	text

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
workflow_trigger_instances_ibfk_1	workflow_transition_id	workflow_transitions (id)

Indexes

Index Name	Type	Fields
workflow_transition_id	key	workflow_transition_id
namespace	key	namespace
workflow_trigger_instances_ibfk_1	key	workflow_transition_id

TABLE: workflows

No comment.

Fields

Fieldname	Type	Not Null	Default	Comment
id	int	Yes	'0'
name	char(250)	Yes
human_name	char(100)	Yes
start_state_id	int

Primary Key

id

Foreign Keys

Field Name	Field	Mapping
workflows_ibfk_1	start_state_id	workflow_states (id)

Indexes

Index Name	Type	Fields
name	unique	name
start_state_id	key	start_state_id