4 <name>civicrm_cxn
</name>
8 <title>Connection ID
</title>
9 <type>int unsigned
</type>
10 <required>true
</required>
11 <comment>Connection ID
</comment>
16 <autoincrement>false
</autoincrement>
19 <!-- Application identification -->
23 <title>Application GUID
</title>
26 <comment>Application GUID
</comment>
31 <fieldName>app_guid
</fieldName>
37 <title>Application Metadata (JSON)
</title>
39 <comment>Application Metadata (JSON)
</comment>
43 <!-- Connection details -->
47 <title>Connection GUID
</title>
50 <comment>Connection GUID
</comment>
54 <name>UI_keypair_cxnid
</name>
55 <fieldName>cxn_guid
</fieldName>
62 <comment>Shared secret
</comment>
68 <comment>Permissions approved for the service (JSON)
</comment>
74 <comment>Options for the service (JSON)
</comment>
78 <!-- Connection lifecycle -->
81 <name>is_active
</name>
82 <title>Is Active
</title>
85 <comment>Is connection currently enabled?
</comment>
89 <name>created_date
</name>
90 <type>timestamp
</type>
91 <comment>When was the connection was created.
</comment>
92 <required>false
</required>
93 <default>NULL
</default>
97 <name>modified_date
</name>
98 <type>timestamp
</type>
99 <comment>When the connection was created or modified.
</comment>
100 <required>false
</required>
101 <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
</default>
105 <name>fetched_date
</name>
106 <type>timestamp
</type>
107 <comment>The last time the application metadata was fetched.
</comment>
108 <required>false
</required>
109 <default>NULL
</default>