Dp Component Settings Table Schema (dp_component_settings)


Stores the names and component-independent settings for each installed component.

dp_component_settings table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
templateid BIGINT 19 null
dp_template.id dpcompsett_tem3_fk R

Identifies which template this component setting is for.

component VARCHAR 255 null

Shortname of the component

enabled SMALLINT 5 1

Controls if this component is available or not

sortorder BIGINT 19 null

Controls the ordering of components, used when displaying component tabs.

Table contained -1 rows

dp_component_settings table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpcompsett_tem_ix Performance Asc templateid
dpcompsett_temcom_uix Must be unique Asc/Asc templateid + component

dp_component_settings table relationships