Ver esquema da tabela

Coluna	Tipo	PK
id	TEXT	✓
material_id	TEXT
concentracao	TEXT
tipo_produto	TEXT
esus_id	INTEGER
apresentacao	TEXT
dose_frequencia_tipo	TEXT
dose_frequencia_unidade_medida	TEXT
material_medicamento_principio_ativo_id	TEXT
material_medicamento_forma_farmaceutica_id	TEXT
material_medicamento_catmat_horus_id	TEXT
material_medicamento_programa_horus_id	TEXT
material_medicamento_programa_id	TEXT
material_medicamento_receituario_id	TEXT
material_medicamento_catmat_esus_id	TEXT
material_medicamento_via_administracao_id	TEXT
ativo	INTEGER
data_criacao	TEXT
data_alteracao	TEXT
material_medicamento_grupo_id	TEXT
material_medicamento_subgrupo_id	TEXT

id	material_id	concentracao	tipo_produto	esus_id	apresentacao	dose_frequencia_tipo	dose_frequencia_unidade_medida	material_medicamento_principio_ativo_id	material_medicamento_forma_farmaceutica_id	material_medicamento_catmat_horus_id	material_medicamento_programa_horus_id	material_medicamento_programa_id	material_medicamento_receituario_id	material_medicamento_catmat_esus_id	material_medicamento_via_administracao_id	ativo	data_criacao	data_alteracao	material_medicamento_grupo_id	material_medicamento_subgrupo_id
38d7264d-9a14-47ad-b7e3-1d11d8419161	7e1cb6a7-68d2-4876-9809-625d3dd9bec5	20 mg	B	1314	Cápsula	<span class="null">NULL</span>	<span class="null">NULL</span>	efc95b1f-798b-4fb0-82d7-a88971aa7b4f	9e1ab6ab-3afe-4a76-8fa6-c5317f8c3fd7	47e35cc8-d4c9-4262-9d0a-627a8b5fd9ac	<span class="null">NULL</span>	<span class="null">NULL</span>	1428424e-1776-4c45-9bb2-27168fbb2ee0	b5b454e4-d427-44a5-89c2-3b11c34f883b	<span class="null">NULL</span>	1	2023-02-02T11:15:57.222000+00:00	2025-09-24T18:30:20.383000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
0427aa96-18d6-49c7-a437-b20403f887aa	37133d07-9496-411f-b912-6805b3cef8a0	<span class="null">NULL</span>	B	<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>	<span class="null">NULL</span>	cf487680-6f75-42cc-9f7a-51b8e235f5ec	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-03-17T22:37:24.205752+00:00	2025-09-24T18:31:40.613000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
801d8edb-2385-478d-97cd-3ea23137eeb9	9003c767-3a42-4233-8298-ae7c1aa580d3	<span class="null">NULL</span>	B	<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>	<span class="null">NULL</span>	bfb26003-83a4-4838-b04b-51b4f835123d	<span class="null">NULL</span>	<span class="null">NULL</span>	1428424e-1776-4c45-9bb2-27168fbb2ee0	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-03-17T22:37:24.205752+00:00	2025-09-24T19:05:36.195000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
0c301731-44c7-476d-a256-14777f77db4c	60808b48-5fc0-4015-a77c-65db8ff06226	<span class="null">NULL</span>	B	<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>	<span class="null">NULL</span>	b7ca8b0f-8b4d-46e5-9737-aeee6d1df9de	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-03-17T22:37:24.205752+00:00	2025-09-24T19:18:40.477000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
1f305da4-f04c-4efe-b45a-298210adf26b	5885b817-298c-437c-90ff-464563407368	<span class="null">NULL</span>	B	<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>	<span class="null">NULL</span>	4cb4789a-817d-4dc3-b8b0-3f285a619b62	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-03-17T22:37:24.205752+00:00	2025-09-24T19:19:06.936000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
54599d5d-5131-453b-ae10-6c139cba7044	61a1de70-6f7b-4f50-af7b-0b69a9625ac7	<span class="null">NULL</span>	B	<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>	<span class="null">NULL</span>	4587a8ea-f691-4a04-b0c3-933143b9f924	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-03-17T22:37:24.205752+00:00	2025-09-26T16:21:26.056000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
91cfe814-5d56-4017-93dd-43d7735d8912	ee24c030-cbd6-4f2e-8206-c6a03cd99cb4	<span class="null">NULL</span>	O	<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>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-03-17T22:37:24.205752+00:00	2025-09-26T16:28:56.396000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
b3ad2c60-6e22-40f2-847f-639469d403fe	876af834-b08c-4c2f-a24d-e9f0432f23e1	<span class="null">NULL</span>	O	<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>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-03-17T22:37:24.205752+00:00	2025-09-26T16:38:15.283000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
f8ce593b-7143-4091-a1f1-78a5e914d976	2395f8ec-e07a-498c-8770-cbe745a95a83	<span class="null">NULL</span>	B	<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>	<span class="null">NULL</span>	6941f54f-fb6e-4ce2-9923-b44b7154c2f7	<span class="null">NULL</span>	<span class="null">NULL</span>	5aa93c34-503f-4223-b911-26afe199d613	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-03-17T22:37:24.205752+00:00	2025-09-26T16:43:13.220000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
ceb1c674-ed92-4b07-aff9-b7c1edeb1bfd	3620d519-7bb6-44bc-bff2-7b79bba2725d	2 mg/ml	O	2130	Ampola 4 ml	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	f73f1eaa-dc72-4e53-b7ef-142c3e7123e4	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	a918f41e-ce24-4fae-bd70-0ad6d6882a3d	<span class="null">NULL</span>	1	2023-02-02T11:15:57.222000+00:00	2025-09-26T17:16:18.535000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
8454ce19-a493-457c-a630-bdae548219ed	b0d296fd-5b99-4399-8a47-d96696d02422	<span class="null">NULL</span>	E	<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>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1428424e-1776-4c45-9bb2-27168fbb2ee0	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-03-17T22:37:24.205752+00:00	2025-09-26T17:22:54.441000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
6e583675-0ca0-40ba-93d9-6f53ffcceac3	152c5756-499c-48fe-8128-f4518327654a	<span class="null">NULL</span>	B	<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>	<span class="null">NULL</span>	425c9bd4-0cde-4fe3-9e8e-df27bdb53cf3	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-09-26T17:24:45.386424+00:00	2025-09-26T17:24:45.386424+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
de6bf416-37cb-4880-a1ac-1ad13226ea2e	0a75fc75-bd76-470c-84aa-5ac85129b304	<span class="null">NULL</span>	B	<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>	907f2ccd-601a-4dc6-9c74-2961e4b90e72	ea2e5fb9-4e96-41ee-8972-7f440e82bd90	<span class="null">NULL</span>	<span class="null">NULL</span>	5aa93c34-503f-4223-b911-26afe199d613	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-08-18T18:09:39.051282+00:00	2025-09-26T17:36:54.878000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
1fccc354-a547-4476-87ff-3ac97b91f2c0	7f201ced-3331-49d6-b47e-b2628f51b32e	<span class="null">NULL</span>	B	<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>	<span class="null">NULL</span>	d237800d-d7dc-4b3c-b1c2-1b30ef18c6a4	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-03-17T22:37:24.205752+00:00	2025-09-26T17:41:57.008000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
dc3ada97-f041-4813-b1e9-a4de75b978a3	ff8f9f75-c941-4226-b8b3-0bf689fa4a9c	<span class="null">NULL</span>	O	<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>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	<span class="null">NULL</span>	<span class="null">NULL</span>	1	2025-03-17T22:37:24.205752+00:00	2025-09-26T17:42:46.685000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>
249fdbaf-7c97-4115-93a2-2feaded8d0f8	ec2ff379-91dd-4e17-a4b1-0de4f6b1e0d9	30 mg	O	2139	Cápsula	<span class="null">NULL</span>	<span class="null">NULL</span>	0c69a1e3-b8f1-403a-bfdb-a9644b300c59	9e1ab6ab-3afe-4a76-8fa6-c5317f8c3fd7	9f2f96d7-c685-42f6-acc8-00daf3cf4dfc	<span class="null">NULL</span>	<span class="null">NULL</span>	1428424e-1776-4c45-9bb2-27168fbb2ee0	84924e83-032d-461d-94e2-b25c1804c44f	<span class="null">NULL</span>	1	2023-02-02T11:15:57.222000+00:00	2026-04-30T13:33:00.669000+00:00	<span class="null">NULL</span>	<span class="null">NULL</span>