docs/mash-data-import.svg

<?xml version="1.0" encoding="UTF-8" standalone="no"?><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" contentScriptType="application/ecmascript" contentStyleType="text/css" height="1256px" preserveAspectRatio="none" style="width:770px;height:1256px;background:#EEEBDC;" version="1.1" viewBox="0 0 770 1256" width="770px" zoomAndPan="magnify"><defs/><g><text fill="#000000" font-family="Comic Sans MS" font-size="18" lengthAdjust="spacing" textLength="217" x="270" y="16.708">MASH data import - WIP</text><!--MD5=[990d9a6e75dfc0b31ac96c22292f7806]
cluster googles--><polygon fill="#EEEBDC" points="7,544.9531,7,545.1633,17.027,544.5388,27.0541,545.1464,37.0811,545.3528,47.1081,544.2397,57.1351,544.8754,67.1622,544.5266,77.1892,544.5696,87.2162,544.885,97.2432,544.2618,107.2703,545.5068,117.2973,544.3228,127.3243,544.7554,137.3514,545.3851,147.3784,544.8673,157.4054,545.0214,167.4324,544.9212,177.4595,545.1317,187.4865,545.1923,197.5135,545.5388,207.5405,545.6242,217.5676,545.6324,227.5946,545.2078,237.6216,545.4167,247.6486,545.6554,257.6757,544.2319,267.7027,545.6316,277.7297,544.6566,287.7568,545.4869,297.7838,544.4581,307.8108,544.8846,317.8378,545.6947,327.8649,544.9044,337.8919,545.0584,347.9189,545.2918,357.9459,545.3694,367.973,544.9492,378,544.9531,378.2872,544.9531,377.4276,554.9617,378.2844,564.9704,378.5482,574.979,378.4445,584.9876,378.613,594.9962,377.5169,605.0048,377.3478,615.0135,377.3786,625.0221,377.9411,635.0307,377.8035,645.0393,378.6814,655.048,377.8253,665.0566,377.6569,675.0652,378.2283,685.0738,377.3332,695.0824,377.4809,705.0911,378.649,715.0997,378.4357,725.1083,378.7345,735.1169,377.6782,745.1255,378.3192,755.1342,378.5904,765.1428,377.5276,775.1514,377.9041,785.16,378.126,795.1686,378.6518,805.1773,377.9958,815.1859,378.4626,825.1945,377.4462,835.2031,377.3227,845.2117,378.5036,855.2204,377.2831,865.229,378.509,875.2376,378.2066,885.2462,377.7321,895.2548,377.6462,905.2635,378.4588,915.2721,377.7007,925.2807,378.5919,935.2893,377.4473,945.298,378.6174,955.3066,378.4843,965.3152,378.245,975.3238,378.0472,985.3324,378.7266,995.3411,378.6136,1005.3497,378.1693,1015.3583,378.2682,1025.3669,377.8697,1035.3755,378.7165,1045.3842,378.1549,1055.3928,378.1726,1065.4014,377.3916,1075.41,377.5948,1085.4186,378.5307,1095.4273,378.4298,1105.4359,377.9571,1115.4445,378,1125.4531,378,1125.131,367.973,1125.2342,357.9459,1124.7669,347.9189,1125.8679,337.8919,1126.1927,327.8649,1125.9795,317.8378,1126.1481,307.8108,1125.3164,297.7838,1125.5403,287.7568,1125.0655,277.7297,1125.7372,267.7027,1125.6999,257.6757,1126.0055,247.6486,1125.2235,237.6216,1125.3187,227.5946,1125.8966,217.5676,1126.0205,207.5405,1124.9406,197.5135,1125.2592,187.4865,1125.6024,177.4595,1124.8423,167.4324,1125.8065,157.4054,1125.7111,147.3784,1125.3524,137.3514,1125.5954,127.3243,1126.1818,117.2973,1125.1403,107.2703,1125.7681,97.2432,1125.7388,87.2162,1125.5689,77.1892,1125.594,67.1622,1125.5666,57.1351,1124.829,47.1081,1125.0523,37.0811,1124.9916,27.0541,1125.5169,17.027,1125.5413,7,1125.4531,7.1617,1125.4531,6.709,1115.4445,6.9325,1105.4359,6.8798,1095.4273,7.5769,1085.4186,7.4266,1075.41,6.5145,1065.4014,6.9271,1055.3928,6.4228,1045.3842,7.2884,1035.3755,7.6085,1025.3669,7.5446,1015.3583,6.5644,1005.3497,7.464,995.3411,6.2572,985.3324,7.2002,975.3238,6.7007,965.3152,7.0967,955.3066,7.2403,945.298,7.4721,935.2893,6.2801,925.2807,7.4755,915.2721,7.1782,905.2635,7.3553,895.2548,7.7478,885.2462,7.0055,875.2376,7.1753,865.229,7.2134,855.2204,7.1972,845.2117,6.9992,835.2031,7.7107,825.1945,6.3903,815.1859,7.5653,805.1773,6.376,795.1686,6.4597,785.16,7.04,775.1514,7.0283,765.1428,6.5072,755.1342,7.4137,745.1255,7.1089,735.1169,7.7267,725.1083,7.6671,715.0997,6.5517,705.0911,6.6021,695.0824,6.8708,685.0738,7.3555,675.0652,7.403,665.0566,7.3012,655.048,6.658,645.0393,7.6364,635.0307,7.6338,625.0221,6.9527,615.0135,6.7609,605.0048,6.5986,594.9962,6.7854,584.9876,7.1374,574.979,6.9316,564.9704,6.5822,554.9617,7,544.9531" style="stroke:#444444;stroke-width:1.0;stroke-dasharray:7.0,7.0;"/><text fill="#444444" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="61" x="162" y="561.8047">Google</text><text fill="#444444" font-family="Comic Sans MS" font-size="12" lengthAdjust="spacing" textLength="55" x="165" y="576.7168">[System]</text><!--MD5=[8ae77ada6169822435c3d3bcb01b6727]
cluster system--><polygon fill="#EEEBDC" points="524,27.9531,524,28.1633,534,27.5388,544,28.1464,554,28.3528,564,27.2397,574,27.8754,584,27.5266,594,27.5696,604,27.885,614,27.2618,624,28.5068,634,27.3228,644,27.7554,654,28.3851,664,27.8673,674,28.0214,684,27.9212,694,28.1317,704,28.1923,714,28.5388,724,28.6242,734,28.6324,744,28.2078,754,28.4167,764,27.9531,764.7022,27.9531,763.2788,37.9531,764.6785,47.9531,763.7035,57.9531,764.5338,67.9531,763.505,77.9531,763.9315,87.9531,764.7416,97.9531,763.9513,107.9531,764.1053,117.9531,764.3386,127.9531,764.4162,137.9531,763.9961,147.9531,764.2872,157.9531,763.4276,167.9531,764.2844,177.9531,764.5482,187.9531,764.4445,197.9531,764.613,207.9531,763.5169,217.9531,763.3478,227.9531,763.3786,237.9531,763.9411,247.9531,763.8035,257.9531,764.6814,267.9531,763.8253,277.9531,763.6569,287.9531,764.2283,297.9531,763.3332,307.9531,763.4809,317.9531,764.649,327.9531,764.4357,337.9531,764.7345,347.9531,763.6782,357.9531,764.3192,367.9531,764.5904,377.9531,763.5276,387.9531,763.9041,397.9531,764.126,407.9531,764.6518,417.9531,763.9958,427.9531,764.4626,437.9531,763.4462,447.9531,763.3227,457.9531,764.5036,467.9531,763.2831,477.9531,764.509,487.9531,764.2066,497.9531,763.7321,507.9531,763.6462,517.9531,764.4588,527.9531,763.7007,537.9531,764.5919,547.9531,763.4473,557.9531,764.6174,567.9531,764.4843,577.9531,764.245,587.9531,764.0472,597.9531,764.7266,607.9531,764.6136,617.9531,764.1693,627.9531,764.2682,637.9531,763.8697,647.9531,764.7165,657.9531,764.1549,667.9531,764.1726,677.9531,763.3916,687.9531,763.5948,697.9531,764.5307,707.9531,764.4298,717.9531,763.9571,727.9531,763.6778,737.9531,763.7811,747.9531,763.3138,757.9531,764.4147,767.9531,764.7396,777.9531,764.5264,787.9531,764.6949,797.9531,763.8633,807.9531,764.0872,817.9531,763.6124,827.9531,764.284,837.9531,764.2468,847.9531,764.5524,857.9531,763.7703,867.9531,763.8656,877.9531,764.4435,887.9531,764.5673,897.9531,763.4875,907.9531,763.8061,917.9531,764.1493,927.9531,763.3892,937.9531,764.3534,947.9531,764.258,957.9531,763.8992,967.9531,764.1422,977.9531,764.7287,987.9531,763.6871,997.9531,764.315,1007.9531,764.2856,1017.9531,764.1158,1027.9531,764.1409,1037.9531,764.1135,1047.9531,763.3758,1057.9531,763.5992,1067.9531,763.5385,1077.9531,764.0638,1087.9531,764.0881,1097.9531,764.1617,1107.9531,763.709,1117.9531,763.9325,1127.9531,764,1137.9531,764,1137.8329,754,1138.53,744,1138.3797,734,1137.4676,724,1137.8802,714,1137.3759,704,1138.2415,694,1138.5616,684,1138.4977,674,1137.5176,664,1138.4171,654,1137.2103,644,1138.1533,634,1137.6538,624,1138.0498,614,1138.1935,604,1138.4252,594,1137.2332,584,1138.4286,574,1138.1313,564,1138.3085,554,1138.7009,544,1137.9586,534,1138.1284,524,1137.9531,524.2134,1137.9531,524.1972,1127.9531,523.9992,1117.9531,524.7107,1107.9531,523.3903,1097.9531,524.5653,1087.9531,523.376,1077.9531,523.4597,1067.9531,524.04,1057.9531,524.0283,1047.9531,523.5072,1037.9531,524.4137,1027.9531,524.1089,1017.9531,524.7267,1007.9531,524.6671,997.9531,523.5517,987.9531,523.6021,977.9531,523.8708,967.9531,524.3555,957.9531,524.403,947.9531,524.3012,937.9531,523.658,927.9531,524.6364,917.9531,524.6338,907.9531,523.9527,897.9531,523.7609,887.9531,523.5986,877.9531,523.7854,867.9531,524.1374,857.9531,523.9316,847.9531,523.5822,837.9531,524.4874,827.9531,523.5411,817.9531,524.5024,807.9531,524.4272,797.9531,524.3719,787.9531,524.6925,777.9531,523.7541,767.9531,523.6994,757.9531,524.5189,747.9531,523.4031,737.9531,523.766,727.9531,524.1155,717.9531,524.0687,707.9531,523.6415,697.9531,523.957,687.9531,524.7446,677.9531,524.6485,667.9531,523.4037,657.9531,524.0785,647.9531,523.4861,637.9531,523.9737,627.9531,524.293,617.9531,524.4199,607.9531,523.3353,597.9531,524.4005,587.9531,524.0084,577.9531,523.4447,567.9531,523.5289,557.9531,524.3266,547.9531,524.2499,537.9531,523.9836,527.9531,523.3279,517.9531,524.6581,507.9531,523.6882,497.9531,523.4719,487.9531,523.9327,477.9531,524.5897,467.9531,524.6154,457.9531,524.0351,447.9531,523.8488,437.9531,524.1698,427.9531,524.1862,417.9531,523.4922,407.9531,524.414,397.9531,524.5588,387.9531,523.7842,377.9531,523.5708,367.9531,524.6746,357.9531,524.021,347.9531,523.9998,337.9531,524.299,327.9531,523.3543,317.9531,524.53,307.9531,523.9846,297.9531,524.6688,287.9531,523.7841,277.9531,524.409,267.9531,523.556,257.9531,524.245,247.9531,524.3793,237.9531,523.6727,227.9531,524.363,217.9531,523.4286,207.9531,523.5295,197.9531,524.6828,187.9531,524.6844,177.9531,524.5685,167.9531,523.6396,157.9531,524.3842,147.9531,523.5279,137.9531,524.0582,127.9531,523.9987,117.9531,523.7376,107.9531,524.6159,97.9531,524.4433,87.9531,523.6792,77.9531,524.5266,67.9531,524.0919,57.9531,523.4164,47.9531,523.7667,37.9531,524,27.9531" style="stroke:#444444;stroke-width:1.0;stroke-dasharray:7.0,7.0;"/><text fill="#444444" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="158" x="565" y="44.8047">Social Care (AWS)</text><text fill="#444444" font-family="Comic Sans MS" font-size="12" lengthAdjust="spacing" textLength="55" x="616.5" y="59.7168">[System]</text><!--MD5=[4b8ff0ae24b06888b09e088f894ada77]
entity gform--><polygon fill="#999999" points="29,595.9531,29,596.1633,38.7333,595.5388,48.4667,596.1464,58.2,596.3528,67.9333,595.2397,77.6667,595.8754,87.4,595.5266,97.1333,595.5696,106.8667,595.885,116.6,595.2618,126.3333,596.5068,136.0667,595.3228,145.8,595.7554,155.5333,596.3851,165.2667,595.8673,175,595.9531,175.0682,595.9531,174.9681,606.1272,175.1785,616.3013,175.2391,626.4754,175.5857,636.6496,175.6711,646.8237,175.6793,656.9978,175,667.1719,175,667.4265,165.2667,667.6355,155.5333,667.8741,145.8,666.4507,136.0667,667.8504,126.3333,666.8754,116.6,667.7057,106.8667,666.6769,97.1333,667.1034,87.4,667.9135,77.6667,667.1231,67.9333,667.2772,58.2,667.5105,48.4667,667.5881,38.7333,667.168,29,667.1719,29.2872,667.1719,28.4276,656.9978,29.2844,646.8237,29.5482,636.6496,29.4445,626.4754,29.613,616.3013,28.5169,606.1272,29,595.9531" style="stroke:#8A8A8A;stroke-width:1.5;"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="112" x="46" y="620.8047">Google Form</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="104" y="637.5732"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="122" x="43" y="653.8701">filled in by referrer</text><!--MD5=[e15485026dee7db80668b1f02f7f495b]
entity gscript--><polygon fill="#999999" points="132.5,1021.4531,132.5,1021.6633,142.25,1021.0388,152,1021.6464,161.75,1021.8528,171.5,1020.7397,181.25,1021.3754,191,1021.0266,200.75,1021.0696,210.5,1021.385,220.25,1020.7618,230,1022.0068,239.75,1020.8228,249.5,1021.2554,259.25,1021.8851,269,1021.3673,278.75,1021.5214,288.5,1021.4212,298.25,1021.6317,308,1021.6923,317.75,1022.0388,327.5,1021.4531,328.1711,1021.4531,328.1793,1031.1771,327.7546,1040.901,327.9636,1050.625,328.2022,1060.349,326.7788,1070.0729,328.1785,1079.7969,327.2035,1089.5208,328.0338,1099.2448,327.5,1108.9688,327.5,1108.4737,317.75,1108.9003,308,1109.7104,298.25,1108.92,288.5,1109.0741,278.75,1109.3074,269,1109.385,259.25,1108.9648,249.5,1109.256,239.75,1108.3963,230,1109.2531,220.25,1109.5169,210.5,1109.4133,200.75,1109.5818,191,1108.4857,181.25,1108.3166,171.5,1108.3473,161.75,1108.9099,152,1108.7722,142.25,1109.6502,132.5,1108.9688,132.3253,1108.9688,132.1569,1099.2448,132.7283,1089.5208,131.8332,1079.7969,131.9809,1070.0729,133.149,1060.349,132.9357,1050.625,133.2345,1040.901,132.1782,1031.1771,132.5,1021.4531" style="stroke:#8A8A8A;stroke-width:1.5;"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="119" x="170.5" y="1046.3047">Google Script</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="232" y="1063.0732"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="167" x="146.5" y="1079.3701">triggered by new row on</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="95" x="182.5" y="1095.667">Google Sheet</text><!--MD5=[b879284a20cf8a89874e1551f926a403]
entity gsheet--><polygon fill="#999999" points="84,802.4531,84,802.6633,94.1176,802.0388,104.2353,802.6464,114.3529,802.8528,124.4706,801.7397,134.5882,802.3754,144.7059,802.0266,154.8235,802.0696,164.9412,802.385,175.0588,801.7618,185.1765,803.0068,195.2941,801.8228,205.4118,802.2554,215.5294,802.8851,225.6471,802.3673,235.7647,802.5214,245.8824,802.4212,256,802.4531,256.1785,802.4531,256.2391,812.6272,256.5857,822.8013,256.6711,832.9754,256.6793,843.1496,256.2546,853.3237,256.4636,863.4978,256,873.6719,256,874.3741,245.8824,872.9507,235.7647,874.3504,225.6471,873.3754,215.5294,874.2057,205.4118,873.1769,195.2941,873.6034,185.1765,874.4135,175.0588,873.6231,164.9412,873.7772,154.8235,874.0105,144.7059,874.0881,134.5882,873.668,124.4706,873.9591,114.3529,873.0995,104.2353,873.9563,94.1176,874.2201,84,873.6719,84.4445,873.6719,84.613,863.4978,83.5169,853.3237,83.3478,843.1496,83.3786,832.9754,83.9411,822.8013,83.8035,812.6272,84,802.4531" style="stroke:#8A8A8A;stroke-width:1.5;"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="119" x="110.5" y="827.3047">Google Sheet</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="172" y="844.0732"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="148" x="98" y="860.3701">form submission data</text><!--MD5=[030f0568401b93fc2546ca7381717dea]
entity gdoc--><polygon fill="#999999" points="210.5,595.9531,210.5,596.1633,220.5833,595.5388,230.6667,596.1464,240.75,596.3528,250.8333,595.2397,260.9167,595.8754,271,595.5266,281.0833,595.5696,291.1667,595.885,301.25,595.2618,311.3333,596.5068,321.4167,595.3228,331.5,595.9531,331.3022,595.9531,331.9319,606.1272,331.4142,616.3013,331.5682,626.4754,331.4681,636.6496,331.6785,646.8237,331.7391,656.9978,331.5,667.1719,331.5,667.7576,321.4167,667.8429,311.3333,667.8511,301.25,667.4265,291.1667,667.6355,281.0833,667.8741,271,666.4507,260.9167,667.8504,250.8333,666.8754,240.75,667.7057,230.6667,666.6769,220.5833,667.1034,210.5,667.1719,211.2416,667.1719,210.4513,656.9978,210.6053,646.8237,210.8386,636.6496,210.9162,626.4754,210.4961,616.3013,210.7872,606.1272,210.5,595.9531" style="stroke:#8A8A8A;stroke-width:1.5;"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="101" x="220.5" y="620.8047">Google Doc</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="273" y="637.5732"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="71" x="237.5" y="653.8701">document</text><!--MD5=[27f03d1005842210d54266b6b13a4e72]
entity aws_s3--><polygon fill="#438DD5" points="559,254.9531,559,255.1633,568.8824,254.5388,578.7647,255.1464,588.6471,255.3528,598.5294,254.2397,608.4118,254.8754,618.2941,254.5266,628.1765,254.5696,638.0588,254.885,647.9412,254.2618,657.8235,255.5068,667.7059,254.3228,677.5882,254.7554,687.4706,255.3851,697.3529,254.8673,707.2353,255.0214,717.1176,254.9212,727,254.9531,727.1785,254.9531,727.2391,265.4719,727.5857,275.9906,727.6711,286.5094,727.6793,297.0281,727,307.5469,727,307.8015,717.1176,308.0105,707.2353,308.2491,697.3529,306.8257,687.4706,308.2254,677.5882,307.2504,667.7059,308.0807,657.8235,307.0519,647.9412,307.4784,638.0588,308.2885,628.1765,307.4981,618.2941,307.6522,608.4118,307.8855,598.5294,307.9631,588.6471,307.543,578.7647,307.8341,568.8824,306.9745,559,307.5469,559.2844,307.5469,559.5482,297.0281,559.4445,286.5094,559.613,275.9906,558.5169,265.4719,559,254.9531" style="stroke:#3C7FC0;stroke-width:1.5;"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="69" x="608.5" y="279.8047">AWS S3</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="12" font-style="italic" lengthAdjust="spacing" textLength="148" x="569" y="294.7168">[object storage service]</text><!--MD5=[58d6fe77a513a93e457ba915868afe75]
entity aws_SQS--><polygon fill="#438DD5" points="540.5,383.9531,540.5,384.1633,550.3571,383.5388,560.2143,384.1464,570.0714,384.3528,579.9286,383.2397,589.7857,383.8754,599.6429,383.5266,609.5,383.5696,619.3571,383.885,629.2143,383.2618,639.0714,384.5068,648.9286,383.3228,658.7857,383.7554,668.6429,384.3851,678.5,383.8673,688.3571,384.0214,698.2143,383.9212,708.0714,384.1317,717.9286,384.1923,727.7857,384.5388,737.6429,384.6242,747.5,383.9531,748.1793,383.9531,747.7546,393.4184,747.9636,402.8837,748.2022,412.349,746.7788,421.8142,748.1785,431.2795,747.2035,440.7448,748.0338,450.2101,747.005,459.6753,747.5,469.1406,747.5,469.0721,737.6429,469.8822,727.7857,469.0919,717.9286,469.2459,708.0714,469.4793,698.2143,469.5569,688.3571,469.1367,678.5,469.4278,668.6429,468.5682,658.7857,469.425,648.9286,469.6888,639.0714,469.5852,629.2143,469.7536,619.3571,468.6575,609.5,468.4884,599.6429,468.5192,589.7857,469.0817,579.9286,468.9441,570.0714,469.822,560.2143,468.9659,550.3571,468.7976,540.5,469.1406,540.7283,469.1406,539.8332,459.6753,539.9809,450.2101,541.149,440.7448,540.9357,431.2795,541.2345,421.8142,540.1782,412.349,540.8192,402.8837,541.0904,393.4184,540.5,383.9531" style="stroke:#3C7FC0;stroke-width:1.5;"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="83" x="602.5" y="408.8047">AWS SQS</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="12" font-style="italic" lengthAdjust="spacing" textLength="167" x="560.5" y="423.7168">[message queuing service]</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="646" y="439.542"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="183" x="554.5" y="455.8389">Creates a message queue</text><!--MD5=[f9af842696453729b2ea1787ecca78d6]
entity aws_lambda--><polygon fill="#438DD5" points="560.5,604.9531,560.5,605.1633,570.1429,604.5388,579.7857,605.1464,589.4286,605.3528,599.0714,604.2397,608.7143,604.8754,618.3571,604.5266,628,604.5696,637.6429,604.885,647.2857,604.2618,656.9286,605.5068,666.5714,604.3228,676.2143,604.7554,685.8571,605.3851,695.5,604.9531,695.4142,604.9531,695.5682,615.4719,695.4681,625.9906,695.6785,636.5094,695.7391,647.0281,695.5,657.5469,695.5,658.1326,685.8571,658.2179,676.2143,658.2261,666.5714,657.8015,656.9286,658.0105,647.2857,658.2491,637.6429,656.8257,628,658.2254,618.3571,657.2504,608.7143,658.0807,599.0714,657.0519,589.4286,657.4784,579.7857,658.2885,570.1429,657.4981,560.5,657.5469,560.6053,657.5469,560.8386,647.0281,560.9162,636.5094,560.4961,625.9906,560.7872,615.4719,560.5,604.9531" style="stroke:#3C7FC0;stroke-width:1.5;"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="115" x="570.5" y="629.8047">AWS Lambda</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="12" font-style="italic" lengthAdjust="spacing" textLength="60" x="598" y="644.7168">[Lambda]</text><!--MD5=[14700f941117e1460a0310c6ed983dfa]
entity social_care_service_api--><polygon fill="#438DD5" points="540.5,769.9531,540.5,770.1633,550.4474,769.5388,560.3947,770.1464,570.3421,770.3528,580.2895,769.2397,590.2368,769.8754,600.1842,769.5266,610.1316,769.5696,620.0789,769.885,630.0263,769.2618,639.9737,770.5068,649.9211,769.3228,659.8684,769.7554,669.8158,770.3851,679.7632,769.8673,689.7105,770.0214,699.6579,769.9212,709.6053,770.1317,719.5526,770.1923,729.5,769.9531,730.0857,769.9531,730.1711,779.6964,730.1793,789.4397,729.7546,799.183,729.9636,808.9263,730.2022,818.6696,728.7788,828.4129,730.1785,838.1563,729.2035,847.8996,730.0338,857.6429,729.005,867.3862,729.4315,877.1295,730.2416,886.8728,729.4513,896.6161,729.5,906.3594,729.5,906.4647,719.5526,906.698,709.6053,906.7756,699.6579,906.3555,689.7105,906.6466,679.7632,905.787,669.8158,906.6438,659.8684,906.9076,649.9211,906.8039,639.9737,906.9724,630.0263,905.8763,620.0789,905.7072,610.1316,905.738,600.1842,906.3005,590.2368,906.1628,580.2895,907.0408,570.3421,906.1847,560.3947,906.0163,550.4474,906.5876,540.5,906.3594,539.8332,906.3594,539.9809,896.6161,541.149,886.8728,540.9357,877.1295,541.2345,867.3862,540.1782,857.6429,540.8192,847.8996,541.0904,838.1563,540.0276,828.4129,540.4041,818.6696,540.626,808.9263,541.1518,799.183,540.4958,789.4397,540.9626,779.6964,540.5,769.9531" style="stroke:#3C7FC0;stroke-width:1.5;"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="146" x="559" y="794.8047">Social Care Case</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="97" x="586.5" y="813.4297">Viewer API</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="12" font-style="italic" lengthAdjust="spacing" textLength="86" x="592" y="828.3418">[Lambda, C#]</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="637" y="844.167"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="137" x="566.5" y="860.4639">Provides service API</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="165" x="550.5" y="876.7607">capabilities to the Social</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="91" x="589.5" y="893.0576">Care System.</text><!--MD5=[6c5f5d14eff0125482ffa12bfc7089db]
entity service_api_api_gateway--><polygon fill="#438DD5" points="540.5,78.9531,540.5,79.1633,550.2619,78.5388,560.0238,79.1464,569.7857,79.3528,579.5476,78.2397,589.3095,78.8754,599.0714,78.5266,608.8333,78.5696,618.5952,78.885,628.3571,78.2618,638.119,79.5068,647.881,78.3228,657.6429,78.7554,667.4048,79.3851,677.1667,78.8673,686.9286,79.0214,696.6905,78.9212,706.4524,79.1317,716.2143,79.1923,725.9762,79.5388,735.7381,79.6242,745.5,78.9531,746.1793,78.9531,745.7546,89.1016,745.9636,99.25,746.2022,109.3984,744.7788,119.5469,746.1785,129.6953,745.2035,139.8438,746.0338,149.9922,745.005,160.1406,745.4315,170.2891,745.5,180.4375,745.5,181.1791,735.7381,180.3888,725.9762,180.5428,716.2143,180.7761,706.4524,180.8537,696.6905,180.4336,686.9286,180.7247,677.1667,179.8651,667.4048,180.7219,657.6429,180.9857,647.881,180.882,638.119,181.0505,628.3571,179.9544,618.5952,179.7853,608.8333,179.8161,599.0714,180.3786,589.3095,180.241,579.5476,181.1189,569.7857,180.2628,560.0238,180.0944,550.2619,180.6658,540.5,180.4375,539.8332,180.4375,539.9809,170.2891,541.149,160.1406,540.9357,149.9922,541.2345,139.8438,540.1782,129.6953,540.8192,119.5469,541.0904,109.3984,540.0276,99.25,540.4041,89.1016,540.5,78.9531" style="stroke:#3C7FC0;stroke-width:1.5;"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="142" x="572" y="103.8047">SC API Gateway</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="12" font-style="italic" lengthAdjust="spacing" textLength="88" x="599" y="118.7168">[API Gateway]</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="645" y="134.542"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="177" x="554.5" y="150.8389">Provides routing and auth</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="83" x="601.5" y="167.1357">via API keys.</text><!--MD5=[54aebe15b87ad3d042ed2f1804921f7c]
entity service_api_rds--><path d="M549,1018.9531 L549,1018.9531 L549.0369,1019.0389 L551.6147,1017.6277 L554.409,1016.7195 L557.1327,1015.6475 L559.6247,1014.0369 L562.4375,1013.1719 L562.4331,1013.1376 L565.1679,1012.6284 L567.9251,1012.2919 L570.6977,1012.0754 L573.4169,1011.4453 L576.2109,1011.3945 L576.2295,1011.6399 L579.3477,1010.8769 L582.5199,1010.8303 L585.6988,1010.8711 L588.8393,1010.4034 L592,1010.2031 L592.0014,1010.2334 L595.1572,1010.0444 L598.3193,1009.9933 L601.4783,1009.8757 L604.6432,1009.885 L607.7891,1009.4805 L607.7971,1009.7786 L610.5519,1009.708 L613.3015,1009.4452 L616.0587,1009.4638 L618.8162,1009.4956 L621.5625,1009.1094 L621.5588,1008.7889 L624.2535,1009.3797 L626.936,1008.9151 L629.6278,1009.2529 L632.3099,1008.7644 L635,1008.9531 L635,1008.9531 L634.9996,1008.9227 L637.6913,1009.314 L640.3747,1008.994 L643.063,1009.0937 L645.7517,1009.2286 L648.4375,1009.1094 L648.4425,1009.2943 L651.1921,1009.1819 L653.9503,1009.3854 L656.6947,1009.0777 L659.4597,1009.5326 L662.2109,1009.4805 L662.2221,1009.7239 L665.3778,1009.8224 L668.539,1010.0417 L671.6746,1009.6996 L674.8289,1009.769 L678,1010.2031 L677.9792,1009.9277 L681.1558,1010.4153 L684.3091,1010.5926 L687.4962,1011.22 L690.6254,1011.0788 L693.7891,1011.3945 L693.7695,1011.2433 L696.5567,1011.8506 L699.2605,1011.8115 L702.0236,1012.2321 L704.8447,1013.1025 L707.5625,1013.1719 L707.639,1013.3497 L710.379,1014.628 L712.881,1015.353 L715.6811,1016.7709 L718.4162,1018.0379 L721,1018.9531 L719.7403,1018.9531 L720.7444,1029.2656 L721.336,1039.5781 L722.738,1049.8906 L720.9888,1060.2031 L722.2335,1070.5156 L719.5232,1080.8281 L719.194,1091.1406 L722.343,1101.4531 L721,1111.7656 L721,1111.7656 L720.8741,1111.4729 L718.4019,1113.1297 L715.6613,1114.1625 L712.8904,1115.125 L710.1879,1116.2462 L707.5625,1117.5469 L707.5886,1117.7491 L704.7908,1117.7704 L702.0868,1118.5187 L699.267,1118.3696 L696.5789,1119.2409 L693.7891,1119.3242 L693.8053,1119.5389 L690.6394,1119.6711 L687.475,1119.8217 L684.3399,1120.3611 L681.1783,1120.5493 L678,1120.5156 L678.0034,1120.5908 L674.8476,1120.7792 L671.6817,1120.7469 L668.5411,1121.2673 L665.3719,1121.1625 L662.2109,1121.2383 L662.213,1121.315 L659.449,1121.0422 L656.6967,1121.2067 L653.9532,1121.6967 L651.1973,1121.7261 L648.4375,1121.6094 L648.4373,1121.5903 L645.7483,1121.4974 L643.0614,1121.5746 L640.3715,1121.3982 L637.6896,1121.9187 L635,1121.7656 L635,1121.7656 L635.0038,1122.0943 L632.3152,1121.9683 L629.6286,1122.012 L626.9368,1121.6111 L624.2505,1121.6794 L621.5625,1121.6094 L621.5579,1121.4372 L618.8112,1121.6614 L616.0561,1121.5706 L613.305,1121.6321 L610.541,1121.2105 L607.7891,1121.2383 L607.7863,1121.1786 L604.6403,1121.2906 L601.485,1121.2011 L598.3052,1120.5771 L595.1539,1120.5741 L592,1120.5156 L592.005,1120.5818 L588.8218,1120.0066 L585.6962,1120.1957 L582.5352,1119.9151 L579.3654,1119.5178 L576.2109,1119.3242 L576.219,1119.3869 L573.4977,1119.2899 L570.6838,1118.4754 L567.9648,1118.3967 L565.2084,1118.0283 L562.4375,1117.5469 L562.4578,1117.5941 L559.7748,1116.4482 L557.0824,1115.2807 L554.2654,1113.8233 L551.6171,1112.7582 L549,1111.7656 L547.7692,1111.7656 L549.1702,1101.4531 L549.235,1091.1406 L549.4313,1080.8281 L548.2241,1070.5156 L548.82,1060.2031 L548.6794,1049.8906 L550.5383,1039.5781 L550.1375,1029.2656 L549,1018.9531 " fill="#438DD5" style="stroke:#3C7FC0;stroke-width:1.5;"/><path d="M549,1018.9531 L549,1018.9531 L549.0369,1019.0389 L551.6147,1019.9402 L554.409,1021.3445 L557.1327,1022.585 L559.6247,1023.2869 L562.4375,1024.7344 L562.4331,1024.7001 L565.1679,1024.9018 L567.9251,1025.2763 L570.6977,1025.7707 L573.4169,1025.8515 L576.2109,1026.5117 L576.2295,1026.7571 L579.3477,1026.4707 L582.5199,1026.9006 L585.6988,1027.418 L588.8393,1027.4268 L592,1027.7031 L592.0014,1027.7334 L595.1572,1027.8335 L598.3193,1028.0714 L601.4783,1028.2429 L604.6432,1028.5413 L607.7891,1028.4258 L607.7971,1028.7239 L610.5519,1028.8018 L613.3015,1028.6873 L616.0587,1028.8544 L618.8162,1029.0346 L621.5625,1028.7969 L621.5588,1028.4764 L624.2535,1029.1297 L626.936,1028.7276 L629.6278,1029.1279 L632.3099,1028.7019 L635,1028.9531 L635,1028.9531 L634.9996,1028.9227 L637.6913,1029.2515 L640.3747,1028.869 L643.063,1028.9062 L645.7517,1028.9786 L648.4375,1028.7969 L648.4425,1028.9818 L651.1921,1028.7209 L653.9503,1028.776 L656.6947,1028.3199 L659.4597,1028.6263 L662.2109,1028.4258 L662.2221,1028.6692 L665.3778,1028.4786 L668.539,1028.4089 L671.6746,1027.7777 L674.8289,1027.5581 L678,1027.7031 L677.9792,1027.4277 L681.1558,1027.4387 L684.3091,1027.1395 L687.4962,1027.2903 L690.6254,1026.6726 L693.7891,1026.5117 L693.7695,1026.3605 L696.5567,1026.2569 L699.2605,1025.5068 L702.0236,1025.2165 L704.8447,1025.3759 L707.5625,1024.7344 L707.639,1024.9122 L710.379,1023.878 L712.881,1022.2905 L715.6811,1021.3959 L718.4162,1020.3504 L721,1018.9531 " fill="none" style="stroke:#3C7FC0;stroke-width:1.5;"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="146" x="559" y="1047.8047">Social Care Case</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="92" x="589" y="1066.4297">Viewer DB</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="12" font-style="italic" lengthAdjust="spacing" textLength="69" x="600.5" y="1081.3418">[MongoDB]</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="637" y="1097.167"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="89" x="592.5" y="1113.4639">Data storage</text><!--MD5=[5f2f9dbbee692058d60489180693f774]
entity users--><polygon fill="#08427B" points="54,382.9531,54,383.1633,63.6,382.5388,73.2,383.1464,82.8,383.3528,92.4,382.2397,102,382.8754,111.6,382.5266,121.2,382.5696,130.8,382.885,140.4,382.2618,150,382.9531,150.5536,382.9531,149.3697,392.5781,149.8022,402.2031,150.4319,411.8281,149.9142,421.4531,150.0682,431.0781,149.9681,440.7031,150.1785,450.3281,150.2391,459.9531,150,469.5781,150,470.1638,140.4,470.2492,130.8,470.2574,121.2,469.8328,111.6,470.0417,102,470.2804,92.4,468.8569,82.8,470.2566,73.2,469.2816,63.6,470.1119,54,469.5781,53.505,469.5781,53.9315,459.9531,54.7416,450.3281,53.9513,440.7031,54.1053,431.0781,54.3386,421.4531,54.4162,411.8281,53.9961,402.2031,54.2872,392.5781,54,382.9531" style="stroke:#073B6F;stroke-width:1.5;"/><image height="48" width="48" x="78" xlink:href="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAIAAADYYG7QAAACD0lEQVR4Xu2YoU4EMRCGT+4j8Ai8AhaH4QHgAUjQuFMECUgMIUgwJAgMhgQsAYUiJCiQIBBY+EITsjfTdme6V24v4c8vyGbb+ZjOtN0bNcvjQXmkH83WvYBWto6PLm6v7p7uH1/w2fXD+PBycX1Pv2l3IdDm/vn7x+dXQiAubRzoURa7gRZWd0iGRIiJbOnhnfYBQZNJjNbuyY2eJG8fkDE3bbG4ep6MHUAsgYxmE3nVs6VsBWJSGccsOlFPmLIViMzLOB7pCVO2AtHJMohH7Fh6zqitQK7m0rJvAVYgGcEpe//PLdDz65sM4pF9N7ICcXDKIB5Nv6j7tD0NoSdM2QrU9Gg0ewE1LqBhHR3BBdvj2vapnidjHxD/q6vd7Pvhr31AwcY8eXMTXAKECZZJFXuEq27aLgQK5uLMohCenGGuGewOxSjBvYBqeG6B+Nqiblggdjnc+ZXDy+FNFpFzw76O3UBAROuXh6FoiAcf5g9eTvUgzy0nWg6I8cXHRUpg5bOVBCo+KDpFajOf23GgPme7RSQ+lacIENUgJ6gg1k6HjgOlqnLqip4tEuhv0hNEMXUD0clyXE3p6pZA0S2nnvTlXwLJEZWlb7cTQH1+USgTN4VhAenm/wea1OCAOmqo6fE1WCb9WSKBah+rbUWPWAmE2Rvk0ApiB45eOyNAzU8xcTvj8KvkKEoOaIYeHNA3ZuygAvFMUO0AAAAASUVORK5CYII=" y="392.9531"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="16" font-weight="bold" lengthAdjust="spacing" textLength="76" x="64" y="455.8047">Referrer</text><!--MD5=[7566e6a0020db946438df3591ecd4330]
link users to gform--><path d="M102,470.0131 L102.2802,470.0131 L101.4476,479.8173 L102.2577,489.6215 L102.5329,499.4256 L101.0488,509.2298 L101.8964,519.034 L101.4313,528.8381 L101.4887,538.6423 L101.9091,548.4465 L101.0782,558.2506 L102.7382,568.0548 L101.1596,577.859 L102,587.6631 " fill="none" style="stroke:#666666;stroke-width:1.0;"/><polygon fill="#666666" points="102,595.7131,102.0656,595.7377,102.4707,594.0646,103.2603,592.5357,103.9247,590.9599,104.1773,589.2296,105,587.7131,105,587.6872,103.8,587.571,102.6,587.5853,101.4,587.6904,100.2,587.4827,99,587.7131,99.1728,587.7779,99.4033,589.2394,100.1383,590.89,100.9348,592.5637,101.3732,594.1031,102,595.7131" style="stroke:#666666;stroke-width:1.0;"/><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="108" x="103" y="519.0918">Fill in a referral</text><!--MD5=[67faf09482cc2c83277ea095b906151a]
link gform to gsheet--><path d="M113.54,667.1431 L113.8059,667.2315 L116.2766,676.7773 L120.3061,686.8413 L123.828,696.7366 L125.6805,706.0769 L129.7455,716.1527 L132.565,725.8145 L135.8802,735.641 L139.5399,745.5821 L142.0122,755.1285 L146.8482,765.4606 L148.611,774.7711 L152.419,784.7615 L155.93,794.6531 " fill="none" style="stroke:#666666;stroke-width:1.0;"/><polygon fill="#666666" points="158.52,802.4331,158.59,802.4358,158.4481,800.7203,158.7167,799.0206,158.8516,797.3157,158.5469,795.5938,158.8507,793.8955,158.8426,793.8709,157.6669,794.1381,156.5324,794.5293,155.4264,795.0066,154.222,795.1869,153.1554,795.7832,153.299,795.8991,154.0648,796.9813,155.2499,798.4018,156.4862,799.8636,157.4248,801.0852,158.52,802.4331" style="stroke:#666666;stroke-width:1.0;"/><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="119" x="142.5" y="716.0918">Form submission</text><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-style="italic" lengthAdjust="spacing" textLength="130" x="137" y="730.0605">[Google automation]</text><!--MD5=[eb8a92dfc9539a04ecdb65b545b22041]
link gsheet to gscript--><path d="M109.86,873.5531 L109.9154,873.6283 L106.8315,875.5569 L104.0724,877.9263 L101.2076,880.1521 L97.9948,881.9059 L95.2637,884.3131 L95.2413,884.2868 L92.3624,886.5219 L89.596,888.8898 L86.9079,891.3501 L83.9501,893.4921 L81.37,896.08 L81.5452,896.2527 L78.6832,898.4064 L76.3327,901.0644 L74.0446,903.784 L71.3934,906.1455 L68.9332,908.6953 L68.9572,908.7138 L66.8768,911.3477 L64.9058,914.0658 L62.8821,916.7433 L60.959,919.4982 L58.7075,922.0006 L58.9716,922.1392 L57.5227,924.9083 L55.9036,927.588 L54.5337,930.3985 L53.1756,933.2151 L51.4471,935.8375 L51.1361,935.76 L51.0316,938.7524 L49.9029,941.4896 L49.5528,944.4209 L48.4009,947.1523 L47.9063,950.0475 L47.8759,950.0455 L48.4217,952.9537 L48.2578,955.816 L48.5127,958.7053 L48.8028,961.597 L48.8391,964.4722 L49.0094,964.5446 L50.0697,967.3677 L51.4209,970.3145 L52.3016,973.0612 L53.8841,976.1064 L55,978.9531 L55.1998,979.0925 L56.4631,980.931 L57.8257,982.8387 L58.7273,984.4249 L59.9668,986.2467 L61.5056,988.2774 L61.2954,988.0983 L62.9581,989.9884 L64.384,991.6766 L66.1534,993.6576 L67.3363,995.1388 L68.8678,996.917 L68.7609,996.8083 L70.5611,998.5853 L71.9043,999.8977 L73.5725,1001.5405 L75.5587,1003.5065 L76.9786,1004.8969 L77.1031,1005.0452 L78.9388,1006.6159 L80.3872,1007.7253 L82.3207,1009.4125 L84.1484,1010.9739 L85.73,1012.2419 L85.6067,1012.0719 L87.5618,1013.5544 L89.4764,1014.9813 L91.4704,1016.5174 L93.156,1017.6285 L95.0139,1018.9771 L95.1239,1019.1507 L96.8238,1019.9992 L98.7361,1021.1829 L100.9586,1022.8563 L102.61,1023.6281 L104.7222,1025.1273 L104.8324,1025.3249 L106.7719,1026.3256 L108.6741,1027.2595 L110.6604,1028.3442 L112.8413,1029.7777 L114.7469,1030.7177 L114.688,1030.5984 L116.91,1031.9646 L118.7313,1032.5196 L121.0083,1033.997 L123.0287,1034.955 L124.98,1035.7731 " fill="none" style="stroke:#666666;stroke-width:1.0;"/><polygon fill="#666666" points="132.36,1039.0731,132.4093,1039.1229,131.0481,1037.7731,129.9759,1036.7152,128.8096,1035.5623,127.3339,1034.0966,126.2864,1033.0638,126.2628,1033.0532,125.6659,1034.1008,125.1883,1035.2017,124.7935,1036.3397,124.1131,1037.3499,123.8327,1038.5392,123.8442,1038.7234,125.525,1038.4363,127.2395,1038.687,128.9581,1039.0032,130.6528,1038.9378,132.36,1039.0731" style="stroke:#666666;stroke-width:1.0;"/><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="119" x="61.5" y="955.0918">Form submission</text><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-style="italic" lengthAdjust="spacing" textLength="130" x="56" y="969.0605">[Google automation]</text><!--MD5=[3b18b287fc915950472c63cebb013368]
link gscript to gsheet--><path d="M218.48,1021.1731 L218.7508,1021.2452 L215.2947,1011.0661 L213.4262,1001.3094 L211.0407,991.4152 L206.9551,981.0685 L205.1227,971.3215 L202.0219,961.2369 L199.4259,951.2866 L197.1808,941.4298 L193.7263,931.2511 L192.6791,921.7129 L188.5022,911.342 L186.408,901.5253 L184.568,891.7762 L181.36,881.6631 " fill="none" style="stroke:#666666;stroke-width:1.0;"/><polygon fill="#666666" points="179.24,873.6931,179.3097,873.7001,178.9335,875.3799,178.966,877.1003,178.8654,878.8076,178.3272,880.4713,178.3948,882.1952,178.3881,882.1702,179.518,881.7497,180.6815,881.4554,181.8682,881.2489,182.9747,880.74,184.1936,880.6546,184.344,880.7616,183.0317,879.1405,182.1585,877.8318,181.3388,876.5612,180.2074,875.0688,179.24,873.6931" style="stroke:#666666;stroke-width:1.0;"/><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="118" x="213" y="948.0918">Update row with</text><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="67" x="240.5" y="962.0605">unique ID</text><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-style="italic" lengthAdjust="spacing" textLength="130" x="209" y="976.0293">[Google automation]</text><!--MD5=[0ee2777490c29ab23322e271da674e05]
link gscript to service_api_api_gateway--><path d="M305.93,1021.3031 L305.9885,1021.3759 L308.1497,1019.2818 L310.654,1017.6145 L313.0465,1015.8082 L315.0716,1013.5449 L317.6053,1011.9142 L317.582,1011.8888 L319.7016,1009.7331 L321.9389,1007.7057 L324.2581,1005.7675 L326.2953,1003.522 L328.7275,1001.7069 L328.9076,1001.8746 L330.5707,999.3166 L332.7596,997.2483 L335.0126,995.2397 L336.8924,992.8835 L338.9684,990.7102 L338.9925,990.7286 L340.7635,988.3501 L342.644,986.0557 L344.4717,983.7207 L346.4001,981.4631 L348,978.9531 L348.2481,979.1187 L349.5339,977.1982 L350.6598,975.1709 L352.0198,973.3 L353.3909,971.4364 L354.4141,969.3406 L354.1423,969.1708 L355.7951,967.6998 L356.5529,965.6695 L357.9912,964.0645 L358.7287,962.0215 L360.0406,960.3375 L360.0139,960.3229 L362.1491,957.1755 L363.6604,953.6863 L365.5398,950.3989 L367.4501,947.1283 L369.1375,943.7356 L369.3077,943.808 L370.449,940.6478 L371.8812,937.6113 L372.8428,934.3747 L374.5063,931.4366 L375.7031,928.3 L375.9369,928.3688 L376.782,925.3324 L377.7433,922.3301 L378.1653,919.1693 L378.9825,916.1247 L380.15,913.1831 L379.878,913.1355 L380.6723,910.0495 L381.1602,906.9098 L382.0927,903.848 L382.266,900.6532 L382.8906,897.5375 L382.7387,897.5246 L383.2811,894.1417 L383.1741,890.7036 L383.5289,887.3048 L384.3355,883.9444 L384.3375,880.5156 L384.531,880.5213 L384.7769,876.6761 L384.4208,872.8132 L384.8187,868.9724 L385.0523,865.1268 L384.9031,861.27 L384.6932,861.2691 L384.8799,856.8064 L384.9979,852.3435 L385.2509,847.8811 L384.9788,843.4165 L385,838.9531 L385.6168,838.9531 L384.2616,828.9799 L384.097,819.0067 L385.6715,809.0335 L384.0441,799.0603 L385.6786,789.0871 L385.2755,779.1138 L384.6428,769.1406 L384.5283,759.1674 L385.6117,749.1942 L384.6009,739.221 L385.7891,729.2478 L384.263,719.2746 L385.8232,709.3013 L385.6457,699.3281 L385.3266,689.3549 L385.063,679.3817 L385.9688,669.4085 L385.8181,659.4353 L385.2257,649.4621 L385.3576,639.4888 L384.8263,629.5156 L385.9553,619.5424 L385.2065,609.5692 L385.2301,599.596 L384.1889,589.6228 L384.4597,579.6496 L385.7077,569.6763 L385.573,559.7031 L384.9428,549.7299 L384.5704,539.7567 L384.7081,529.7835 L384.0851,519.8103 L385.553,509.8371 L385.9861,499.8638 L385.7019,489.8906 L385.9266,479.9174 L384.8177,469.9442 L385.1163,459.971 L384.4832,449.9978 L385.3787,440.0246 L385.329,430.0513 L385.7365,420.0781 L384.6938,410.1049 L384.8208,400.1317 L385.5913,390.1585 L385.7564,380.1853 L384.3166,370.2121 L384.7415,360.2388 L385.199,350.2656 L384.1855,340.2924 L385.4712,330.3192 L385.344,320.346 L384.8657,310.3728 L385.1897,300.3996 L385.9716,290.4263 L385,280.4531 L384.8613,280.4438 L385.3167,277.8205 L385.4806,275.1777 L385.5823,272.5306 L385.7704,269.8894 L385.8849,267.2432 L385.9342,267.2535 L386.1276,264.7022 L386.7392,262.2375 L387.2272,259.7472 L387.9702,257.3097 L388.4569,254.8191 L388.4938,254.8322 L389.3517,252.5108 L389.9891,250.1111 L390.9097,247.8119 L391.7147,245.4717 L392.5921,243.1572 L392.8205,243.2738 L393.8759,241.0588 L394.6297,238.6899 L395.908,236.5886 L396.8233,234.3021 L398.1667,232.2341 L398.273,232.3058 L399.7689,230.3438 L401.1234,228.2863 L402.1403,226.001 L403.8497,224.1831 L405.0568,222.0261 L404.8052,221.8124 L406.741,220.1804 L408.1881,218.1335 L409.9386,216.3441 L411.6036,214.4822 L413.1385,212.5098 L413.2844,212.6606 L414.746,210.5102 L416.9452,209.1225 L418.6832,207.2578 L420.5679,205.5448 L422.288,203.6617 L422.4976,203.9196 L424.3082,202.0228 L426.3744,200.4407 L428.4038,198.8132 L430.4179,197.1669 L432.3813,195.4581 L432.381,195.4578 L434.7441,194.201 L436.5919,192.2026 L439.0725,191.115 L440.9536,189.1644 L443.2945,187.8757 L443.1707,187.6699 L445.6255,186.494 L447.9447,185.0925 L450.1472,183.4971 L452.6767,182.4453 L454.9038,180.8908 L454.9263,180.9336 L457.4905,179.8945 L459.9145,178.5889 L462.1199,176.868 L464.5667,175.6057 L467.0853,174.48 L467.0612,174.4279 L469.6778,173.4513 L472.2126,172.2983 L474.7196,171.0852 L477.1252,169.6539 L479.7152,168.6197 L479.8228,168.8812 L482.4132,167.8135 L484.8889,166.4669 L487.4473,165.3215 L490.0107,164.1881 L492.6694,163.2864 L492.6366,163.1968 L495.3214,162.3777 L497.9209,161.3259 L500.4983,160.2142 L503.2679,159.6258 L505.8242,158.4565 L505.7605,158.2628 L508.5403,157.7987 L511.1761,156.8969 L513.8147,156.0036 L516.5055,155.269 L519.0557,154.1066 L519.0248,154.0018 L521.6547,153.1998 L524.3948,152.7704 L526.8912,151.5161 L529.5737,150.8921 L532.24,150.2131 " fill="none" style="stroke:#666666;stroke-width:1.0;"/><polygon fill="#666666" points="540.29,148.0331,540.2966,148.1029,538.5758,147.734,536.8938,147.7741,535.1992,147.6809,533.4629,147.15,531.7843,147.2251,531.7593,147.2183,531.9603,148.3464,532.2873,149.5085,532.702,150.6944,532.8146,151.7986,533.3503,153.0171,533.4579,153.167,534.6157,151.8497,536.0877,150.97,537.5981,150.1437,538.8854,149.0067,540.29,148.0331" style="stroke:#666666;stroke-width:1.0;"/><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="140" x="386" y="512.0918">Send form data and</text><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="67" x="422.5" y="526.0605">unique ID</text><!--MD5=[e70be681b23308ea1764dcfc1004fac5]
link service_api_api_gateway to aws_s3--><path d="M643,179.9831 L643.2802,179.9831 L642.4476,189.4831 L643.2577,198.9831 L643.5329,208.4831 L642.0488,217.9831 L642.8964,227.4831 L642.4313,236.9831 L643,246.4831 " fill="none" style="stroke:#666666;stroke-width:1.0;"/><polygon fill="#666666" points="643,254.5431,643.0656,254.5677,643.4707,252.8946,644.2603,251.3657,644.9247,249.7899,645.1773,248.0596,646,246.5431,646,246.5172,644.8,246.401,643.6,246.4153,642.4,246.5204,641.2,246.3127,640,246.5431,640.1728,246.6079,640.4033,248.0694,641.1383,249.72,641.9348,251.3937,642.3732,252.9331,643,254.5431" style="stroke:#666666;stroke-width:1.0;"/><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="96" x="644" y="222.0918">Forward data</text><!--MD5=[bbc1304a19436895a794e04efcc7bc47]
link aws_s3 to aws_SQS--><path d="M643.18,308.0231 L643.4602,308.0251 L642.6947,317.6764 L643.572,327.3392 L643.9143,336.9983 L642.4974,346.6451 L643.4121,356.3081 L643.0142,365.962 L643.65,375.6231 " fill="none" style="stroke:#666666;stroke-width:1.0;"/><polygon fill="#666666" points="643.71,383.8531,643.7758,383.8773,644.1689,382.2013,644.9476,380.6668,645.6007,379.0863,645.841,377.3542,646.6528,375.8319,646.6526,375.806,645.4518,375.6983,644.2519,375.7212,643.0527,375.8349,641.8513,375.6357,640.6529,375.8748,640.8253,375.9408,641.0682,377.3953,641.8142,379.0425,642.6216,380.7133,643.0719,382.2472,643.71,383.8531" style="stroke:#666666;stroke-width:1.0;"/><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="96" x="644" y="350.0918">Forward data</text><!--MD5=[f811a4eaf3f6edd8df2c972583423acf]
link aws_SQS to aws_lambda--><path d="M640.72,469.0231 L640.9994,469.0451 L639.3954,478.7974 L639.4292,488.6788 L638.9297,498.5181 L636.6764,508.2192 L636.7475,518.1034 L635.51,527.8846 L634.7933,537.7068 L634.4386,547.5575 L632.8364,557.3099 L633.7174,567.2581 L631.3699,576.9517 L631.171,586.8147 L630.66,596.6531 " fill="none" style="stroke:#666666;stroke-width:1.0;"/><polygon fill="#666666" points="630.03,604.6831,630.0935,604.7128,630.6288,603.0767,631.5362,601.6147,632.3224,600.0959,632.7103,598.3909,633.6496,596.9437,633.6476,596.9179,632.4421,596.7077,631.247,596.6276,630.0589,596.6381,628.8463,596.3366,627.6682,596.4721,627.8455,596.5231,627.9386,598.0562,628.5495,599.7383,629.2236,601.4385,629.5302,603.033,630.03,604.6831" style="stroke:#666666;stroke-width:1.0;"/><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="96" x="638" y="519.0918">Forward data</text><!--MD5=[37afce3c10749b8182214cb835e5c192]
link aws_lambda to gdoc--><path d="M560.44,631.4531 L560.44,631.7334 L550.4168,630.9007 L540.3936,631.7108 L530.3705,631.986 L520.3473,630.5019 L510.3241,631.3495 L500.3009,630.8845 L490.2777,630.9418 L480.2545,631.3622 L470.2314,630.5313 L460.2082,632.1913 L450.185,630.6128 L440.1618,631.1894 L430.1386,632.0291 L420.1155,631.3388 L410.0923,631.5441 L400.0691,631.4105 L390.0459,631.6912 L380.0227,631.772 L369.9995,632.234 L359.9764,632.3479 L349.9532,632.3588 L339.93,631.4531 " fill="none" style="stroke:#666666;stroke-width:1.0;"/><polygon fill="#666666" points="331.56,631.4531,331.5846,631.5187,333.1115,631.9238,334.7826,632.7135,336.4068,633.3779,337.8765,633.6305,339.56,634.4531,339.5341,634.4531,339.4178,633.2531,339.4322,632.0531,339.5373,630.8531,339.3295,629.6531,339.56,628.4531,339.6248,628.6259,337.8862,628.8564,336.3369,629.5914,334.8106,630.3879,333.15,630.8264,331.56,631.4531" style="stroke:#666666;stroke-width:1.0;"/><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="121" x="383.5" y="597.5918">Generate Google</text><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="142" x="373" y="611.5605">Doc using form data</text><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="81" x="405.5" y="625.5293">in message</text><!--MD5=[3d80daa5ba3d76fcb6ef371ed0b000b8]
link aws_lambda to gsheet--><path d="M567.24,658.0131 L567.3501,658.2708 L558.1482,661.2971 L549.5918,665.8341 L540.8251,669.8792 L531.3673,672.3064 L522.8663,676.9731 L522.8249,676.8781 L513.4659,680.4478 L504.3155,684.4963 L495.3102,688.8778 L485.8051,692.112 L477,696.9531 L477.3004,697.6274 L466.857,700.5522 L457.2906,705.4456 L447.8313,710.5793 L437.7493,714.3154 L428.0318,718.8697 L418.1937,723.1533 L418.1762,723.1145 L409.818,727.1989 L401.3775,731.1013 L393.094,735.3511 L384.6672,739.2836 L376.1979,743.1223 L367.491,746.435 L358.8775,749.9544 L359.1342,750.5167 L349.8459,755.1058 L339.6374,757.6789 L330.9919,763.6764 L321.0317,766.7934 L312.0709,772.1002 L302.355,775.7523 L302.0792,775.1527 L293.9127,779.5345 L285.9598,784.381 L277.1153,787.2887 L268.797,791.3404 L260.5228,795.4882 L251.93,798.9431 " fill="none" style="stroke:#666666;stroke-width:1.0;"/><polygon fill="#666666" points="244.53,802.3531,244.5352,802.423,246.2238,802.0882,247.9429,802.163,249.6521,802.1044,251.3285,801.6072,253.0503,801.7171,253.0268,801.7062,252.4174,800.5683,251.9266,799.4852,251.5182,798.4402,250.8259,797.2639,250.5312,796.2715,250.6626,796.4012,249.1814,797.3403,248.0838,798.6579,247.033,800.0216,245.7099,801.1167,244.53,802.3531" style="stroke:#666666;stroke-width:1.0;"/><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="132" x="481.5" y="716.0918">Update sheet with</text><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="143" x="478" y="730.0605">Google Doc edit URL</text><!--MD5=[6b1b5b04abb92b701007d0dc55670c97]
link aws_lambda to social_care_service_api--><path d="M628.89,658.3531 L629.1701,658.3627 L628.6909,668.6472 L629.8536,678.9879 L630.4816,689.3104 L629.3514,699.5726 L630.5514,709.9146 L630.4397,720.2117 L630.85,730.5266 L631.6232,740.854 L631.1457,751.1386 L632.42,761.4831 " fill="none" style="stroke:#666666;stroke-width:1.0;"/><polygon fill="#666666" points="632.69,769.6131,632.7564,769.6355,633.1045,767.9496,633.8419,766.3948,634.4525,764.7974,634.6462,763.0595,635.417,761.516,635.4161,761.4901,634.2129,761.4146,633.014,761.4696,631.8183,761.6154,630.6119,761.4484,629.4205,761.7195,629.591,761.7901,629.8803,763.2178,630.6674,764.8517,631.5152,766.5108,632.0097,768.0234,632.69,769.6131" style="stroke:#666666;stroke-width:1.0;"/><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="114" x="632" y="709.0918">Send form data,</text><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="98" x="640" y="723.0605">unique ID and</text><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="111" x="635.5" y="737.0293">Google Doc URL</text><!--MD5=[17018694561fb21447cd1f314fdab1a7]
link social_care_service_api to service_api_rds--><path d="M635,906.0031 L635.2802,906.0031 L634.4476,916.5031 L635.2577,927.0031 L635.5329,937.5031 L634.0488,948.0031 L634.8964,958.5031 L634.4313,969.0031 L634.4887,979.5031 L634.9091,990.0031 L635,1000.5031 " fill="none" style="stroke:#666666;stroke-width:1.0;"/><polygon fill="#666666" points="635,1008.6831,635.0656,1008.7077,635.4707,1007.0346,636.2603,1005.5057,636.9247,1003.9299,637.1773,1002.1996,638,1000.6831,638,1000.6572,636.8,1000.541,635.6,1000.5553,634.4,1000.6604,633.2,1000.4527,632,1000.6831,632.1728,1000.7479,632.4033,1002.2094,633.1383,1003.86,633.9348,1005.5337,634.3732,1007.0731,635,1008.6831" style="stroke:#666666;stroke-width:1.0;"/><text fill="#666666" font-family="Comic Sans MS" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="92" x="636" y="962.0918">Send data to</text><polygon fill="#EEEBDC" points="601,1150.9531,601,1151.1633,611.1429,1150.5388,621.2857,1151.1464,631.4286,1151.3528,641.5714,1150.2397,651.7143,1150.8754,661.8571,1150.5266,672,1150.5696,682.1429,1150.885,692.2857,1150.2618,702.4286,1151.5068,712.5714,1150.3228,722.7143,1150.7554,732.8571,1151.3851,743,1150.9531,742.9891,1150.9267,743.7158,1151.267,744.4101,1151.5291,745.1441,1151.8868,745.8589,1152.1983,746.5355,1152.4176,746.7159,1152.4923,747.0351,1153.2103,747.3305,1153.9185,747.4926,1154.5714,747.8499,1155.3052,748,1155.9531,748.7022,1155.9531,747.2788,1165.8371,748.6785,1175.721,747.7035,1185.6049,748.5338,1195.4888,747.505,1205.3728,747.9315,1215.2567,748,1225.1406,748.2284,1225.2352,747.6921,1225.8415,747.4466,1226.5683,747.2256,1227.3051,746.9566,1228.0221,746.5355,1228.6762,746.535,1228.675,745.8651,1229.0575,745.0483,1229.0857,744.4505,1229.6424,743.777,1230.0166,743,1230.1406,743,1230.5852,732.8571,1230.7536,722.7143,1229.6575,712.5714,1229.4884,702.4286,1229.5192,692.2857,1230.0817,682.1429,1229.9441,672,1230.822,661.8571,1229.9659,651.7143,1229.7976,641.5714,1230.3689,631.4286,1229.4738,621.2857,1229.6215,611.1429,1230.7896,601,1230.1406,601.0556,1230.2748,600.3866,1230.0739,599.5447,1229.4557,598.9194,1229.3602,598.2469,1229.1509,597.4645,1228.6762,597.319,1228.6159,597.1421,1227.9568,596.9175,1227.278,596.7865,1226.638,596.2916,1225.8472,596,1225.1406,596.4626,1225.1406,595.4462,1215.2567,595.3227,1205.3728,596.5036,1195.4888,595.2831,1185.6049,596.509,1175.721,596.2066,1165.8371,596,1155.9531,595.9175,1155.9189,596.1839,1155.2009,596.7271,1154.5974,596.7865,1153.7936,597.3538,1153.2002,597.4645,1152.4176,597.394,1152.2474,598.2503,1152.3148,598.9405,1151.981,599.617,1151.6144,600.2989,1151.2606,601,1150.9531" style="stroke:#EEEBDC;stroke-width:1.0;"/><polygon points="602,1157.9531,602,1158.1633,612,1157.5388,622,1158.1464,632,1158.3528,642,1157.2397,652,1157.8754,662,1157.5266,672,1157.5696,682,1157.885,692,1157.2618,702,1158.5068,712,1157.3228,722,1157.7554,732,1158.3851,742,1157.9531,741.9714,1157.9531,742.0227,1161.2125,741.9894,1164.4719,742.0595,1167.7313,742.0797,1170.9906,742,1174.25,742,1174.8357,732,1174.9211,722,1174.9293,712,1174.5046,702,1174.7136,692,1174.9522,682,1173.5288,672,1174.9285,662,1173.9535,652,1174.7838,642,1173.755,632,1174.1815,622,1174.9916,612,1174.2013,602,1174.25,602.0351,1174.25,602.1129,1170.9906,602.1387,1167.7313,601.9987,1164.4719,602.0957,1161.2125,602,1157.9531" style="stroke:none;stroke-width:1.0;fill:none;"/><text fill="#000000" font-family="Comic Sans MS" font-size="14" font-weight="bold" lengthAdjust="spacing" textLength="59" x="602" y="1170.9482">Legend</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="665" y="1170.9482"/><polygon fill="#08427B" points="602,1174.25,602,1174.4602,612,1173.8357,622,1174.4433,632,1174.6497,642,1173.5366,652,1174.1723,662,1173.8235,672,1173.8665,682,1174.1818,692,1173.5586,702,1174.8036,712,1173.6197,722,1174.0522,732,1174.6819,742,1174.25,741.9714,1174.25,742.0227,1177.5094,741.9894,1180.7688,742.0595,1184.0281,742.0797,1187.2875,742,1190.5469,742,1191.1326,732,1191.2179,722,1191.2261,712,1190.8015,702,1191.0105,692,1191.2491,682,1189.8257,672,1191.2254,662,1190.2504,652,1191.0807,642,1190.0519,632,1190.4784,622,1191.2885,612,1190.4981,602,1190.5469,602.0351,1190.5469,602.1129,1187.2875,602.1387,1184.0281,601.9987,1180.7688,602.0957,1177.5094,602,1174.25" style="stroke:none;stroke-width:1.0;"/><text fill="#073B6F" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="8" x="606" y="1187.2451">▯</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="618" y="1187.2451"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="49" x="622" y="1187.2451">person</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="679" y="1187.2451"/><polygon fill="#438DD5" points="602,1190.5469,602,1190.7571,612,1190.1326,622,1190.7402,632,1190.9466,642,1189.8335,652,1190.4692,662,1190.1204,672,1190.1634,682,1190.4787,692,1189.8555,702,1191.1005,712,1189.9166,722,1190.3491,732,1190.9788,742,1190.5469,741.9714,1190.5469,742.0227,1193.8063,741.9894,1197.0656,742.0595,1200.325,742.0797,1203.5844,742,1206.8438,742,1207.4294,732,1207.5148,722,1207.523,712,1207.0984,702,1207.3073,692,1207.546,682,1206.1226,672,1207.5223,662,1206.5472,652,1207.3776,642,1206.3487,632,1206.7753,622,1207.5854,612,1206.795,602,1206.8438,602.0351,1206.8438,602.1129,1203.5844,602.1387,1200.325,601.9987,1197.0656,602.0957,1193.8063,602,1190.5469" style="stroke:none;stroke-width:1.0;"/><text fill="#3C7FC0" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="8" x="606" y="1203.542">▯</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="618" y="1203.542"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="65" x="622" y="1203.542">container</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="695" y="1203.542"/><polygon fill="#999999" points="602,1206.8438,602,1207.0539,612,1206.4294,622,1207.037,632,1207.2434,642,1206.1304,652,1206.766,662,1206.4173,672,1206.4603,682,1206.7756,692,1206.1524,702,1207.3974,712,1206.2135,722,1206.646,732,1207.2757,742,1206.8438,741.9714,1206.8438,742.0227,1210.1031,741.9894,1213.3625,742.0595,1216.6219,742.0797,1219.8813,742,1223.1406,742,1223.7263,732,1223.8117,722,1223.8199,712,1223.3953,702,1223.6042,692,1223.8429,682,1222.4194,672,1223.8191,662,1222.8441,652,1223.6744,642,1222.6456,632,1223.0721,622,1223.8822,612,1223.0919,602,1223.1406,602.0351,1223.1406,602.1129,1219.8813,602.1387,1216.6219,601.9987,1213.3625,602.0957,1210.1031,602,1206.8438" style="stroke:none;stroke-width:1.0;"/><text fill="#8A8A8A" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="8" x="606" y="1219.8389">▯</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="618" y="1219.8389"/><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="112" x="622" y="1219.8389">external_system</text><text fill="#FFFFFF" font-family="Comic Sans MS" font-size="14" lengthAdjust="spacing" textLength="0" x="742" y="1219.8389"/><path d="M602,1157.9531 L602,1158.2334 L612,1157.4007 L622,1158.2108 L632,1158.486 L642,1157.0019 L652,1157.8495 L662,1157.3845 L672,1157.4418 L682,1157.8622 L692,1157.0313 L702,1158.6913 L712,1157.1128 L722,1157.6894 L732,1158.5291 L742,1157.9531 " fill="none" style="stroke:#00000000;stroke-width:1.0;"/><path d="M602,1174.25 L602,1174.5302 L612,1173.6976 L622,1174.5077 L632,1174.7829 L642,1173.2988 L652,1174.1464 L662,1173.6813 L672,1173.7387 L682,1174.1591 L692,1173.3282 L702,1174.9882 L712,1173.4096 L722,1173.9863 L732,1174.8259 L742,1174.25 " fill="none" style="stroke:#00000000;stroke-width:1.0;"/><path d="M602,1190.5469 L602,1190.8271 L612,1189.9944 L622,1190.8046 L632,1191.0798 L642,1189.5957 L652,1190.4433 L662,1189.9782 L672,1190.0355 L682,1190.456 L692,1189.625 L702,1191.2851 L712,1189.7065 L722,1190.2832 L732,1191.1228 L742,1190.5469 " fill="none" style="stroke:#00000000;stroke-width:1.0;"/><path d="M602,1206.8438 L602,1207.124 L612,1206.2913 L622,1207.1015 L632,1207.3767 L642,1205.8926 L652,1206.7401 L662,1206.2751 L672,1206.3324 L682,1206.7529 L692,1205.9219 L702,1207.5819 L712,1206.0034 L722,1206.5801 L732,1207.4197 L742,1206.8438 " fill="none" style="stroke:#00000000;stroke-width:1.0;"/><path d="M602,1223.1406 L602,1223.4209 L612,1222.5882 L622,1223.3983 L632,1223.6735 L642,1222.1894 L652,1223.037 L662,1222.572 L672,1222.6293 L682,1223.0497 L692,1222.2188 L702,1223.8788 L712,1222.3003 L722,1222.8769 L732,1223.7166 L742,1223.1406 " fill="none" style="stroke:#00000000;stroke-width:1.0;"/><path d="M602,1157.9531 L602.2802,1157.9531 L601.4476,1167.2656 L602.2577,1176.5781 L602.5329,1185.8906 L601.0488,1195.2031 L601.8964,1204.5156 L601.4313,1213.8281 L602,1223.1406 " fill="none" style="stroke:#00000000;stroke-width:1.0;"/><path d="M742,1157.9531 L742.2802,1157.9531 L741.4476,1167.2656 L742.2577,1176.5781 L742.5329,1185.8906 L741.0488,1195.2031 L741.8964,1204.5156 L741.4313,1213.8281 L742,1223.1406 " fill="none" style="stroke:#00000000;stroke-width:1.0;"/><text fill="#FF0000" font-family="Comic Sans MS" font-size="10" lengthAdjust="spacing" textLength="42" x="247" y="1248.4229">Warning:</text><text fill="#888888" font-family="Comic Sans MS" font-size="10" lengthAdjust="spacing" textLength="218" x="292" y="1248.4229">Created for discussion, needs to be validated</text><!--MD5=[a2ed752421c4101d3b9eccc4d1aeea6f]
@startuml
!include https://raw.githubusercontent.com/plantuml-stdlib/C4-PlantUML/v2.2.0/C4_Container.puml

'ref http://plantuml.com/stdlib
!include <office/Users/user.puml>
!include <office/Users/mobile_user.puml>

title MASH data import - WIP

Person(users, Referrer)


System_Boundary(googles, "Google") {
    System_Ext(gform, "Google Form", "filled in by referrer")
    System_Ext(gscript, "Google Script", "triggered by new row on Google Sheet")
    System_Ext(gsheet, "Google Sheet", "form submission data")
    System_Ext(gdoc, "Google Doc",  "document", "")

}

System_Boundary(system, "Social Care (AWS)") {
Container(aws_s3, "AWS S3", "object storage service")
Container(aws_SQS, "AWS SQS", "message queuing service", "Creates a message queue")
Container(aws_lambda, "AWS Lambda",  "Lambda", "")
Container(social_care_service_api,  "Social Care Case Viewer API", "Lambda, C#", "Provides service API capabilities to the Social Care System.") 
Container(service_api_api_gateway, "SC API Gateway",  "API Gateway", "Provides routing and auth via API keys.")
ContainerDb(service_api_rds, "Social Care Case Viewer DB", "MongoDB", "Data storage")
}

 Rel(users, gform, "Fill in a referral", "")
 Rel(gform, gsheet, "Form submission", "Google automation")
 Rel(gsheet, gscript, "Form submission", "Google automation")
 Rel(gscript, gsheet, "Update row with unique ID", "Google automation")
 Rel(gscript, service_api_api_gateway, "Send form data and unique ID ")
 Rel(service_api_api_gateway, aws_s3, "Forward data")
 Rel(aws_s3, aws_SQS, "Forward data")
 Rel(aws_SQS, aws_lambda, "Forward data")
 Rel(aws_lambda, gdoc, "Generate Google Doc using form data in message")
 Rel(aws_lambda, gsheet, "Update sheet with Google Doc edit URL")
 Rel(aws_lambda, social_care_service_api, "Send form data, unique ID and Google Doc URL")
 Rel(social_care_service_api,service_api_rds , "Send data to")

SHOW_DYNAMIC_LEGEND()
LAYOUT_AS_SKETCH()
@enduml

@startuml














skinparam defaultTextAlignment center

skinparam wrapWidth 200
skinparam maxMessageSize 150

skinparam LegendBorderColor transparent
skinparam LegendBackgroundColor transparent
skinparam LegendFontColor #FFFFFF

skinparam shadowing<<legendArea>> false
skinparam rectangle<<legendArea>> {
    backgroundcolor #00000000
    bordercolor #00000000
}

skinparam rectangle {
    StereotypeFontSize 12
    shadowing false
}

skinparam database {
    StereotypeFontSize 12
    shadowing false
}

skinparam queue {
    StereotypeFontSize 12
    shadowing false
}

skinparam arrow {
    Color #666666
    FontColor #666666
    FontSize 12
}

skinparam actor {
    StereotypeFontSize 12
    shadowing false
    style awesome
}

skinparam person {
    StereotypeFontSize 12
    shadowing false
}

skinparam package {
    StereotypeFontSize 6
    StereotypeFontColor transparent
    FontStyle plain
    BackgroundColor transparent
}

skinparam rectangle<<boundary>> {
    Shadowing false
    StereotypeFontSize 6
    StereotypeFontColor transparent
    FontColor #444444
    BorderColor #444444
    BackgroundColor transparent
    BorderStyle dashed
}





































































































skinparam rectangle<<person>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #08427B
    BorderColor #073B6F
}
skinparam database<<person>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #08427B
    BorderColor #073B6F
}
skinparam queue<<person>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #08427B
    BorderColor #073B6F
}
skinparam actor<<person>> {
    StereotypeFontColor #08427B
    FontColor #08427B
    BackgroundColor #08427B
    BorderColor #073B6F
}
skinparam person<<person>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #08427B
    BorderColor #073B6F
}


