From KnowledgeTree Document Management Made Simple

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.