demtipvisita


Columns

Column Type Size Nulls Auto Default Children Parents Comments
iddemtipvisita int8 19 null
demtipvisita_aud.iddemtipvisita Implied Constraint R
demtipvisitacampo.iddemtipvisita fk_5kpbovhu6mjus8d7e93x6jxea R
demtipvisitacampo_aud.iddemtipvisita Implied Constraint R
iddemtipconfig int8 19 null
demtipconfig.iddemtipconfig fk_bhwxbaqjql55p6je6kk8vbr44 R
idvisitatipo int8 19 null
visitatipo.idvisitatipo fk_91spx2iy72svml9cqscy4itvf R
identidade int8 19 null
entidade.identidade fk_kwafv3va2x60oqabjp7mw6bew R
idsegmentacao int8 19 √ null
segmentacao.idsegmentacao fk_6vybrl77sr5es9q4hopskps0m R
idnobrigatorio int2 5 null
dias numeric 18 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pkcbf7a665 Primary key Asc iddemtipvisita
idx297b5883 Performance Asc identidade
idx424d2bf7 Performance Asc idvisitatipo
idx7d67052c Performance Asc idsegmentacao
idxf4401a4f Performance Asc iddemtipconfig
idxwsversao_cbf7a665 Performance Desc wsversao

Relationships

Close relationships within degrees of separation