Untitled :: Corteza Docs

Table 1. compose_attachment
Column	Type	Default	Description
id	bigint(20) unsigned NOT NULL
rel_namespace	bigint(20) unsigned NOT NULL
rel_owner	bigint(20) unsigned NOT NULL
kind	varchar(32) NOT NULL
url	varchar(512)	NULL
preview_url	varchar(512)	NULL
size	int(10) unsigned	NULL
mimetype	varchar(255)	NULL
name	text
meta	json	NULL
created_at	datetime NOT NULL	CURRENT_TIMESTAMP
updated_at	datetime	NULL
deleted_at	datetime	NULL

Table 2. compose_automation_script
Column	Type	Default	Description
id	bigint(20) unsigned NOT NULL
rel_namespace	bigint(20) unsigned NOT NULL
name	varchar(64) NOT NULL	'unnamed'	The name of the script
source	text	NOT NULL	Source code for the script
source_ref	varchar(200) NOT NULL		Where is the script located (if remote)
async	tinyint(1) NOT NULL	'0'	Do we run this script asynchronously?
rel_runner	bigint(20) unsigned NOT NULL	'0'	Who is running the script? 0 for invoker
run_in_ua	tinyint(1) NOT NULL	'0'	Run this script inside user-agent environment
timeout	int(10) unsigned NOT NULL	'0'	Any explicit timeout set for this script (milliseconds)?
critical	tinyint(1) NOT NULL	'1'	Is it critical that this script is executed successfully
enabled	tinyint(1) NOT NULL	'1'	Is this script enabled?
created_by	bigint(20) unsigned NOT NULL	'0'
created_at	datetime NOT NULL	CURRENT_TIMESTAMP
updated_by	bigint(20) unsigned NOT NULL	'0'
updated_at	datetime	NULL
deleted_by	bigint(20) unsigned NOT NULL	'0'
deleted_at	datetime	NULL

Table 3. compose_automation_trigger
Column	Type	Default	Description
id	bigint(20) unsigned NOT NULL
rel_script	bigint(20) unsigned NOT NULL		Script that is triggered
resource	varchar(128) NOT NULL		Resource triggering the event
event	varchar(128) NOT NULL		Event triggered
event_condition	text NOT NULL		Trigger condition
enabled	tinyint(1) NOT NULL	'1'	Trigger enabled?
weight	int(11) NOT NULL	'0'
created_by	bigint(20) unsigned NOT NULL	'0'
created_at	datetime NOT NULL	CURRENT_TIMESTAMP
updated_by	bigint(20) unsigned NOT NULL	'0'
updated_at	datetime	NULL
deleted_by	bigint(20) unsigned NOT NULL	'0'
deleted_at	datetime	NULL

Table 4. compose_chart
Column	Type	Default	Description
id	bigint(20) unsigned NOT NULL
handle	varchar(200) NOT NULL
rel_namespace	bigint(20) unsigned NOT NULL
name	varchar(64) NOT NULL	The name of the chart	config
json NOT NULL	Chart & reporting configuration	created_at	datetime NOT NULL
CURRENT_TIMESTAMP		updated_at	datetime
NULL		deleted_at	datetime

Table 5. compose_module
Column	Type	Default	Description
id	bigint(20) unsigned NOT NULL
handle	varchar(200) NOT NULL
rel_namespace	bigint(20) unsigned NOT NULL
name	varchar(64) NOT NULL	The name of the module	json
json NOT NULL	List of field definitions for the module	created_at	datetime NOT NULL
CURRENT_TIMESTAMP		updated_at	datetime
NULL		deleted_at	datetime

Table 6. compose_module_field
Column	Type	Default	Description
id	bigint(20) unsigned NOT NULL
rel_module	bigint(20) unsigned NOT NULL
place	tinyint(3) unsigned NOT NULL
kind	varchar(64) NOT NULL		The type of the form input field
options	json NOT NULL		Options in JSON format.
default_value	json	NULL	Default value as a record value set.
name	varchar(64) NOT NULL		The name of the field in the form
label	varchar(255) NOT NULL		The label of the form input
is_private	tinyint(1) NOT NULL		Contains personal/sensitive data?
is_required	tinyint(1) NOT NULL
is_visible	tinyint(1) NOT NULL
is_multi	tinyint(1) NOT NULL
created_at	datetime NOT NULL	CURRENT_TIMESTAMP
updated_at	datetime	NULL
deleted_at	datetime	NULL

Table 7. compose_namespace
Column	Type	Default	Description
id	bigint(20) unsigned NOT NULL
name	varchar(64) NOT NULL	Name	slug
varchar(64) NOT NULL	URL slug	enabled	tinyint(1) NOT NULL
Is namespace enabled?	meta	json NOT NULL	Meta data
created_at	datetime NOT NULL	CURRENT_TIMESTAMP
updated_at	datetime	NULL
deleted_at	datetime	NULL

Table 8. compose_page
Column	Type	Default	Description
id	bigint(20) unsigned NOT NULL		Page ID
handle	varchar(200) NOT NULL
rel_namespace	bigint(20) unsigned NOT NULL
self_id	bigint(20) unsigned NOT NULL		Parent Page ID
rel_module	bigint(20) unsigned NOT NULL	'0'
title	varchar(255) NOT NULL		Title (required)
description	text NOT NULL		Description
blocks	json NOT NULL		array of blocks for the page
visible	tinyint(4) NOT NULL		Is page visible in navigation?
weight	int(11) NOT NULL		Order for navigation
created_at	datetime NOT NULL	CURRENT_TIMESTAMP
updated_at	datetime	NULL
deleted_at	datetime	NULL

Table 9. compose_permission_rules
Column	Type	Default	Description
rel_role	bigint(20) unsigned NOT NULL
resource	varchar(128) NOT NULL
operation	varchar(128) NOT NULL
access	tinyint(1) NOT NULL

Table 10. compose_record
Column	Type	Default	Description
id	bigint(20) unsigned NOT NULL
rel_namespace	bigint(20) unsigned NOT NULL
module_id	bigint(20) unsigned NOT NULL
owned_by	bigint(20) unsigned NOT NULL	'0'
created_at	datetime NOT NULL	CURRENT_TIMESTAMP
updated_at	datetime	NULL
deleted_at	datetime	NULL
created_by	bigint(20) unsigned NOT NULL	'0'
updated_by	bigint(20) unsigned NOT NULL	'0'
deleted_by	bigint(20) unsigned NOT NULL	'0'

Table 11. compose_record_value
Column	Type	Default	Description
record_id	bigint(20) NOT NULL
name	varchar(64) NOT NULL
value	longtext
ref	bigint(20) unsigned NOT NULL	'0'	Field is used for quicker lookups when it comes to values that represent a reference, such as recordID, userID and attachmentID.
deleted_at	datetime	NULL
place	int(10) unsigned NOT NULL	'0'

Table 12. compose_settings
Column	Type	Default	Description
rel_owner	bigint(20) unsigned NOT NULL	'0'	Value owner
0 for global settings	name	varchar(200) NOT NULL	Unique set of setting keys
value	json	NULL	Setting value
updated_at	datetime NOT NULL	CURRENT_TIMESTAMP	When was the value updated
updated_by	bigint(20) unsigned NOT NULL	'0'	Who created/updated the value