Ver esquema da tabela
ColunaTipoPK
idTEXT
codigoINTEGER
descricaoTEXT
material_idTEXT
unidade_medida_idTEXT
material_medicamento_catmat_horus_idTEXT
material_medicamento_receituario_idTEXT
apresentacaoTEXT
ativoINTEGER
data_criacaoTEXT
data_alteracaoTEXT
idcodigodescricaomaterial_idunidade_medida_idmaterial_medicamento_catmat_horus_idmaterial_medicamento_receituario_idapresentacaoativodata_criacaodata_alteracao
b2ec508c-aa26-4eb1-95fa-83ed085a753a1450Memantina 10 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
ec486825-a8a6-478d-8372-e976b2b7b47f1458Escitalopram 20 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
62849958-8382-4a4b-8794-3d20bac8b9e21451Zolpidem 10 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
c32e6be9-bb22-4ccb-be63-73e84d4dd1db1459Risperidona 1mg solucao<span class="null">NULL</span>e89a2779-d6b3-4920-937b-65203a8edc5e<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
bfd7d7b0-4d94-45df-976a-b872d9a59d831460Donepezila 10 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
ff0fa68a-9a6e-4edb-b0db-1f44e8776d681425Formoterol + Budesonida 12/400mg cap<span class="null">NULL</span>e89a2779-d6b3-4920-937b-65203a8edc5e<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
f8e40825-276e-417c-b6b4-29667d7c3c3b1426Desvenlafaxina 100 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
785dd3e1-aeef-49fc-bf64-669221a50bf11468Esomeprazol 40 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
1f7c305b-9447-4961-a645-092ec053bb2f1453Tibolona 2,5<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
f6ccdcf5-c1ed-47cb-88d7-b250c907b4511462Varfarina sódica 5 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
29d99f83-cc35-41d6-ac14-c7f1cd8ef7631463Olanzapina 5 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
f16757b8-5ebe-4d42-9ecf-6a805c4d06e71465Esomeprazol magnesico 40mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
65e0e34d-2858-4178-b044-d68380de77fa1466Hidroxido de Alumínio + magnésio+ simeticona <span class="null">NULL</span>e89a2779-d6b3-4920-937b-65203a8edc5e<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
e1194801-cee7-4360-89b3-1ba389db3fcd1467Domperidona 10 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
3005a2ba-6814-427a-9b38-af7c96712ed51469Travoprosta 0,04 solução oftálmica <span class="null">NULL</span>e89a2779-d6b3-4920-937b-65203a8edc5e<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
76908d28-cedc-4717-8310-7054bd44577f1474Colecalciferol (Vitamina D3) 50000 UI<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
155c15d8-1814-4908-ad3c-fce7265f78a21033Gentamicina 80 mg Inj.<span class="null">NULL</span>ebd93caa-aa61-49ce-b06a-2af9b2ca1b5a<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
d368050d-4fc7-4f1f-99bb-66a18925e4981471Cloridrato de metilfenidato 10 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
2613e833-871e-48cc-8216-17d6369f4fa31415FIBER MAIS <span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
7c72df57-2fe8-4188-87c6-7394621723231416NUTREN 1.0<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
40f51d9a-e1c4-4440-a433-4b33c41b1b7c1417GLUCERNA 1.5 <span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
f1a5332e-b14c-40ca-91b9-1905efc242011418FORTINI <span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
fc92c488-7f44-44df-812b-d2d99c9307851473Oxcarbamazepina 600 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
ceb64201-e52a-43de-b285-8cfae6de92381475Diacereina 50 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
fc692afa-df8b-4c2b-a881-8fb39479d1841476Alprazolam 1 mg <span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
fa9b57b1-5c79-4480-a438-37e25a2fe4d21477Acido tranexamico 250/5 inj<span class="null">NULL</span>ebd93caa-aa61-49ce-b06a-2af9b2ca1b5a<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
e804beb5-0019-47bf-9976-01772a7541901478Vitamina k (fitomenadiona) 10 mg <span class="null">NULL</span>ebd93caa-aa61-49ce-b06a-2af9b2ca1b5a<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
876af834-b08c-4c2f-a24d-e9f0432f23e11002Meloxicam 15 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
27c1b0b8-e8c9-4524-a6a4-1a004bfb607e1483Ondansetrona 2 mg<span class="null">NULL</span>ebd93caa-aa61-49ce-b06a-2af9b2ca1b5a<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
222d8a4d-7d51-4fa9-9685-0cf91c7e93d91499Tramadol 37,5 mg + paracetamol 325 mg <span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
645c4111-1795-4c97-b658-0072990247201495Tramadol 100 mg <span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
1e9bfb70-98f2-43d3-a03f-67581380cdcb1502Colecalciferol 2000 UI capsula<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
709c35a1-61f2-4991-944e-cc27b1f8474f1503Colacalciferol 1000 Ui<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
cc71054f-4919-4d46-aebb-94fb1d1ee9531504Colecalciferol 200 ui gotas<span class="null">NULL</span>e89a2779-d6b3-4920-937b-65203a8edc5e<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
aeaf84e2-3c0c-430f-897f-14bcc60fbfff1505Colecalciferol 1000 UI capsula <span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
8fe1b064-98ab-4edc-b62f-ce3b65a32f611515Dimeticona 4% <span class="null">NULL</span>e89a2779-d6b3-4920-937b-65203a8edc5e<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
86a4c236-697b-4e07-87b3-150cd3ff98ef1521Topiramato 100 mg <span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
68c471bc-6cf4-40ad-9ee5-e9f3ef069e381523Clomipramina 25 mg <span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
74eee9aa-8681-4195-bf12-73e46377c9141508Lamotrigina 50 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
61a27fcc-9716-4327-90ce-4cd2310462001479Atorvastatina 40 mg <span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
7c8423ac-7bd6-4965-8641-b516d15956ba1497Atorvastatina 10 mg <span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
b7be0f98-b9fd-42a3-8bc3-44d8974b95281511Dapagliflozina 10 mg<span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
b44b1459-ea51-4040-aa45-24459e66cef91480Tramadol 50mg/ml 2 ml inj<span class="null">NULL</span>ebd93caa-aa61-49ce-b06a-2af9b2ca1b5a<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
6154a3a0-7dc0-4dd4-98f7-6cb1c773a8331481Sulfadiazina de prata 10mg creme <span class="null">NULL</span>521980df-ad1b-4ab0-9c98-11067a838e65<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
69eaca82-442a-4335-b375-fb64954365591509Codeina 30 + paracetamol 500 mg <span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
04a2f13b-a467-4f7d-9c3a-0b6f295ca04f1498 Escitalopram 20 mg/ml <span class="null">NULL</span>e89a2779-d6b3-4920-937b-65203a8edc5e<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
a53a6f29-eca7-4505-a35f-f6e1d00dd31a1516Hidroxicloroquina 400 mg <span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
55c1cf2c-90bf-447d-b239-0264ee037b331512Naproxeno 500 mg <span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
effbfc37-f316-4908-999f-9a6249d18d821513Morfina 10 mg <span class="null">NULL</span>27635943-81e8-4a99-ad5e-0661bc79f02d<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00
828294e7-9267-423e-bbf1-1d63cd8cc3b01484Moxifloxacino 5,45mg + dexametasona 1,10mg colirio<span class="null">NULL</span>e89a2779-d6b3-4920-937b-65203a8edc5e<span class="null">NULL</span><span class="null">NULL</span><span class="null">NULL</span>12025-03-17T22:37:23.776928+00:002025-03-17T22:37:23.776928+00:00