skinparam rectangle<<external_person>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #686868
    BorderColor #8A8A8A
}
skinparam database<<external_person>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #686868
    BorderColor #8A8A8A
}
skinparam queue<<external_person>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #686868
    BorderColor #8A8A8A
}
skinparam actor<<external_person>> {
    StereotypeFontColor #686868
    FontColor #686868
    BackgroundColor #686868
    BorderColor #8A8A8A
}
skinparam person<<external_person>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #686868
    BorderColor #8A8A8A
}


skinparam rectangle<<system>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #1168BD
    BorderColor #3C7FC0
}
skinparam database<<system>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #1168BD
    BorderColor #3C7FC0
}
skinparam queue<<system>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #1168BD
    BorderColor #3C7FC0
}
skinparam actor<<system>> {
    StereotypeFontColor #1168BD
    FontColor #1168BD
    BackgroundColor #1168BD
    BorderColor #3C7FC0
}
skinparam person<<system>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #1168BD
    BorderColor #3C7FC0
}


skinparam rectangle<<external_system>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #999999
    BorderColor #8A8A8A
}
skinparam database<<external_system>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #999999
    BorderColor #8A8A8A
}
skinparam queue<<external_system>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #999999
    BorderColor #8A8A8A
}
skinparam actor<<external_system>> {
    StereotypeFontColor #999999
    FontColor #999999
    BackgroundColor #999999
    BorderColor #8A8A8A
}
skinparam person<<external_system>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #999999
    BorderColor #8A8A8A
}





