Ver esquema da tabela

Coluna	Tipo	PK
id	TEXT	✓
codigo	INTEGER
descricao	TEXT
material_id	TEXT
unidade_medida_id	TEXT
material_medicamento_catmat_horus_id	TEXT
material_medicamento_receituario_id	TEXT
apresentacao	TEXT
ativo	INTEGER
data_criacao	TEXT
data_alteracao	TEXT

id	codigo	descricao	material_id	unidade_medida_id	material_medicamento_catmat_horus_id	material_medicamento_receituario_id	apresentacao	ativo	data_criacao	data_alteracao
796e64d6-0631-46ef-9134-0c8ae780255d	729	Agua destilada 5ml	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
9968b9d1-664c-4f70-9d6b-c6c913b23259	898	Acido Acetilsalicílico 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
d4af2d31-f9ac-4e92-9f26-168258939ae8	120	Cetoconazol 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
a638daba-7884-43ba-be19-a8e750b67b4c	915	Cetoconazol + betametasona - pomada - 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
4bc178d5-9265-4245-ac2a-40012cd1fc32	776	Levonorgestrel 0,15mg + etinilestradiol 0,03 mg	<span class="null">NULL</span>	7c2740c5-fcb3-4c42-8559-22c9a2e7faf4	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
37133d07-9496-411f-b912-6805b3cef8a0	33	Dexclorfeniramina 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
2ebd683f-b73f-403d-ab79-52adebe765f6	721	Complexo B 2ml 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
56fecd4b-4fbf-4c16-90a6-d87c63a35a74	742	Lidocaína Gel 2% - 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
8dc8c9d8-3dc6-414d-9c0d-e0ab4566b2a6	722	Berotec - 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
7340199e-05bc-4783-a421-998b223bff3c	765	Miconazol 20mg/g Creme vaginal - 80g	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
201db61f-6349-47e8-8759-b6d329237d1a	899	Soro Nasal Jato - 30mg/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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
67c81553-ec1c-4f8a-b5f6-449161be6bf3	900	Diclofenaco dietilamônio - Uso Exclusivo USJ	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
85fdfbdb-ebe5-4e0a-be80-b38ced05609f	901	Dexclorfeniramina + Betametasona - 120ml	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
88f12eba-46f6-4071-a78c-ba2aa1c3e6a4	737	Soro Glicose 5% 250 ml	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
6565f1e0-d344-47d1-8ef6-916f704f6930	902	Lidocaína Injetável - Frasco 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
3ad40a64-88ba-4d29-a3b3-2f69a9871510	738	Adrenalina injetavel	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
a6dcd751-63e3-4593-8ed4-e39c65b54054	903	Carbidopa + Levodopa 25/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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
71e8476e-882e-4584-aaa3-023c62f07d67	739	Aminofilina Injetavel	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
69feafbb-fa4a-42d4-8abe-a86ce08462d2	740	Diazepam 10mg injetavel	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
54ccdb0d-e125-46a3-a8fc-50d3bdf9722d	796	Dipirona 500mg/ml - 2ml 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
eda817f6-0003-413d-ae14-cfe4d3fcd8eb	817	Noretisterona 035mg	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
1ec225e2-92c2-4de6-983f-b591df12b370	928	Buscopam 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
83017c7e-9ec9-4250-8d45-e72411e75fe3	912	Medroxiprogesterona 150mg - Contracept.Trimestral	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
fc9c7e96-e3da-453e-90ec-28492d37dda9	913	Levonorgestrel 0,75mg - 2CP	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
721e8547-86e5-48b4-9b79-05f2d9ec69db	929	Midazolam 1mg/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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
6bc1c7f3-38a6-44a7-b21e-fa9e78ac1bb2	916	Carbonato de calcio 600mg + Vit D 200UI	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
a5e98d58-34a4-4a89-ab81-c39de31b9ee2	917	Alendronato de Sódio 70mg	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
153d20ee-f1bc-4f4b-96db-250a39cb107f	66	Metoclopramida 4mg/ml - 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
b14363f1-bb1e-41ef-945d-499dc966bc80	905	Risperidona 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
e73edad9-b8f4-4513-8833-54e30424c1a6	68	Metronidazol 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
81577be8-7881-470b-816e-d72a8ac86d39	906	Risperidona 3mg	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
8fe9e5b8-f160-4860-833a-45006258d941	84	Nistatina Suspensão 100.000UI/ml - 50ml	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
e6eaa5bd-f423-4a51-9ae5-ee619301d158	312	Mebendazol Suspensão 20mg/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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
7d601212-eedc-4ed5-b4d2-77c9ed9e691b	907	Haloperidol Decanoato	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
09768ff9-0fb1-4b10-9dee-a7839225d434	914	Deltametrina 0,2mg/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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
46f9a65c-93ca-4b83-8606-9d961690eb7a	78	Carbocisteina Adulto 50mg /ml - 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
a6527c59-b8e2-4ed1-8ae7-73f93feb47ed	909	Paracetamol 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
64377b01-9d36-42a0-b463-9608b8245abd	910	Hidroxido de Aluminio + Magnésio 60+40mg/ml 240ml	<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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
9808a3af-97e7-49d6-b4b7-ec9ceb40a23d	749	Amitriptilina 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
be5bd9b3-1e83-408e-a4b4-0728e68375ff	750	Biperideno 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
572e52f6-dfac-4ae6-a7fb-86a85631024d	64	Hidroclorotiazida 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
0a298c92-5a68-4ff3-9617-aff0b76ad18f	751	Carbamazepina 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
5b72cfde-a884-4289-b62f-fddce76dc0c3	93	Nifedipino 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
a84fa3c2-7c41-4f09-b42b-da1ad936db08	94	Digoxina 0.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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
a26582e0-4a0b-4fb1-b16c-fbc70092e865	752	Carbonato de Lítio 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
47c51865-3c33-4fb7-8e18-5d6b74d04f36	753	Diazepam 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
5db28997-fdbc-4c5f-982b-ac8ef011e896	754	Fenitoí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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
c423f330-2d48-498f-b331-2e721782eeff	755	Fenobarbital 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
fd32d8a3-7459-4468-a1b4-f03f253d2352	240	Amiodarona 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00
4283ac29-831e-406f-863e-cf1dd6c81ef5	404	Hidroclorotiazida 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>	1	2025-03-17T22:37:23.776928+00:00	2025-03-17T22:37:23.776928+00:00