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
d295e819-2b16-442f-8f72-868e7d24c516880Levofloxacino 750 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
93d81058-8af7-4ea2-b8f3-b2e05d685f0c881Clonazepam 2,5mg/ml 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
834e84d1-64e4-4c84-a9fb-b3e07dd42fce882Clonazepam 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
cd32a2f7-4e3a-40c2-86e6-b559f91f5f08494Salbutamol 2mg/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
c16057a5-a324-47e4-8035-ce6ea3373d7c883Codeína 30mg<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
5962cd66-05e2-4015-901b-ac8b090377bd884Enalapril 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
92eba430-d936-4713-b124-625573e5eb80681Cetoconazol 20mg/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
e0f413cb-7ea7-49cd-8733-e8e2f011de96670Sulfametoxazol 400mg +Trimetoprima 80 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
be48c8e6-b370-40d4-9dd7-51c09707db73885Enalapril 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
aaca1e45-3131-4e5c-a315-3d5b998ae687886Fluconazol 150mg<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
0218054c-0533-4c31-941c-700782d70d3b686Dexametasona 1mg/g Creme - 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
4c32b461-fc99-4b36-b287-72aa839c6b26687Dipirona Sódica 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
23d09a75-b2bc-46a2-be44-adb901241e69688Dipirona Sódica 500mg/ml - Gotas - 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
ad630b01-821f-4502-b4b4-81c45b5bb102887Fluoxetina 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
276fb35e-551f-4f51-bc88-0117c8ccc552703Ranitidina 25mg/ml amp 2ml<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
df170086-32f9-4b67-95bc-66cf06957550888Haloperidol 1mg<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
47992bb7-38ad-44c5-9c77-779b5671604d889Ivermectina 6mg<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
924d9629-7ab0-450b-8fa8-a0e6ecf0ecbc53Cefalexina 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
efbc4a97-ec37-40fb-8317-203815bb38b4704Metoclopamida inj. 05mg/ml 2ml<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
59b8a823-f4a4-4c98-9e31-196b9ccc6c20890Ibuprofeno 50mg/ml - 30ml<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
d4ceeacb-76c9-4301-b401-d1804f8ce86e891Levotiroxina Sódica 25mcg<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
9cab52ac-b6fa-457b-ac6c-8f7919eb79ab705Diclofenaco potássico Inj 25mg/ml amp. 3ml<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
5d22e62e-9403-4a88-a0e9-d37c0509cde7892Levotiroxina Sódica 50mcg<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
82f9c760-3a6b-4b4f-a582-63889a48ca88693Buscopam composto injetável<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
cb92c317-da60-4ccf-a0a1-cd4cbdbc6451706Hidroxido de alumínio suspensão<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
91c0268d-0832-4936-b4e9-f5c3f8b60b24104Cefalexina Suspensão 250mg/5ml - 100 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
9b8f37b6-4311-47e9-ac04-0fe1c16df59d893Nitrofurantoína 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
ba999657-eef7-4faa-b9dd-c5b7e26a7861894Permitrina 10mg/ml - 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
6e4fa29f-3e4b-4eda-8cb0-8f77357091d8895Sinvastatina 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
0e72a4a8-0a7d-4b2c-a7ad-fb6bea095015310Azitromicina 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
1c1b966c-0af5-40e4-a972-4a35383e945f727Ampicilina Suspensâo 250mg/5ml - 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
68b21803-58e9-4640-93c2-9235c338cfb7707Oleo Mineral - Suspensão 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
8140c2b8-d82a-4797-ba1c-7527eeedefc3908Risperidona 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
4826e7d3-7a35-40f7-b386-fd126b54f23f896Azitromicina 40mg/ml - 15ml(600mg)<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
3d0c2721-d9cc-4b86-8e26-7913777182b1708Cimetidina 300mg amp.2ml<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
9d705c78-1e16-4c84-a8dd-86c2207a5d14709Cimetidina 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
3f79da76-51be-4ccb-868a-6820463c1d9372Prednisona 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
77c089c5-cd96-49d9-af30-afbaf34bf36188Prednisona 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
48ff1cc1-2647-477f-8a79-3162d9d788b5700Soro Glicofisiologico 250ml<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
125d9b73-fb23-4770-88ea-32f9e69d6dc1710Verapamil 80mg<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
335e6443-6a30-4c62-b3a1-2461a0d52918897Enalapril 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
74cef3fc-1609-45eb-96c6-255b5e6340ca711Sais para reidratação oral<span class="null">NULL</span>0b7ebf01-95d5-4cc8-84d8-4e8d6d91b7a5<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
fcb437d7-1ba2-4aed-afd1-f6faf40d72d4712Omeprazol 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
06e749e5-9d44-4117-b702-6071b14047c4713Colagenase 0,6U/g + Clorafenicol 0,01g/g pom. 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
2495df84-13f1-4af8-a172-e2a03b3e4388715Atrovent<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
d11a0a42-9add-4793-83a0-9ad269d64884161Hidrocortisona 500mg<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
70e50adf-d87f-4516-8408-9ddf996f55bd911Nimesulida 50mg/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
c221ccf7-e5f7-48cd-9c6f-aca7620f7dd1741Amiodarona 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
8621d9d3-b7a3-4fb7-8c7a-20211f0f9b81718Diclofenaco Potássico 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
dea7ead6-0148-48e1-97f0-40e39d9493cb732Agua destilada 10ml<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