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
7f9cc939-988d-4214-b381-b0114946e4ec	4172	PARAFUSO CORTICAL 1,5 MM	9999	9999	0702030660	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
389f02a1-4949-40c7-ba6a-5d413b508347	4333	MICRO CATETER	9999	9999	0702050350	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
cfc527ba-5e5b-4edd-af47-7825eb3ef9f0	1882	MICROCIRURGIA COM RIZOTOMIA A CEU ABERTO	0	1571	0403050073	202402	1	1	3	4	20	184	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
a8d126dc-cdb5-4163-9b1d-715f7005d0f8	4334	MICRO GUIA	9999	9999	0702050369	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
eeaf3087-065a-4053-a249-8f7712c2c00f	1028	MICRO-AGLUTINACAO P/ IDENTIFICACAO DE LEPTOSPIRAS (LEPTOSPIROSE)	0	1571	0213010453	202402	1	1	2	2	52	15	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
5afbcdc4-e388-4afe-aaf3-4687db4a3229	3642	MORFINA 10 MG/ML SOLUCAO ORAL (POR FRASCO DE 60 ML)	0	1571	0604050062	202402	1	1	3	6	26	179	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
65863199-4368-4537-9fce-d413f0f7e7da	3564	MUROMONABE CD3 5 MG INJETAVEL (POR AMPOLA DE 0,5 ML)	0	1571	0603020100	202402	1	1	2	6	19	71	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
d58da246-5cd3-4661-8d4d-4276a039fcb7	1494	MOLDAGEM EM COLO E/OU CORPO DO UTERO	240	1571	0304010162	202402	0	1	3	3	27	20	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
dfe89a14-5536-43c6-8b6a-b638b9f45399	3041	MIOMECTOMIA	144	1571	0409060194	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
2f45fe13-b8fb-475e-8670-4a752b1fc672	1495	NARCOSE DE CRIANÇA (POR PROCEDIMENTO)	0	239	0304010170	202402	1	1	3	3	27	20	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
b805a49c-a689-4698-bd34-136971aa05fe	1607	MONOQUIMIOTERAPIA DO CARCINOMA DE MAMA HER-2 POSITIVO EM ESTÁDIO I (ADJUVANTE)	228	1571	0304050296	202402	1	1	3	3	27	182	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
e46b2681-976b-473d-928d-163961cbf024	1946	MIRINGOTOMIA (TIMPANOPLASTIA)	0	1571	0404010245	202402	1	1	2	4	24	30	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
1dfb525a-fd5e-4c2c-b19a-58c6eb8b38ac	609	NECROPSIA	0	1571	0203020057	202402	1	1	2	2	17	96	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
46f46408-977e-40ad-89f7-dc1ea00ee534	3709	MOLGRAMOSTIM 300 MCG INJETAVEL (POR FRASCO)	0	1571	0604250029	202402	1	1	3	6	26	317	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
2c4763b3-3868-4ceb-b20f-57dcaff615f4	3042	MIOMECTOMIA VIDEOLAPAROSCOPICA	144	1571	0409060208	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
d1ed9211-dcf7-4cd3-9c2f-3b17ce8d404c	3146	MOBILIZACAO DE RETALHOS MUSCULARES / DO OMENTO	0	1571	0412040050	202402	1	1	3	4	50	165	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
ffb0cbfc-5349-4711-8f4c-79af6903fd73	3422	MOBILIZAÇÃO, COLETA E ACONDICIONAMENTO DE CELULAS TRONCO HEMATOPOETICAS DE SANGUE PERIFERICO NO BRASIL PARA TRANSPLANTE AUTOGENICO OU DE DOADOR APARENTADO OU NAO APARENTADO	0	911	0501030077	202402	1	1	3	5	7	112	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
ef6b5b49-91e9-4543-b520-d334e8f12544	3641	MORFINA 10 MG/ML (POR AMPOLA DE 1 ML)	0	1571	0604050054	202402	1	1	3	6	26	179	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
e177429c-9296-4ed9-a0b0-74839e72de28	3643	MORFINA 10 MG (POR COMPRIMIDO)	0	1571	0604050070	202402	1	1	3	6	26	179	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
8deca07c-4140-4eba-b901-253daee59e82	3644	MORFINA 30 MG (POR COMPRIMIDO)	0	1571	0604050089	202402	1	1	3	6	26	179	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
3fd09986-0863-49ec-9692-d8f00f8135f5	3645	MORFINA DE LIBERACAO CONTROLADA 30 MG (POR CAPSULA)	0	1571	0604050097	202402	1	1	3	6	26	179	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
9396335e-c932-4f67-ba9e-6ea957af3b6d	3759	NATALIZUMABE 300MG (POR FRASCO-AMPOLA)	216	1571	0604320116	202402	1	1	3	6	26	331	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
b0bf3ab5-ed73-41cb-aa43-c87f5bf8e9bb	3867	MIGLUSTATE 100 MG (POR CAPSULA)	216	1571	0604630018	202402	1	1	3	6	26	366	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
8ce5310f-955b-486d-ab39-e09cb64db97f	3882	NAPROXENO 250 MG (POR COMPRIMIDO)	0	1571	0604720017	202402	1	1	3	6	26	375	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
d3e559d6-cf4e-4cf9-9b06-52ae0651befa	3883	NAPROXENO 500 MG (POR COMPRIMIDO)	0	1571	0604720025	202402	1	1	3	6	26	375	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
8f44d281-d0ea-4196-93c7-b1acc3eb2ddc	3897	MULETA AXILAR REGULÁVEL DE MADEIRA (PAR)	24	1571	0701010126	202402	1	1	0	7	5	55	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
f607a8e6-b5e9-4395-a8f8-4bcb202d8f06	3898	MULETA AXILAR TUBULAR EM ALUMÍNIO REGULÁVEL NA ALTURA (PAR)	24	1571	0701010134	202402	1	1	0	7	5	55	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
c86c7813-eaa8-4214-a133-21313d8bb96e	3991	MOLDE AURICULAR (REPOSIÇÃO)	9999	9999	0701030151	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
3f840698-5d5b-4e8b-ae44-6ab729923f2f	4166	MINI-FIXADOR EXTERNO	9999	9999	0702030600	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
2a690958-415c-4462-9934-631acbb11757	4167	MINI-PARAFUSO DE AUTO-COMPRESSAO	9999	9999	0702030619	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
edd82068-6df1-4616-b36f-705e2eff41c5	4173	PARAFUSO CORTICAL 2,0 MM	9999	9999	0702030678	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
6ffd07c5-34f8-4634-addc-bc067de9c9bd	4174	PARAFUSO CORTICAL 2,7 MM	9999	9999	0702030686	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
59a47655-982f-4727-8ef8-0e35e318a998	4176	PARAFUSO CORTICAL 4,5 MM	9999	9999	0702030708	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
48f02992-af17-4229-a663-2c1415fc15b3	4177	PARAFUSO DE INTERFERÊNCIA DE TITÂNIO	9999	9999	0702030716	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.278000+00:00	2021-05-25T19:39:57.278000+00:00
24d3cde1-d8fa-4141-9b4e-2a1cb36e32d5	1507	MOLDAGEM/IMPLANTE EM MUCOSA (POR TRATAMENTO COMPLETO)	240	1571	0304010324	202402	1	1	3	3	27	20	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
f30684ec-7979-4dad-879a-c95c603f7538	1508	MOLDAGEM/IMPLANTE EM PELE/MUCOSA (POR TRATAMENTO COMPLETO)	240	1571	0304010332	202402	1	1	3	3	27	20	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
5a075002-9ad3-4e9d-8104-7028a5b63054	863	MONITORAMENTO PELO SISTEMA HOLTER 24 HS (3 CANAIS)	0	1571	0211020044	202402	1	1	2	2	49	104	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
00492018-970c-449b-81c9-44018a641c3f	4486	MOLDAGEM DENTO-GENGIVAL P/ CONSTRUÇÃO DE PRÓTESE DENTÁRIA	0	1571	ABPO014	202402	1	1	1	3	36	156	0	1705	1	<span class="null">NULL</span>	<span class="null">NULL</span>	<span class="null">NULL</span>	1	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
b0b080b7-7eec-4907-b925-818512237eac	557	MIELOGRAMA	0	1571	0202090191	202402	1	1	2	2	9	248	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
2b2fb262-1df4-4067-af9c-3da49bc15d99	1705	MOLDAGEM DENTO-GENGIVAL P/ CONSTRUCAO DE PROTESE DENTARIA	0	1571	0307040070	202402	1	1	1	3	36	156	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
0c469656-5d66-4fb9-8030-faad6ea8c0ed	4420	MONITORAMENTO DE CIRCULACAO EXTRACORPOREA	9999	9999	0802020011	202402	1	1	0	8	11	60	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
4626def9-be7b-489f-9591-a4b37cff3046	633	MIELOGRAFIA	0	1571	0204020018	202402	1	1	3	2	25	97	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
dea7cd55-bf95-4105-a6a2-42b73dd195c1	3600	MUROMONABE CD3 5 MG INJETAVEL P/TRANSPLANTE (POR FRASCO AMPOLA DE 0,5 ML)	0	1571	0603080154	202402	1	1	3	6	19	243	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
43481229-21a7-4e4b-83a6-f7f141861e63	864	MONITORIZACAO AMBULATORIAL DE PRESSAO ARTERIAL (M.A.P.A)	0	1571	0211020052	202402	1	1	2	2	49	104	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.276000+00:00	2021-05-25T19:39:57.276000+00:00
cf13ad2e-580f-4cd8-9ba1-a778000eb46e	4241	MINI PLACA EM T OU L (INCLUI PARAFUSO)	9999	9999	0702031364	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
ad841d55-cc4e-419f-b8c2-83fea7cb4ca7	3267	NEFROURETERECTOMIA TOTAL EM ONCOLOGIA	0	1571	0416010091	202402	1	1	3	4	57	42	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.277000+00:00	2021-05-25T19:39:57.277000+00:00
5d3fba4b-7a9a-4593-86dc-c25e39b7c81b	3266	NEFRECTOMIA TOTAL EM ONCOLOGIA	0	1571	0416010075	202402	1	1	3	4	57	42	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.276000+00:00	2021-05-25T19:39:57.276000+00:00
0cd77936-0c01-4355-b85e-13fbc6f535d1	1691	OBTURAÇÃO DE DENTE DECÍDUO	0	1571	0307020037	202402	1	1	2	3	36	78	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
927bf5e6-9f19-4eea-8ef2-8d7121a98433	1692	OBTURAÇÃO EM DENTE PERMANENTE BIRRADICULAR	0	1571	0307020045	202402	1	1	2	3	36	78	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00
ebd93181-6e41-4c96-a5b4-6efa4fc2385b	1693	OBTURAÇÃO EM DENTE PERMANENTE COM TRÊS OU MAIS RAÍZES	0	1571	0307020053	202402	1	1	2	3	36	78	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.277000+00:00	2021-05-25T19:39:57.277000+00:00