VPPRAMEDICOESEPI

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VCATALOGOEPI.CODCOLIGADA FKVPPRAMEDICOESEPI_VCATALOGOEPR
VPPRAMEDICOES.CODCOLIGADA FKVPPRAMEDICOESEPI_VPPRAMEDICOR
CODITEMRISCO varchar 10 null
VPPRAMEDICOES.CODITEMRISCO FKVPPRAMEDICOESEPI_VPPRAMEDICOR
CODEPI varchar 10 null
VCATALOGOEPI.CODEPI FKVPPRAMEDICOESEPI_VCATALOGOEPR
IDSEQUENCIAL int 4 null
VPPRAMEDICOES.IDSEQUENCIAL FKVPPRAMEDICOESEPI_VPPRAMEDICOR
DURABILIDADE int 4 √ null
TIPOUSO smallint 2 √ null
CLASSIFICACAO smallint 2 √ null
CODPOSTOTRABALHO varchar 25 √ null
CODSECAOLOT varchar 35 √ null
CODFUNCAOLOT varchar 10 √ null
CODSECAO varchar 35 √ null
CODTAREFA varchar 10 √ null
CODLOCALTRABALHO varchar 10 √ null
DATA DDATETIME 16,3 null
INDEPI int 4 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DATAINICIO DDATETIME 16,3 √ null
PFHSTGRADEREMUN.DATAINICIO Implied ConstraintR
DATAFIM DDATETIME 16,3 √ null
EPIEFICAZ smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKVPPRAMEDICOESEPI Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODITEMRISCO + CODEPI + IDSEQUENCIAL + INDEPI

Relationships

Close relationships within degrees of separation