基于下图,我们可以看到这两个标准表的关系:Account是Contact的父,Contact是Account的子。
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAvEAAAD7CAIAAABsXlz5AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAFiUAABYlAUlSJPAAAFWOSURBVHhe7b0PTFtZnu9J1cv0wCyRoMc9Y0ZUPyg5GajnqoYM5IUaYAIbMg1bpJusYOWMIGNGEEEmRNCCKCDIBF7IFrwGBV5gC7bxBlYggVSUoIRHgQWE/QIDKGQT1KCKZ0BdnsaathrvhPewnqLp/drn5NaNbRwbDNjXv4+Ic37nnHvuudfH53zPv3vf+93vfhdCHBrb29vPnj3jRkiI1Wqdn5/nRkhIaGhoSkoKN+xkZGRwF0EQBOH3oEpHxc6NkJCVlRWLxcKNkJC4uLioqChuhITExMTExsZygzgESNMclN3d3YWFhbW1NZPJNDMzYzKZDYZ1HhYSEh4ekZCg5EZIyInQ0OTEZG5A4rx+vbL0ncQBer2eu+wkJSXJ5fLExET8MPBLcBBABEEQxGEDmYLqHdplc9O4sfHSuZZG75QbISHxHydGhIdzIyTk5UuD2bzFjZCQTSRhNHIjJCQ6GiInOi0tTSaTsXpeLICIfUCaxjs2NjZQKJl2WVt78ezZ6uvXVpTp2FPxcpksJS0DEkShUPDYB2Z5eXlry7S+uoIfhtG4AdPhN5CQkBAZGcljEwRBEAeA9VFZPc9EDPqoSqVSJpejO4ra94MPYlNTU3nsA2MTOJubS0vzZrN57cXK+joEkAnpx8aeQj2PTizr0/LYhAeQpnk3KNlarRY6BvI82q4pUlLSUMRPnYpXKhMiIr6T5EeAw28Aogqe58+nZmRkZGdnx8fHs2gEQRCEJ0DBoHqfndXjE5ICfVQIF1T1CckpsTExPuyjeggamm+/3bDV8ytLZpNpdXUVWcrKykJX9vz582FhYTwe4QrSNK6BjkH5BiheEOkZGVkpaRk+lOc+xGLZ0elmFxZ0M5NauCFumMQhfUMQBOGSra0tVO/QMeivhoS8TkvLOJeaiko+Jjqax/AnlpeXdbqZ+Xndgr09QvcVNTzgwYQI0jTfsbKywnQMCnpcnALl+1xKWlpqqniu1M8xmc3zOpsOw6fV+hqFnukbWpVGEESQs729PTs7q9VOopK3WCypqWkpaakZWdn+qWP2AvoG3VfoG9Tz6GYzfUNLLQVI09ikTHd379DQkG3+EjrmnG2E74hnlA6DTaMRyga6HgI/NDRcrS5UqVQkbgiCCCogZVC9azSa9XVDqq2Pl5WWlnH0M0qHAWTNzMwk6vnV1dX8fFTw+ZA4PCxYCV5Ns7GxYS/oA6GhJwrVJXl5KgnomL0wGAxDQwOjI9BtMWq1Oi8vj1YWEwQhbQYHB7/66mutVptna/ALk5KSeIDksFqto6Mj+Ft9tlpYqCopKQnatQdBp2mg2UdHR6HZNzc382zCtlAagt1DoOtHhgYmJyczMjIg6iFueABBEIQkmJ+fR2cVXdYLF7Kycz/Ly8vnAUGAyWxG33VA0xsScqKsrAQtXLBtDg8iTQO1joI+MzOTlZWVryr0zwW/RwNEvVY7DlG/vLAMWYOiT9sFCYIIaDY2NtBZRSUvl8tQw0t76P2dGAwGjaZ3dGQkIUHJxuaDZMOU9DXN9vZ2e3t7d3evMkGpUhVmZ+cG0JrfwwaiHtoGot5qfQ1lU1ZWRhsFCYIILEZHR5ubm00mE2r4/EJ1YK35PWwmp6ZGBgf0el12dvbdu/WSX1IpZU2ztbV1/37r6OiISqUuLCmRy2Q8gHCCiXrom8rKSlI2BEEEBH19fajkFXGKiooaCS+XOTgWy45WO9p6vykjI0vayuZ9/r+0gJqpqKg6e/asTC6fnntaffs2CRr3KBSKe/c+n5h+sm7Y/OEPP2xoaNje3uZhBEEQfgbUzAcfxE5NzfYPDvf3D5OgcU9ERLhKVfj0+TdJ586lp6fn5uaurKzwMGkhNU2zsbFRVFT8ySdnoGaeLD4vK7sRzFOq3gLlB2WD+2a1hnzyySdQNlCHPIwgCOK42d3dbWtr+8EPoqBmvpx4/ODhF0G1yePgMGWTl18EoGzmRe9UlgbS0TRra2tQM1Cg0KG//OafoGZo3cz+gAqsvn17eu4plM3Zs2crKqpI2RAEcbxsb29DzZw+fXrdsDn9ZBFqhtbN7Jvc3M+m5xahbCoqKtLS0mZmZnhA4COF9TRQMzU1Nevr6zcqqyFCuS/hC6xWq0bT29vdmZeXf/t2Nb0zliCII2Z3d/f+/fsajSY7Nw+VPC0k8C16vb6tpRGOxsZGCbxvIbA1Dcr6nTtNWu14ZXUDhCf3JXwNUzYDmt6ysrKqqiruSxAEcchotdqKioq8PFUJLSQ4TJiyiYr64MGDnwd03zWA555GR0dPnz4dGho68XiOBM2hgptcVnZj4rFtBXFycrL0pmAJgvA3NjY2srKyWtraBr+cqL59mwTNoZKamvrl2OMLP/5xenp6W1sb9w1AAnKcBmW9tLT0RGhoS1sXjUMeMcvLyw21VYmJyZ9/fo9esEAQhM/Z3d1tb2/XaDR3m9uyLlzgvsSRYLHstLY2zetmenp6AvHVmAE2ToOy3tDQcPHiRXVpRX//MAmaoycpKWni8ZwiLu6TTz7p6+vjvgRBEL5Aq9WePXvWZLZMzy2SoDl6IiLC7937vKOrr6KioqioOOAe6hFImgZlHe2o1RpCZf3YUatLpueeTk3NJicnS/U5BwRBHCVbW1u5ubktbW09fYP19Xdp4+oxolQq0XdNOncObW5XVxf3DQQCY+4JZb20tHTHam1p66L9e37F8vJyTVU5ezYlTUURBLE/mpubNRrN7fpmWhzpV1gsO/eb6l68WOno6AiIqagAGKcZHR1NT0/Pyy8aHh4jQeNvJCUlTc8tyuTyixcv0oANQRDegi5rcnKyyWyZePyEBI2/ERER/vnPHzQ2t9XU1ATE2mG/HqfZ3d29davu5cbLjo4+WvTu5xgMhoryYrVaXV5ezr0IgiDcwrZqd3T10csN/Byr1drUdGfr243+/n5/HpL333GajY0NdP1lcnl//zAJGv9HoVB8OfZ4eflZbm4uvSuKIIh3UlNT29LWNvH4CQka/yc0NPTevc/zVUVnz57158d5+KmmGR0dvXTpUm1Dc1nZDe5F+D0o9J///AEKfXp6Oj3DhiCIvWDzTagxhofHqMsaQGRnf/blxHRFRUVzczP38jP8bu6J5pskwKbRWFVenJeXRw8dJgjCAZpvkgBNTXfWXqwMDw/72zyUf43TrK2toYtP802BTkx09ODw2Lphk+ahCIIQQJe1oqKK5pskQH39XXVphR/OQ/nROM3g4GB7e3tLW5dSqeReRICj1X7der8xQJ9HSRCED9nY2CgqKsrKzqUVBZLBZDYXX7mcl5dXW1vLvY4bf9E0DQ0NL16st7Q9pOEZicHmocrKyq5cucK9CIIIMlZWViBo0GWl4Rnp0dR0x2TcfPToUVhYGPc6PvxC05SWlkfIZNXVt7lNSAur1VpRfi0r6zxt8yaIIESr1TY3N/f1f0ldVqkyOjoyPjriD9u8j1nT7O7uXr16Nelcqlpdwr0IiXLrZzejo+WNjY3cJggiCBgcHBwYGqI9H5Jncnaqu61lbGzseGXNcWqa7e3toqKi3Lz8vLx87kVImtbW+ybjJrQ8twmCkDRdXV2Tk7MdXV/Qy5uCgdXV1YryYsia2NhY7nXkHJumgaC5dOlSWVVN1nl6G2UQMTQ0MKkdHx4e9oeZV4IgDo+Ghgaj0fT5zx9wmwgCNo3G8uIrPT09iYmJ3OtoOZ693BsbG+np6Y3NbSRogg2VqjBfVQQ5S3u8CULCFBUVWV+HkKAJNmKio/sGv6yoqJiZmeFeR8sxjNOsrKyUlpZ29Q3SCymDFr1e39bSODw8HBUVxb0IgpAEu7u7BQUFWdm56MBwLyLIsFh2SkuvVJSX5+Xlca+j4qg1DbRbQ0MDBI1cJuNeRFCyurpaU1UOWXOMM68EQfiW7e1tCJpCdWl2Nr1hO6ixWq2lpUX5eXnFxcXc60g40rknrVbbaN/RR4KGUCqVkLZFRUUbGxvcy7/BLzPtbdAF6erq4sFuQTQP+ysrKyvM4fkhXvHy5UvkHJ/cFuEmSGL09/fj3p6yA4dPBsmFL25/vLLDjYCFrZIsr6ghQUOEhob29w9PTc329fVxryPh6DQNfvMNDQ300gNCICY6uq2rD726ra0t7uXHoLE3mUzZIuB5/fp16AAWwQ0Wi2V1dZUbewPZVFFRwdweHuItOzs7er0en9wWAU9coMsgKQER09TUFBkZqbYDn8zMzAPuxRN/cfsARevMmTMGg4HbgQmbcqqqaUhNTeVeRNDz4OEX4+N/Pzg4yO3D54jmntAXh37/cmyaBA3hAFruhtqqY3+qwTth2kWn0zGT0dXVBVkzPT2dkZHBvVzR3Nys0WjeOQTi8hS+BV0LNJ9Pnz49rl0Jx0tNTc3o6Ojw8LD48qFIcM/n5ub2vbrrgF+cNL6U3NzcfFURjdAQDrBJqIryctYPPGyOYpyGveajb5AeIkm4QKlUom+HHh76edwrcGDvsRK/xY3Na6CRQ/O512yCEAefwggB5JHJDgQQDpyZmRG/zR8mm/zCp6CNEI3FwSdLTTyNgmjsEPFZGBaLxfkQlhrLMzID//HxccQBew1jIA5ibm1tCXkTD7nBjZvAUoBDCBISZzeBJS6YcLBoDOFeubmf0ATOuIwMQYPUHKTDvXv3UAjX19eZKWQbMcWZYdkGLD/Ct+PwxcFnrwtnID4LYheOQ4aGhuDAJ4LgcPPF+S2o4bOyc0nQEM6Ehob29PQ3NDTgV8m9DpND1zTswXqNzW20y4nYi9TU1EJ1KWQNtwMHrVaLz/x8/tBINEVNTU2nTp1CjwRCB51v55YVjZwQJzIy8urVq0LrKAaHazQa5kaEzMxMOFhHJycnh7W1BoMBcdD4wYEgs9lcWlrKWlC0i4jGDsG5HM6CaMIhSJmJJPjU1dWxGRC0r6iDWlpaSkpKoNuQYWTbfuhbIJPt7e22d+nLZEhNp9MJXyKyAX+kDH+AmDBZkJB4cnIyyxvuGzORzqVLl6AbWExP7ifASZ3p7OzkwW9Asrg6lUrF7TdERUVB67CRNsQRso3zIjPChbNsA+QT9wT3CtljQWLcXDjAl4V04M/uqnMK7r84/wT3RB4dQ7uciL2ArBkcnjia1ZOHO/eEnjdbMkYzrMQ7GRoaWF7Q+23HFK0R+uJyuZzbdvR6vVqtZovg0BxCH4jnoXAImiWEollic09oktEw19fX4+ctxMEnm7YQu4VDWBuJswhvvkVDiDgIQr8HqVVXV0MQwJ8lzmLicOgtYTaENcyI5uYQFsRmQNjFCtMx+FLQADvPzuAsaNrHxsZyc3NhQmnh985ScMiAc+Jwnzx5EkG4RfjE5dgj2kyWHzf3k5newm6p+zkmnAK6ChKHmV32ucVvvvkG53XINm4porFsIwifwhe314WzDAgpCHcVyYrjuPzimOmH4BYtLz+j59AQ74S9zxjF/lD3uh7uOA0qOHV5BQkawhPQz0NvD30+bvs3UDNo/NDaCU0seuQKhSIiIgLNGAMNodA4MdCYoRVkggZiBXHQnrGgvZicnMSn+FX+N27cMBgMOJaZwsADEhckV3R0NHII9cM0IhpFcbvo8hAHlEql0PazDAstvRhcMhM0AA6YzI0Mi9t13BzmZuCkrF1nbnEeBLcn99O34BvB1yFe7VteXo48jIyMMBN5E7KdvcfiADcXDrGCuyqkgLuKwuAgsNx/cf7G4ODg5OQsCRrCE2Kioxub21DsD/WBq4eoaZD13Lx8elIw4TnV1beNRhNbVeCHoElDc8V49OjRV199JbR2AC0WpAaf+bCDaDxMxLh9kQqa5/T0dE82yxiNRu7yBvz6Hj58iAywuRucEe0rD/OM5ORk7nqDxWLhLs9Aw4xTA9yKIfuSEa/w8H4CtsDFAedSBBWCBF2KSDbcgiBEgIpinu5xE83NhTvfVQcO/sUdGfiCbC+n7PqC2wTxLo5g9eRhaRqaYSX2B/p86Pkd5d6//YG2R61W19XVCYs/UlJS0KdH6+gAC2VsbW1VVVWhrRoeHkYQmi7xEIVLPGxinSkvL8cp5ubm6uvrYaIeYf4egtadu97gVU7QruPq2trakAFko6Ojgwd4jCf3kwGhAL3iQHx8PA9+Q2JiIhJ0qa5ycnJqamrCw22bGLyVbg64v3CHu+pSrxzwizsakPPm5uaOjj56OSXhFampqeryikuXLnHb1xyKpkEPCb1t9Lm5TRDegJ5fd3e3w2yFH/LgwQO0kcJkGbog+BS3UnlOz9DU2Jf94kC0r8znnXNPWVlZaAjZTAQD/WOcV0jBJWihcXY4oqKiIL/YsgwoKnugR4gHRcbHx5EH5ITbHoDD09LScnNz2dzKixcvmL/neHI/GbWucLm7HlkaHR11UBIszcrKSmhN3NiBgQHmD9iyYqgrbnuAmwtH+uK7isTPnDnjoNIO/sUdAcgPlFZfP21lJfZD1vkLaRlZFRVV3PYpvtc0a2traJDu3vuc2wThJej5tXX1lZaW+vl7Lk+ePInuuF6vZw0PWiC5XI66HvoDrSY8v/rqK9Y+CeTn56ONvHnzJiIAh1C0eZA46P6Kd/fAU61WNzU1sWQRWldXBx8evAdoVnF2RMYhaDtbWlqQN4elG+5BPtHY43Cct6qqCmdETniYB0CRoP2GGEIK6OQg//D0agjEk/vpLX19fSxNXBqSRcaQIIRmfX09uzlwwGT3DRFQCH/605+6f/gQEH9xbi783r17+GR3FV8K1DASx7HIErRUZ2cn4h/8izsCcANb2rpI0BD7pqzsxsuNly6X6B0QH2sa9ijJnr5BGpAkDkJMdHT17Qa0atz2A9D2AG68Ad1xNPbz8/NMhbA+Opox/ArgKWwIioiIYKMOSOHRo0fomiNCRUUFGlSoIvizw2/fvo0GTKvVooEUDgFoiXGW3t5eHIVQpFBrXzIcHh6emprKZkwYSJ/NEOG8ODsi4xA0zPBnIwRuDnEIglsmk+FwXA7O7nK3kTiTDJgsBdRWcEMMIYXl5eW5uTm032zsDWcE9ug2nE2WH7DX/TwISBOXg68Ayba3t8NnenpaKGlwCPeNXbhQ7TrkE5cpXLv4i3Nz4ZAmExMT7I1I+FJSUlJY4vBHSUCWEH+vL85/gBRLSctA8eA2QeyLjo4+lCWf7+728V7uoqLipHPnaBkN4RPq6m7FKWLQPHCbOCqgJPDpb60pceyw4aUvxx5zmyAOAER8c2Pt48ePw8LCuNeB8eU4DXpyr1+/JkFD+Ir6+rvoyLI+LkEQx8vW1lZFRUVXn7+v3ycChaSkpKzs3Fu36rjtC3ymadbW1trb2+lBBYQPCZSFNdJDZocbBGGnoKCgsblNTgWD8B0+X1jjm7mn3d3ds2fP9vQNKt48cYsgfIVW+/XIUP/4268BIgjiKGloaLC+tj1BitsE4SMslp3LlzLHxsZ88nxh34zTXLt2vaTsBgka4jDIzv4s6oNYtpaWIIijZ8YOCRriMIiICG9p6yoqKvLJg/h8oGloGQ1x2NDCGoI4LmgZDXHY+HBhzUHnntbW1goKCiYez9HmbeJQ2TQai69cnpubi4yM5F4EQRw+aWlpVTUNtHmbOGyKigpKi4sP+Ayqg2qa5OTkxuY2iCxuE8ShodH0GtbXe3r89G1QBCE9uui128RRYTKbL+dkLi4uHqTjeqC5p76+vlOn4knQEEeDWl0yP69b8ddX+hGExNja2uru7q68bXvtFEEcNnKZrFBdcueO7dHb+2b/4zQo7hcvXhz8coK29hFHxurqakV58T5eHkQQhLfQM1SJoycz/Wx/f7/799m5Yf/jNBBTkFQkaIijRKlUJiendHXR9BNBHC7z8/Nray9I0BBHTEtbV2lpKTe8Z5/jNCsrK0VFRdNzi9wmiKPCYtnJufjp3Nycv73YjyCkxMcff9zR1Se804ogjoxbP7uZlJRQXl7ObW/Yp6ah4k4cI0NDA8sLC/39Lt6qSBDEwWlra1s3bN679zm3CeIIMZnNVy7nPH78eB8d1/1oGiruxLGTczG9o6MjJSWF2wRB+Iitra2zZ88+WXxOT+ggjot973L1WtOguKenp088fhIREc69COLIocXCBHFIFBQUXPjxZ3l5+dwmiONgf4uFvV4jfOtW3Y3KahI0xPGiVCpT0jLohQl+xczMzMuXL7nhBKon7vIFp06dam5u5oaIlZUVBLEN/3l2mL8DboKCHHyJ6LiSoCGOnY6uvqKiIm54jHeahlbCE/5Dff3d9vZ21L/cJo4VyIjMzMydnR1uvw30R1PTgR474SHh4eFyuRyfcJvtMH8H3AQFM7u7uzU1NY3N1FUgjp/9dVy90zSlpaUtbbSNlvALQkNDS8pu3L/fClkTG2t7yeVer0CDFs/Ozo6MjES04uLi7e1tHkBIjlOnTul0Onxym/CG7u7uxOQU2vxB+Ak3KqvRcfXq3ZZeaJrR0dHomBgq7oT/oFaXjI6OwPHkyROj0fjRRx85Kxv4VFVVVVRU/NM//dP09HRqampmZubGxgYPlhZdXV0Qbf39/WjUQV5enngyaHx8PC0tjQXBAZP54xAciMjwh1vwFGLOzMwwT5a+kI6QCM6COwwHPoUUBHCURqMxGAyIz54t9OrVK5fpu6S5uVmIKeQZWCwWIRHhpMgJormcAhMi19TUcC9CBH44aD/QinCbII4buUyWnZsHqc1tD/BC0zQ0NNTUNHCDIPwAYagmKioK2oUpmzNnzvT18W3eKysrIyMjkDLicRqEXrlyxSvtHyigmdfpdL29vT09PRMTE7jknJwcFgTdcOnSJdyHYTto2iH12MwdFAAaMzjUajVbZcJkARJhMUtLS5lKYOm3tLQ0NjYiCD5IBJ+IU1JSAgc+b9++DYeYwsJCJKtQKDo6OuCGD3IlTh8qcy9ZA/0BPVRfX4+YyDwuQZA16GUhTfhXVlYiDlMqOzs7er3eeQoMGUDOUUgQ32w2Iw4PIN6AlgPtBz1GlfArvB2q8XTfE6qPnr6+/n5bLUYQ/oPVav307CeLi4vCkww2NjaamprQRqIhnJqa+uyzz6BgWJAAWriioiLWfkuJ5ubmuro6aLiMjAzmA8WAJr+8vLzL9jLCZbHag/h7+vRpYmIiFIzJZBLGNvr7+3EDxU81ZDcKlQBL/5tvvkGy8BEnInbbD3oLHAjZwU6BnKCSckgfOgOag5kCbJclvkdhqSAkqUwmg6hCBpRKJbLE/IUUHK4LQfDEeU+fPj02Npabm8vi43C5XO58xqAFbQZu0cT0E9I0hL9RV3crThHDuk/vxFNNg7ogL78oN/czbhOE39De3jqg6UWXndt2Nu2EhoaieYuPj+e+bygtLZ2cnIyJieH20YLmli1i9S1Idm1tTZAODKFdZyaCdnZ2tFqtwWBATIe2n8WpqamBVlCr1cwES0tLq6urOFYsTRgQB8PDw0hELCZevXqF9FkEXCniiA90VjBCKBLhXvbLgVlQUODymdFIEzmsra1lJlLARSFNl5qGqShxtnGN8/Pz4jwEOdRrJfwWk9mck/kpulJhYWHca2880jSoJuhNCITfYrVaz575CO1WREQE85mZmens7ExISEBQQ0NDdnY28xdg3X1n/6MBPyiLxcIN34FWHJqGNe3cS6Rp0KLjqk0mE0ylUglN0Nra6lLTwEQ0uVzOTAZuFxun8UTTsGgsAhtNER/ocDoghCI17hUSgmSNRiM6Z+LTCXilaZyzzeL39/d/+OGH3OvQQDkUSqbfAg3aP/glLZck/BPPh2o80jQ0SEP4Od3dnWaTqaOjDc1nS0tLaGgopExGRgaEzurqKj55PDvb29uffvrp9PS0c+8/0HFuvNGuo/nv6+tjoyMTExMnT56Ev8u2336Ei0S2trbYvXIOcqlpeJgI8YGQVjiXg8JwSJbB0hSmugDUKnRbeXm5V5oGR5WWlorHe5AHnE645EMFWToMCetD7LdIN/zlGLcJws/wfKjm3ZoGP0gapCH8HKvVevrDP1HYqampEb8zAW052jZB4EPQoD3Lz893XmQjAdC0i9fT4MdbUFDA1qNABOA+COtpWEyXmgYKIDMz89GjR8IqFkTwapyGh4kQH9jf33/16lXxoh8hfWaKcdAuiAkfXIVXmgaf4vivXr1CHFpPI0Dv7yP8n5vXr124cB61N7f34N37ntDfraym7U6E/2KT8BfT0URlZWWjXXR4CdTg4KDRaIyNjUULCj766COpChqB0tJSCDsAQYN2nUkTaDuoCnii+Ue9AAUA/efy5RK4S2j+ITsQDZGRgslkamlp4cF7AA2BBHFGl5UOvhRhLzfyg/RZJoX0HcbSBCDIoL1YTnAJiHnv3j0e5g3idHJychxm1oIZ/GToIR2E/1NSdoNtz3TPv/u7v/s77nQFOj2oB5v/91ZuE4T/Ef4Hf/DnaRlXS8rqblWWlZX93u/9Hg+wA/Mv//Ivf/KTn/zoRz/6i7/4i9bWVvTReZjk0Ol0v/rVr4aHh2dnZ//5n//52rVr6JOwoKysrD/6oz9aWlr69a9/nZ2d/eDBgxMnTvzxH//xn/7pn1qtVvTUk5OTWUyA2/Xhhx9ubm7+wz/8AyJ3dHT8+3//7+H/+vVrmUzGxj8YOzs7iPD7v//7cEM4/smf/AkOFCfFQBDO/sEHH0D6wI30IyIifvnLXyJ9lUo1MDDAZsScYd8a8jwzMwM3FOof/uEfwh/nhU5CUiwaMgaZgvOG22FZEl8XS+f58+f/+I//+Ld/+7coEiw+OzyYgQz9T81t+Ha4TRB+CYro/zMz+T+FhTnv+RDzjrknWklDBBBebfmTJM17LEwhCJeM0nYnInDw5NXF7uaetra2FhaWSdAQgYJ9cLKTGwRBvIuurq7ColJuEIR/o1QqIyIiZtw+dtydphkaGsrLp7ezEgFDTHR0TEy0+xIvbfCDp4URhIeg17q+vp6WmsptgvB78lWFGs0AN1zhbu6JFsMTAcfQ0MDywkJ/P9/dQxDEXrS1ta0bNu/d+5zbBOH3WK3Wj05/+C//8uu9NnXvOU6ztraGg0nQEIFFXl7+6OioJN/lRBC+xTYSn0cj8UQgERoampubi6LLbSf21DQDAwP5Ktvb5ggigECJv3Ahy+WTTgiCEECv1WKxJCUlcZsgAoTP8vLdaJo9555+8IOo6SeL9D4zIuCYnJrS9HRMTk5ymyAIJ2yPHzwRWllZzW2CCBw+Ov3h8+dPXT4I3vU4jVarVSYoSdAQgUjWhQvPnq1ubW1xmyAIJ3p7NarC715TShABhKqwUPPmjXIOuNY0Q0MjNM9KBC5uSjxBEDMzM3FxCuq1EgGKau/dTy40ze7u7ujoKGkaInBB6XUz4UoQQQ7aA1ouSQQuCoUiNPTEysoKt0W40DRoDHJzc0NDQ7lNEIEG26/nssQTRJBDvVZCAuz1oBoXmkaj0ZCEJwKd3Lz8kZERbhAE8QbqtRISIC9f5XIw3lHT2J8saUilJ0sSAY6qUN3bS0tqCMIRtASf0SANEeDIZTJlglKr1XL7DY6aBjGysrK4QRABC0q8XC6j6SeCELO7u7uwsEzvQyAkQEZGlvMzOxw1zeys/hwVd0ISpKRlBPO7nwjCmYWFhYQEJU08ERIgLS3j3ZoGbQBaAm4QRCBz7lwaaRqCEGOr4VPSuEEQgYxSqdzcNG5vb3PbzluaZmNjIyTkdUx0NLcJIpBJSzs/O6vnBkEQ1GslpEXq+dTZ2Vlu2HlL06C4p1FxJ6RCRER4TEw0LakhCMbu7u6zZ6v0jidCMqSkpOl0Om7YeUvT0GIaQmLQkhqCEKDFNITEcF5S4zhOQ8OShJQ4n5HlvNmPIIITWkxDSAylUmkymcVv9/tO06ysrNjG6mkxDSEh0lJTFxaWd3d3uU0QQczo6Gh2bh43CEISZGW91XH9TtPQIA0hPUJDQxMSlAsLC9wmiGBle3t7c9PIXhtCEJLhXGqqeC/IW5rm3DkaliSkRkoK7egmiJDZ2dnU87RckpAaDosmv9M0UDppaee5QRBSgZYJEwTQ6XS0mIaQHvYFM6/tT6KxwTXNyspKTEx0REQ4MwlCMiQlJS0vL3ODIIKVyclJelQHIUmSklLm5+eZm2uatbU1hSKeuQlCSoSGhkZHR6OEc5sgghKDwaBQKLhBEBIi/mPl6uoqc3NNs76+fuoUFXdCmiji4lDCuUEQwcfGxoZMJqMn0xCSRKGIf/HiBXMLmsaAep+5CUJinDoVT+M0RDADTU81PCFV4uPRazUwtzD39AL1PnMThMRQKBRCiSeIIASanmp4QqqghjcY+Eg81zQ01UpIGPs4DR+ZJIggxDYSTzU8IV1QvNlgvE3T0FQrIW0Uiu9GJgkiCKGReELaCIsmbZqGploJaRMREQ7JLn4nCEEEFbRikpA2wqJJm6ahqVZC8sTFKWjrExGcbG9vW61WuUzGbYKQHMKiSTZOQ1OthMSJpa1PRLACNQ9Nzw2CkCLCokk2TkNTrYTEgWo3GGhJDRGM0Eg8IXmERZPv/e53v/vBD6KmnywGw8jks2fPZmYmuRESkpyckppKL3ULCianpjQ9HZOT3337BBEk1NbWhpwIrays5rbkQHdlZ2cHDrkd5kkEGx+d/vD586fv/fa3v/3hDz/8p1/9mntLEZPJdP9+07xOt7np2FOPiVGkpKXdvl3vJ78Erfbr7OzPuHHk4EahdpCkzts0Gi/nXPz2W/6eM4IIHnJzc/Pyi3Jzj61iOWzOnvmE1e1J585NTEwzT8INkqzqL1+62NjY+L7FYpH2qyt7e7sv5VwcGtAIggY6Bn/MDU8EIcLIyBDzOS6gZnJyMjs727h95LS3t+I+LC3xN4FJjJjoaKNxkxsEEUygko+MjOCG5EDVLdTtywsLNMX8TqRa1X/wQezGxsb70GsSHqy7efN63a2fCRL+3uc/f7L4fPGp7Q8OmPBEECJcv/Y3UBX2g46BZ8+eXf2rAvwguX3koJTfb7ojVA0EQUgGk8ks4Upeo+nFp9BT7exst3sTrpF8Vf++1WqV6tP2enu7hwY0zA35MjExXVJSJuzwggMmPFWFauZzp64WCo+5CekRHh6xvb3NDYIIGlDJn5BoJY8a22wyw6EqLJTJbUtC53U6ewgRdIRHRFgsFpumkWRxR1nv7e5m7odf/ALyhbmdefDgoTBac/9+E/MkpEdERDhKPDcIImiQcMe1u7uTDTlkZGTl5eXDAfPYFxIQx0JEuK2Gf39rayvqB1HcT0JAnbCy/uPPPsvPVzHPvbhxo4o53Gt8g8HwzA63PYYd6KuJXpYHwG0PgMLz9hCCIKSB2WyS6rZW7fg4PmNiFAkJCbm5eWz6ic1GeYi3tfphxz8g7FzBPOHw3i9+8YupqdkHD7/gHlJBWAn/5dhjT1Z3FxUVJCYmu9zdjULZ2dku3jaFX06cMq60tMI5cm9v9+joCBwdHT0KheLmzesOB6oKC8WbKpF4RUUpHGwxDSKwEVT0OcRjSyijbOsW3OLUEFmtLnEj2trbW4cGBuBgR7FDoOGE3VUsw2aTWRwBDpZ/exSJwFbFZ2RkcJsggoP33nvvX37737khIfR6PX7UcKgK1Q8ePIQD1fjff21bFvnOal+oUR1q9YaGZpf1nrfxD9JqME8xaEdevlyTyWT9/cPc621PnK6xsXZ9dV1cjTs0DZKv6oeGBtCM2tYIyyS3fAxCVfjaPBE0AMUCUsM5MjTBlYLLwrYpJIhPuPHLwc8Jpcoe6zt2dnZwW/G3srKUk5Mp3m8F4L7fdAf+3BbFZyYiMJM9boExMjIkbN3CH/IgZAMxr1/7G/ySWUwxuAkQdmw5mHAUO+TqXxUIOWcZgD8zWQSHDBAEEaBsbW3JZNJcINzT08EcQsudm5vHHO6nn8Q1KkxxrY7a3vlYb+Pvu9XYq9aFdkEoJAu37QieECs4HRJnpwNwIAhNg/hcQVLV29cInzjBLakgPFiP6dB9g7IiLBFHV+Dx9JPFp8/xebv+LiumKLXOBZTRev8+ikvSuXMPv/gFDsGfsBgZ/ij0zJ2QkIAgxGEm4rPIwiANBDiSYnkou1GJoLGJx/gTJ4jS7PC7glQtLS5iR/34s8/Qa0HOcRROJOSc5QEnQlJI2XbYm1PgDxljPpKBrSDjBkEEB/bFNFKr4RmsjUeFJvRFIW5Y/caGtF2i1X6Nxt6hVn+y+By1Onzgj1C9Xm+Pa8Pb+AdpNfYBTtTb3Y1PnAv1PE6ET9T5LBTnEvIm+ao+PDxye/s3779+/VqqS+JBVlY2d3kPZIF4lfGDBw/Zd4/Pysrqnr5+oYCKC7QAK2QTE9P4meEQgBTuff5zFsrmgxgIEj+5nEUOD+cPDWpsrGU/Dxx79+49BNmelCmXw4EE2e8KjI+PMgejpqZC+FH19w+z3zyOQmZEObflASdCUhER/PEVcNhOLzlBAyJPosTTviciuJDqAmFIhzdVXCHzYaSkpeETQYjAfBy4U1fLHOJaXaFQoFYX6mdhBAh4Ff+Arcb+wMWyc6Gex4nwiTofNT8LFbq7kq/qIyPt+56MRgk+n2ZyUstdB0BYUQ/dIJ6VZKAoVN++zdziH4AAyi4KGTfeAKXMyrTnoC+CQ/AnXl4joFIVsgTNZtuGRgZ+V6wHk3TunHMekHPhZ+/D3xVBEH4IagPp1fCALUBB7Yc6kPkwhLqaRXAADfwbJaR2rtWF+lmY5fE2/gFbjf3hch/MjTfjMS9fBte7e23vsCRcIqyod/jNCKAYORRoMUw3OOPtdBibMxoc/pLbb+OythofH2W/q72GqVDcvxx7/GTxufP6IQkTHR29uUmPEiaIgMdgsK0FgSNOGedQB6JOY9UyIjj32YTxbLW6hDkcuHuv+bF9fp+Z3sY/YKuxP4RVRGIUiu8elx8kRMfEbG4a39/a+lYmub3cyckp3OUL3PRy8IvCJwTEM6etejExMdx1YJAB53Xp+FWjD3Hz5nUmX8Ssrq4yR0ZGFnM4gNTwy3dOkyAIiWFfIyy1Gl54WLDL5lyYjXIeC2FKAo39XnMu2dmfIUio872NL7C/VmN/0EvXxdjWCIdJbrZVmDLcd79c2DnlflglMTGZuw4fpmBycjLPnvkEf5+e/eT6tb8ZevOgZDHBNthIEMRe2Gr4MKnV8MISYI2mF1Wiw5+w9gCKxHSET2rxw1YjCJHm3JMwTuN56+7P+9na21shYpiCWbZvxsMfug74UxWqg22AkSCIYEZY4wJQH7r8Y6GINjT03W4MIhh4Pzb21LffbnBLKghTquxVIJ5QV3cLugEan73JUth2dOzcvHld2BnIRMzt+rtsBnfx6XPnJcAEQRACsbGxEqvhhTUuSefOufljccQ7TA8b/2k1ghnJrhEW5iz32tHnAHvgIwT+yZO2eSthgZV7VeSTDVZuMBgMbHYJmWHPmIGIqaysdjmDK+DJ9Oqz4Ht+tsks5bcTE0QwIGzqRJU4MTHt5o9V4KjVR9w+f88Zb5e5CPEP3mrsNbHgeec8mDHbtvjJ3pfJpPkgMmHtWG939zvnldrbW9lACNS9sBVImBN10/azooZyvNcKsgMi9Eiyc3Nd7lESZnDFKJVK5nC5mxHgqIuZn17KcfFESwnzWrpv8iOIvYiQ1qMmhc3SqBKZz14IO0+FWhQIfd29HmOBtgB149kznzAl5G38A7YaRqORuwjvYY9iej88PHxHipomP1/Fhh9RHMvLi5mnS9DAC+OT4g17bFEODt/rZd3CQ59YuT8IKNxM4O+FsOrZAZdvaxPe5cY2FjrDtA4yL+ikvXZISYndXdI0RNAhMU0j1GmFb54ptxfCA1rEK4Xf+fIEYRAlLc32Yjhv4++v1YiOjmYOl98UTs0O8QkSrup3mabhlhTp6OhhTfvff/11Tk6mS6GNEiZ+h4D4yUVlZTfY4UMDGucCDSUkPC+ytLSCOXyOMEG7srLEHGKQK5f7nuRyufBUPeeRGOSc1QvQfM5PapLkoB3DbN6KipLgK+gJIkhAHc7qatRd73wUBSII3dru7k7mKfR1XdbqaA7Y+mLUn2ye2tv4+2s1hJ1QqJkRh7kZMFvv3+eGT5FeVW/+DWr4D96PiYmR6ngXynT17dushKHkXb50Ecrmzp269vZW/KGxP3vmk7pbPxN+JOJXngKUUeGZj9ftLwPDLwolDMAtKKGyG5UuZ4X2B/LJtiPi1wJTGHGBLMNJcWq40edAToqKCpArmCyCw4TrvXufCz8txMSvi+Ucly/k/MaNKnvct+jubGcZMBhscQiCCGhiY2MlU8MLz5vJy8tnDvcI0cQj1rW1jcwhrtXxCTeaA/ij5rx9u57FAV7F31+rgaaKvaEJoYiDWlo4BTuE6SrfItWq/r1f/OIXU1OzDx5+wT0kBwpHbW0VU9N7oXrzqnpnoAaEV0g6gKKsKiysrKzmth2opftNd+C4XX/XIYiBMoTM4NjFp8+5lx2UYxQybtg11sTENBzIANMuDKZUWH4QB783/M6heOA/NvGY9RUYbi4ckfHDcxikYRnjxt75D1w+PfvJ2NhYfDw9n4oILt57771/+e1/50Ygg14oqj7nus4N7BA4Hn7xC6HGc1+r9/T1O6x08W1851YDQFhcKbjs8hDkHKoUzQqOFbcaQo2913so2bULTYmAVKt6NL4hr63/7q//+q//6z/Meyh7AxEU/b/6q6sxH374byH/9vp//FtExPctlt/CH+UD7uzcnzT+p5Zr11y8SonxH/7Dx7k/ybP867/u/OsO4gt/OLDr//g/s7L+ksd7w+rqc0T9k+joH/0o8c/+zMWzlRYXF0P/IPSHMT90uOcZGf/zie99z/grI0tfiIAMpPz5X/x/r7ZZ5llkRdzp6zcq29r+yw9/+MPQ0DDjr7/9g/A/+P73v4/ILAJgF440rf/D+r0ToSxZ/LGc/8f/6PioZUQ2/vrXwmV+/KMfpaT8OQ+TBA8720tKSiIjI7lNEMHBz3/+4Kr6Wmjo97gdmGi1X6/+8v+1Va2Jf5af/79x33dh/LUx5P0QHPXf/ttudvb/wjz3qtXLbtzs+7/+b2e15Kv4e7UaALW36q8K/8VsFh9yLvXTlv/8X5Bt1qw4tBqsKcGl/eQn/ysO574idP91JuL73z91Kl64cIZUq3r97PT3vnfivenp6YaGhi/H+OsqggE21PbO6VhCYnx0+sPnz5/Skhoi2Pjgg9gvJx7HvFmIShCSpKnpjlwWEYzvsISaIUEThJjNJhI0BEEQksT+fBq5bY0wvayYIAhCqsTERBupkieCg/dDQ0Ot1tfcIgiJYjKbZTKPFhUShMRAJb9rtXKDICTKlm0vd9T7+Ge1Wi0W/32DI0EcHPRT0VvlBkEEEx9//LGB3tVPSB17JR9jW08TF6cwGGxv0CAIqfLixQq94p8IThQK1PAuNgkThGSwWq1GozE+Pt6maST5am6CEIM6HdqdGwQRTEjv1dwE4QBqeLb1x6ZpEhKUq6urdn+CkCYvX67R0/aI4CQhIWH1GdXwhJSx1/C2x7PZNA3q+r1ecU4Q0oBNtXKDIIIJWjRJSJ7NzU2FwlbDs/U0cYZ1Wk9DSBZhqpXbBBFk0KJJQtqsvVhVKpVw2DSNhF9jSRBAmGoliOCEFk0S0sZg4KsLbJomLCwsOjqGFsYTUkWYaiWI4IQWTRLSxr4LJA4Om6YBcXGKtTUamSSkiTDVShDBCS2aJCSMyWwOD48ICwuDm2sa20OZDFTiCWkiTLUSRHBCiyYJCfPi2bOEBF7Dc00THR1NS2oIqSJMtRJEcEKLJgkJY3i59vHHfHUB1zSJiYlrL1aYmyAkhjDVShDBCS2aJCSMeBcI1zQJCQnr6wYrveeMkByrq6so7myqlSCClpSUlKWleW4QhIRYWZpH8WZurmlQ4yckKJeXl5lJEJJBp5vJysriBkEEK+fPpy7o9dwgCKlgsexsbhoTExOZyTUNyMjImNfNcIMgpML8vC4tLY0bBBGsoIaHvucGQUgFnW4Wep0bjppmXscNgpAK+ln9+fPnuUEQwUpsbGxIyIlNWilMSIuFBR3UCzfEmubcuXPr6wZ6JwghJZaXl+PiFJGRkdwmiCAmOzt7ZlLLDYKQBCjSKNjcEGuasLCwc+eSdLpZbhNE4ONQ3AkimMnOzpqZmeQGQQQ+m0aj1fpa/KiO7zQNyMjIWFig6SdCOszPvzUsSRDBzPnz5/WztEyYkA7zuhmHGt5R09AyYUIyWK3WZ89Wz507x22CCG4iIyNjYqLpxU+EZFjQ68ULhMFbmiYxMXFz00hLaghpsLy8nJCgpCfTEIRAVlYW7X4iJAMKs7txGgDJQ0tqCGngPCxJEEFOWloa7W8lpIF9E98J+4a+73DUNGgDaEkNIQ1oMQ1BOEBLagjJ4LLX6qhpaLMfIQ1oMQ1BOBMZGRkXp6BHxhMSwHkxDXDUNPY9USfoVWdEoDM6OpKXl0eLaQjCAfwutNpxbhBEYIJe6/j4uEql4vYbHDUNUKsLh4YGuEEQgQk0jUqVzw2CIN6gVquHBqiGJwIb6PLs7GznXqtLTUMlnghsTGbz6rNVetoeQTgTFRWVkKCcnJriNkEEIENDA2p1ITdEuNA0KPFxcQo9vcGVCFiGBjQlJWpuEATxNiqV6uvREW4QRKDhptfqQtMAtVo9QtNPRMAyPjqSn08TTwThGmia8fFxq9XKbYIIKEZHhpxX0jBcaxoq8UTgwh6TmpiYyEyCIBwICwvLy8sbpaEaIjAZ2WPiCbjWNCjx2dnZtDaeCETsq4NdS3iCIBgqVT5pGiIQMRgMVuvrvXqtrjUNoN1PRIAyNAAJT4tpCMId6LWuPls1mc3cJogAYa/VwYw9NQ2VeCIQmZyaSkhQRkVFcZsgiD0oKVEPDWi4QRABgvte656aBqhUqtGRIW4QRCDwNU08EYRn5Ofnj9P0ExFQ6PX6uDiFm16rO02jVhfS7icigNjryZIEQTjDViSwNfUEERDYVwe7W1rgTtNQiScCC42mF8Wd3odAEB6C3wutmyQCBZPZrNPNuO+1utM0oLGxsaWlkRsE4cdYrdbe7s7bt6u5TYiYmZlpbm7mxtuIg+CAydxiXr16hSB8ctsJN0GEP1NWVqYdH6V1k0RA0NneWllZ6b7X+g5Nk5eXZ9zcpKEawv+ZnJxKSEig1cEumZ+f12hcrwYVB8EBk7nFGAyGurq6vV5tW1xc3NnZyY1AALotLS2NG8ENmgc0EmgquE0Q/gp6rdDf71xa8A5NA2iohggI2ltRVKmges2NGzeGh4e5sS90Oh13BQjQbSaTiRtSZ21traurq62tbWVlhXu9DRuqgWClSSjCn9FoevPy8t/Za323pqGhGsL/GR//OiYmhp4dzHj58mWzna2tLe71hv7+fvjjk9tuYdNS7iOzltJisYibTHYgmlLnDAi8evUK+YQD0RDZec6LZRWwaAy4cSBLX/AXrlccU0jf4ZLhj9zCgQxLfsqstrb28uXLqL2NRmOxnd3dXR72BnR/4+LiLmZ+ym4LQfghni8teO93v/sdd+5NX1/f1NTsg4dfcJsg/IzM9LNotEjTALRbOp1OLpfDbTKZ6uvri4qK0KhrNBrmCfR6fWpqKhtfYUGs+T916pRarUZDCHdaWhoOxyHsE4c8ffrU+Q6jz/PVV18pFAqlUjk6OgoRU1BQwA5BqJABFlkMzqvVauGQyWT4RLuLM6KqgRuZycnJgYMlglNXV1e3tLTAjTjIJMs5iy++XnFMIX0Ggn76058ih5BQ7e3tBoMBd0ClUpWXl/MYkqOqqio0NBT3gdt2+Tg5OYmbwEzoG9yK3t5e3IfOzs5ffvMrxGdBBOFXdHd3mk2mjo42bu/Nu8dpAEq8TjdD68gI/4QGaQQg7NDADw8P4xNAoDQ1NbEgtOL2H7KNhw8foo0Xj2o4gIYQcoSlg2iQETzACTSQEDQ4EWspmUSA+mEnguxABvYarUEesrOzcSDo6emBtGKjNTU1NVBIOC9LBDKFJc6ADyIjFILG4XofPXrU2toqDPkgffElQ3vhKOQQuUWe4SlhQTNvRyxoAK43LCxscHAQaqatre2jjz7a2dnBl4VoanWJRtPL4xGEP+HV/g+PxmkAfgDrhs179z7nNkH4DTRIIwANgU+01swEKysruDNotITBGAZkCqSAQ5AwTsOGQ9ioCUDo6dOnXY7TAOEo5nYYmIFPZWWls3pwzpJwUmig8PDwkydPMn9IHGgaFtPhAp2vV0jEIX2kmZ6e7nzJPmFtbQ0SkBv+AS4QQt95hRnuTHd3t9FolMvlEIvC6gSLxVJaXv706S9pqIbwNzwfpAGeahroelRqE9NP5PaBYoLwE0ZGhgY0vWiluO0BGxsbm5ub3AhY0CzhQrhhB6310tJSdnY2kxdinFtxNPxuNI3gYJGBED8vL8/8ZsgWDST8hcjQT2fOnHGQPiw0Pz+/uLiY+chkMmgUnFer1TrIEXwyn66urqEh20PMBa3gUtMgcYPBoFAomAnYpBIieHLJuIEffvghDz4AcXFxbPLLf0AJx21vaGjg9hvwld28eXNnZwcZRra5rx3c6nxV4Y0bldwmCD/AarV+evaTxcVFD/e0eqppAA3VEH7Ixcz016+tbE2Gh8TGxkZHR3MjYEEvHBfCDTsREREVFRUpKSlsQYkYH2oaxOde9j1TJ0+eFCK70TSIKd7vjchIZy9NA9m0urqKo3AtaHeRPSGHzpoGPkicmYzw8HD4e3jJUgXaRa/X45Pbb2AqBzehsbERBQZmRkYGC9ra2jp79uyTxec0VEP4D6OjI1N///fDw4PcfhdeaBoaqiH8DbR8FeXFL1684HbQwwZRhCZfmHCBevCkgWf6A4LDIZ2ZmZnMzEwP555wrCCqWAZcLhN2qTmQTn5+PuqZR48eCYe4mXtyyCcoLi6GZ25ubpBrGlTXOTk5uFLoQu5lH6G8fPny9PR0ZGQkTHytbHJKUDYVFVUyubys7C2NSBDHiLdLCzxaI8ygpzMR/kZNVXlPTw83CFubVIHeeVdXFzPr6urkcrnn1YGAOB3oEucpDAcMBgPbyw09Af3BVuniwIKCAmTA5b4ngKOECSnmgKaB8lAoFLOzs8x/fHxcvEDYAZZPIRGoH4iV8PBwZu5FREQEPpGyhPdyo7ru6+srLy+HrMHXAfBtQuXAkwkaAB0Df3y5UDbMfft2dW93p9VqZREI4njRaHpTUtK8qsG80DSgqqpqXjdDz6oh/IGhoYH4+I/F3VACLdOjR4/a29uhDMBL++YgHuYN4nTS09NVKpV4zYoD0DE6nQ7yBe6WlhaYpaWl7ECZTOYmAyxNe05tWR0eHmZT5vX19UiQ+eNwmPBEi4tPJCieZ2T5FCJD/cCEJw/eA+QQn6jNAuvxx94SGxv75MmTnZ0dSBaAehumc/PA1AyUTW9vL9QeOq5NTXd4GEEcHyazeUDTe/eu7efvOV7MPTHm5+fRN5p4PMdtgjgOLJadnIufzs3N0csQXMImVtDMM3PfsG1T3PAGHCiXy918O8IE0NbWFtpd56y+MwUxvrpeYnd3F2K0pa1LqVRyL4I4Dm797GZSUoK3D1zwWtOA0tJyRVycWl3CbYI4curqbsUpYtDV5jYRaATDopYAhTquxLGz77WS3s09Me7erR/Q9NIj+IjjAsV9XjdDgoYgDoOUlJT4+I/p9U/EMQJB0+/ZK1wc2M84Dejq6lpefvb5zx9wmyCOEHrIngR49eqVwWCgL9E/YRvWJh4/iYh4x4JrgvA5Xj1kz4F9ahqQnJzc2NyWlJTEbYI4EjSaXsP6ek8P39pDEMRhQB1X4lgwmc2XczIXFxeFDXpesX9Ns7KyUlRUND23yG2COHxQ3K9cznn8+DEtDSaIw+bjjz/u6OqjxcLEUXLz+rULF84LD2jwlv2sp2EkJiZmZGR1d0t5MyThb9y/U1dZWUmChiCOgP7+/oryfTYtBLEP9Hr9t99u7FvQgP2P04Dt7e2zZ89+OTFNTxYmjoDl5eWG2qqlpSVuEwRxyNAuV+LIsFqtly9d7OnpOcgyuwNpGtDX1zc1Nfvg4RfcJojDwSfFnSAIr9ja2rp48eLglxPUcSUOm872VtTzLS1evJDYmf3PPTGKi4tPnDhBu/6Iw6ap6Y5KpSJBQxBHSVRUVEdHR3nxFW4TxOGwvLw8MzPp7VODnTnoOA3Y3d09e/ZsT9+gm6enE8RB0Gq/HhnqHx8f5zZBEEdIQ0OD9XVIdfVtbhOET7FYdi5fyhwbG4uNjeVe+8UHmgasra0VFBRMPJ6jl9QTPmfTaCy+cnlubm5/W/sIgjg4aWlpVTUNqamp3CYI31FUVFBqf6M+tw/AQeeeGPHx8ZWVlbd+dpPbBOEjrFZrVXlxT08PCRqCOEaGh4cbaqvo8fGEz+nu7jwVe8onggb4RtMAWlhDHAZNTXdQ1unl2wRxvNDCGuIwWF5entSOf/75PW4fGN/MPTFoYQ3hW2gZDUH4FbSwhvAhPlxGI+BLTQNoYQ3hK2gZDUH4IbSwhvAVPlxGI+CzuScGLawhfAItoyEI/4QW1hA+wbfLaAR8rGkALawhDg4toyEI/4QW1hAHx+fLaAR8r2nAF188HBkaQKa5TRDeAEFs3bFUVVVxmyAIfyIjIwNdjrq6W9wmCG/YNBqbG2v7+/vDwsK4l+/w8Xoage3t7UuXLjU2t9E7XQmvmJyd0nR1TE5OcpsgCL+E1gsT+8Bi2blSkANBEx8fz718yqGM04DIyEhkuqG2CoqMexHEu9Dr9RA0Y2Nj3PYz0DdNe5vi4mKUcx7sFsQE3HDLy5cvmcPzQ7yiq6trrzlsN0ESAzcZX19NTQ23/QmhAPg5jY2NJuMmLTMgPMdqtULQ9PT0HJKgAYelaUBsbCyyXl58BbqMexHE3qyurra1NA4PDx/GgKRPQA5lMlm2CDQ/V69e9aRpRExP2io0tCMjI8y9bYe5fYjFYsGFcONt3ARJjPv375tMptHRUW77DeIC4P9A0I+PjkzOTnGbIPYGgqa0tAhS+FBf23eImgZAi0HWQJfhYrgXQbhi02hsqK1CFennG52Sk5NrReh0OrVa7cOmEQ0td4WEINkjbnRxRZ4ILwnAvjg4PBxmOzLEBSAgGBsb03R16PV6bhPEHtz62c38vDx0Bbl9OByupgFQZNBlUGcka4i9sFh2iq9cRuviwycvHRkKhcJgMKysrHDbPoNjm5dKS4ODezkhxCkuLp6ZmWGezc22l+wvLS0xB+KIU8D9YZNfNTU1r169Yp5wsMj4RBAiCKmB8fFxdoj4LAxoF3iyoK2tLeaJOCw1AAdL3DlZMcghggA7kXA4A/7sLEB8LSxx+MBfSFwwHXQV8wfiFBzA/XeGhznBdAw0DdLs7e1lngK4G7jDCHK4ak/8xc+HxDWKoyHzQv7Z5SMbOAoIuordPaEABARhYWHDw8NtLY1BMsJH7I+6ultJSQmoDbh9aBy6pgHQZVBn9NAawiVshjVABQ1ACwRZI4ymookaGhqyT0xlt7e3o51j/mLEcba3tzMzM8WNnwDiAOZGOk1NTadOncIh8/PzZ86cYUIEckqj0SBBOBBkNptLS0tZEFrQqqoqdghM8VkQOScnh82j6XS69PR05o+UkRpzw4E4uLqSkpLIyEgc7vKBzshhg53k5OSUlJS6ujqh2kJ8HAUHzoIg8d1giU9OTgp5RpBgIohFA57cT8iXAlfsJWtGR0eVSmVUVFRhYaFerxfffMgp3A184nTsqpng2Msfxwr+uNWXLl0SJiJxjbifzA3sXyb/NtnlIxvsqKtXrwqyJhCh1ZOEezrbWyPCw49mK+th7Xtypq2tbd2wee/e59wmiDczrBXl5ajcuZcfg+YHn3K5nJmAzRTU19cXFRXBge41mqunT5+ePHkSJmtrWSjaZvhAQKAVRBM+NzeHNhU+AMmq1era2loHt3AIGgw0e9PT0xkZGbYD7EFQJGgUcQrom+rq6paWFvij9w+TpYA4SK2vr48dAjUAtZGbm4tMQnmMjY3BDX8oD7TEyDNkGcs/Wmj441hcKc5uP9q2YBn+gimAs+AmCJeMFh25YingjGjthAzslTgUGGQB0mExEeH06dPi/Li8nzD3BzudkAhyIpwaMM0kTPkJV72Xv/BFMH/oyOvXr3/zzTdIFghfJUBMfLJLRpD43joEiY8KIDY2NlCQvhybjogI514EYX82x/KC/shU+1GM0zCg0aDUWlvvc5sgQkIqyq8VqlQBIWgcQEMO0NRBnQhNrFarRVvFpqIAfGAKDR4DugTNIRM0cLgc/HBgdnY2NTVVEDQAd0w81K9SqZgDbT/OyNxoHSEIIDLYOASywUQMUCgUghuOvV7QJiQLbty4odfrkWFui8AZmeYA4q8SZxS0Au4GbgtzM4SY7FYIeUC2Bbcn99NbcE/wyTQKcwjaAuCuZmVlcSMkBPlnoS79IY9QBioqKrhvSEh5eTky78kiX/GNksazJWNjY9FuXSnIoU0hhMDk7NT46MhRDkMenaYBLS3NIa9f05OaCGC1WgsKLuXm/vjKlUB6ICn60GjMAFp3dK/Rvq6vr/OwN0LHPu/BgcnDRDQ3N6PlBjk5OS0tLQ6NvTMulcQ7QbtbXV2NHGZmZuJcQivuOc5t7c7OO5qriIgI7rJnGydlV4pbgZvGAzzGw/vJvgtnXN43aBrc8DNnzrCM4f7AZCtdXtlXKTlf9V7+yAyOFV/y/jh4Cn5CYmJiR0dHcdFlmoQiwNDQwNE/m+NINQ2ArIlTxNy8fo2WDAcz9scuXaqpqio+/CVjhwdEg1wuLy0tZW0egMmaUjEO4wrostTV1VVWVk5MTCAULf1ewyQCMpmMu7wEggmn+Oabb3C61dVVb2XNixcvuOsN4eFeTCvgyzWbzcPDw/bb8BJykAd4jCf3EyBativgz2O8YWZmBirk0aNHyJVAamoqW+nCRpscrnplZWUvf3Y3LBYL8yEAlB9kTVV58TuVOiFtOttblxf0k5OTR/xsjqPWNKCqqurChfO0EypoQR8OPTk0t2h1uFfA0tjYiLr75k2+/h39fofRCDTJzW/vYUGTjEa0vLwckWGy9bzuycrKMplM4phLS0vODbYDUDBsvSpOhNPB9HZnyuzsLHfZl7hCe7E8ewKafL1eX1JSIqye3kcj58n9BNActa4QZsQEBgYGcBVFRUXIlQAyKawUxl0VXzXOVVBQAIdLf2QPqSFN7vtGMwkjOmK543KESZLglkK4V5QXe1veCMlQV3cL7ftRTjkJHIOmAejAVZSXX750kWZegw3U+OjDoSfnPJIfiGRkZFRXV2s0GrYs5t492yvZ0O6ibUOjDhmBlsxhfAICBS1oV1cXIuAo1mSKGz+tVuvQbEORoE1FTJYsfj5fffUV5BQP3gO0uNBPqFZwCD7h9nacBnoCOcHh+Gxtba2vr+cBHoCGDe19b28vDgdQV/uYe/LkfnoF8uB8EyBxkFWUSbiRT3yb7Kpx0+Bmp9vLH/dE7F9aWvrTn/6UrXxSKpXs/iPzXo1HOheAgCM2Nvbx48c1VeX0OL5gA1Lm5vVrcYoY21KT4+B4NA1AH509jo9mXoMH9NvQe0MtjwaPewUUaKWclz60tLSgGWMTIlFRURMTEzKZDG0bEysw2RpYKAwABwQKZFB7ezsi9PX1QZqglX35ZuUH0w1LS0v4FA4BaIzhZslub28Le6DCw8NTU1PFU0KIxjKJjKHdharAIfiEGz7wR6jDW9hgshQcgpAx5ASHo5UdGxtzudvInsfvBm+QjpDC8PAwPnE4QMq4FVBmaODh6XAnnU2WHzf3cx9AQSIDJSUl3BaBKzWbza9evcrNzcWV4npxuqampsrKylr7FqS9/HFPxP64yawkADigxuCJzEMz4RDhRjlcL9xCkLgABDSRkZFzc3NDfT308oTgAYKmtLTowoXzx/gG4qPby+2StbU1/ODpVZfBAHps7c2N6L2hsuNehB+DVhYtNGu5CWJ/7O7uXrt2TRGnLCu7wb0IiWJfJZmDTtrxLio4tnEaRnx8PHrtDbVVy8vL3IuQIuiroceGfhsJGoIIHsLCwlDDm02mpqY73IuQIptGIwRNT0/Psa+SPGZNA2JjY8fGxpoba0dHA+bNbYRXtLbeX17QD/vxyykJgjg8Ojra5LKI0uKrtC9EkiwvL5cXX/GTRQXHPPcksLu7e/Xq1fDwiLv3Pg8NDeW+RIBjMptR1jMyMt65oJUgCGkzODh4//79nr5BxbseXkAEEJ3trVrt+NjY2L4XuvmW4x+nYbAXoSUlJVy+dJEebCAN9Hr9lcu26VUSNARBXLlyBZV8afEVWjUsDSyWnYKCS1ardWlpyU8EDfCXcRqBlZWVoqKikrIbKlUh9yICkNbW+/O6GVRh/lPWCYI4duyrhq+/erXT0vaQ3gwVuCwvL1fYn8rhb48Z85dxGoHExMTFxcXlhQV61nCAYjKbL1+6GHrCtv2YBA1BEGLsq4b78vN/eqUghx7KF6B0trc21FbNzc354XNT/U7TAFboL1w4n3MxneahAovJqanLOZk030QQhBuuXLEtKa2pKtdoerkXEQiwLqu/zTeJ8bu5JzFra2sFBQU0DxUoNDXdWXuxMjw8TBu2CYJ4J7u7uzdv/uw3vzHTPFRAoNfrG2qrOjo62AM//RN/HKcRiI+PF+ah6C0K/ozBYMi5mC6XRUxOTpKgIQjCE8LCwnp6utg8FD2izJ+xWq3osra12B6a6s+CBvi1pgHCPFRm+hkapfRDWFkvLb4C8U7PnCUIwlvYPFRDbRX6riazmfsSfsPk1FRm+ll0WQNiiaS/axpGcXHx8+fPDevrORfTSc77D0JZX1xclMY7KQmCOHri4+OXlpbQd72ck9nd3cl9ieMGErOoqEDT0/H48eNA6bL69XoaZ+bn5ysqKhKTU6qr62n+9RjZNBprqspPhIT09PTExsZyX4IgiAOwvb19507T/LyusbktKSmJ+xJHjtVq7e3u1Gh6Ozo6nF9l788ExjiNQEpKCuR8nCIm5+Kn9OCmYwFlvbO99crlnJqqqsnJSRI0BEH4isjIyI6ONrSjDbVVt352k5ZRHgt6vT7nYjqq+m+++SawBA0IME3DqKqy7YxfXligzd5HzOTUFCvrz58/98MnExAEIQFY3zUpKSEz/Qz1XY8Sk9lcWny1raVxeHi4paU5LADf0Bdgc08OzM/PFxUVZ+fm3rhRTVNRh8qm0Yie02urFV2o+Ph47ksQBHFobG9v37z5s7W1Fy1tXUqlkvsShwCbbIKCvHv37pUrV7hvABKQ4zQCkPMvX67JZRGQ863379Oa+cMAaubm9WuXcy6WFhdPTk6SoCEI4miIjIzs7+9DP6qivLioqIA2iBwGUDPd3Z2fnv0EjsXFxYAWNCCwNQ2jtrb2+fPnoaEhOZmf1tXdImXjK1ZXV5mauXDh/LffbgTcxCpBEBIAfdcXL16gT9VQW3X50kW9Xs8DiINhsey0t7dCzZhNJqiZlpZmCTxdLLDnnhzY3d3t7u5ub2/PyMq+UVkdEx3NAwgvgZppaWk0bm5WVlYWFxdzX4IgiGNlZmamoaEBDnVJRW7uZ8yT8BaoGftMk6awsPDGjRtSejGfpDQNA8pGo9Hcv9+alpZWebuelI1XoA/U0dEC2d7Y2EgDMwRB+CFQNm1tbZvodFU3kLLxCpPZ3Nneqh0fVavV6LJK77HvEtQ0An19fXfuNCUlJVdUVdP6sncCNdPWYnvxZG1tLe1pIgjCz1lZWWloaFhfX79RWU3vBHwngpqBlIGgkepLbKSsaRiDg4P3798PDQ3NVxXm5aloe5QDm0bj6MjQyNCAXC5vbGz083d5EARBiFlbW7t/v1Wr1ebl56vVJQqFggcQdqxWqxZCZnRkeWH59u3qsrKyQNyh7TnS1zSM+fl5jWZgaGjowoWs7NzP8vLyeUCwYrHsaLUQMwObm8bCQlVhYSFtaCIIIkDZ2tpC9d7d3RsS8rpQXZKXr5LLZDwsWFleXh7Q9E5OTqKnqlLlB8lagmDRNAKDg4NfffX1zMxMdm4uRH0QzkmNj389Pjqi1+uys7PV6kIamCEIQjKsra319vYODAwpE5Tou+IvNDSUhwUHm0bjyIBmyD70XlZWBikj1WkmlwSdpmFA1I+OjnZ3d1utVtucVL5K8kuJV1dXNZpe7fj4uXNJKpUKBV3aI5AEQQQzWq12aGgE9Xxubu5neflZFy7wAIliseyMjtpWEZhMZnRW1Wp1cL64Jkg1jQBE/YCNIblclpGRlZKWkZqaysMCH5RynW52YUE3M6lFZ4Vpdilt2yMIgnDD7u7ukJ1nz1azsrLOpaZmZGVLaVoKndXJSe38vG55YRmdVaiZlJQUHhaUBLumEZifn4eun5mZ0ev1kDVpGVlpaRmB+GJYq9Wq0+tnZybndTObm8bz51MzMjKys7NpuQxBEEHL1tYWavjZWT0+IyLCWfcVn4Gob6BjdLoZ6Bj9rD4mJjo3NzctLY02qzJI07gAymbSDooOdH1KSlpWVrafr7yZnJpamNdBxyDP+K2ifEPKJCYm8mCCIAjCztraGip56Bt8yuUyKJtz56AKzvvzrliDwWDTMeiw6nXIc1YWet1p58+fD6q1Mp5AmsYdu7u7s7OzOp1ufHx8c9OYkKCEvpHJ5adOxSuVCcf4A9g0Go2bm0tL82azee3FCor5hQsXIGJAkA88EgRBeM7KygqUDZM4MTHRH3+cGB0dnZCcEhsTc7zbwlGrf/vthq2eX1lafbYaERGB6p2Nu9P6ATeQpvGU7e3tZ8+eoeibTOa1tRfPnq2+fm1NSkqKPRUvl9mUvlwuP6TfwPLy8taWaX115eVLg9G4ATM6OgY/P+h0mUyWmJiIUs6jEgRBEPsC+gZsbm7Oz8+jE2swrCuVSnRikxOTUeN+8EEsKvzD2EXl0EddXzeYzabU1NTY2FOo59FNTUhIIB3jIaRp9s/u7u7CwsLa2prJZGJah/0GIKhZBPwGIPmZG7BfBTdEvHixsmOxcAPm2gvBxK8LpR0/JAgmaJe4uLjY2FgaiSEIgjgCIHFQvTOJs7HxEv3J8PCIuDjedz0RGgq5w9wMdG65S8RvfrNlWF/nRkiIZWcHwoUb9vEYhz4q6nlSMPuGNI2PwW/A8kaRbGxsQJQwN2C/Cm6ISE5ODg//bhoLZVpQRSjpwbkfjyAIwg/Z2tpafyNQrFYr5A5zM9C55S4RUVEfCDIIoHoXr3SkUXZfEhLy/wPo6Nt/ifly3QAAAABJRU5ErkJggg==
这里有两个概念:
- child-to-parent:父子关系中,查询子表数据,子表作为 FROM,比如上图中搜索 Contact
- parent-to-child:父子关系中,查询父表数据,父表作为FROM,比如上图中搜索Account
标准表和自定义表父子查询也有一些区别。下图中有两个自定义表: Daughter__c & Mother_of_Child__c
我们可以看到Daughter是子,Mother_Of_Child是父。Daughter表创建了字段 Mother_of_child__c,child relationship name为Daughters。当进行parent-to-child查询时,在 child relationship name基础上后缀添加 __r. 来查询子表数据。 当进行 child-to-parent查询时,field name 后缀使用 __r 而不是 __c 来进行父表的字段查询
注:标准的表,直接使用 child relationship name即可,只有自定义的,需要使用 __r
查看下方的关联表跨表查询操作相关的demo进行更好的了解
| child-to-parent关联表查询 | SELECT
Contact.FirstName, Contact.Account.Name FROM
Contact
SELECT
Id, Name, Account.Name FROM Contact WHERE
Account.Industry
= 'media' |
| --- | --- |
| parent-to-child关联表查询 | SELECT
Name, (SELECT LastName FROM Contacts) FROM Account
SELECT
Account.Name, (SELECT Contact.LastName FROM
Account.Contacts)
FROM Account |
| 包含WHERE的关联表查询 | SELECT
Name, (SELECT LastName FROM Contacts WHERE
CreatedBy.Alias
= 'x') FROM Account WHERE Industry =
'media' |
| 自定义表的child-to parent查询 | SELECT
Id, FirstName__c, Mother_of_Child__r.FirstName__c
FROM
Daughter__c WHERE Mother_of_Child__r.LastName__c
LIKE
'C%' |
| 自定义表的parent to child查询 | SELECT
Name, (SELECT Name FROM Line_Items__r) FROM
Merchandise__c
WHERE Name LIKE ‘Acme%’ |
| 带有多态键的关系查询 like | SELECT
Id, Owner.Name FROM Task WHERE Owner.FirstName
like
'B%'
SELECT
Id, Who.FirstName, Who.LastName FROM Task WHERE
Owner.FirstName
LIKE 'B%' |
| 带有聚合的关系查询 | SELECT Name, (SELECT CreatedBy.Name FROM Notes) FROM Account
SELECT Amount, Id, Name, (SELECT Quantity, ListPrice,
PricebookEntry.UnitPrice,
PricebookEntry.Name FROM
OpportunityLineItems)
FROM Opportunity |
常见的关系查询的限制。
Child-to-parent 关系不能超过5层。比如 SELECT Id,Contact.Account.Owner.FirstName FROM Contact,其中Contact.Account.Owner.FirstName为3层。
在指定的关系中,query里面只能有一层 parent-to-child的查询。