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>
75 <serialize>JSON
</serialize>
79 <!-- Connection lifecycle -->
82 <name>is_active
</name>
83 <title>Is Active
</title>
86 <comment>Is connection currently enabled?
</comment>
90 <name>created_date
</name>
91 <type>timestamp
</type>
92 <comment>When was the connection was created.
</comment>
93 <required>false
</required>
94 <default>NULL
</default>
98 <name>modified_date
</name>
99 <type>timestamp
</type>
100 <comment>When the connection was created or modified.
</comment>
101 <required>false
</required>
102 <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
</default>
106 <name>fetched_date
</name>
107 <type>timestamp
</type>
108 <comment>The last time the application metadata was fetched.
</comment>
109 <required>false
</required>
110 <default>NULL
</default>