tiponotafiscal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idtiponotafiscal int8 19 null
cfop.idtiponotafiscal fk_rtxib64jooln1gbs5q1eskywy R
cfop_aud.idtiponotafiscal Implied Constraint R
metricanftipo.idtiponotafiscal fk_6ltty6575rmi6x262he9j4o1q R
metricanftipo_aud.idtiponotafiscal Implied Constraint R
notafiscal.idtiponotafiscal fk_2gkldkdjm1ovuvd1g8a56iot9 R
notafiscal_aud.idtiponotafiscal Implied Constraint R
notafiscalproduto.idtiponotafiscal fk_efashpeqs2qd9eqn8oudufsty R
notafiscalproduto_aud.idtiponotafiscal Implied Constraint R
tiponotafiscal_aud.idtiponotafiscal Implied Constraint R
transacaofiscal.idtiponotafiscal fk_i0yuvwq3t6u02a02c6px2gfaf R
transacaofiscal_aud.idtiponotafiscal Implied Constraint R
idnativo int2 5 null
descricao varchar 80 null
sgltiponotafiscal varchar 10 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk3027b5c0 Primary key Asc idtiponotafiscal
idxwsversao_3027b5c0 Performance Desc wsversao
uc3b70401a Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation