visitacampo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idvisitacampo int8 19 null
visitacampo_aud.idvisitacampo Implied Constraint R
visitaprod.idvisitacampo fk_6usl2lytd39evjbhna2cci4yv R
visitaprod_aud.idvisitacampo Implied Constraint R
visitaprodconcorr.idvisitacampo fk_rtpu5enx8469inemw3opmxeo4 R
visitaprodconcorr_aud.idvisitacampo Implied Constraint R
idvisita int8 19 null
visita.idvisita fk_7cfwxcdvp8g4v3a7u6qb73k7p R
idcampo int8 19 null
campo.idcampo fk_bbtxeet2o3dw1kthhplw5tlfw R
valor varchar 4000 √ null
idnobrigatorio int2 5 null
ordem int8 19 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pkec38b18 Primary key Asc idvisitacampo
idx67a5698a Performance Asc idcampo
idx6e12387a Performance Asc idvisita
idxwsversao_ec38b18 Performance Desc wsversao
uc60befc04 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation