operacaosegmento


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idoperacaosegmento int8 19 null
operacaosegmento_aud.idoperacaosegmento Implied Constraint R
idoperacao int8 19 null
operacao.idoperacao fk_1h6tabbno80lb6tgv81twdk1t R
idsegmento int8 19 null
segmento.idsegmento fk_4bg4x2c64k6f1e3wfya0oq2lu R
valor numeric 18,6 √ null
valorminimo numeric 18,6 √ null
valormaximo numeric 18,6 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pkd9e5d8fa Primary key Asc idoperacaosegmento
idx60ef39b4 Performance Asc idoperacao
idxd323b16 Performance Asc idsegmento
idxwsversao_d9e5d8fa Performance Desc wsversao
uc32d4bf40 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation