Ver esquema da tabela
ColunaTipoPK
idTEXT
descricaoTEXT
grupoTEXT
cbo_idTEXT
esus_conduta_idTEXT
odontologicaINTEGER
esus_idINTEGER
ativoINTEGER
data_criacaoTEXT
data_alteracaoTEXT
temp_cboINTEGER
temp_esus_condutaINTEGER
esus_odonto_tipo_encaminhamento_idTEXT
iddescricaogrupocbo_idesus_conduta_idodontologicaesus_idativodata_criacaodata_alteracaotemp_cbotemp_esus_condutaesus_odonto_tipo_encaminhamento_id
c1ef7b84-5f1b-4b98-b489-8e5c58555eb4CONSULTA EM ACUPUNTURAMÉDICO1d301832-51d5-421a-b2a7-f5fe4888d35371feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>112021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
344dfebb-f537-4281-ac0b-31c5b5eb8409CONSULTA EM ANGIOLOGIAMÉDICO1bcadb67-6007-4593-8c50-be9660fc7da871feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>412021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
f63d7eae-6d18-4395-af42-b7a91ff8cf26CONSULTA EM CIRURGIA ONCOLÓGICAMÉDICOaff27b58-0278-4446-8b65-c57b0e6fa5ed71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>512021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
8cde1906-80a0-4e28-bf9b-75d72c7c4df7CONSULTA EM ENDOCRINOLOGIAMÉDICOca34c6bd-602d-4828-a0d0-20e2d483b57b71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>1612021-05-25T19:40:19.412000+00:002026-07-30T18:04:49.383000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
99dbb17a-7e88-42a1-a1bd-6994a03273c0CONSULTA EM CIRURGIA CARDÍACAMÉDICOceaf3e59-5e39-430e-a963-0994a083fdca71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>712021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
a213c464-415f-4cdf-8dbe-983442346cc6CONSULTA EM CIRURGIA REPARADORAMÉDICO713d754d-6023-40d1-bd70-8f4a112e878171feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>912021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
965a24ee-f32c-4191-ac08-fd778472bd9cCONSULTA EM CIRURGIA PEDIÁTRICAMÉDICO2d6c1a78-f0f2-4929-9ea3-04ecd7f445aa71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>1012021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
f8d1a2f9-596a-4586-bf85-9e663aebc51eCONSULTA EM CIRURGIA PLÁSTICAMÉDICOb7f454ae-e2f6-4012-bf58-0cfd91a8dba971feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>1112021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
e754fad1-1339-4db0-8956-fe164ccce151CONSULTA EM CIRURGIA TORÁCICAMÉDICO731d5058-4923-4a00-a2d3-79cac941de0771feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>1212021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
b528cfd2-6eb2-4a56-b3c8-c9da29be048bCONSULTA MÉDICA EM SAÚDE DO TRABALHADORMÉDICO7ab15e22-2d23-4099-bb30-beb22837cfef71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>1412021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
1d075b82-c509-41eb-aaf8-945852fa8aadCONSULTA EM GENÉTICA MÉDICAMÉDICO210f9bee-ec44-441c-8df2-5f146c27fbff71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>2012021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
fedd1584-efa1-4dbb-b592-a1459d3285fdCONSULTA EM GERIATRIAMÉDICOcd7d12ae-b35f-4a4a-a9ec-aa92ebd7a52871feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>2112021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
b019c507-54b7-4134-b30d-956700cfd0e4CONSULTA EM UROGINECOLOGIAMÉDICO00ba5b4f-7e36-4c07-ab97-2fba62b9dbf171feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>2412021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
2a754c71-582d-4408-a03e-ea8d6b25b899CONSULTA EM HEMATOLOGIAMÉDICO4a23b13b-65b2-4091-8e7f-1a9ea490110471feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>2512021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
9004bf2d-fd3f-45cd-94b9-e3d615d5278dCONSULTA EM HOMEOPATIAMÉDICO81a14da9-510d-4403-bf31-875d8c2e092571feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>2612021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
dc11cf87-6212-4790-a9eb-a12434ccbee4CONSULTA EM NUTROLOGIAMÉDICO5b6a25d9-94d4-4d53-90f1-f8db99e4e8a171feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>3312021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
964c4a72-f236-4715-bd70-036cea5f5deaCONSULTA EM GASTROENTEROLOGIAMÉDICOb0e0ed6e-37ca-4cdc-a4a4-c1e145ae8b6671feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>1812021-05-25T19:40:19.412000+00:002026-07-22T12:09:59.101000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
f32f698c-ddec-4027-9d5a-6af11cd3057dCONSULTA EM CIRURGIA OFTALMOLÓGICAMÉDICOd3203bf1-2772-4a14-8e6d-83bf726f855771feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>3512021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
14d41925-9a90-4a7e-b39e-1595957e3110CONSULTA EM TRAUMATOLOGIAMÉDICO9098b7fa-bfc2-4b70-8793-af569093b06371feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>3812021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
761ff1b1-7eda-495f-a614-ee3f31223463CONSULTA EM CIRURGIA OTORRINOLARINGOLOGIAMÉDICOab6c8fbb-045a-4e76-999f-ffdeeb79217a71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>4112021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
9bdf2050-1741-4aec-951a-ddb7208bb4b8CONSULTA EM NEONATOLOGIAMÉDICO9bc132a6-3545-4893-8cc9-e742b22b8e3771feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>4412021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
f4f8a4b9-4e0f-4abc-b4c9-ab328a30f597CONSULTA EM TISIOLOGIAMÉDICOe9cb07bc-d2a1-4321-a15c-bd93fe26901571feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>4612021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
7cc6434d-be74-4ca7-ad94-9f74aa3254a0CONSULTA EM PROCTOLOGIAMÉDICOecfd54f3-366d-460c-937d-98d5080d2afa71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>4212021-05-25T19:40:19.412000+00:002026-07-31T12:19:55.107000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
5a087d99-b60f-4c43-b78b-41724a187e02CONSULTA EM ANDROLOGIAMÉDICOd583bc11-1e39-4a8b-8be7-14d058ef7b8771feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>5012021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
21ab9144-b39f-4650-99d8-e3202a88ca5bCONSULTA EM CIRURGIA POSTECTOMIAMÉDICO<span class="null">NULL</span>71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>5212021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
4de3fbb0-466d-4fcd-b39d-52ccc9281a39CONSULTA EM HEPATOLOGIAMÉDICO<span class="null">NULL</span>71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>5312021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
f94e73cd-2822-43d6-8d7a-73ed9ea04767CONSULTA EM REABILITAÇÃO FÍSICAOUTRAS CATEGORIAS<span class="null">NULL</span>71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>5412021-05-25T19:40:19.412000+00:002021-05-25T19:40:19.412000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
9d12d508-3c71-49ff-849a-5f127c774868CONSULTA EM CIRURGIA UROLÓGICAMÉDICOd583bc11-1e39-4a8b-8be7-14d058ef7b8771feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>5112021-05-25T19:40:19.412000+00:002026-07-28T11:30:13.258000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
d19451ff-2a34-41cf-8626-4952235d1568CONSULTA EM FISIOTERAPIAOUTRAS CATEGORIAS5860c9c2-4b7c-48a8-b92f-c2b5ad2bee2c71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>5512021-05-25T19:40:19.412000+00:002026-07-30T17:46:59.263000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
ba143c8e-d08f-41cc-89ee-2c00b642eb16CONSULTA EM NEFROLOGIAMÉDICO761c3cfb-8227-490a-8002-6a36350ad43571feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>2912021-05-25T19:40:19.412000+00:002026-07-14T19:00:42.475000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
bfacfa9b-87a6-4d04-860c-a1c34f185319CONSULTA EM GINECOLOGIA E OBSTETRÍCIAMÉDICO00ba5b4f-7e36-4c07-ab97-2fba62b9dbf171feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>2212021-05-25T19:40:19.412000+00:002026-07-28T18:14:56.134000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
2e74210b-8dc4-4916-b0d9-f1bb148cff35CONSULTA EM ORTOPEDIAMÉDICO9098b7fa-bfc2-4b70-8793-af569093b06371feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>3712021-05-25T19:40:19.412000+00:002026-07-31T11:43:31.102000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
8d082b0d-ba54-4372-bdbd-855eeefa6a98CONSULTA EM CIRURGIA GERALMÉDICO713d754d-6023-40d1-bd70-8f4a112e878171feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>812021-05-25T19:40:19.412000+00:002026-07-21T12:02:15.647000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
f655e70f-3d94-4f18-b332-24b3723e9395CONSULTA EM PEDIATRIAMÉDICO9bc132a6-3545-4893-8cc9-e742b22b8e3771feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>4312021-05-25T19:40:19.412000+00:002026-03-18T13:49:17.246000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
e778dfc8-df82-46ff-a4b2-ffd555f68837CONSULTA EM PNEUMOLOGIAMÉDICOe9cb07bc-d2a1-4321-a15c-bd93fe26901571feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>4512021-05-25T19:40:19.412000+00:002026-07-16T17:32:33.548000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
2dcd1c2a-fde7-4681-bfbd-db8768ff839dCONSULTA EM ALERGIA E IMUNOLOGIAMÉDICO656e5c8f-657b-4f29-854f-610a4fcfc82371feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>212021-05-25T19:40:19.412000+00:002026-04-17T11:38:54.830000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
44c86b3f-5a63-498c-8160-16a8d7042971CONSULTA EM NEUROPEDIATRIAMÉDICOeedf6b05-45a1-49af-b819-6ae17fbf64ec71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>3212021-05-25T19:40:19.412000+00:002026-07-10T19:47:24.307000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
df29ac27-cd8e-496e-bf58-734812ceb496CONSULTA EM CIRURGIA NEUROLÓGICAMÉDICO6fdc8967-a552-4fa8-b409-044bfe71800671feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>3012021-05-25T19:40:19.412000+00:002026-07-02T16:37:20.462000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
7e8b0029-c06f-4c9d-8c32-b659ae18774fCONSULTA EM UROLOGIAMÉDICOd583bc11-1e39-4a8b-8be7-14d058ef7b8771feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>4912021-05-25T19:40:19.412000+00:002026-06-15T16:41:32.715000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
b448113b-fb07-476e-97af-e12a3d074c73CONSULTA EM ANESTESIOLOGIAMÉDICOe1192af4-aa7a-43f6-9e12-b8abf078aac071feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>312021-05-25T19:40:19.412000+00:002026-04-24T14:40:00.365000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
59dcdc91-8b1f-480c-a679-64a1f41cee15CONSULTA EM CIRURGIA VASCULARMÉDICO9c18974e-e86c-41b6-9740-2804a9afaff271feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>1512021-05-25T19:40:19.412000+00:002026-07-13T11:17:29.831000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
e831aa56-4966-442c-9514-2878bdc1ecffCONSULTA EM NEUROLOGIAMÉDICOeedf6b05-45a1-49af-b819-6ae17fbf64ec71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>3112021-05-25T19:40:19.412000+00:002026-07-28T13:38:22.401000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
5b1b9a63-e881-4961-a939-7f67006992f3CONSULTA EM MASTOLOGIAMÉDICO25151505-8ef4-4dc3-8b6a-affa6318f2fc71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>2812021-05-25T19:40:19.412000+00:002026-07-07T13:16:37.845000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
36203d16-fc24-454d-bbfd-d2bba3ee84a3CONSULTA EM FISIATRIAMÉDICO1fcf574a-d5b3-4ccb-a9a7-2e97e30c014a71feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>1712021-05-25T19:40:19.412000+00:002026-07-23T18:10:28.042000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
4b3da3a5-cfad-40d4-a14c-2d18f3e7218bCONSULTA EM ONCOLOGIAMÉDICO6f61c7a0-2101-44d0-93d8-123efe4cf51271feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>3612021-05-25T19:40:19.412000+00:002026-06-17T16:56:42.328000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
212a1885-1410-412d-9288-3dffd51cd6deCONSULTA EM INFECTOLOGIAMÉDICO03487c47-7a96-4808-aaa1-fbf495f5ce8571feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>2712021-05-25T19:40:19.412000+00:002026-05-12T17:34:56.735000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
b30715fd-75ab-4807-a9df-50336c46bb19CONSULTA EM CIRURGIA ORTOPÉDICAMÉDICO9098b7fa-bfc2-4b70-8793-af569093b06371feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>3912021-05-25T19:40:19.412000+00:002026-07-15T16:12:51.003000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
483b6a7c-561d-4013-8fbb-c0491e1277e2CONSULTA EM PSIQUIATRIAMÉDICO95cc9a7d-9e1d-4da6-9633-181eb9e35c2771feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>4712021-05-25T19:40:19.412000+00:002026-07-22T16:49:43.880000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
89310712-add5-459e-9e3c-8edd554fc9a4CONSULTA EM DERMATOLOGIAMÉDICO923311d0-4fa1-4c4f-8a2b-6be846c9515671feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>1312021-05-25T19:40:19.412000+00:002026-07-31T11:41:59.388000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>
38271a1a-b17a-447b-a39d-fea930945738CONSULTA EM CIRURGIA GINECOLÓGICAMÉDICO00ba5b4f-7e36-4c07-ab97-2fba62b9dbf171feb6dc-44ea-4aac-9da1-0b97dd67383d<span class="null">NULL</span>2312021-05-25T19:40:19.412000+00:002026-06-30T11:30:25.057000+00:00<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>