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
d2c83307-bc7a-45f3-afa0-2b40f831f4c5613Furosemida 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
abcc4b5b-4d92-47e8-9680-efbef16a74d0614Aminofilina 100mg<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
4101fd9b-3ac1-45f1-8969-52980ff394e6615Metildopa 500mg <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
f8e7a69a-311d-46fd-8aec-8a67e5b4f757626Nifedipino 10mg <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
0b070c33-c41e-4628-96d1-aebdf8b461ad657Neomicina + Bacitracina 5mg/g + 250UI/g Pom - 10g<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
6f790c4d-dc83-472a-9e81-549cb82ba26b658Metoclopramida 10mg<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
79666bd3-42e5-4123-b6f7-c46065e1f5a5660Soro Nasal Adulto + Pediatrico<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
8ad55ce2-39a9-4afb-bc9c-b5604b210fb7661Garasone Colirio 10ml<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
a506b6d2-1281-4426-acd4-683ee50fcbbd662Otolóide 10ml<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
9c2102bd-b95f-4836-97a5-3b9a257e8ad4663Aceratum 100mg/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
7c172a82-138c-4828-a677-641f27805946666Buscopam Composto<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
f2cd34fb-07a3-42ae-a07c-a760315f4d7e667Buscopam 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
e70150bb-0c22-46d5-bbb4-620711131d09857Salbutamol Spray 100mg/dose<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
2327f2a1-f41d-4982-ae6f-1c5505b00c37933Piportil L4<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
b6bb9045-5241-4c5b-b824-f168744267c8920Levotiroxina sódica 100mcg<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
f249f9f3-8254-45e5-9bec-f991c03c3d83925Prednisolona 20mg<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
99f85d0f-7b1f-4063-8cc4-1b0889636b30921Primera 30<span class="null">NULL</span>7e52c6f5-007e-46cd-9fa2-24da8f336b1f<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
f4932748-4e98-4628-8274-92dec1515edf922Amoxicilina 250mg/5m Susp. 60ml<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
af09b72b-e518-468b-853a-fec832fc14ad926Carbonato de Cálcio 500mg<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
01c135ec-17b2-437e-a5ba-6a0b65103fe3923Paroxetina 20mg<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
e5cde5e4-e1be-4f77-8761-3b8663c8ca90924Carbamazepina 400mg<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
ca99d212-6504-4fd4-801d-c5528a660081927Buscopam<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
546d502d-de80-4691-b361-ee1fe77b4c19918NULO<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
ed4bd8cc-81ec-457a-bc1c-3f9a63454aa9935Agua Injeção 20ml<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
5885b817-298c-437c-90ff-464563407368930Doxazosina 2mg<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
7695a808-8b00-4602-9058-41d567f6ecac931Finasterida 5mg<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
41c19764-5fa8-4287-a90a-4a46d4d91020934Dexametasona Oftálmico<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
c799f8f7-3756-4210-a510-f052b886f02f936Dramin B6 50/50<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
97a38da0-6aa8-4741-afed-32201900dce9937Cefalexina 250mg/5ml - 100ml<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
418e2368-4761-4030-8eb3-b9077fbd2316938Nulo -<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
abcf1a1b-85ba-4ccb-ad1e-26a3ef77fd45939Petidina 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
1ddafd8e-755b-400c-84a9-36f6d1aba008940Dexametasona Inj. 4mg/ml - 2.5ml<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
73aab570-a03d-4af3-8396-06611123385a941Contraceptivo Inj Mensal - Noretisterona + estradi<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
4082b26a-9e96-4da8-be56-cdde095ba511919Captopril 50mg<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
ff8f9f75-c941-4226-b8b3-0bf689fa4a9c944Terbutalina 0,5mg/ml<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
eaa9daab-f835-4847-b250-81843d3526a1945Diclofenaco Sódico 50mg<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
089f4229-ccef-40d2-b6eb-996f0ad587d1946Carvão Vegetal Ativado 250mg<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
7eeea594-f2b3-45fa-9e69-6fe69550fa78947Aciclovir 200mg<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
30f7d577-a393-46cc-bccc-7b0d33520fd8948Alopurinol 300mg<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
0c080345-e3f6-4539-8092-74fa009b81fd949Amoxicilina + Clavulanato de Potássio 500mg+125mg<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
fade13c7-b1eb-4e48-8a43-365d059e4369950Amoxicilina + Clavulanato 250mg+62,5mg/ml - 75ml<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
247a0d8c-2e57-4a3f-9b90-dcb20e388adb951Cetoprofeno 100mg INJ IV<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
c3e77364-291f-4c59-b312-549b551587c7978Diclofenaco sódico 25mg/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
c3b28bf0-d372-41fd-b0e2-986f91a53cac952Ciprofibrato 100mg<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
f55a660d-2fb3-4a04-af73-fe81e9d03848955Ciprofloxacino + Dexametasona 3,5mg+1mg - Colírio <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
29f47de7-c549-4168-897e-8ec8b59fa392956Ciprofloxacino 500mg<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
68115401-6dd1-4ee4-96f3-edfe7fcb2aa7942Morfina 10mg/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
f949c4a9-f6d2-4da1-81ff-4854d6749db8958Citalopram 20mg<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
ae6e54c7-def1-4879-997b-29fb7b1d2875959Desonida 0,5mg/g Creme 30g<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
4fae3255-a29e-4fd1-adb9-5cfd18bbc99f960Dimenidrinato + Piroxidina gotas 20ml<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