registroponto


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idregistroponto int8 19 null
registroponto_aud.idregistroponto Implied Constraint R
idusuario int8 19 null
usuario.idusuario fk_scixj19js8okcgojtrjus0y0x R
idpontogps int8 19 √ null
pontogps.idpontogps fk_3h1rnxiosqhp8rgapwhtyyofk R
idtipojustificativaponto int8 19 √ null
tipojustificativaponto.idtipojustificativaponto fk_7imj0y0xeaowgkho71m2c9130 R
dataregistro date 13 null
horaregistro varchar 8 null
horaregistrooriginal varchar 8 √ null
observacao varchar 4000 √ null
idnausencia int2 5 null
horainicioausencia varchar 8 √ null
horafimausencia varchar 8 √ null
imagem bytea 2147483647 √ null
idndiatodo int2 5 null
idtiporegistroponto int8 19 √ null
tiporegistroponto.idtiporegistroponto fk_54n18tkypv8nd0b4hj9cl3k93 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idnexportadoerp int2 5 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk8683a077 Primary key Asc idregistroponto
idx1d27172 Performance Asc idtiporegistroponto
idx5c060847 Performance Asc idpontogps
idx6182b070 Performance Asc idtipojustificativaponto
idx86fe066a Performance Asc idusuario
idxwsversao_8683a077 Performance Desc wsversao
ucef347cc5 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.