sprite $person [48x48/16] {
000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000
0000000000000000000049BCCA7200000000000000000000
0000000000000000006EFFFFFFFFB3000000000000000000
00000000000000001CFFFFFFFFFFFF700000000000000000
0000000000000001EFFFFFFFFFFFFFF80000000000000000
000000000000000CFFFFFFFFFFFFFFFF6000000000000000
000000000000007FFFFFFFFFFFFFFFFFF100000000000000
00000000000001FFFFFFFFFFFFFFFFFFF900000000000000
00000000000006FFFFFFFFFFFFFFFFFFFF00000000000000
0000000000000BFFFFFFFFFFFFFFFFFFFF40000000000000
0000000000000EFFFFFFFFFFFFFFFFFFFF70000000000000
0000000000000FFFFFFFFFFFFFFFFFFFFF80000000000000
0000000000000FFFFFFFFFFFFFFFFFFFFF80000000000000
0000000000000DFFFFFFFFFFFFFFFFFFFF60000000000000
0000000000000AFFFFFFFFFFFFFFFFFFFF40000000000000
00000000000006FFFFFFFFFFFFFFFFFFFE00000000000000
00000000000000EFFFFFFFFFFFFFFFFFF800000000000000
000000000000007FFFFFFFFFFFFFFFFFF100000000000000
000000000000000BFFFFFFFFFFFFFFFF5000000000000000
0000000000000001DFFFFFFFFFFFFFF70000000000000000
00000000000000000BFFFFFFFFFFFF500000000000000000
0000000000000000005DFFFFFFFFA1000000000000000000
0000000000000000000037ABB96100000000000000000000
000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000
000000000000025788300000000005886410000000000000
000000000007DFFFFFFD9643347BFFFFFFFB400000000000
0000000004EFFFFFFFFFFFFFFFFFFFFFFFFFFB1000000000
000000007FFFFFFFFFFFFFFFFFFFFFFFFFFFFFD200000000
00000006FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFE10000000
0000003FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFB0000000
000000BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF5000000
000003FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFD000000
000009FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF200000
00000DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF600000
00000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF800000
00001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFA00000
00001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFB00000
00001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFB00000
00001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFB00000
00001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFA00000
00000EFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF700000
000006FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFE100000
0000008FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFD3000000
000000014555555555555555555555555555555300000000
000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000
}

sprite $person2 [48x48/16] {
0000000000000000000049BCCA7200000000000000000000
0000000000000000006EFFFFFFFFB3000000000000000000
00000000000000001CFFFFFFFFFFFF700000000000000000
0000000000000001EFFFFFFFFFFFFFF80000000000000000
000000000000000CFFFFFFFFFFFFFFFF6000000000000000
000000000000007FFFFFFFFFFFFFFFFFF100000000000000
00000000000001FFFFFFFFFFFFFFFFFFF900000000000000
00000000000006FFFFFFFFFFFFFFFFFFFF00000000000000
0000000000000BFFFFFFFFFFFFFFFFFFFF40000000000000
0000000000000EFFFFFFFFFFFFFFFFFFFF70000000000000
0000000000000FFFFFFFFFFFFFFFFFFFFF80000000000000
0000000000000FFFFFFFFFFFFFFFFFFFFF80000000000000
0000000000000DFFFFFFFFFFFFFFFFFFFF60000000000000
0000000000000AFFFFFFFFFFFFFFFFFFFF40000000000000
00000000000006FFFFFFFFFFFFFFFFFFFE00000000000000
00000000000000EFFFFFFFFFFFFFFFFFF800000000000000
000000000000007FFFFFFFFFFFFFFFFFF100000000000000
000000000000000BFFFFFFFFFFFFFFFF5000000000000000
0000000000000001DFFFFFFFFFFFFFF70000000000000000
00000000000000000BFFFFFFFFFFFF500000000000000000
0000000000000000005DFFFFFFFFA1000000000000000000
0000000000000000000037ABB96100000000000000000000
000000000002578888300000000005888864100000000000
0000000007DFFFFFFFFD9643347BFFFFFFFFFB4000000000
00000004EFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFB10000000
0000007FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFD2000000
000006FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFE100000
00003FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFB00000
0000BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF50000
0003FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFD0000
0009FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF2000
000DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF6000
000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF8000
001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFB000
001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFB000
001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFB000
001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFA000
000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF8000
000DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF6000
0009FFFFFFFF8FFFFFFFFFFFFFFFFFFFFFF8FFFFFFFF2000
0003FFFFFFFF8FFFFFFFFFFFFFFFFFFFFFF8FFFFFFFD0000
0000BFFFFFFF8FFFFFFFFFFFFFFFFFFFFFF8FFFFFFF50000
00003FFFFFFF8FFFFFFFFFFFFFFFFFFFFFF8FFFFFFB00000
000006FFFFFF8FFFFFFFFFFFFFFFFFFFFFF8FFFFFE100000
0000007FFFFF8FFFFFFFFFFFFFFFFFFFFFF8FFFFD2000000
00000004EFFF8FFFFFFFFFFFFFFFFFFFFFF8FFFB10000000
0000000007DF8FFFFFFFFFFFFFFFFFFFFFF8FB4000000000
000000000002578888888888888888888864100000000000
}


























skinparam rectangle<<container>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #438DD5
    BorderColor #3C7FC0
}
skinparam database<<container>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #438DD5
    BorderColor #3C7FC0
}
skinparam queue<<container>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #438DD5
    BorderColor #3C7FC0
}
skinparam actor<<container>> {
    StereotypeFontColor #438DD5
    FontColor #438DD5
    BackgroundColor #438DD5
    BorderColor #3C7FC0
}
skinparam person<<container>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #438DD5
    BorderColor #3C7FC0
}


skinparam rectangle<<external_container>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #B3B3B3
    BorderColor #A6A6A6
}
skinparam database<<external_container>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #B3B3B3
    BorderColor #A6A6A6
}
skinparam queue<<external_container>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #B3B3B3
    BorderColor #A6A6A6
}
skinparam actor<<external_container>> {
    StereotypeFontColor #B3B3B3
    FontColor #B3B3B3
    BackgroundColor #B3B3B3
    BorderColor #A6A6A6
}
skinparam person<<external_container>> {
    StereotypeFontColor #FFFFFF
    FontColor #FFFFFF
    BackgroundColor #B3B3B3
    BorderColor #A6A6A6
}
















sprite $user [44x48/16] {
00000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000
000000000000000000048AA851000000000000000000
0000000000000000059AAAAAAA710000000000000000
00000000000000008AAAAAAAAAAA2000000000000000
0000000000000008AAAAAAAAAAAA9100000000000000
000000000000006AAAAAAAAAAAAAA900000000000000
00000000000001AAAAAAAAAAAAAAAA50000000000000
00000000000007AAAAAAAAAAAAAAAA80000000000000
0000000000001AAAAAAAAAAAAAAAAAA2000000000000
0000000000003AAAAAAAAAAAAAAAAAA5000000000000
0000000000005AAAAAAAAAAAAAAAAAA8000000000000
0000000000006AAAAAAAAAAAAAAAAAAA000000000000
0000000000006AAAAAAAAAAAAAAAAAAA000000000000
0000000000005AAAAAAAAAAAAAAAAAA9000000000000
0000000000004AAAAAAAAAAAAAAAAAA6000000000000
0000000000001AAAAAAAAAAAAAAAAAA2000000000000
00000000000008AAAAAAAAAAAAAAAA90000000000000
00000000000002AAAAAAAAAAAAAAAA60000000000000
000000000000007AAAAAAAAAAAAAAA10000000000000
0000000000000019AAAAAAAAAAAAA300000000000000
00000000000000019AAAAAAAAAAA3000000000000000
000000000000000017AAAAAAAA830000000000000000
00000000000000000017AAAA83000000000000000000
00000000000021000000011000000001000000000000
000000000029AA30000000000000007AA40000000000
0000000026AAAAA610000000000038AAAA8300000000
00000005AAAAAAAAA40000000028AAAAAAAA70000000
0000007AAAAAAAAAAAA8666679AAAAAAAAAAA9200000
000006AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA900000
000019AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA50000
00004AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA80000
00008AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA1000
0000AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA3000
0002AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA6000
0004AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8000
0006AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA000
0007AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA100
0008AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA300
0009AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA400
0009AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA600
000AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA700
001AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA800
002AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA800
004AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA900
005AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA900
00000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000
}

sprite $mobile_user [48x45/16] {
000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000
000000000000000169AAA850000000000000000000000000
000000000000004ABBBBBBB9200000000000000000000000
00000000000005ABBBBBBBBBA20000000000000000000000
0000000000002BBBBBBBBBBBBA0000000000000000000000
000000000000ABBBBBBBBBBBBB8000000000000000000000
000000000004BBBBBBBBBBBBBBA100000000000000000000
000000000007BBBBBBBBBBBBBBB400000000000000000000
00000000000ABBBBBBBBBBBBBBB800000000000000000000
00000000000BBBBBBBBBBBBBBBBA00000000000000000000
00000000000BBBBBBBBBBBBBBBBA00000000000000000000
00000000000ABBBBBBBBBBBBBBB900000000000000000000
000000000008BBBBBBBBBBBBBBB600000000000000000000
000000000005BBBBBBBBBBBBBBA200000000000000000000
000000000001BBBBBBBBBBBBBBA000000000000000000000
0000000000004BBBBBBBBBBBBA2000000000000000000000
00000000000008BBBBBBBBBBB50000000000000000000000
000000000000007ABBBBBBBA500000000000000000000000
00000000000000039ABBBA82000000000000000000000000
000000000000000000221000000000000000000000000000
000000000389400000000000005982000000000000000000
000000028ABBA7100000000017BBBA7103ABBBBBBBBBBA30
0000006ABBBBBBA631000136ABBBBBBA04BBBBBBBBBBBB50
000008BBBBBBBBBBBBBABBBBBBBBBBBA04B8888888888B50
00004BBBBBBBBBBBBBBBBBBBBBBBBBBA04A0000000000B50
0000ABBBBBBBBBBBBBBBBBBBBBBBBBBA04A0000000000B50
0002BBBBBBBBBBBBBBBBBBBBBBBBBBBA04A0000000000B50
0004BBBBBBBBBBBBBBBBBBBBBBBBBBBA04A0000000000B50
0007BBBBBBBBBBBBBBBBBBBBBBBBBBBA04A0000000000B50
0009BBBBBBBBBBBBBBBBBBBBBBBBBBBA04A0000000000B50
000ABBBBBBBBBBBBBBBBBBBBBBBBBBBA04A0000000000B50
002BBBBBBBBBBBBBBBBBBBBBBBBBBBBA04A0000000000B50
003BBBBBBBBBBBBBBBBBBBBBBBBBBBBA04A0000000000B50
004BBBBBBBBBBBBBBBBBBBBBBBBBBBBA04A0000000000B50
005BBBBBBBBBBBBBBBBBBBBBBBBBBBBA04A0000000000B50
006BBBBBBBBBBBBBBBBBBBBBBBBBBBBA04A0000000000B50
007BBBBBBBBBBBBBBBBBBBBBBBBBBBBA04A0000000000B50
008AAAAAAAAAAAAAAAAAAAAAAAAAAAAA04A0000000000B50
0000000000000000000000000000000004A2222222222B50
0000000000000000000000000000000004BBBBBBBBBBBB50
0000000000000000000000000000000004BBBB8007BBBB50
0000000000000000000000000000000004BBBBBBBBBBBB50
000000000000000000000000000000000066666666666610
000000000000000000000000000000000000000000000000
}


