Message Providers Table Schema (message_providers)


This table stores the message providers (modules and core systems)

message_providers table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null

id of the table, please edit me

name VARCHAR 100

The full name of the message provider in standard form

component VARCHAR 200

The name of the component that produces these messages

capability VARCHAR 255 null

Optional: permission that is required on the user's setting screen to see this message provider.

Table contained -1 rows

message_providers table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
messprov_comnam_uix Must be unique Asc/Asc component + name