limitecredito


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlimitecredito int8 19 null
limitecredito_aud.idlimitecredito Implied Constraint R
limitecreditomovimento.idlimitecredito fk_iph3lhbj4buru2tre0i7797go R
limitecreditomovimento_aud.idlimitecredito Implied Constraint R
idsegmento int8 19 √ null
segmento.idsegmento fk_epj3xb01xrsr2t1k07sbc6f0l R
datainiciovigencia date 13 null
datafimvigencia date 13 null
saldolimite numeric 18,6 √ null
saldodisponivel numeric 18,6 √ null
idparceiro int8 19 null
parceiro.idparceiro fk_komwbdseow2iaxaunblkevq3k R
idlocal int8 19 √ null
local.idlocal fk_a8o9vh89b7oslw2tiob4tm4yd R
idlocalfilial int8 19 √ null
local.idlocal fk_eu1jvjwrut2uls7gpc6x6112c R
idusuario int8 19 √ null
usuario.idusuario fk_4bj66ywpcd6m37um9ud8y9ndc R
idtipolimitecredito int8 19 √ null
tipolimitecredito.idtipolimitecredito fk_mr5xw901ppqn3jis7bewq00ox R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 7198 rows

Indexes

Constraint Name Type Sort Column(s)
pk59a3910c Primary key Asc idlimitecredito
idx609e881a Performance Asc idtipolimitecredito
idx73e047ab Performance Asc idsegmento
idx8a91f49a Performance Asc idlocal
idxa0fee487 Performance Asc idlocalfilial
idxb3594eb9 Performance Asc idusuario
idxce1503ff Performance Asc idparceiro
idxwsversao_59a3910c Performance Desc wsversao
uc2b8f6e50 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.