title MASH data import - WIP

rectangle "<$person>\n==Referrer" <<person>> as users 


rectangle "==Google\n<size:12>[System]</size>" <<boundary>> as googles  {
    rectangle "==Google Form\n\n filled in by referrer" <<external_system>> as gform 
    rectangle "==Google Script\n\n triggered by new row on Google Sheet" <<external_system>> as gscript 
    rectangle "==Google Sheet\n\n form submission data" <<external_system>> as gsheet 
    rectangle "==Google Doc\n\n document" <<external_system>> as gdoc 

}

rectangle "==Social Care (AWS)\n<size:12>[System]</size>" <<boundary>> as system  {
rectangle "==AWS S3\n//<size:12>[object storage service]</size>//" <<container>> as aws_s3 
rectangle "==AWS SQS\n//<size:12>[message queuing service]</size>//\n\n Creates a message queue" <<container>> as aws_SQS 
rectangle "==AWS Lambda\n//<size:12>[Lambda]</size>//" <<container>> as aws_lambda 
rectangle "==Social Care Case Viewer API\n//<size:12>[Lambda, C#]</size>//\n\n Provides service API capabilities to the Social Care System." <<container>> as social_care_service_api  
rectangle "==SC API Gateway\n//<size:12>[API Gateway]</size>//\n\n Provides routing and auth via API keys." <<container>> as service_api_api_gateway 
database "==Social Care Case Viewer DB\n//<size:12>[MongoDB]</size>//\n\n Data storage" <<container>> as service_api_rds 
}

 users - ->> gform : **Fill in a referral**
 gform - ->> gsheet : **Form submission**\n//<size:12>[Google automation]</size>//
 gsheet - ->> gscript : **Form submission**\n//<size:12>[Google automation]</size>//
 gscript - ->> gsheet : **Update row with unique ID**\n//<size:12>[Google automation]</size>//
 gscript - ->> service_api_api_gateway : **Send form data and unique ID **
 service_api_api_gateway - ->> aws_s3 : **Forward data**
 aws_s3 - ->> aws_SQS : **Forward data**
 aws_SQS - ->> aws_lambda : **Forward data**
 aws_lambda - ->> gdoc : **Generate Google Doc using form data in message**
 aws_lambda - ->> gsheet : **Update sheet with Google Doc edit URL**
 aws_lambda - ->> social_care_service_api : **Send form data, unique ID and Google Doc URL**
 social_care_service_api - ->> service_api_rds : **Send data to**

hide stereotype
legend right
<#00000000,#00000000>|<color:#000000>**Legend**</color> |
|<#08427B><color:#073B6F> <U+25AF></color> <color:#FFFFFF> person </color> |
|<#438DD5><color:#3C7FC0> <U+25AF></color> <color:#FFFFFF> container </color> |
|<#999999><color:#8A8A8A> <U+25AF></color> <color:#FFFFFF> external_system </color> |
endlegend
skinparam backgroundColor #EEEBDC
skinparam handwritten true
skinparam defaultFontName "Comic Sans MS"
center footer <font color=red>Warning:</font> Created for discussion, needs to be validated
@enduml

PlantUML version 1.2021.7(Sun May 23 13:40:07 BST 2021)
(GPL source distribution)
Java Runtime: OpenJDK Runtime Environment
JVM: OpenJDK 64-Bit Server VM
Default Encoding: UTF-8
Language: en
Country: null
--></g></svg>