civicrm_cxn

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

Connection ID

app_guid VARCHAR 128 null

Application GUID

app_meta TEXT 65535 null

Application Metadata (JSON)

cxn_guid VARCHAR 128 null

Connection GUID

secret TEXT 65535 null

Shared secret

perm TEXT 65535 null

Permissions approved for the service (JSON)

options TEXT 65535 null

Options for the service (JSON)

is_active TINYINT 3 1

Is connection currently enabled?

created_date TIMESTAMP 19 null

When was the connection was created.

modified_date TIMESTAMP 19 CURRENT_TIMESTAMP

When the connection was created or modified.

fetched_date TIMESTAMP 19 null

The last time the application metadata was fetched.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UI_appid Must be unique Asc app_guid
UI_keypair_cxnid Must be unique Asc cxn_guid

Diagram producer might be missing

No diagrams were produced please see application output for any errors