mirror of
https://github.com/jambonz/jambonz-api-server.git
synced 2026-07-24 21:12:10 +00:00
Dave Horton
1117 lines
64 KiB
XML
1117 lines
64 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<SQLContainer>
|
|
<SQLTable>
|
|
<name><![CDATA[users]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<location>
|
|
<x>1599.00</x>
|
|
<y>37.00</y>
|
|
</location>
|
|
<size>
|
|
<width>250.00</width>
|
|
<height>120.00</height>
|
|
</size>
|
|
<zorder>11</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[user_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[F33F9604-ADC9-46E3-AE51-A2A839A81758]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[name]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[6E8DE796-46DA-4644-AA7F-1A75D9B834FB]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[hashed_password]]></name>
|
|
<type><![CDATA[VARCHAR(1024)]]></type>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[3E7E38A2-96FC-4E28-BF10-332823FB17F1]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[salt]]></name>
|
|
<type><![CDATA[CHAR(16)]]></type>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[F21A170F-5922-4749-A062-6C7516051560]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[force_change]]></name>
|
|
<type><![CDATA[BOOLEAN]]></type>
|
|
<defaultValue><![CDATA[TRUE]]></defaultValue>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[57655C0C-9427-4CC7-9502-24ACF56AAECF]]></uid>
|
|
</SQLField>
|
|
<labelWindowIndex><![CDATA[3]]></labelWindowIndex>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[2A735FAB-592C-42E5-9C8B-06B109314799]]></uid>
|
|
</SQLTable>
|
|
<SQLTable>
|
|
<name><![CDATA[voip_carriers]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<comment><![CDATA[A Carrier or customer PBX that can send or receive calls]]></comment>
|
|
<tableType><![CDATA[InnoDB]]></tableType>
|
|
<location>
|
|
<x>417.00</x>
|
|
<y>263.00</y>
|
|
</location>
|
|
<size>
|
|
<width>266.00</width>
|
|
<height>140.00</height>
|
|
</size>
|
|
<zorder>6</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[voip_carrier_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<autoIncrement><![CDATA[0]]></autoIncrement>
|
|
<forcedUnique><![CDATA[1]]></forcedUnique>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[E34851EF-3C5F-4118-8425-F88EE16E38AA]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[name]]></name>
|
|
<type><![CDATA[VARCHAR(64)]]></type>
|
|
<autoIncrement><![CDATA[0]]></autoIncrement>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[41945C7A-F511-4902-AA12-79F3C7024A8E]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[description]]></name>
|
|
<type><![CDATA[VARCHAR(255)]]></type>
|
|
<uid><![CDATA[27E702F3-73ED-43F4-8B40-3C170AA17445]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[account_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>account_sid</referencesField>
|
|
<referencesTable>accounts</referencesTable>
|
|
<referencesField><![CDATA[account_sid]]></referencesField>
|
|
<referencesTable><![CDATA[accounts]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>2</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[1342FAFA-C15C-429B-809B-C6C55F9FA5B6]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[985D6997-B1A7-4AB3-80F4-4D59B45480C8]]></referencesTableUID>
|
|
<objectComment><![CDATA[if provided, indicates this entity represents a customer PBX that is associated with a specific account]]></objectComment>
|
|
<uid><![CDATA[A1047797-5ACB-4E2E-8F87-5AA965D2EBD8]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[application_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>application_sid</referencesField>
|
|
<referencesTable>applications</referencesTable>
|
|
<referencesField><![CDATA[application_sid]]></referencesField>
|
|
<referencesTable><![CDATA[applications]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>2</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[EF943D13-DCB0-43C1-B03F-550612E20F9D]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[E97EE4F0-7ED7-4E8C-862E-D98192D6EAE0]]></referencesTableUID>
|
|
<objectComment><![CDATA[If provided, all incoming calls from this source will be routed to the associated application]]></objectComment>
|
|
<uid><![CDATA[B6545E2E-7F55-4082-AEFA-29F50C137D64]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[e164_leading_plus]]></name>
|
|
<type><![CDATA[BOOLEAN]]></type>
|
|
<defaultValue><![CDATA[false]]></defaultValue>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[123EA4AC-627B-42A1-8779-D72494E8D47F]]></uid>
|
|
</SQLField>
|
|
<labelWindowIndex><![CDATA[8]]></labelWindowIndex>
|
|
<objectComment><![CDATA[A Carrier or customer PBX that can send or receive calls]]></objectComment>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[3D3136A7-AFC0-4A70-AEC3-68577955CA2E]]></uid>
|
|
</SQLTable>
|
|
<SQLTable>
|
|
<name><![CDATA[api_keys]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<comment><![CDATA[An authorization token that is used to access the REST api]]></comment>
|
|
<tableType><![CDATA[InnoDB]]></tableType>
|
|
<location>
|
|
<x>1319.00</x>
|
|
<y>38.00</y>
|
|
</location>
|
|
<size>
|
|
<width>245.00</width>
|
|
<height>160.00</height>
|
|
</size>
|
|
<zorder>1</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[api_key_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[062C3C28-6EEE-4C79-86F3-4B6E22BD36E4]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[token]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[FA502459-B245-4609-A121-B87ED84CF673]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[account_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>account_sid</referencesField>
|
|
<referencesTable>accounts</referencesTable>
|
|
<referencesField><![CDATA[account_sid]]></referencesField>
|
|
<referencesTable><![CDATA[accounts]]></referencesTable>
|
|
<sourceCardinality>3</sourceCardinality>
|
|
<destinationCardinality>2</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[1342FAFA-C15C-429B-809B-C6C55F9FA5B6]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[985D6997-B1A7-4AB3-80F4-4D59B45480C8]]></referencesTableUID>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[0]]></notNull>
|
|
<uid><![CDATA[430FF789-8E76-4274-B73B-BE25A240B64E]]></uid>
|
|
<unsigned><![CDATA[0]]></unsigned>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[service_provider_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>service_provider_sid</referencesField>
|
|
<referencesTable>service_providers</referencesTable>
|
|
<referencesField><![CDATA[service_provider_sid]]></referencesField>
|
|
<referencesTable><![CDATA[service_providers]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>2</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[58E1702C-6A95-4B17-8C08-8A3810EA16A1]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[F294B51E-F867-47CA-BC1F-F70BDF8170FF]]></referencesTableUID>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<uid><![CDATA[3F553F20-AA47-471E-A650-0B4CEC9DCB0A]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[expires_at]]></name>
|
|
<type><![CDATA[TIMESTAMP]]></type>
|
|
<defaultValue><![CDATA[NULL]]></defaultValue>
|
|
<uid><![CDATA[DE86BC18-858E-4D7E-9B83-891DB2861434]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[last_used]]></name>
|
|
<type><![CDATA[TIMESTAMP]]></type>
|
|
<defaultValue><![CDATA[NULL]]></defaultValue>
|
|
<uid><![CDATA[11A93288-B892-436B-9BB4-D5C3B70DB061]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[created_at]]></name>
|
|
<type><![CDATA[TIMESTAMP]]></type>
|
|
<defaultValue><![CDATA[CURRENT_TIMESTAMP]]></defaultValue>
|
|
<uid><![CDATA[C84C9B6A-80B5-4B0B-8C14-EB02F7421BBE]]></uid>
|
|
</SQLField>
|
|
<labelWindowIndex><![CDATA[13]]></labelWindowIndex>
|
|
<objectComment><![CDATA[An authorization token that is used to access the REST api]]></objectComment>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[3EDF89A0-FD38-4DF9-BB65-E0FCD0A678BE]]></uid>
|
|
</SQLTable>
|
|
<SQLTable>
|
|
<name><![CDATA[webhooks]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<comment><![CDATA[An HTTP callback]]></comment>
|
|
<location>
|
|
<x>1315.00</x>
|
|
<y>376.00</y>
|
|
</location>
|
|
<size>
|
|
<width>254.00</width>
|
|
<height>120.00</height>
|
|
</size>
|
|
<zorder>10</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[webhook_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<forcedUnique><![CDATA[1]]></forcedUnique>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[E046BA30-BC18-483C-A5C8-766E7160F574]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[url]]></name>
|
|
<type><![CDATA[VARCHAR(1024)]]></type>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[EB1F13D9-E99A-4F31-B5B0-78C3E0F1E344]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[method]]></name>
|
|
<type><![CDATA[ENUM("GET","POST")]]></type>
|
|
<defaultValue><![CDATA[POST]]></defaultValue>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[6DFFE441-D825-43D4-AFFB-231D5B3F565E]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[username]]></name>
|
|
<type><![CDATA[VARCHAR(255)]]></type>
|
|
<uid><![CDATA[D1EE3F3C-8C60-4F67-A7B1-77DC2A1AFBA5]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[password]]></name>
|
|
<type><![CDATA[VARCHAR(255)]]></type>
|
|
<uid><![CDATA[04BB457A-D532-4780-8A58-5900094171EC]]></uid>
|
|
</SQLField>
|
|
<labelWindowIndex><![CDATA[4]]></labelWindowIndex>
|
|
<objectComment><![CDATA[An HTTP callback]]></objectComment>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[64D64CB9-0990-4C68-BE71-F9FD43C2BE19]]></uid>
|
|
</SQLTable>
|
|
<SQLTable>
|
|
<name><![CDATA[call_routes]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<comment><![CDATA[a regex-based pattern match for call routing]]></comment>
|
|
<tableType><![CDATA[InnoDB]]></tableType>
|
|
<location>
|
|
<x>424.00</x>
|
|
<y>461.00</y>
|
|
</location>
|
|
<size>
|
|
<width>254.00</width>
|
|
<height>120.00</height>
|
|
</size>
|
|
<zorder>5</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[call_route_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<autoIncrement><![CDATA[0]]></autoIncrement>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[BEEB7DBE-19A7-4C44-BD3E-CFA34A343955]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[priority]]></name>
|
|
<type><![CDATA[INTEGER]]></type>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[C1C84C91-F37F-49E0-8D2E-681097AB92AB]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[account_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>account_sid</referencesField>
|
|
<referencesTable>accounts</referencesTable>
|
|
<referencesField><![CDATA[account_sid]]></referencesField>
|
|
<referencesTable><![CDATA[accounts]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>1</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[1342FAFA-C15C-429B-809B-C6C55F9FA5B6]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[985D6997-B1A7-4AB3-80F4-4D59B45480C8]]></referencesTableUID>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[A7C22866-D49D-4267-A6B0-1EED3D096CC6]]></uid>
|
|
<unsigned><![CDATA[0]]></unsigned>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[regex]]></name>
|
|
<type><![CDATA[VARCHAR(255)]]></type>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[90D95BA1-00EC-4ACA-9C00-E2DCD433AD84]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[application_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>application_sid</referencesField>
|
|
<referencesTable>applications</referencesTable>
|
|
<referencesField><![CDATA[application_sid]]></referencesField>
|
|
<referencesTable><![CDATA[applications]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>1</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[EF943D13-DCB0-43C1-B03F-550612E20F9D]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[E97EE4F0-7ED7-4E8C-862E-D98192D6EAE0]]></referencesTableUID>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[9B4208B5-9E3B-4B76-B7F7-4E5D36B99BF2]]></uid>
|
|
<unsigned><![CDATA[0]]></unsigned>
|
|
</SQLField>
|
|
<labelWindowIndex><![CDATA[12]]></labelWindowIndex>
|
|
<objectComment><![CDATA[a regex-based pattern match for call routing]]></objectComment>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[78584D93-2CD7-4495-9C5E-893C7B869133]]></uid>
|
|
</SQLTable>
|
|
<SQLTable>
|
|
<name><![CDATA[ms_teams_tenants]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<comment><![CDATA[A Microsoft Teams customer tenant]]></comment>
|
|
<location>
|
|
<x>1309.00</x>
|
|
<y>219.00</y>
|
|
</location>
|
|
<size>
|
|
<width>298.00</width>
|
|
<height>120.00</height>
|
|
</size>
|
|
<zorder>12</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[ms_teams_tenant_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[A0E48CB5-C2B2-47FC-8486-EF5F16DAF797]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[service_provider_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>service_provider_sid</referencesField>
|
|
<referencesTable>service_providers</referencesTable>
|
|
<referencesField><![CDATA[service_provider_sid]]></referencesField>
|
|
<referencesTable><![CDATA[service_providers]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>1</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[58E1702C-6A95-4B17-8C08-8A3810EA16A1]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[F294B51E-F867-47CA-BC1F-F70BDF8170FF]]></referencesTableUID>
|
|
<indexed><![CDATA[0]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[519A33A0-B678-4F60-892F-ADA90E656500]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[account_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>account_sid</referencesField>
|
|
<referencesTable>accounts</referencesTable>
|
|
<referencesField><![CDATA[account_sid]]></referencesField>
|
|
<referencesTable><![CDATA[accounts]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>2</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[1342FAFA-C15C-429B-809B-C6C55F9FA5B6]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[985D6997-B1A7-4AB3-80F4-4D59B45480C8]]></referencesTableUID>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[EB48F39F-9D5F-43E0-BE8A-34A5C1304A76]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[application_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>application_sid</referencesField>
|
|
<referencesTable>applications</referencesTable>
|
|
<referencesField><![CDATA[application_sid]]></referencesField>
|
|
<referencesTable><![CDATA[applications]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>2</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[EF943D13-DCB0-43C1-B03F-550612E20F9D]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[E97EE4F0-7ED7-4E8C-862E-D98192D6EAE0]]></referencesTableUID>
|
|
<forcedUnique><![CDATA[0]]></forcedUnique>
|
|
<uid><![CDATA[7959F455-D49D-4185-97B5-37C7FAAB339B]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[tenant_fqdn]]></name>
|
|
<type><![CDATA[VARCHAR(255)]]></type>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[1DDAD1A1-942D-4487-89C8-D496B7F82274]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<labelWindowIndex><![CDATA[2]]></labelWindowIndex>
|
|
<objectComment><![CDATA[A Microsoft Teams customer tenant]]></objectComment>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[92FD042A-5AEC-4D8F-AB94-C73C0F566F75]]></uid>
|
|
</SQLTable>
|
|
<SQLTable>
|
|
<name><![CDATA[lcr_carrier_set_entry]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<comment><![CDATA[An entry in the LCR routing list]]></comment>
|
|
<location>
|
|
<x>63.00</x>
|
|
<y>315.00</y>
|
|
</location>
|
|
<size>
|
|
<width>259.00</width>
|
|
<height>120.00</height>
|
|
</size>
|
|
<zorder>9</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[lcr_carrier_set_entry_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<uid><![CDATA[7F8F912B-6596-4068-8C4D-9C790A2DEC8C]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[workload]]></name>
|
|
<type><![CDATA[INTEGER]]></type>
|
|
<defaultValue><![CDATA[1]]></defaultValue>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<objectComment><![CDATA[represents a proportion of traffic to send through the associated carrier; can be used for load balancing traffic across carriers with a common priority for a destination]]></objectComment>
|
|
<uid><![CDATA[D3930B7F-96F4-4FF7-8713-0DD7D6CC0AE0]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[lcr_route_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>lcr_route_sid</referencesField>
|
|
<referencesTable>lcr_routes</referencesTable>
|
|
<referencesField><![CDATA[lcr_route_sid]]></referencesField>
|
|
<referencesTable><![CDATA[lcr_routes]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>1</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[B558A3B9-2F3E-40E0-B78E-997350021A6B]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[F283D572-F670-4571-91FD-A665A9D3E15D]]></referencesTableUID>
|
|
<connectorMidPoint><![CDATA[329.042969]]></connectorMidPoint>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[103C5143-A9A8-40E8-ABE9-97BFAF9D31C5]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[voip_carrier_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>voip_carrier_sid</referencesField>
|
|
<referencesTable>voip_carriers</referencesTable>
|
|
<referencesField><![CDATA[voip_carrier_sid]]></referencesField>
|
|
<referencesTable><![CDATA[voip_carriers]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>1</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[E34851EF-3C5F-4118-8425-F88EE16E38AA]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[3D3136A7-AFC0-4A70-AEC3-68577955CA2E]]></referencesTableUID>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[39CA632B-0E98-497D-BC0A-07FBE06AF7E9]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[priority]]></name>
|
|
<type><![CDATA[INTEGER]]></type>
|
|
<defaultValue><![CDATA[0]]></defaultValue>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<objectComment><![CDATA[lower priority carriers are attempted first]]></objectComment>
|
|
<uid><![CDATA[01F61C68-799B-49B0-9E6A-0E2162EE5A54]]></uid>
|
|
</SQLField>
|
|
<labelWindowIndex><![CDATA[7]]></labelWindowIndex>
|
|
<objectComment><![CDATA[An entry in the LCR routing list]]></objectComment>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[956025F5-0798-47F7-B76C-457814C7B52E]]></uid>
|
|
</SQLTable>
|
|
<SQLTable>
|
|
<name><![CDATA[accounts]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<comment><![CDATA[An enterprise that uses the platform for comm services]]></comment>
|
|
<tableType><![CDATA[InnoDB]]></tableType>
|
|
<location>
|
|
<x>825.00</x>
|
|
<y>321.00</y>
|
|
</location>
|
|
<size>
|
|
<width>380.00</width>
|
|
<height>160.00</height>
|
|
</size>
|
|
<zorder>4</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[account_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<autoIncrement><![CDATA[0]]></autoIncrement>
|
|
<forcedUnique><![CDATA[1]]></forcedUnique>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[1342FAFA-C15C-429B-809B-C6C55F9FA5B6]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[name]]></name>
|
|
<type><![CDATA[VARCHAR(64)]]></type>
|
|
<indexed><![CDATA[0]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[87414407-17CB-4582-9C0B-73CA548E1016]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[sip_realm]]></name>
|
|
<type><![CDATA[VARCHAR(132)]]></type>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<objectComment><![CDATA[sip domain that will be used for devices registering under this account]]></objectComment>
|
|
<uid><![CDATA[CD99250E-6126-4CCA-A1F1-63FFFB028E63]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[service_provider_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>service_provider_sid</referencesField>
|
|
<referencesTable>service_providers</referencesTable>
|
|
<referencesField><![CDATA[service_provider_sid]]></referencesField>
|
|
<referencesTable><![CDATA[service_providers]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>1</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[58E1702C-6A95-4B17-8C08-8A3810EA16A1]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[F294B51E-F867-47CA-BC1F-F70BDF8170FF]]></referencesTableUID>
|
|
<forcedUnique><![CDATA[0]]></forcedUnique>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<objectComment><![CDATA[service provider that owns the customer relationship with this account]]></objectComment>
|
|
<uid><![CDATA[4A8C5F2C-DACE-4C7E-916A-66485BE06884]]></uid>
|
|
<unsigned><![CDATA[0]]></unsigned>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[registration_hook_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>webhook_sid</referencesField>
|
|
<referencesTable>webhooks</referencesTable>
|
|
<referencesField><![CDATA[webhook_sid]]></referencesField>
|
|
<referencesTable><![CDATA[webhooks]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>2</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[E046BA30-BC18-483C-A5C8-766E7160F574]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[64D64CB9-0990-4C68-BE71-F9FD43C2BE19]]></referencesTableUID>
|
|
<objectComment><![CDATA[webhook to call when devices underr this account attempt to register]]></objectComment>
|
|
<uid><![CDATA[A75FAB8E-C2A1-4A05-A09E-6FF454109B6F]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[device_calling_application_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>application_sid</referencesField>
|
|
<referencesTable>applications</referencesTable>
|
|
<referencesField><![CDATA[application_sid]]></referencesField>
|
|
<referencesTable><![CDATA[applications]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>2</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[EF943D13-DCB0-43C1-B03F-550612E20F9D]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[E97EE4F0-7ED7-4E8C-862E-D98192D6EAE0]]></referencesTableUID>
|
|
<objectComment><![CDATA[application to use for outbound calling from an account]]></objectComment>
|
|
<uid><![CDATA[36C13087-E026-4F6F-A409-A082F7ADE1B6]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[is_active]]></name>
|
|
<type><![CDATA[BOOLEAN]]></type>
|
|
<defaultValue><![CDATA[true]]></defaultValue>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[C7130A90-DBB4-424D-A9A9-CB203C32350C]]></uid>
|
|
</SQLField>
|
|
<labelWindowIndex><![CDATA[11]]></labelWindowIndex>
|
|
<objectComment><![CDATA[An enterprise that uses the platform for comm services]]></objectComment>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[985D6997-B1A7-4AB3-80F4-4D59B45480C8]]></uid>
|
|
</SQLTable>
|
|
<SQLTable>
|
|
<name><![CDATA[phone_numbers]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<comment><![CDATA[A phone number that has been assigned to an account]]></comment>
|
|
<tableType><![CDATA[InnoDB]]></tableType>
|
|
<location>
|
|
<x>385.00</x>
|
|
<y>625.00</y>
|
|
</location>
|
|
<size>
|
|
<width>331.00</width>
|
|
<height>120.00</height>
|
|
</size>
|
|
<zorder>2</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[phone_number_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<autoIncrement><![CDATA[0]]></autoIncrement>
|
|
<forcedUnique><![CDATA[0]]></forcedUnique>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[0]]></notNull>
|
|
<uid><![CDATA[6E7DDB07-BED7-405B-961F-8BBA119D38DA]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[number]]></name>
|
|
<type><![CDATA[VARCHAR(32)]]></type>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[159B82ED-C6B0-4FC6-957B-5C354AF9E783]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[voip_carrier_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>voip_carrier_sid</referencesField>
|
|
<referencesTable>voip_carriers</referencesTable>
|
|
<referencesField><![CDATA[voip_carrier_sid]]></referencesField>
|
|
<referencesTable><![CDATA[voip_carriers]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>1</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[E34851EF-3C5F-4118-8425-F88EE16E38AA]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[3D3136A7-AFC0-4A70-AEC3-68577955CA2E]]></referencesTableUID>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[58A047B9-C1C9-4697-9FE8-08E3BFF91660]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[account_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>account_sid</referencesField>
|
|
<referencesTable>accounts</referencesTable>
|
|
<referencesField><![CDATA[account_sid]]></referencesField>
|
|
<referencesTable><![CDATA[accounts]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>2</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[1342FAFA-C15C-429B-809B-C6C55F9FA5B6]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[985D6997-B1A7-4AB3-80F4-4D59B45480C8]]></referencesTableUID>
|
|
<notNull><![CDATA[0]]></notNull>
|
|
<uid><![CDATA[66690304-2370-4480-99E5-52C73A20F597]]></uid>
|
|
<unique><![CDATA[0]]></unique>
|
|
<unsigned><![CDATA[0]]></unsigned>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[application_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>application_sid</referencesField>
|
|
<referencesTable>applications</referencesTable>
|
|
<referencesField><![CDATA[application_sid]]></referencesField>
|
|
<referencesTable><![CDATA[applications]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>2</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[EF943D13-DCB0-43C1-B03F-550612E20F9D]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[E97EE4F0-7ED7-4E8C-862E-D98192D6EAE0]]></referencesTableUID>
|
|
<uid><![CDATA[962CB80A-54CB-4C6A-9591-9BFC644CF80F]]></uid>
|
|
<unsigned><![CDATA[0]]></unsigned>
|
|
</SQLField>
|
|
<labelWindowIndex><![CDATA[10]]></labelWindowIndex>
|
|
<objectComment><![CDATA[A phone number that has been assigned to an account]]></objectComment>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[BA650DDC-AC7B-4DFE-A5E5-828C75607807]]></uid>
|
|
</SQLTable>
|
|
<SQLTable>
|
|
<name><![CDATA[sip_gateways]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<comment><![CDATA[A whitelisted sip gateway used for origination/termination]]></comment>
|
|
<location>
|
|
<x>401.00</x>
|
|
<y>17.00</y>
|
|
</location>
|
|
<size>
|
|
<width>310.00</width>
|
|
<height>180.00</height>
|
|
</size>
|
|
<zorder>7</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[sip_gateway_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<uid><![CDATA[66770F98-7390-4AEB-890F-A1A16672CE20]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[ipv4]]></name>
|
|
<type><![CDATA[VARCHAR(128)]]></type>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<objectComment><![CDATA[ip address or DNS name of the gateway. For gateways providing inbound calling service, ip address is required.]]></objectComment>
|
|
<uid><![CDATA[F18DB7D4-F902-4863-870C-CB07032AE17C]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[port]]></name>
|
|
<type><![CDATA[INTEGER]]></type>
|
|
<defaultValue><![CDATA[5060]]></defaultValue>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<objectComment><![CDATA[sip signaling port]]></objectComment>
|
|
<uid><![CDATA[26B20F1E-4DB0-48C0-90F7-CA90A06A1070]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[inbound]]></name>
|
|
<type><![CDATA[BOOLEAN]]></type>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<objectComment><![CDATA[if true, whitelist this IP to allow inbound calls from the gateway]]></objectComment>
|
|
<uid><![CDATA[CDE029DC-0C7C-400C-85E9-5005C53B7460]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[outbound]]></name>
|
|
<type><![CDATA[BOOLEAN]]></type>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<objectComment><![CDATA[if true, include in least-cost routing when placing calls to the PSTN]]></objectComment>
|
|
<uid><![CDATA[4BD24677-82BA-4647-9873-A5245F53FF1C]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[voip_carrier_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>voip_carrier_sid</referencesField>
|
|
<referencesTable>voip_carriers</referencesTable>
|
|
<referencesField><![CDATA[voip_carrier_sid]]></referencesField>
|
|
<referencesTable><![CDATA[voip_carriers]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>1</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[E34851EF-3C5F-4118-8425-F88EE16E38AA]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[3D3136A7-AFC0-4A70-AEC3-68577955CA2E]]></referencesTableUID>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[BC25D27E-54E4-4D14-B53D-D1C6254D1D72]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[is_active]]></name>
|
|
<type><![CDATA[BOOLEAN]]></type>
|
|
<defaultValue><![CDATA[1]]></defaultValue>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[27D4A5BD-8093-4ADD-B5B5-D546844206F9]]></uid>
|
|
</SQLField>
|
|
<SQLIndex>
|
|
<name><![CDATA[sip_gateway_idx_hostport]]></name>
|
|
<fieldName><![CDATA[ipv4]]></fieldName>
|
|
<fieldName><![CDATA[port]]></fieldName>
|
|
<SQLIndexEntry>
|
|
<name><![CDATA[ipv4]]></name>
|
|
<prefixSize><![CDATA[]]></prefixSize>
|
|
<fieldUid><![CDATA[F18DB7D4-F902-4863-870C-CB07032AE17C]]></fieldUid>
|
|
</SQLIndexEntry>
|
|
<SQLIndexEntry>
|
|
<name><![CDATA[port]]></name>
|
|
<prefixSize><![CDATA[]]></prefixSize>
|
|
<fieldUid><![CDATA[26B20F1E-4DB0-48C0-90F7-CA90A06A1070]]></fieldUid>
|
|
</SQLIndexEntry>
|
|
<indexNamePrefix><![CDATA[sip_gateway]]></indexNamePrefix>
|
|
<indexType><![CDATA[UNIQUE]]></indexType>
|
|
<uid><![CDATA[1C744DE3-39BD-4EC6-B427-7EB2DD258771]]></uid>
|
|
</SQLIndex>
|
|
<labelWindowIndex><![CDATA[6]]></labelWindowIndex>
|
|
<objectComment><![CDATA[A whitelisted sip gateway used for origination/termination]]></objectComment>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[D8A564E2-DA41-4217-8ACE-06CF77E9BEC1]]></uid>
|
|
</SQLTable>
|
|
<SQLTable>
|
|
<name><![CDATA[applications]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<comment><![CDATA[A defined set of behaviors to be applied to phone calls ]]></comment>
|
|
<tableType><![CDATA[InnoDB]]></tableType>
|
|
<location>
|
|
<x>829.00</x>
|
|
<y>568.00</y>
|
|
</location>
|
|
<size>
|
|
<width>345.00</width>
|
|
<height>260.00</height>
|
|
</size>
|
|
<zorder>0</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[application_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<forcedUnique><![CDATA[1]]></forcedUnique>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[EF943D13-DCB0-43C1-B03F-550612E20F9D]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[name]]></name>
|
|
<type><![CDATA[VARCHAR(64)]]></type>
|
|
<indexed><![CDATA[0]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[E0EDB7B1-B7F7-4F56-B94F-6B81BB87C514]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[account_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>account_sid</referencesField>
|
|
<referencesTable>accounts</referencesTable>
|
|
<referencesField><![CDATA[account_sid]]></referencesField>
|
|
<referencesTable><![CDATA[accounts]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>1</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[1342FAFA-C15C-429B-809B-C6C55F9FA5B6]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[985D6997-B1A7-4AB3-80F4-4D59B45480C8]]></referencesTableUID>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<objectComment><![CDATA[account that this application belongs to]]></objectComment>
|
|
<uid><![CDATA[8799F9EA-2C44-4C7D-8AEE-27179D09EBED]]></uid>
|
|
<unsigned><![CDATA[0]]></unsigned>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[call_hook_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>webhook_sid</referencesField>
|
|
<referencesTable>webhooks</referencesTable>
|
|
<referencesField><![CDATA[webhook_sid]]></referencesField>
|
|
<referencesTable><![CDATA[webhooks]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>2</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[E046BA30-BC18-483C-A5C8-766E7160F574]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[64D64CB9-0990-4C68-BE71-F9FD43C2BE19]]></referencesTableUID>
|
|
<objectComment><![CDATA[webhook to call for inbound calls ]]></objectComment>
|
|
<uid><![CDATA[55AE0F31-209A-49F9-A6CB-1BB31BE4178A]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[call_status_hook_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>webhook_sid</referencesField>
|
|
<referencesTable>webhooks</referencesTable>
|
|
<referencesField><![CDATA[webhook_sid]]></referencesField>
|
|
<referencesTable><![CDATA[webhooks]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>2</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[E046BA30-BC18-483C-A5C8-766E7160F574]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[64D64CB9-0990-4C68-BE71-F9FD43C2BE19]]></referencesTableUID>
|
|
<objectComment><![CDATA[webhook to call for call status events]]></objectComment>
|
|
<uid><![CDATA[A3B4621B-DF13-4920-A718-068B20CB4E8A]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[messaging_hook_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>webhook_sid</referencesField>
|
|
<referencesTable>webhooks</referencesTable>
|
|
<referencesField><![CDATA[webhook_sid]]></referencesField>
|
|
<referencesTable><![CDATA[webhooks]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>1</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[E046BA30-BC18-483C-A5C8-766E7160F574]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[64D64CB9-0990-4C68-BE71-F9FD43C2BE19]]></referencesTableUID>
|
|
<objectComment><![CDATA[webhook to call for inbound SMS/MMS ]]></objectComment>
|
|
<uid><![CDATA[4690A98A-2F67-4205-A5C1-D9523F6B3282]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[speech_synthesis_vendor]]></name>
|
|
<type><![CDATA[VARCHAR(64)]]></type>
|
|
<defaultValue><![CDATA[google]]></defaultValue>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[05D3C937-255D-44A5-A102-40303FA37CF1]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[speech_synthesis_language]]></name>
|
|
<type><![CDATA[VARCHAR(12)]]></type>
|
|
<defaultValue><![CDATA[en-US]]></defaultValue>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[2498FC63-58A1-40AF-8502-ABC4F1F5F541]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[speech_synthesis_voice]]></name>
|
|
<type><![CDATA[VARCHAR(64)]]></type>
|
|
<notNull><![CDATA[0]]></notNull>
|
|
<uid><![CDATA[929D66F0-64B9-4D7C-AB4B-24F131E1178F]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[speech_recognizer_vendor]]></name>
|
|
<type><![CDATA[VARCHAR(64)]]></type>
|
|
<defaultValue><![CDATA[google]]></defaultValue>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[0A601195-287E-4F35-BE69-9A80CAF363D2]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[speech_recognizer_language]]></name>
|
|
<type><![CDATA[VARCHAR(64)]]></type>
|
|
<defaultValue><![CDATA[en-US]]></defaultValue>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[A03AFB7B-492F-48E3-AE3C-B1416D5B6B12]]></uid>
|
|
</SQLField>
|
|
<SQLIndex>
|
|
<name><![CDATA[applications_idx_name]]></name>
|
|
<fieldName><![CDATA[account_sid]]></fieldName>
|
|
<fieldName><![CDATA[name]]></fieldName>
|
|
<SQLIndexEntry>
|
|
<name><![CDATA[account_sid]]></name>
|
|
<prefixSize><![CDATA[]]></prefixSize>
|
|
<fieldUid><![CDATA[8799F9EA-2C44-4C7D-8AEE-27179D09EBED]]></fieldUid>
|
|
</SQLIndexEntry>
|
|
<SQLIndexEntry>
|
|
<name><![CDATA[name]]></name>
|
|
<prefixSize><![CDATA[]]></prefixSize>
|
|
<fieldUid><![CDATA[E0EDB7B1-B7F7-4F56-B94F-6B81BB87C514]]></fieldUid>
|
|
</SQLIndexEntry>
|
|
<indexNamePrefix><![CDATA[applications]]></indexNamePrefix>
|
|
<indexType><![CDATA[UNIQUE]]></indexType>
|
|
<uid><![CDATA[3FDDDF3B-375D-4DE4-B759-514438845F7D]]></uid>
|
|
</SQLIndex>
|
|
<labelWindowIndex><![CDATA[9]]></labelWindowIndex>
|
|
<objectComment><![CDATA[A defined set of behaviors to be applied to phone calls ]]></objectComment>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[E97EE4F0-7ED7-4E8C-862E-D98192D6EAE0]]></uid>
|
|
</SQLTable>
|
|
<SQLTable>
|
|
<name><![CDATA[sbc_addresses]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<location>
|
|
<x>1305.00</x>
|
|
<y>564.00</y>
|
|
</location>
|
|
<size>
|
|
<width>281.00</width>
|
|
<height>120.00</height>
|
|
</size>
|
|
<zorder>13</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[sbc_address_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[468F8C06-5A38-494A-8E77-3F53F111237B]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[ipv4]]></name>
|
|
<type><![CDATA[VARCHAR(255)]]></type>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[4FE97DA7-8D8E-4BE3-982A-01B0444FB070]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[port]]></name>
|
|
<type><![CDATA[INTEGER]]></type>
|
|
<defaultValue><![CDATA[5060]]></defaultValue>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[707EF28F-F4AF-4B7E-AB04-C128C894ECE9]]></uid>
|
|
</SQLField>
|
|
<SQLIndex>
|
|
<name><![CDATA[sbc_addresses_idx_host_port]]></name>
|
|
<fieldName><![CDATA[ipv4]]></fieldName>
|
|
<fieldName><![CDATA[port]]></fieldName>
|
|
<SQLIndexEntry>
|
|
<name><![CDATA[ipv4]]></name>
|
|
<prefixSize><![CDATA[]]></prefixSize>
|
|
<fieldUid><![CDATA[4FE97DA7-8D8E-4BE3-982A-01B0444FB070]]></fieldUid>
|
|
</SQLIndexEntry>
|
|
<SQLIndexEntry>
|
|
<name><![CDATA[port]]></name>
|
|
<prefixSize><![CDATA[]]></prefixSize>
|
|
<fieldUid><![CDATA[707EF28F-F4AF-4B7E-AB04-C128C894ECE9]]></fieldUid>
|
|
</SQLIndexEntry>
|
|
<indexNamePrefix><![CDATA[sbc_addresses]]></indexNamePrefix>
|
|
<uid><![CDATA[174BD35A-B09C-4F4A-B3D2-D5464D927D9B]]></uid>
|
|
</SQLIndex>
|
|
<SQLField>
|
|
<name><![CDATA[service_provider_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>service_provider_sid</referencesField>
|
|
<referencesTable>service_providers</referencesTable>
|
|
<referencesField><![CDATA[service_provider_sid]]></referencesField>
|
|
<referencesTable><![CDATA[service_providers]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>1</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[58E1702C-6A95-4B17-8C08-8A3810EA16A1]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[F294B51E-F867-47CA-BC1F-F70BDF8170FF]]></referencesTableUID>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<uid><![CDATA[6F249D1F-111F-45B4-B76C-8B5E6B9CB43F]]></uid>
|
|
</SQLField>
|
|
<labelWindowIndex><![CDATA[1]]></labelWindowIndex>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[F0EE651E-DBF6-4CAC-A517-AC85BCC2D3AF]]></uid>
|
|
</SQLTable>
|
|
<SQLTable>
|
|
<name><![CDATA[lcr_routes]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<comment><![CDATA[Least cost routing table]]></comment>
|
|
<location>
|
|
<x>66.00</x>
|
|
<y>176.00</y>
|
|
</location>
|
|
<size>
|
|
<width>233.00</width>
|
|
<height>100.00</height>
|
|
</size>
|
|
<zorder>8</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[lcr_route_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<forcedUnique><![CDATA[1]]></forcedUnique>
|
|
<indexed><![CDATA[0]]></indexed>
|
|
<uid><![CDATA[B558A3B9-2F3E-40E0-B78E-997350021A6B]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[regex]]></name>
|
|
<type><![CDATA[VARCHAR(32)]]></type>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<objectComment><![CDATA[regex-based pattern match against dialed number, used for LCR routing of PSTN calls]]></objectComment>
|
|
<uid><![CDATA[A1433A26-AF1E-4FCA-A2B0-7B89BBEBB9A6]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[description]]></name>
|
|
<type><![CDATA[VARCHAR(1024)]]></type>
|
|
<uid><![CDATA[8219C17E-56E1-416E-841C-B177869AC127]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[priority]]></name>
|
|
<type><![CDATA[INTEGER]]></type>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<objectComment><![CDATA[lower priority routes are attempted first]]></objectComment>
|
|
<uid><![CDATA[B73773BA-AB1B-47AA-B995-2D2FE006198F]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<labelWindowIndex><![CDATA[5]]></labelWindowIndex>
|
|
<objectComment><![CDATA[Least cost routing table]]></objectComment>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[F283D572-F670-4571-91FD-A665A9D3E15D]]></uid>
|
|
</SQLTable>
|
|
<SQLTable>
|
|
<name><![CDATA[service_providers]]></name>
|
|
<schema><![CDATA[]]></schema>
|
|
<comment><![CDATA[A partition of the platform used by one service provider]]></comment>
|
|
<tableType><![CDATA[InnoDB]]></tableType>
|
|
<location>
|
|
<x>838.00</x>
|
|
<y>96.00</y>
|
|
</location>
|
|
<size>
|
|
<width>293.00</width>
|
|
<height>140.00</height>
|
|
</size>
|
|
<zorder>3</zorder>
|
|
<SQLField>
|
|
<name><![CDATA[service_provider_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<primaryKey>1</primaryKey>
|
|
<autoIncrement><![CDATA[0]]></autoIncrement>
|
|
<forcedUnique><![CDATA[1]]></forcedUnique>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[58E1702C-6A95-4B17-8C08-8A3810EA16A1]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[name]]></name>
|
|
<type><![CDATA[VARCHAR(64)]]></type>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<notNull><![CDATA[1]]></notNull>
|
|
<uid><![CDATA[BEC72602-A02E-453D-9EE1-9947F7EEAE73]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[description]]></name>
|
|
<type><![CDATA[VARCHAR(255)]]></type>
|
|
<uid><![CDATA[0FDACE57-2FEB-4F6C-96F5-C7C64CA6BFCA]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[root_domain]]></name>
|
|
<type><![CDATA[VARCHAR(128)]]></type>
|
|
<indexed><![CDATA[1]]></indexed>
|
|
<uid><![CDATA[7074CA4C-D211-4926-8BD2-7EF97B49071A]]></uid>
|
|
<unique><![CDATA[1]]></unique>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[registration_hook_sid]]></name>
|
|
<type><![CDATA[CHAR(36)]]></type>
|
|
<referencesField>webhook_sid</referencesField>
|
|
<referencesTable>webhooks</referencesTable>
|
|
<referencesField><![CDATA[webhook_sid]]></referencesField>
|
|
<referencesTable><![CDATA[webhooks]]></referencesTable>
|
|
<sourceCardinality>4</sourceCardinality>
|
|
<destinationCardinality>2</destinationCardinality>
|
|
<referencesFieldUID><![CDATA[E046BA30-BC18-483C-A5C8-766E7160F574]]></referencesFieldUID>
|
|
<referencesTableUID><![CDATA[64D64CB9-0990-4C68-BE71-F9FD43C2BE19]]></referencesTableUID>
|
|
<uid><![CDATA[506BBE72-1A97-4776-B2C3-D94169652FFE]]></uid>
|
|
</SQLField>
|
|
<SQLField>
|
|
<name><![CDATA[ms_teams_fqdn]]></name>
|
|
<type><![CDATA[VARCHAR(255)]]></type>
|
|
<uid><![CDATA[FA39B463-61C7-4654-BE9C-D1AC39AB1B97]]></uid>
|
|
</SQLField>
|
|
<labelWindowIndex><![CDATA[0]]></labelWindowIndex>
|
|
<objectComment><![CDATA[A partition of the platform used by one service provider]]></objectComment>
|
|
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
|
|
<uid><![CDATA[F294B51E-F867-47CA-BC1F-F70BDF8170FF]]></uid>
|
|
</SQLTable>
|
|
<SQLDocumentInfo>
|
|
<encodedPrintInfo><![CDATA[BAtzdHJlYW10eXBlZIHoA4QBQISEhAtOU1ByaW50SW5mbwGEhAhOU09iamVjdACFkoSEhBNOU011dGFibGVEaWN0aW9uYXJ5AISEDE5TRGljdGlvbmFyeQCUhAFpDZKEhIQITlNTdHJpbmcBlIQBKw5OU1BNUGFnZUZvcm1hdIaShISEDU5TTXV0YWJsZURhdGEAhIQGTlNEYXRhAJSXgbIbhAdbNzA5MGNdPD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPCFET0NUWVBFIHBsaXN0IFBVQkxJQyAiLS8vQXBwbGUvL0RURCBQTElTVCAxLjAvL0VOIiAiaHR0cDovL3d3dy5hcHBsZS5jb20vRFREcy9Qcm9wZXJ0eUxpc3QtMS4wLmR0ZCI+CjxwbGlzdCB2ZXJzaW9uPSIxLjAiPgo8ZGljdD4KCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhZ2VGb3JtYXQuUE1Ib3Jpem9udGFsUmVzPC9rZXk+Cgk8ZGljdD4KCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuY3JlYXRvcjwva2V5PgoJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5pdGVtQXJyYXk8L2tleT4KCQk8YXJyYXk+CgkJCTxkaWN0PgoJCQkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFnZUZvcm1hdC5QTUhvcml6b250YWxSZXM8L2tleT4KCQkJCTxyZWFsPjcyPC9yZWFsPgoJCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LnN0YXRlRmxhZzwva2V5PgoJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJPC9kaWN0PgoJCTwvYXJyYXk+Cgk8L2RpY3Q+Cgk8a2V5PmNvbS5hcHBsZS5wcmludC5QYWdlRm9ybWF0LlBNT3JpZW50YXRpb248L2tleT4KCTxkaWN0PgoJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJPHN0cmluZz5jb20uYXBwbGUuam9idGlja2V0PC9zdHJpbmc+CgkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0Lml0ZW1BcnJheTwva2V5PgoJCTxhcnJheT4KCQkJPGRpY3Q+CgkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYWdlRm9ybWF0LlBNT3JpZW50YXRpb248L2tleT4KCQkJCTxpbnRlZ2VyPjE8L2ludGVnZXI+CgkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQk8L2RpY3Q+CgkJPC9hcnJheT4KCTwvZGljdD4KCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhZ2VGb3JtYXQuUE1TY2FsaW5nPC9rZXk+Cgk8ZGljdD4KCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuY3JlYXRvcjwva2V5PgoJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5pdGVtQXJyYXk8L2tleT4KCQk8YXJyYXk+CgkJCTxkaWN0PgoJCQkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFnZUZvcm1hdC5QTVNjYWxpbmc8L2tleT4KCQkJCTxyZWFsPjE8L3JlYWw+CgkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQk8L2RpY3Q+CgkJPC9hcnJheT4KCTwvZGljdD4KCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhZ2VGb3JtYXQuUE1WZXJ0aWNhbFJlczwva2V5PgoJPGRpY3Q+CgkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LmNyZWF0b3I8L2tleT4KCQk8c3RyaW5nPmNvbS5hcHBsZS5qb2J0aWNrZXQ8L3N0cmluZz4KCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuaXRlbUFycmF5PC9rZXk+CgkJPGFycmF5PgoJCQk8ZGljdD4KCQkJCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhZ2VGb3JtYXQuUE1WZXJ0aWNhbFJlczwva2V5PgoJCQkJPHJlYWw+NzI8L3JlYWw+CgkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQk8L2RpY3Q+CgkJPC9hcnJheT4KCTwvZGljdD4KCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhZ2VGb3JtYXQuUE1WZXJ0aWNhbFNjYWxpbmc8L2tleT4KCTxkaWN0PgoJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJPHN0cmluZz5jb20uYXBwbGUuam9idGlja2V0PC9zdHJpbmc+CgkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0Lml0ZW1BcnJheTwva2V5PgoJCTxhcnJheT4KCQkJPGRpY3Q+CgkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYWdlRm9ybWF0LlBNVmVydGljYWxTY2FsaW5nPC9rZXk+CgkJCQk8cmVhbD4xPC9yZWFsPgoJCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LnN0YXRlRmxhZzwva2V5PgoJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJPC9kaWN0PgoJCTwvYXJyYXk+Cgk8L2RpY3Q+Cgk8a2V5PmNvbS5hcHBsZS5wcmludC5zdWJUaWNrZXQucGFwZXJfaW5mb190aWNrZXQ8L2tleT4KCTxkaWN0PgoJCTxrZXk+UE1QUERQYXBlckNvZGVOYW1lPC9rZXk+CgkJPGRpY3Q+CgkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuaXRlbUFycmF5PC9rZXk+CgkJCTxhcnJheT4KCQkJCTxkaWN0PgoJCQkJCTxrZXk+UE1QUERQYXBlckNvZGVOYW1lPC9rZXk+CgkJCQkJPHN0cmluZz5MZXR0ZXI8L3N0cmluZz4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCTwvZGljdD4KCQkJPC9hcnJheT4KCQk8L2RpY3Q+CgkJPGtleT5QTVBQRFRyYW5zbGF0aW9uU3RyaW5nUGFwZXJOYW1lPC9rZXk+CgkJPGRpY3Q+CgkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuaXRlbUFycmF5PC9rZXk+CgkJCTxhcnJheT4KCQkJCTxkaWN0PgoJCQkJCTxrZXk+UE1QUERUcmFuc2xhdGlvblN0cmluZ1BhcGVyTmFtZTwva2V5PgoJCQkJCTxzdHJpbmc+VVMgTGV0dGVyPC9zdHJpbmc+CgkJCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LnN0YXRlRmxhZzwva2V5PgoJCQkJCTxpbnRlZ2VyPjA8L2ludGVnZXI+CgkJCQk8L2RpY3Q+CgkJCTwvYXJyYXk+CgkJPC9kaWN0PgoJCTxrZXk+UE1UaW9nYVBhcGVyTmFtZTwva2V5PgoJCTxkaWN0PgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuY3JlYXRvcjwva2V5PgoJCQk8c3RyaW5nPmNvbS5hcHBsZS5qb2J0aWNrZXQ8L3N0cmluZz4KCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0Lml0ZW1BcnJheTwva2V5PgoJCQk8YXJyYXk+CgkJCQk8ZGljdD4KCQkJCQk8a2V5PlBNVGlvZ2FQYXBlck5hbWU8L2tleT4KCQkJCQk8c3RyaW5nPm5hLWxldHRlcjwvc3RyaW5nPgoJCQkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5zdGF0ZUZsYWc8L2tleT4KCQkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQkJPC9kaWN0PgoJCQk8L2FycmF5PgoJCTwvZGljdD4KCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYWdlRm9ybWF0LlBNQWRqdXN0ZWRQYWdlUmVjdDwva2V5PgoJCTxkaWN0PgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuY3JlYXRvcjwva2V5PgoJCQk8c3RyaW5nPmNvbS5hcHBsZS5qb2J0aWNrZXQ8L3N0cmluZz4KCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0Lml0ZW1BcnJheTwva2V5PgoJCQk8YXJyYXk+CgkJCQk8ZGljdD4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYWdlRm9ybWF0LlBNQWRqdXN0ZWRQYWdlUmVjdDwva2V5PgoJCQkJCTxhcnJheT4KCQkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCQkJPHJlYWw+NzM0PC9yZWFsPgoJCQkJCQk8cmVhbD41NzY8L3JlYWw+CgkJCQkJPC9hcnJheT4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCTwvZGljdD4KCQkJPC9hcnJheT4KCQk8L2RpY3Q+CgkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFnZUZvcm1hdC5QTUFkanVzdGVkUGFwZXJSZWN0PC9rZXk+CgkJPGRpY3Q+CgkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuaXRlbUFycmF5PC9rZXk+CgkJCTxhcnJheT4KCQkJCTxkaWN0PgoJCQkJCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhZ2VGb3JtYXQuUE1BZGp1c3RlZFBhcGVyUmVjdDwva2V5PgoJCQkJCTxhcnJheT4KCQkJCQkJPHJlYWw+LTE4PC9yZWFsPgoJCQkJCQk8cmVhbD4tMTg8L3JlYWw+CgkJCQkJCTxyZWFsPjc3NDwvcmVhbD4KCQkJCQkJPHJlYWw+NTk0PC9yZWFsPgoJCQkJCTwvYXJyYXk+CgkJCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LnN0YXRlRmxhZzwva2V5PgoJCQkJCTxpbnRlZ2VyPjA8L2ludGVnZXI+CgkJCQk8L2RpY3Q+CgkJCTwvYXJyYXk+CgkJPC9kaWN0PgoJCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhcGVySW5mby5QTVBQRFBhcGVyRGltZW5zaW9uPC9rZXk+CgkJPGRpY3Q+CgkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuaXRlbUFycmF5PC9rZXk+CgkJCTxhcnJheT4KCQkJCTxkaWN0PgoJCQkJCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhcGVySW5mby5QTVBQRFBhcGVyRGltZW5zaW9uPC9rZXk+CgkJCQkJPGFycmF5PgoJCQkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQkJCQk8cmVhbD42MTI8L3JlYWw+CgkJCQkJCTxyZWFsPjc5MjwvcmVhbD4KCQkJCQk8L2FycmF5PgoJCQkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5zdGF0ZUZsYWc8L2tleT4KCQkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQkJPC9kaWN0PgoJCQk8L2FycmF5PgoJCTwvZGljdD4KCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYXBlckluZm8uUE1QYXBlck5hbWU8L2tleT4KCQk8ZGljdD4KCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LmNyZWF0b3I8L2tleT4KCQkJPHN0cmluZz5jb20uYXBwbGUuam9idGlja2V0PC9zdHJpbmc+CgkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5pdGVtQXJyYXk8L2tleT4KCQkJPGFycmF5PgoJCQkJPGRpY3Q+CgkJCQkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFwZXJJbmZvLlBNUGFwZXJOYW1lPC9rZXk+CgkJCQkJPHN0cmluZz5uYS1sZXR0ZXI8L3N0cmluZz4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCTwvZGljdD4KCQkJPC9hcnJheT4KCQk8L2RpY3Q+CgkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFwZXJJbmZvLlBNVW5hZGp1c3RlZFBhZ2VSZWN0PC9rZXk+CgkJPGRpY3Q+CgkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuaXRlbUFycmF5PC9rZXk+CgkJCTxhcnJheT4KCQkJCTxkaWN0PgoJCQkJCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhcGVySW5mby5QTVVuYWRqdXN0ZWRQYWdlUmVjdDwva2V5PgoJCQkJCTxhcnJheT4KCQkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCQkJPHJlYWw+NzM0PC9yZWFsPgoJCQkJCQk8cmVhbD41NzY8L3JlYWw+CgkJCQkJPC9hcnJheT4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCTwvZGljdD4KCQkJPC9hcnJheT4KCQk8L2RpY3Q+CgkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFwZXJJbmZvLlBNVW5hZGp1c3RlZFBhcGVyUmVjdDwva2V5PgoJCTxkaWN0PgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuY3JlYXRvcjwva2V5PgoJCQk8c3RyaW5nPmNvbS5hcHBsZS5qb2J0aWNrZXQ8L3N0cmluZz4KCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0Lml0ZW1BcnJheTwva2V5PgoJCQk8YXJyYXk+CgkJCQk8ZGljdD4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYXBlckluZm8uUE1VbmFkanVzdGVkUGFwZXJSZWN0PC9rZXk+CgkJCQkJPGFycmF5PgoJCQkJCQk8cmVhbD4tMTg8L3JlYWw+CgkJCQkJCTxyZWFsPi0xODwvcmVhbD4KCQkJCQkJPHJlYWw+Nzc0PC9yZWFsPgoJCQkJCQk8cmVhbD41OTQ8L3JlYWw+CgkJCQkJPC9hcnJheT4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCTwvZGljdD4KCQkJPC9hcnJheT4KCQk8L2RpY3Q+CgkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFwZXJJbmZvLnBwZC5QTVBhcGVyTmFtZTwva2V5PgoJCTxkaWN0PgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuY3JlYXRvcjwva2V5PgoJCQk8c3RyaW5nPmNvbS5hcHBsZS5qb2J0aWNrZXQ8L3N0cmluZz4KCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0Lml0ZW1BcnJheTwva2V5PgoJCQk8YXJyYXk+CgkJCQk8ZGljdD4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYXBlckluZm8ucHBkLlBNUGFwZXJOYW1lPC9rZXk+CgkJCQkJPHN0cmluZz5MZXR0ZXI8L3N0cmluZz4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCTwvZGljdD4KCQkJPC9hcnJheT4KCQk8L2RpY3Q+CgkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LkFQSVZlcnNpb248L2tleT4KCQk8c3RyaW5nPjAwLjIwPC9zdHJpbmc+CgkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LnR5cGU8L2tleT4KCQk8c3RyaW5nPmNvbS5hcHBsZS5wcmludC5QYXBlckluZm9UaWNrZXQ8L3N0cmluZz4KCTwvZGljdD4KCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5BUElWZXJzaW9uPC9rZXk+Cgk8c3RyaW5nPjAwLjIwPC9zdHJpbmc+Cgk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQudHlwZTwva2V5PgoJPHN0cmluZz5jb20uYXBwbGUucHJpbnQuUGFnZUZvcm1hdFRpY2tldDwvc3RyaW5nPgo8L2RpY3Q+CjwvcGxpc3Q+CoaShJmZC05TUGFwZXJTaXplhpKEhIQHTlNWYWx1ZQCUhAEqhIQLe0NHU2l6ZT1kZH2fgWQCgRgDhpKEmZkWTlNIb3Jpem9udGFsbHlDZW50ZXJlZIaShISECE5TTnVtYmVyAJ+ehIQBY6EBhpKEmZkUTlNWZXJ0aWNhbGx5Q2VudGVyZWSGkqKShJmZDE5TTGVmdE1hcmdpboaShKOehIQBZKIShpKEmZkNTlNSaWdodE1hcmdpboaSp5KEmZkLTlNUb3BNYXJnaW6GkoSjnqiiHoaShJmZDU5TT3JpZW50YXRpb26GkoSjnoSEAXGjAIaShJmZFU5TSG9yaXpvbmFsUGFnaW5hdGlvboaSrZKEmZkUTlNWZXJ0aWNhbFBhZ2luYXRpb26Gkq2ShJmZDk5TQm90dG9tTWFyZ2luhpKEo56oojSGkoSZmQtOU1BhcGVyTmFtZYaShJmZCW5hLWxldHRlcoaShJmZD05TU2NhbGluZ0ZhY3RvcoaShKOeqKIBhoaG]]></encodedPrintInfo>
|
|
<autoSizeTablesOption><![CDATA[0]]></autoSizeTablesOption>
|
|
<documentScaleFactor><![CDATA[1]]></documentScaleFactor>
|
|
<dropTableOption><![CDATA[1]]></dropTableOption>
|
|
<exportDialect><![CDATA[mysql]]></exportDialect>
|
|
<fileversion><![CDATA[4]]></fileversion>
|
|
<generator><![CDATA[com.malcolmhardie.sqleditor]]></generator>
|
|
<generatorVersion><![CDATA[3.5.1]]></generatorVersion>
|
|
<hideFieldIcons><![CDATA[0]]></hideFieldIcons>
|
|
<hideFieldTypes><![CDATA[0]]></hideFieldTypes>
|
|
<overviewPanelHidden><![CDATA[0]]></overviewPanelHidden>
|
|
<pageBoundariesVisible><![CDATA[0]]></pageBoundariesVisible>
|
|
<PageGridVisible><![CDATA[0]]></PageGridVisible>
|
|
<RightSidebarWidth><![CDATA[1924.000000]]></RightSidebarWidth>
|
|
<sidebarIndex><![CDATA[2]]></sidebarIndex>
|
|
<snapToGrid><![CDATA[0]]></snapToGrid>
|
|
<SourceSidebarWidth><![CDATA[0.000000]]></SourceSidebarWidth>
|
|
<SQLEditorFileFormatVersion><![CDATA[4]]></SQLEditorFileFormatVersion>
|
|
<uid><![CDATA[58C99A00-06C9-478C-A667-C63842E088F3]]></uid>
|
|
<windowHeight><![CDATA[1013.000000]]></windowHeight>
|
|
<windowLocationX><![CDATA[2716.000000]]></windowLocationX>
|
|
<windowLocationY><![CDATA[1913.000000]]></windowLocationY>
|
|
<windowScrollOrigin><![CDATA[{0, 5}]]></windowScrollOrigin>
|
|
<windowWidth><![CDATA[2201.000000]]></windowWidth>
|
|
</SQLDocumentInfo>
|
|
<AllowsIndexRenamingOnInsert><![CDATA[1]]></AllowsIndexRenamingOnInsert>
|
|
<defaultLabelExpanded><![CDATA[1]]></defaultLabelExpanded>
|
|
<ui.treeDisplayMode><![CDATA[0]]></ui.treeDisplayMode>
|
|
</SQLContainer> |