visitaconfig


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idvisitaconfig int8 19 null
visita.idvisitaconfig fk_bf1egauupyb6s38gvjt7jdyp9 R
visita_aud.idvisitaconfig Implied Constraint R
visitaconfig_aud.idvisitaconfig Implied Constraint R
visitaconfigcampo.idvisitaconfig fk_5dtnqv6dgn3rlo4qi8ylbfit R
visitaconfigcampo_aud.idvisitaconfig Implied Constraint R
visitademandaconfig.idvisitaconfig fk_shry8thu5utdmtlao26te6nnk R
visitademandaconfig_aud.idvisitaconfig Implied Constraint R
idvisitatipo int8 19 null
visitatipo.idvisitatipo fk_lu2ax5c60qjgdht6cqin53rb0 R
idsegmentacao int8 19 √ null
segmentacao.idsegmentacao fk_7ogmcjpoefbjl4amik0ewu6m4 R
idcultura int8 19 null
cultura.idcultura fk_oo4j672vaq347txqklq6lfhsv R
idnativo int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idvisitatiposuperior int8 19 √ null
visitatipo.idvisitatipo fk_et489cqkrlr5tkiyemw1a1con R

Indexes

Constraint Name Type Sort Column(s)
pkca736f78 Primary key Asc idvisitaconfig
idx332d16ed Performance Asc idsegmentacao
idx49ac4d89 Performance Asc idvisitatipo
idxac74f08f Performance Asc idcultura
idxc33ab0d2 Performance Asc idcultura
idxd65b07fb Performance Asc idvisitatiposuperior
idxwsversao_ca736f78 Performance Desc wsversao
uc4a981502 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation