usuariofilial


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idusuariofilial int8 19 null
usuariofilial_aud.idusuariofilial Implied Constraint R
idnpadrao int2 5 √ null
idusuario int8 19 null
usuario.idusuario fk_qjvlrho15y5wyn4iuqfxke88g R
idlocalfilial int8 19 √ null
local.idlocal fk_ryyaunu8nkwe0bfn1swj4mg57 R
idsegmento int8 19 √ null
segmento.idsegmento fk_lubthymm6bu5krbhhexk94mma R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 12 rows

Indexes

Constraint Name Type Sort Column(s)
pk51be1659 Primary key Asc idusuariofilial
idx642e084e Performance Asc idusuario
idxc2101d51 Performance Asc idlocalfilial
idxc80730f7 Performance Asc idsegmento
idxwsversao_51be1659 Performance Desc wsversao
uc983c1a63 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.