Table

co_settings

Description

CO specific settings


Column

Format

Description

Definition

Required

Comments

id

integer, primary key

Row identifier

autoincrement

(tick)


co_idinteger, foreign keyCO Record IDcos:id

default_address_type_id

integer, foreign key

Default type when adding a new Address

types:id where attribute is Addresses.type



default_email_address_type_id

integer, foreign key

Default type when adding a new Email Address

types:id where attribute is EmailAddresses.type



default_identifier_type_id

integer, foreign key

Default type when adding a new Identifier

types:id where attribute is Identifiers.type



default_name_type_id

integer, foreign key

Default type when adding a new Name

types:id where attribute is Names.type



default_telephone_number_type_id

integer, foreign key

Default type when adding a new Telephone Number

types:id where attribute is TelephoneNumbers.type



default_url_type_id

integer, foreign key

Default type when adding a new URL

types:id where attribute is Urls.type



email_delivery_address_type_id

integer, foreign key

When sending Notification emails, the Email Address type to use

types:id where attribute is EmailAddresses.type



email_smtp_server_id

integer, foreign key

SMTP Server configuration to use when sending Notifications

Registry Table: servers:id where plugin is CoreServer.SmtpServers

permitted_fields_name

varchar(160)

Comma separated list of which Name fields are enabled


(tick)

permitted_fields_telephone_number

varchar(160)

Comma separated list of which Telephone Number fields are enabled


(tick)

required_fields_address

varchar(160)

Comma separated list of which Address fields are required


(tick)


required_fields_namevarchar(160)Comma separated list of which Name fields are required
(tick)
search_global_limitintegerMaximum number of records for a backend to return during Global Search
(tick)
search_global_limited_modelsbooleanIf true, Global Search searches limited backend models


  • No labels