servico


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idservico int8 19 null
servico_aud.idservico Implied Constraint R
servicorealizado.idservico fk_oqalbnu3j8bsdqeoqoamgogw3 R
servicorealizado_aud.idservico Implied Constraint R
idnativo int2 5 null
descricao varchar 80 null
codigo varchar 20 √ null
valorhoraservico numeric 18,6 √ null
valorservico numeric 18,6 √ null
idncalculavalorporhora int2 5 √ null
tempominimohorainteira varchar 8 √ null
idestagioposterior int8 19 √ null
estagio.idestagio fk_n8pn8adwl8o4ybgbj2su3jlsp R
idtiposervico int8 19 null
tiposervico.idtiposervico fk_s45unmyv1mu0im9tkghbco0rw R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pkd97c5e9f Primary key Asc idservico
idx4d2d4035 Performance Asc idestagioposterior
idx5f09d146 Performance Asc idtiposervico
idxwsversao_d97c5e9f Performance Desc wsversao
uca8b5007d Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation