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
6f8ea2f9-9ad5-4de2-a643-c0b2a873efa3	3909	CADEIRA DE RODAS PARA BANHO COM ENCOSTO RECLINÁVEL	9999	9999	0701010240	202402	1	1	0	7	5	55	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
9d58dd10-e8a1-4570-8666-aa9055ebbc8b	34	CADASTRO DE HOSPITAIS	9999	9999	0102010250	202402	1	1	0	1	10	2	1	<span class="null">NULL</span>	0	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.268000+00:00	2021-05-25T19:39:57.268000+00:00
7acf4ba2-0b86-45c4-b685-6a2b6a6b4c33	36	CADASTRO DE INSTITUIÇÕES DE LONGA PERMANÊNCIA PARA IDOSOS	9999	9999	0102010277	202402	1	1	0	1	10	2	1	<span class="null">NULL</span>	0	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.268000+00:00	2021-05-25T19:39:57.268000+00:00
01eb7c3c-c2d4-4982-9c5f-bee0a067dc57	39	CADASTRO DE INDÚSTRIAS DE MEDICAMENTOS	9999	9999	0102010307	202402	1	1	0	1	10	2	1	<span class="null">NULL</span>	0	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.268000+00:00	2021-05-25T19:39:57.268000+00:00
72437220-9ff4-4d30-9996-6bfa1b1f8f2c	4538	CADASTRO DE INDÚSTRIAS DE INSUMOS FARMACÊUTICOS	9999	9999	0102010544	202402	1	1	0	1	10	2	1	<span class="null">NULL</span>	0	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.268000+00:00	2021-05-25T19:39:57.268000+00:00
db65479f-524b-4e3d-87ab-606fc769adef	4539	CADASTRO DE INDÚSTRIAS DE PRODUTOS PARA SAÚDE	9999	9999	0102010552	202402	1	1	0	1	10	2	1	<span class="null">NULL</span>	0	ADMINISTRATIVO	<span class="null">NULL</span>	<span class="null">NULL</span>	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.268000+00:00	2021-05-25T19:39:57.268000+00:00
b3dda51c-0afb-4312-bb7e-b6f76ddb9217	4533	DANÇA CIRCULAR/BIODANÇA	0	1571	0101010060	202402	1	1	1	1	4	1	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
2c340fc0-c2a4-407d-b614-c6dd9e2b5369	646	BRONCOGRAFIA UNILATERAL	0	1571	0204030013	202402	1	1	2	2	25	135	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.268000+00:00	2021-05-25T19:39:57.268000+00:00
18b0258b-9548-42f6-a722-174d69747351	2843	BURSECTOMIA	144	1571	0408060085	202402	1	1	2	4	41	214	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
85e84fa2-c6cd-48a8-808d-97554aba8a17	3623	BROMOCRIPTINA 5 MG (POR COMPRIMIDO OU CÁPSULA DE LIBERAÇÃO RETARDADA	0	1571	0604030029	202402	1	1	3	6	26	117	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
50be3faa-d078-4d71-9dc1-1fb67d8ae47b	3122	TRAQUEOSTOMIA COM COLOCAÇÃO DE ORTESE TRAQUEAL OU TRAQUEOBRONQUICA	0	1571	0412010127	202402	1	1	3	4	50	38	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.285000+00:00	2021-05-25T19:39:57.285000+00:00
88bece98-48fd-4a4d-bc3d-72a0f791a322	3127	MEDIASTINOTOMIA P/ DRENAGEM	0	1571	0412020033	202402	1	1	3	4	50	91	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
147467a4-3f90-4930-82cb-ee1158e4a182	3569	CABERGOLINA 0,5 MG (POR COMPRIMIDO)	0	1571	0603040012	202402	1	1	2	6	19	151	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
3b474850-db53-4906-ac24-6b8488c28d65	3727	BUDESONIDA 200 MCG (POR CAPSULA INALANTE)	0	1571	0604280068	202402	1	1	3	6	26	323	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
8aaaab03-515d-48b8-b66d-90f6fda42570	3729	BUDESONIDA 200 MCG PO INALANTE OU AEROSSOL BUCAL (POR FRASCO C/ 100 DOSES)	0	1571	0604280084	202402	1	1	3	6	26	323	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
2fce5896-4d4d-475a-8276-3750a9e9a117	3887	CADEIRA DE RODAS ADULTO / INFANTIL (TIPO PADRÃO)	9999	9999	0701010029	202402	1	1	0	7	5	55	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
9e1dda48-585b-4919-92b6-8fe43706c060	3888	CADEIRA DE RODAS PARA BANHO COM ASSENTO SANITÁRIO	9999	9999	0701010037	202402	1	1	0	7	5	55	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
dfc955e1-4bf8-475f-be1c-865d0d558d62	3889	CADEIRA DE RODAS PARA TETRAPLÉGICO - TIPO PADRÃO	9999	9999	0701010045	202402	1	1	0	7	5	55	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
110f11d0-fd2e-459e-81dc-1e6081e0ea83	3890	CALÇADOS ANATÔMICOS COM PALMILHAS PARA PÉS NEUROPÁTICOS (PAR)	0	1571	0701010053	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
5b07e091-e849-4301-83e5-4bfe0503d0e6	3891	CALÇADOS ORTOPÉDICOS CONFECCIONADOS SOB MEDIDA ATÉ NÚMERO 45 (PAR)	9999	9999	0701010061	202402	1	1	0	7	5	55	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
8fe94b0e-3141-4deb-a664-845595a44164	3892	CALÇADOS ORTOPÉDICOS PRÉ-FABRICADOS COM PALMILHAS ATÉ NÚMERO 45 (PAR)	9999	9999	0701010070	202402	1	1	0	7	5	55	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
648d3a1e-5097-4e20-829e-91e82db6dbba	3905	CADEIRA DE RODAS MONOBLOCO	132	611	0701010207	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
2994573c-b80c-4d8a-ac4f-ce1b778bb0b4	1127	BUSCA ATIVA	9999	9999	0301050139	202402	1	1	1	3	1	194	1	<span class="null">NULL</span>	0	ADMINISTRATIVO	0	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.268000+00:00	2021-05-25T19:39:57.268000+00:00
f76ede0f-dff6-44ba-8e0e-116796577cd4	830	BRONCOSCOPIA (BRONCOFIBROSCOPIA)	0	1571	0209040017	202402	1	1	2	2	44	170	1	<span class="null">NULL</span>	1	CLINICO	1	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.268000+00:00	2021-05-25T19:39:57.268000+00:00
0284a343-4074-484a-97d2-598b95f39597	3728	BUDESONIDA 400 MCG (POR CAPSULA INALANTE)	0	1571	0604280076	202402	1	1	3	6	26	323	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
b214f2a4-dff7-4782-ac00-6e3fbf3ce550	3848	CALCITONINA 50 UI INJETAVEL (POR AMPOLA)	0	1571	0604570015	202402	1	1	3	6	26	360	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
f53b801b-e843-4dd3-ab6d-17aab455c1a5	1753	CARDIOVERSAO ELETRICA	0	1571	0309040027	202402	1	1	2	3	43	158	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
ef62ac94-6638-4e57-8548-e8a85bb4b074	4479	CAPEAMENTO PULPAR	0	1571	ABPO006	202402	1	1	1	3	36	23	0	1684	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
93924f7a-11f5-4590-8905-b0e7b15f6bc7	2907	CAPSULECTOMIA RENAL	0	1571	0409010014	202402	1	1	2	4	42	35	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
d08ab86c-cfd4-415a-b30f-f757029b80e1	4361	CATETER DUPLO J	9999	9999	0702060011	202402	1	1	0	7	12	215	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
c715e368-9477-4967-895d-99733718f159	898	CAMPIMETRIA COMPUTADORIZADA OU MANUAL COM GRÁFICO	0	1571	0211060038	202402	1	1	2	2	49	203	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.268000+00:00	2021-05-25T19:39:57.268000+00:00
bdbe1df1-a699-4380-a247-19e1c5a8d538	3486	CAPTAÇÃO DE ÓRGÃO EFETIVAMENTE TRANSPLANTADO	0	1091	0503040088	202402	1	1	3	5	22	148	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
42dd8cb4-11f2-40f7-abb5-a57c9a75348d	2119	CAPSULOTOMIA A YAG LASER	0	1571	0405050020	202402	1	1	2	4	29	185	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
7e2cc7ce-1167-446e-ba8c-20610fb9ed84	860	CATETERISMO CARDIACO	144	1571	0211020010	202402	1	1	3	2	49	104	1	<span class="null">NULL</span>	1	CLINICO	0	1	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.268000+00:00	2021-05-25T19:39:57.268000+00:00
15c2c934-3db6-4bb2-bcd4-cab634bf92e4	1684	CAPEAMENTO PULPAR	0	1571	0307010015	202402	1	1	1	3	36	23	1	<span class="null">NULL</span>	1	CLINICO	1	0	0	<span class="null">NULL</span>	1	2021-05-25T19:39:57.268000+00:00	2021-05-25T19:39:57.268000+00:00
5d891392-c76c-43ea-8e49-9f19ac32550d	3850	CALCITONINA 200 UI/DOSE SPRAY NASAL (POR FRASCO)	0	1571	0604570031	202402	1	1	3	6	26	360	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
3fee5524-60c2-4e58-9b4c-81160bd945d1	3865	CALCITRIOL 0,25 MCG (POR CAPSULA)	0	1571	0604620039	202402	1	1	3	6	26	365	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
c80d42e2-353a-4c28-a08d-7969afcd29e0	3895	CARRINHO DOBRÁVEL PARA TRANSPORTE DE CRIANÇA COM DEFICIÊNCIA	0	371	0701010100	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
2ced3ac0-4e27-4a41-8e87-71a5444d24ac	4084	CATETER ATRIAL / PERITONEAL	9999	9999	0702010030	202402	1	1	0	7	12	56	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
649a9403-e195-41a7-8f56-afb6386b9746	4085	CATETER GUIA CALIBRE 6F A 8F	9999	9999	0702010049	202402	1	1	0	7	12	56	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
d2545dc3-0915-4607-916a-7f75b1f9d5f7	4086	CATETER VENTRICULAR C/ RESERVATORIO	9999	9999	0702010057	202402	1	1	0	7	12	56	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
1cc61fd6-1960-4161-a384-d57b8a0b479f	4087	CATETER VENTRICULAR ISOLADO	9999	9999	0702010065	202402	1	1	0	7	12	56	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
dd88b741-e02e-4287-bb82-8a8d5657ce9e	4247	CARDIOVERSOR DESFIBRILADOR C/ MARCAPASSO MULTI-SITIO	9999	9999	0702040045	202402	1	1	0	7	12	154	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
d016b8c2-e69f-417e-900b-96978b23c419	4249	CARDIOVERSOR DESFIBRILADOR IMPLANTAVEL	9999	9999	0702040061	202402	1	1	0	7	12	154	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
3fad84ba-debb-4c3a-9872-13a662486373	4250	CATETER BALAO P/ ANGIOPLASTIA PERIFERICA	9999	9999	0702040070	202402	1	1	0	7	12	154	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
bc8b5fa8-e8fc-400a-be83-f068865224c2	4302	CANULA P/ TRAQUEOSTOMIA S/ BALAO	9999	9999	0702050024	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
ba8fdc26-d94b-4314-8a64-322144b85a94	4303	CARGA P/ GRAMPEADOR LINEAR	9999	9999	0702050032	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
205a2eae-0ec3-41db-aea4-1c5a4e958496	4304	CARGA P/ GRAMPEADOR LINEAR CORTANTE	9999	9999	0702050040	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
fd11a29e-37db-4419-bbf5-bb13337d68be	4305	CATETER BALAO P/ EMBOLECTOMIA ARTERIAL / VENOSA	9999	9999	0702050059	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.268000+00:00	2021-05-25T19:39:57.268000+00:00
e4164f1f-7b8b-407b-b563-9ca7b44b6610	4306	CATETER DE TERMODILUICAO	9999	9999	0702050067	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.268000+00:00	2021-05-25T19:39:57.268000+00:00