dadopessoalacesso


Columns

Column Type Size Nulls Auto Default Children Parents Comments
iddadopessoalacesso int8 19 null
dadopessoalacesso_aud.iddadopessoalacesso Implied Constraint R
dadopessoalacessoids.iddadopessoalacesso fk_t16mybb23nub5grf9w4r20vgh R
dadopessoalacessoids_aud.iddadopessoalacesso Implied Constraint R
idusuario int8 19 null
usuario.idusuario fk_8ufskdrbcasjyas8mf8cmgro2 R
dataacesso date 13 null
horaacesso varchar 8 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 8 rows

Indexes

Constraint Name Type Sort Column(s)
pk8bb33ba9 Primary key Asc iddadopessoalacesso
idx4a489868 Performance Asc idusuario
idxwsversao_8bb33ba9 Performance Desc wsversao
uc55edf273 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.