DCARTA

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DITEMCARTA.CODCOLIGADA FKDITEMCARTA_DCARTAR
DLAFAGRUPHISTORICO.CODCOLIGADA FKDCARTA_DLAFAGRUPHISTORICOR
GCOLIGADA.CODCOLIGADA FKDCARTA_GCOLIGADAR
GFILIAL.CODCOLIGADA FKDCARTA_GFILIALR
DLAFAGRUP.CODCOLIGADA FKDCARTA_DLAFAGRUPR
IDCARTA int 4 null
DITEMCARTA.IDCARTA FKDITEMCARTA_DCARTAR
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKDCARTA_GFILIALR
IDLAF int 4 √ null
NROCARTA varchar 10 √ null
DATAEMISSAO datetime 16,3 √ null
OBSERVACAO varchar 200 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDLAFAGRUP int 4 √ null
DLAFAGRUP.IDLAFAGRUP FKDCARTA_DLAFAGRUPR
IDLAFAGRUPHIST int 4 √ null
DLAFAGRUPHISTORICO.IDLAFAGRUP FKDCARTA_DLAFAGRUPHISTORICOR

Indexes

Constraint Name Type Sort Column(s)
PKDCARTA Primary key Asc/Asc CODCOLIGADA + IDCARTA

Relationships

Close relationships within degrees of separation