Ver esquema da tabela

Coluna	Tipo	PK
id	TEXT	✓
sequencia	INTEGER
descricao	TEXT
idade_minima	INTEGER
idade_maxima	INTEGER
codigo	TEXT
competencia_bpa	TEXT
masculino	INTEGER
feminino	INTEGER
procedimento_complexidade	INTEGER
tb_grupo	INTEGER
tb_sub_grupo	INTEGER
tb_forma_organizacao	INTEGER
filtro_padrao_esus	INTEGER
codigo_sigtap	INTEGER
idade_aplicavel	INTEGER
tipo	TEXT
plano	INTEGER
exame	INTEGER
padrao_dab	INTEGER
esus_id	INTEGER
ativo	INTEGER
data_criacao	TEXT
data_alteracao	TEXT

id	sequencia	descricao	idade_minima	idade_maxima	codigo	competencia_bpa	masculino	feminino	procedimento_complexidade	tb_grupo	tb_sub_grupo	tb_forma_organizacao	filtro_padrao_esus	codigo_sigtap	idade_aplicavel	tipo	plano	exame	padrao_dab	esus_id	ativo	data_criacao	data_alteracao
bd1d0be5-b6cf-41e5-a02e-9b7ee1c7c34b	4329	HASTE DE DISTRACAO	9999	9999	0702050318	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
25927a66-f7e8-4f4f-8c31-9d47e7376880	4330	HASTE LISA TIPO LUQUE	9999	9999	0702050326	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
3554fc24-1df3-4856-a17c-e4aa86521891	4331	HASTE PARA ASSOCIACAO COM PARAFUSOS DE TITANIO	9999	9999	0702050334	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
bddb09e4-2e4c-4baf-8c24-f2478004ac7b	4381	GUIA METALICO P/ INTRODUCAO DE CATETER DUPLO LUMEN	9999	9999	0702100102	202402	1	1	0	7	12	264	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
1c0496ec-b696-47a7-845e-0979acf4e1d7	4505	HDL	0	1571	ABEX007	202402	1	1	2	2	9	4	1	159	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
f947fa96-e80b-4f05-bc1c-66e92514727c	4526	HEMOGRAMA	0	1571	ABEX028	202402	1	1	2	2	9	95	1	248	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
d55040a4-0221-4a34-b549-bda798c13319	529	HEMOCULTURA	0	1571	0202080153	202402	1	1	2	2	9	242	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
36debaba-95c2-45f8-8922-8a7271907913	4324	GRAMPEADOR CIRCULAR INTRALUMINAL	9999	9999	0702050261	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
cc28b01d-6d66-44cb-bc92-82c45ff2bdb0	4325	GRAMPEADOR LINEAR	9999	9999	0702050270	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
08cd5ff2-687b-4fac-97f9-4fe87abc1ddb	4326	GRAMPEADOR LINEAR CORTANTE	9999	9999	0702050288	202402	1	1	0	7	12	181	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
aac2569d-e561-4a85-881d-56a9f5863819	4104	GOTEIRAS DENTAIS	12	1571	0702020028	202402	1	1	0	7	12	74	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
8e0e8b3d-866c-4a06-8753-d1d17eb825a3	4105	GUIA SAGITAL	24	1571	0702020036	202402	1	1	0	7	12	74	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
6510c672-edf7-4805-b934-397dbb530e3e	4163	HASTE INTRAMEDULAR TIBIO-TARSICA	9999	9999	0702030570	202402	1	1	0	7	12	119	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
11e2d553-c201-43aa-aedd-ffe591e9ac11	3652	HIDROXICLOROQUINA 400 MG (POR COMPRIMIDO)	0	1571	0604080026	202402	1	1	3	6	26	237	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
e96db9b9-862f-4060-8337-f1ad7200e583	3032	HISTERECTOMIA (POR VIA VAGINAL)	144	1571	0409060100	202402	0	1	2	4	42	211	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
bf41e1aa-aba7-44ca-b4f1-9881c71f92a1	3033	HISTERECTOMIA C/ ANEXECTOMIA (UNI / BILATERAL)	144	1571	0409060119	202402	0	1	2	4	42	211	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
7d6c4be7-e096-4ec9-861b-8955bc3b9aa4	3034	HISTERECTOMIA SUBTOTAL	144	1571	0409060127	202402	0	1	2	4	42	211	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
1d7bbfc0-af0c-42b1-a890-539a13bc5117	3035	HISTERECTOMIA TOTAL	144	1571	0409060135	202402	0	1	2	4	42	211	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
f6b765a9-6d3f-4905-ad45-dcb66b67f1f6	3036	HISTERECTOMIA TOTAL AMPLIADA (WERTHEIN-MEIGS)	144	1571	0409060143	202402	0	1	2	4	42	211	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
31a1a702-cd40-4dd6-be60-8389aa714972	3037	HISTERECTOMIA VIDEOLAPAROSCOPICA	144	1571	0409060151	202402	0	1	2	4	42	211	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.275000+00:00	2021-05-25T19:39:57.275000+00:00
c621c0b7-c93b-4755-8ea2-f7be2db8c15a	4628	HISTERECTOMIA C/ ANEXECTOMIA BILATERAL E COLPECTOMIA SOB PROCESSO TRANSEXUALIZADOR	252	911	0409060291	202402	0	1	3	4	42	211	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
0dd8f6a1-9b0d-4d4c-8693-e4a5d5436005	2494	HEPATECTOMIA PARCIAL	0	1571	0407030131	202402	1	1	2	4	38	128	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
c30d6a1c-a389-423d-8f8c-26a13e56b2d2	2495	HEPATORRAFIA	0	1571	0407030140	202402	1	1	2	4	38	128	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
4cc697ee-5b65-4346-a2fb-be05a9e23621	2497	HEPATOTOMIA E DRENAGEM DE ABSCESSO / CISTO	0	1571	0407030166	202402	1	1	2	4	38	128	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
093a5b7d-4c7b-47a6-8b5f-1038f7206ce7	1358	HEMOPERFUSAO	0	1571	0303070021	202402	1	1	2	3	21	231	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
ec76940f-d94c-4475-b878-6abf1ad78374	1734	HIPERSENSIBILIZACAO ESPECIFICA (POR TRATAMENTO COMPLETO)	0	1571	0309020018	202402	1	1	2	3	43	80	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
839004e3-56df-432c-9741-b32406a46c0c	1735	HIPOSENSIBILIZACAO C/ PRODUTOS AUTOGENOS (POR TRATAMENTO COMPLETO)	0	1571	0309020026	202402	1	1	2	3	43	80	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
9c1d0e5a-488b-4e9d-909f-0e2c942dfd20	1855	HIPOFISECTOMIA TRANSESFENOIDAL POR TECNICA COMPLEMENTAR	0	1571	0403030064	202402	1	1	3	4	20	124	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
1e1950b1-4255-4c1e-bfa8-70719ddea399	3327	HEPATECTOMIA PARCIAL EM ONCOLOGIA	0	1571	0416040101	202402	1	1	3	4	57	146	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
4c7e4d55-5635-4233-ac72-e9cb91824fc0	2460	HEMORROIDECTOMIA	144	1571	0407020284	202402	1	1	2	4	38	87	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
435065dd-6c1a-4b4a-9df2-bfe0687c2bd0	2461	HERNIORRAFIA C/ RESSECCAO INTESTINAL (HERNIA ESTRANGULADA)	0	1571	0407020292	202402	1	1	2	4	38	87	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
42b98a1a-7ab4-4b64-8f51-acd51dd49929	2509	HERNIOPLASTIA DIAFRAGMATICA (VIA ABDOMINAL)	0	1571	0407040048	202402	1	1	2	4	38	162	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
d3164806-49a6-4c8a-8916-acfa27bdecbb	2513	HERNIOPLASTIA INCISIONAL	0	1571	0407040080	202402	1	1	2	4	38	162	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
a497c544-f10e-44f0-bdc5-0a4d529f4696	2514	HERNIOPLASTIA INGUINAL (BILATERAL)	0	1571	0407040099	202402	1	1	2	4	38	162	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
da612f03-811f-45ef-b3fb-4746f44f9bea	2515	HERNIOPLASTIA INGUINAL / CRURAL (UNILATERAL)	0	1571	0407040102	202402	1	1	2	4	38	162	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
73f207df-7c0c-45a0-b382-1d3129027620	2517	HERNIOPLASTIA UMBILICAL	0	1571	0407040129	202402	1	1	2	4	38	162	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
3aa5528d-589c-46f1-91f3-821686016433	2518	HERNIORRAFIA INGUINAL VIDEOLAPAROSCOPICA	0	1571	0407040137	202402	1	1	2	4	38	162	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
9a6c08e2-b1fc-4470-bcec-1f3a7c8d73f4	2519	HERNIORRAFIA S/ RESSECCAO INTESTINAL (HERNIA ESTRANGULADA )	0	1571	0407040145	202402	1	1	2	4	38	162	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
033db8ca-15be-4bda-a897-8de458a0256d	3068	HIMENOTOMIA	0	1571	0409070181	202402	0	1	2	4	42	228	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
9f5d61d1-ede0-4990-8da4-b267f4661e79	3109	HISTERECTOMIA PUERPERAL	108	731	0411020030	202402	0	1	2	4	48	90	1	<span class="null">NULL</span>	1	CLINICO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
14652b64-d790-4799-b013-e5b322e5c9a7	3468	HEPATECTOMIA PARCIAL P/ TRANSPLANTE (DOADOR VIVO)	216	1571	0503020010	202402	1	1	3	5	22	66	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
4b99b0a2-1e0d-410e-8579-e55a8153c4d6	3683	HIDRÓXIDO DE ALUMÍNIO 230 MG (POR COMPRIMIDO)	0	1571	0604170017	202402	1	1	3	6	26	297	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
78db97b3-5b06-4d08-8bb1-8f5a7a2b8f8f	3684	HIDRÓXIDO DE ALUMÍNIO 300 MG (POR COMPRIMIDO)	0	1571	0604170025	202402	1	1	3	6	26	297	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
f9f1ec38-656d-4b0e-a3f8-5d7c2d4c22cf	3685	HIDRÓXIDO DE ALUMÍNIO 61,5 MG/ML (SUSPENSÃO POR FRASCO DE 100 ML)	0	1571	0604170033	202402	1	1	3	6	26	297	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
28026096-6381-4e7a-871a-a0567a741924	3686	HIDRÓXIDO DE ALUMÍNIO 61,5 MG/ML (SUSPENSÃO POR FRASCO DE 150 ML)	0	1571	0604170041	202402	1	1	3	6	26	297	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
7a1ca0ba-5e3f-41af-a322-4654962339d4	3687	HIDRÓXIDO DE ALUMÍNIO 61,5 MG/ML (SUSPENSÃO POR FRASCO DE 240	0	1571	0604170050	202402	1	1	3	6	26	297	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
1d536c14-5240-4b87-93a2-6856ff295fb0	3825	HIDROXIUREIA 500 MG (POR CAPSULA)	0	1571	0604480016	202402	1	1	3	6	26	351	1	<span class="null">NULL</span>	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.274000+00:00	2021-05-25T19:39:57.274000+00:00
898a0210-7600-4a0b-a3d7-8f933051f8d6	3980	APARELHO DE AMPLIFICACAO SONORA INDIVIDUAL (AASI) EXTERNO INTRA-AURICULAR TIPO B	9999	9999	0701030046	202402	1	1	0	7	5	118	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
64a9780a-fb2e-4ce6-98e8-8d1509313314	3981	APARELHO DE AMPLIFICACAO SONORA INDIVIDUAL (AASI) EXTERNO INTRA-AURICULAR TIPO C	9999	9999	0701030054	202402	1	1	0	7	5	118	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00
40d0142f-c0d4-4549-8241-bbd17c30587a	3982	APARELHO DE AMPLIFICACAO SONORA INDIVIDUAL (AASI) EXTERNO INTRACANAL TIPO A	9999	9999	0701030062	202402	1	1	0	7	5	118	1	<span class="null">NULL</span>	0	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.265000+00:00	2021-05-25T19:39:57.265000+00:00