Database Schema CloudManager

table_name	column_name	data_type	is_nullable	column_default
appCategories	id	integer	NO
appCategories	name	text	YES
appCategories	description	text	YES
appCategories	type	text	YES
appCategories	industry_id	integer	YES
appCategories	created_at	timestamp with time zone	NO	now()
appIndustries	id	integer	NO
appIndustries	name	text	YES
appIndustries	type	text	YES
appIndustries	description	text	YES
appIndustries	created_at	timestamp with time zone	NO	now()
appSubscriptions	id	bigint	NO
appSubscriptions	type	text	YES
appSubscriptions	description	text	YES
appSubscriptions	termType	text	YES
appSubscriptions	termLength	numeric	YES
appSubscriptions	created_at	timestamp with time zone	NO	now()
bxEntityTypes	id	integer	NO
bxEntityTypes	EntityType	text	YES
bxEntityTypes	EntityFieldType	text	YES
bxEntityTypes	EntityTypeName	text	YES
bxEntityTypes	EntityTypeId	integer	YES
bxEntityTypes	ShortCode	text	YES
bxEntityTypes	created_at	timestamp with time zone	NO	now()
bxFieldTypes	id	bigint	NO
bxFieldTypes	TypeId	text	YES
bxFieldTypes	TypeTitle	text	YES
bxFieldTypes	created_at	timestamp with time zone	NO	now()
bxUserFieldFields	NAME	text	YES
bxUserFieldFields	type	text	YES
bxUserFieldFields	title	text	YES
bxUserFieldFields	isReadOnly	text	YES
bxUserFieldFields	id	integer	NO
docLibrary	id	bigint	NO
docLibrary	name	text	YES
docLibrary	description	text	YES
docLibrary	industry	text	YES
docLibrary	category	text	YES
docLibrary	subscription_type	text	YES
docLibrary	price	numeric	YES
docLibrary	updated_at	timestamp with time zone	YES	now()
docLibrary	created_at	timestamp with time zone	NO	now()
docLibrary	uf_data	ARRAY	YES
docLibrary	templates	numeric	YES
docLibrary	userFields	numeric	YES
docTemplates	id	bigint	NO
docTemplates	library_id	bigint	YES
docTemplates	name	text	YES
docTemplates	fileContent	text	YES
docTemplates	created_at	timestamp with time zone	NO	now()
docTemplates	updated_at	timestamp with time zone	YES	now()
docTemplates	userFields_id	bigint	YES
docTemplates	library	text	YES
docTemplates	numerator	json	YES
docTemplates	entityTypeId	numeric	YES	'4'::numeric
fields	id	integer	NO	nextval('fields_id_seq'::regclass)
fields	library_id	integer	NO
fields	entity_id	text	NO
fields	field_name	text	NO
fields	user_type_id	text	NO
fields	xml_id	text	YES
fields	sort	integer	YES
fields	multiple	character	YES
fields	mandatory	character	YES
fields	show_filter	character	YES
fields	show_in_list	character	YES
fields	edit_in_list	character	YES
fields	is_searchable	character	YES
fields	edit_form_label	text	YES
fields	list_column_label	text	YES
fields	list_filter_label	text	YES
fields	error_message	text	YES
fields	help_message	text	YES
fields	list	jsonb	YES
fields	settings	jsonb	YES
fields	updated_at	timestamp with time zone	YES	now()
libraries	id	integer	NO	nextval('libraries_id_seq'::regclass)
libraries	name	text	NO
libraries	description	text	YES
libraries	industry	text	YES
libraries	category	text	YES
libraries	subscription_type	text	YES
libraries	price	text	YES
libraries	updated_at	timestamp with time zone	NO	now()
libraries	created_at	timestamp with time zone	NO	now()
libraries	uf_data	jsonb	YES
libraries_counts	id	integer	YES
libraries_counts	name	text	YES
libraries_counts	description	text	YES
libraries_counts	industry	text	YES
libraries_counts	category	text	YES
libraries_counts	subscription_type	text	YES
libraries_counts	price	text	YES
libraries_counts	updated_at	timestamp with time zone	YES
libraries_counts	created_at	timestamp with time zone	YES
libraries_counts	uf_data	jsonb	YES
libraries_counts	template_count	bigint	YES
libraries_counts	userfield_count	bigint	YES
libraries_counts	numerators_count	bigint	YES
licenses	id	integer	NO	nextval('licenses_id_seq'::regclass)
licenses	license_key	character varying	NO
licenses	portal_id	integer	YES
licenses	activated	boolean	YES	false
licenses	expiration_date	date	YES
licenses	created_at	timestamp without time zone	YES	CURRENT_TIMESTAMP
licenses	revoked	boolean	YES	false
licenses	max_uses	integer	YES	1
licenses	current_uses	integer	YES	0
licenses	product	ARRAY	YES
licenses	product_id	integer	YES
numerators	id	integer	NO	nextval('numerators_id_seq'::regclass)
numerators	library_id	integer	NO
numerators	name	text	NO
numerators	template	text	NO
numerators	code	text	YES
numerators	updated_at	timestamp with time zone	YES	now()
numerators	settings:provider	text	YES	'Bitrix_Main_Numerator_Generator_SequentNumberGenerator'::text
numerators	settings:provider:start	integer	YES
numerators	settings:provider:step	integer	YES
numerators	settings:provider:length	integer	YES
numerators	settingsr:provider:padString	text	YES
numerators	setting:provider:periodicBy	text	YES
numerators	settings:provider:timezone	text	YES
numerators	settings:provider:isDirectNumeration	boolean	YES	false
portalAccounts	id	bigint	NO
portalAccounts	name	text	YES
portalAccounts	client_id	text	YES
portalAccounts	client_key	text	YES
portalAccounts	portal_url	text	YES
portalAccounts	client_webhook	text	YES
portalAccounts	created_at	timestamp with time zone	NO	now()
portalAccounts	updated_at	timestamp with time zone	YES	now()
portalAccounts	webhook	text	YES
profiles	id	uuid	NO
profiles	updated_at	timestamp with time zone	YES
profiles	username	text	YES
profiles	full_name	text	YES
profiles	avatar_url	text	YES
profiles	website	text	YES
profiles	firstname	text	YES
profiles	lastname	text	YES
profiles	street	text	YES
profiles	postcode	bigint	YES
profiles	city	text	YES
profiles	country	text	YES
profiles	photo	text	YES
profiles	created_at	timestamp with time zone	YES	now()
templates	id	integer	NO	nextval('templates_id_seq'::regclass)
templates	library_id	integer	NO
templates	name	text	NO
templates	file	text	YES
templates	region	text	YES	'2'::text
templates	users	ARRAY	YES
templates	providers	text	YES
templates	numerator_id	integer	YES
templates	updated_at	timestamp with time zone	YES	now()
templates	entityTypeId	integer	YES
templates	withStamps	boolean	YES
templates	activate	boolean	YES
templates	template	text	YES	'#{NUMBER}'::text
templates	code	text	YES
templates	settings:provider	text	YES	'Bitrix_Main_Numerator_Generator_SequentNumberGenerator'::text
templates	settings:provider:start	numeric	YES	'100'::numeric
templates	settings:provider:step	numeric	YES	'1'::numeric
templates	settings:provider:length	numeric	YES	'0'::numeric
templates	settingsr:provider:padString	text	YES
templates	setting:provider:periodicBy	text	YES
templates	settings:provider:timezone	text	YES
templates	settings:provider:isDirectNumeration	boolean	YES	false
templates	numeratorName	text	YES
templates	description	text	YES	'Default Description'::text

Data Definition and Documentation

CloudManager data definition and documentation.

Overview

CloudManager application documentation.