CTAREFA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKCTAREFA_GCOLIGADAR
IDTAREFA int 4 null
IDTIPOTAREFA int 4 null
CODUSUARIOSOLICITANTE varchar 20 null
GUSUARIO.CODUSUARIO FKCTAREFA_GUSUARIOR
CODUSUARIOEXECUTOR varchar 20 √ null
GUSUARIO.CODUSUARIO FKCTAREFA_GUSUARIOEXECR
STATUS int 4 null
DATASOLICITACAO DDATE 16,3 null
DATAPROCESSAMENTO DDATE 16,3 √ null
OBSERVACAOPROCESSAMENTO MEMO 2147483647 √ null
ORIGEM varchar 3 null
PARAMS MEMO 2147483647 null
MOTIVOSOLICITACAO MEMO 2147483647 null
LOGEXECUCAO MEMO 2147483647 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKCTAREFA Primary key Asc/Asc/Asc CODCOLIGADA + IDTAREFA + IDTIPOTAREFA

Relationships

Close relationships within degrees of separation