servicorealizado


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idservicorealizado int8 19 null
servicoimagem.idservicorealizado fk_sowc13yjntdssd8e9alnwupn6 R
servicoimagem_aud.idservicorealizado Implied Constraint R
servicorealizado_aud.idservicorealizado Implied Constraint R
observacao varchar 4000 √ null
tempo varchar 8 √ null
data date 13 √ null
valortotalservico numeric 18,6 √ null
idprojetoagricolaarea int8 19 √ null
projetoagricolaarea.idprojetoagricolaarea fk_k9qw2v8msrjj8jv7tsf329nu R
idusuario int8 19 √ null
usuario.idusuario fk_pwygg2aeefuptiwpuyaoj3282 R
observacaointegracao varchar 80 √ null
tamanhoarea numeric 18,6 √ null
idnexportadoerp int2 5 √ null
idpontogpsarea int8 19 √ null
pontogpsarea.idpontogpsarea fk_8a8fugqj6rowtb5y4j8vk3dth R
idestagio int8 19 √ null
estagio.idestagio fk_r4y6vjli9svnp7kmhbvg2rfyy R
idatendimento int8 19 √ null
atendimento.idatendimento fk_7p76qphesplo3xe78d4jvngca R
idlocal int8 19 √ null
local.idlocal fk_cm4s6cov14ok04myxlfqhydb3 R
idservico int8 19 null
servico.idservico fk_oqalbnu3j8bsdqeoqoamgogw3 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idvistoria int8 19 √ null
vistoria.idvistoria fk_kb38tgd2fou7hlbh5gg2oga3 R
hora varchar 8 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk6754f1e Primary key Asc idservicorealizado
idx355030bf Performance Asc idlocal
idx49d9d533 Performance Asc idvistoria
idx53d7696 Performance Asc idestagio
idx5de9466a Performance Asc idservico
idxadcfa9f3 Performance Asc idprojetoagricolaarea
idxdb546749 Performance Asc idusuario
idxe714cf86 Performance Asc idatendimento
idxecc77b4a Performance Asc idpontogpsarea
idxwsversao_6754f1e Performance Desc wsversao
uc625e075c Must be unique Asc codigoerp

Graphviz Needed!

SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz graphvizVersion 2.26 or versions greater than 2.31 from www.graphviz.org.