planejamentomodelo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idplanejamentomodelo int8 19 null
planejamentomodelo_aud.idplanejamentomodelo Implied Constraint R
planejamentomodelovinc.idplanejamentomodelo fk_8rag03b7y3kyqgfeesi642oym R
planejamentomodelovinc_aud.idplanejamentomodelo Implied Constraint R
ordem int8 19 null
idplanejamento int8 19 null
planejamento.idplanejamento fk_gm1a7s0lnvc7f2hni0r5fowg R
idplanejamentoentmodelo int8 19 null
planejamentoentmodelo.idplanejamentoentmodelo fk_l3feuhl2vdqdt5hm01fes22ds R
datacadastro date 13 null
dataatualizacao date 13 √ null
idusuariocadastro int8 19 null
usuario.idusuario fk_7x3w45942ui7n0nhlvf6tj60v R
idusuarioatualizacao int8 19 √ null
usuario.idusuario fk_mm1wax7sibvxrun1w1l23kuq2 R
idnagrupamento int2 5 null
idnexibecodigo int2 5 null
idnsomentehierarquia int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 12 rows

Indexes

Constraint Name Type Sort Column(s)
pk5a2bbe44 Primary key Asc idplanejamentomodelo
idx23f80b59 Performance Asc idplanejamento
idx243c8faa Performance Asc idusuarioatualizacao
idxac2b33e4 Performance Asc idusuariocadastro
idxc35145e2 Performance Asc idplanejamentoentmodelo
idxwsversao_5a2bbe44 Performance Desc wsversao
uc70a77e76 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.