planejamento


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idplanejamento int8 19 null
planejamento_aud.idplanejamento Implied Constraint R
planejamentoitem.idplanejamento fk_df0k51p3t4hk96qr6sq26y5o2 R
planejamentoitem_aud.idplanejamento Implied Constraint R
planejamentometrica.idplanejamento fk_dt8gha0npuurk41xxwj7m3a7x R
planejamentometrica_aud.idplanejamento Implied Constraint R
planejamentomodelo.idplanejamento fk_gm1a7s0lnvc7f2hni0r5fowg R
planejamentomodelo_aud.idplanejamento Implied Constraint R
planpermacesso.idplanejamento fk_djp40rxqc9almdghlbv7kmirt R
planpermacesso_aud.idplanejamento Implied Constraint R
wspla2.idplanejamento Implied Constraint R
wspla3.idplanejamento Implied Constraint R
descricao varchar 80 null
idnativo int2 5 null
datainicio date 13 √ null
datafim date 13 √ null
observacao varchar 4000 √ null
idnfinalizado int2 5 null
datacadastro date 13 null
dataatualizacao date 13 √ null
nometabelafato varchar 20 null
idusuariocadastro int8 19 null
usuario.idusuario fk_9kn19cukgwjsp84bxhh9fvgaq R
idusuarioatualizacao int8 19 √ null
usuario.idusuario fk_aquyr85bok7569yhppxh4iii0 R
idagendamento int8 19 √ null
agendamento.idagendamento fk_b7cv7yibqjhu7f1i2980u445b R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 4 rows

Indexes

Constraint Name Type Sort Column(s)
pkc1b8e3e Primary key Asc idplanejamento
idx4f4d7299 Performance Asc idagendamento
idx7c18cbe Performance Asc idusuarioatualizacao
idx9eecbe08 Performance Asc idusuariocadastro
idxwsversao_c1b8e3e Performance Desc wsversao
ucf3ce6fdc 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.