TINVENTARIO

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TITMINVENTARIO.CODCOLIGADA FKTITMINVENTARIO_TINVENTARIOR
GCOLIGADA.CODCOLIGADA FKTINVENTARIO_GCOLIGADAR
CODINVENTARIO varchar 15 null
TITMINVENTARIO.CODINVENTARIO FKTITMINVENTARIO_TINVENTARIOR
DATABASEINVENTARIO DDATE 16,3 null
STATUS varchar 1 null
DATASTATUS DDATE 16,3 null
CODUSUARIO varchar 20 null
OBSERVACAO varchar 255 √ null
BLOQUEIAMOV DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
TIPOSALDO smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TIPOINVENTARIO int 4 √ null
TIPOCONTAGEM int 4 ((0))

Indexes

Constraint Name Type Sort Column(s)
PKTINVENTARIO Primary key Asc/Asc CODCOLIGADA + CODINVENTARIO

Relationships

Close relationships within degrees of separation