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
c0ca0991-6021-4eb5-b85b-30a1f2b9d378961Dimenidrinato + Piridoxina 50 +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
b5df798a-6dad-4951-bf0e-46c23ec8d341962Diosmina + Heperidina 450mg+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
1b5db73a-88cb-4c2d-8b9f-6e136422d82b963Flunarizina 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
bf27054c-c3f8-48cd-8e81-0db190174e7e964Glimepirida 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
ca62b7ae-42fa-486a-834f-46a493064b1f965Hidroxiquinolina + Trolamina - Otológico<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
e3b7ad83-fc6a-461a-8baa-e236bd848219966Ibuprofeno 100mg/ml - 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
5c6ec0b8-ddf6-4258-bf60-9583b306c3f6967Ibuprofeno 600mg<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
4f07a092-da41-4f05-95bf-cd8b4b90a246968Loratadina 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
834843b7-ecae-4e04-a7d6-76c9b501680d969Loratadina 1mg/ml Xarope - 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
455a48e9-b24c-449c-9f54-004a2a786ec9970Nimesulida 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
69563d5f-d48b-4533-89cc-f21fa4746534971Nimesulida 50mg/ml - Gotas 15ml<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
6f64c76b-a68d-4b2d-bfbf-6de60fbccdd5982Acetato de Betametasona + F. Betametasona - 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
c0d6f07a-dedd-4cf7-8fed-1ccaa7d2439d972Sertralina 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
5b549c34-263e-4efc-a1d4-951057ccb927979Fenitoina 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
a6d929ee-1ee6-4598-9f60-768beac84d98980Haloperidol 5mg/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
ab59877d-314a-4286-9a34-77023405890c973Tramadol 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
6c539ef1-c78b-41d6-b16d-95856417ab42975Venlafaxina 75mg<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
0c098ba2-3a93-4dfe-acb2-a5d9ebfaa7d8976Isossorbida 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
e30a8151-8d03-4f1d-8add-cd4121ec3156977Sulfato de Glicosamina 1500mg + Condroitina 1,2<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
8d55ab1a-fd27-4822-a794-7b198af82775983Ácido Tranexâmico 50mg/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
7d749680-e47d-4163-95d4-b32963cb862a984Atorvastatina 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
fe8964af-c817-4005-ad78-c7dc5244d4ff985Benzoato de Benzila<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
652bce61-2fc5-4e71-9f9b-2c4ea96f0e6e986Anlodipino 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
a20fa89e-c83b-4c62-9e3b-788c6a4c316e987Cefaclor 250mg/5ml - Susp. 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
e0536aa8-5517-49e7-88bc-c0eaeb2aed70988Ceftriaxona 1g. IM<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
7e80a2c2-9a02-4680-a652-ddc4f32b8e4e989Ceftriaxona 1g. EV<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
0f45c9b1-7ca1-4c9c-bca6-18131881eb66990Fentanila 50mcg/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
91306996-78c5-4089-9fe6-c1b765c50a551005Clopixol Depot<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
49593512-5267-4442-8ec6-00428b54b8f7991Prednisolona 3mg/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
5076c9ef-4575-482b-b0c1-004c46f7f9b5992Isossorbida 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
f08cd802-81ed-480f-b8aa-aaeb138dec6b993Dersani<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
49df675a-6122-4d49-9e87-702a0680e3151014Alenia<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
224342db-0fc0-419a-a1f7-8d1c01d9b9a1994Midazolam 5mg/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
82b6c1f6-24c7-4d65-b3e5-95cf1433c17a995Colírio Anestésico<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
d4ab3890-f153-4278-af6c-193a5a13e691996Miconazol 20mg/g - Creme Dermatológico<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
f695f6cb-0335-42aa-9df4-b7fa26fe86b71028Clopidogrel 75 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
ee24c030-cbd6-4f2e-8206-c6a03cd99cb4997Levotiroxina Sódica 75mcg<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
ca05bce9-8ec9-4789-a0f3-c1a8eb649569998Levotiroxina Sódica 150mcg<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
be19436d-d588-44ab-972c-4c11d62efbfa1007Complexo B 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
bd3da1eb-e676-4264-a809-ed0947da8c20999Levomepromazina 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
ac31ff02-66d2-4a75-b800-9600ec562b881008Dersani<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
181ecbea-c90f-4323-a560-2239fd6a52c51000Levomepromazina 25mg<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
1a2b7307-57e4-47e1-b939-f295413bd4bc1001Amoxicilina + Clavulanato 875mg + 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
031d1245-7487-41e5-8fc8-672854406ade1009Paroxetina 30 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
00c53f58-6046-4068-a87b-51fddac235ed1010Lactase 10000 fcc<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
92623fdb-6cb6-4b48-8839-a72f7de16e071012Tiras de glicemia<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
f9dae9fe-2d2a-473a-8985-20c0485d632a1013Citoneurin 5000<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
8e9d2010-f0fb-4bbc-b112-445faee132d01011Strasstabs<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
38ba209e-765f-4104-ac78-c4c1003386e11015Soro Fisiolófico 100 <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
7f201ced-3331-49d6-b47e-b2628f51b32e1016SULFATO FERROSO gotas<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