Ver esquema da tabela

Coluna	Tipo	PK
id	TEXT	✓
consulta_id	TEXT
material_id	TEXT
material_medicamento_forma_farmaceutica_id	TEXT
material_medicamento_via_administracao_id	TEXT
material_medicamento_receituario_id	TEXT
medicamento_nome	TEXT
concentracao	TEXT
dose	TEXT
dose_unica	INTEGER
uso_continuo	INTEGER
dose_frequencia_tipo	TEXT
turno	TEXT
dose_frequencia	TEXT
dose_frequencia_quantidade	TEXT
dose_frequencia_unidade_medida	TEXT
data_inicio_tratamento	TEXT
duracao_tratamento	INTEGER
duracao_tratamento_medida	TEXT
quantidade_receitada	INTEGER
fim_tratamento	TEXT
digitacao_livre	INTEGER
recomendacao	TEXT
posologia	TEXT
data_hora	TEXT
data_criacao	TEXT
data_alteracao	TEXT
nome_comercial	TEXT
peso	REAL
altura	REAL
unidade_medida_id	TEXT

id	consulta_id	material_id	material_medicamento_forma_farmaceutica_id	material_medicamento_via_administracao_id	material_medicamento_receituario_id	medicamento_nome	concentracao	dose	dose_unica	uso_continuo	dose_frequencia_tipo	turno	dose_frequencia	dose_frequencia_quantidade	dose_frequencia_unidade_medida	data_inicio_tratamento	duracao_tratamento	duracao_tratamento_medida	quantidade_receitada	fim_tratamento	digitacao_livre	recomendacao	posologia	data_hora	data_criacao	data_alteracao	nome_comercial	peso	altura	unidade_medida_id
584f0b79-e9c5-4a28-b9b1-7c9ba81e3e7c	420f2391-8518-412d-b6cf-0fb9a20544a5	942ab9a7-c95c-4afc-80e2-e1de81beef6b	<span class="null">NULL</span>	<span class="null">NULL</span>	1428424e-1776-4c45-9bb2-27168fbb2ee0	Pregabalina 75 mg	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<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>	30	<span class="null">NULL</span>	0		tomar 1 cp a noite	2026-07-31T19:43:15.734000+00:00	2026-07-31T19:43:15.734493+00:00	2026-07-31T19:44:11.683000+00:00	<span class="null">NULL</span>	90.25	190	27635943-81e8-4a99-ad5e-0661bc79f02d
935d1650-a830-4ed7-b8b8-8872de757f1f	abf0f7b4-d5d7-427c-96fb-0f76f3ca5163	8525517a-90af-4fbe-a7ab-092c9a4d6df5	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	Paracetamol 750mg	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<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>	20	<span class="null">NULL</span>	0		TOMAR 1CP DE 6/6H SE DOR INTENSA	2026-07-31T17:22:26.027000+00:00	2026-07-31T17:22:26.027423+00:00	2026-07-31T17:25:18.426000+00:00	<span class="null">NULL</span>	66.4	165	27635943-81e8-4a99-ad5e-0661bc79f02d
30e54fea-4771-4e4d-b839-c294732fd92f	ad4ae909-41bc-4f6a-9fda-a6dc9c3290af	455a48e9-b24c-449c-9f54-004a2a786ec9	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	Nimesulida 100mg	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<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>	10	<span class="null">NULL</span>	0		TOMAR 1 CP VO DE 12/12H por 3-5 dias	2026-07-31T19:22:50.457000+00:00	2026-07-31T19:22:50.457419+00:00	2026-07-31T19:24:27.194000+00:00	<span class="null">NULL</span>	83.5	156.5	27635943-81e8-4a99-ad5e-0661bc79f02d
3bc667fa-b8b4-42e1-86a2-47c62dcc353b	ad4ae909-41bc-4f6a-9fda-a6dc9c3290af	<span class="null">NULL</span>	a2ab2a9b-8fae-4d3e-8944-00a44d8ebb09	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	budesonida	50mcg	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<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>	1	<span class="null">NULL</span>	1		aplicar 1 jato em cada narina de 12/12 h por 3-5 dia s	2026-07-31T19:22:50.457000+00:00	2026-07-31T19:22:50.457419+00:00	2026-07-31T19:24:27.195000+00:00	<span class="null">NULL</span>	83.5	156.5	e89a2779-d6b3-4920-937b-65203a8edc5e
cbe50895-e6af-4e6f-9d43-2c079751d6b4	575f1892-af21-4200-8e5d-bf7f9a691819	f249f9f3-8254-45e5-9bec-f991c03c3d83	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	Prednisolona 20mg	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<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>	6	<span class="null">NULL</span>	0		TOMAR 1 CP VO DE 12/12H, 3 DIAS	2026-07-31T17:14:31.484000+00:00	2026-07-31T17:14:31.484074+00:00	2026-07-31T17:51:48.378000+00:00	<span class="null">NULL</span>	75	159	27635943-81e8-4a99-ad5e-0661bc79f02d
b356f2af-1a04-4222-8174-47947e0bc801	575f1892-af21-4200-8e5d-bf7f9a691819	4f07a092-da41-4f05-95bf-cd8b4b90a246	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	Loratadina 10mg	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<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>	10	<span class="null">NULL</span>	0		TOMAR 1 CP VO A NOITE	2026-07-31T17:14:31.484000+00:00	2026-07-31T17:14:31.484074+00:00	2026-07-31T17:51:48.379000+00:00	<span class="null">NULL</span>	75	159	27635943-81e8-4a99-ad5e-0661bc79f02d
86402100-69cf-40a9-bf93-d8db45047e55	ad4ae909-41bc-4f6a-9fda-a6dc9c3290af	6cdc741c-95eb-47c3-be5b-a026a608f829	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	Soro fisiologico 100 - sistema aberto	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<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>	1	<span class="null">NULL</span>	0		aplicar 1 jato em cada narina sepre que necessario	2026-07-31T19:22:50.457000+00:00	2026-07-31T19:22:50.457419+00:00	2026-07-31T19:24:27.198000+00:00	<span class="null">NULL</span>	83.5	156.5	e89a2779-d6b3-4920-937b-65203a8edc5e
45088973-5c9c-4301-922a-fe79728dbe5b	c073764f-922c-4bea-9c3b-fef2a0a7b94c	455a48e9-b24c-449c-9f54-004a2a786ec9	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	Nimesulida 100mg	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<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>	10	<span class="null">NULL</span>	0		TOMAR 1CP DE 12/12H POR 5 DIAS	2026-07-31T18:12:15.558000+00:00	2026-07-31T18:12:15.558352+00:00	2026-07-31T18:15:08.818000+00:00	<span class="null">NULL</span>	49.85	155	27635943-81e8-4a99-ad5e-0661bc79f02d
b293daee-d456-4f05-9edc-c53dc0789e5c	ad4ae909-41bc-4f6a-9fda-a6dc9c3290af	4f07a092-da41-4f05-95bf-cd8b4b90a246	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	Loratadina 10mg	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<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>	20	<span class="null">NULL</span>	0		tomar 1 cp ao dia	2026-07-31T19:22:50.457000+00:00	2026-07-31T19:22:50.457419+00:00	2026-07-31T19:24:27.199000+00:00	<span class="null">NULL</span>	83.5	156.5	27635943-81e8-4a99-ad5e-0661bc79f02d
636dde5f-ef7f-4b93-b8db-10018ef55140	bb9df45d-5f54-4156-afc3-22a69b90a6bc	5c6ec0b8-ddf6-4258-bf60-9583b306c3f6	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	Ibuprofeno 600mg	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<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>	10	<span class="null">NULL</span>	0		TOMAR 1CP DE 8/8H	2026-07-31T17:29:49.526000+00:00	2026-07-31T17:29:49.526473+00:00	2026-07-31T18:17:09.054000+00:00	<span class="null">NULL</span>	56.2	155	27635943-81e8-4a99-ad5e-0661bc79f02d
13b846b6-3abf-4215-9386-14dee493b212	ceb0b95b-b19f-48d4-a075-951d3b43b48e	5c6ec0b8-ddf6-4258-bf60-9583b306c3f6	<span class="null">NULL</span>	<span class="null">NULL</span>	b7efedaa-d3f9-4a1f-b11a-40a5bd8e2b69	Ibuprofeno 600mg	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<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>	10	<span class="null">NULL</span>	0		TOMAR 1 CP VO DE 8/8H	2026-07-31T18:11:58.964000+00:00	2026-07-31T18:11:58.964932+00:00	2026-07-31T18:17:51.668000+00:00	<span class="null">NULL</span>	76.25	155	27635943-81e8-4a99-ad5e-0661bc79f02d