FTCF

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DCFOP.CODCOLCFO FKDCFOP_FTCFR
FCFO.CODCOLTCF FKFCFO_FTCFR
HPROSPECT.CODCOLIGADATCF FKHPROSPECT_FTCFR
GCOLIGADA.CODCOLIGADA FKFTCF_GCOLIGADAR
CODTCF varchar 25 null
DCFOP.CODTCFO FKDCFOP_FTCFR
FCFO.CODTCF FKFCFO_FTCFR
HPROSPECT.CODTCF FKHPROSPECT_FTCFR
DESCRICAO varchar 40 √ null
CAMPOLIVRE varchar 40 √ null
CODSEGM varchar 5 √ null
TSEGMENTO.CODSEGM FKFTCF_TSEGMENTOR
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)
PKFTCF Primary key Asc/Asc CODCOLIGADA + CODTCF
FXTCFCOD Performance Asc CODTCF
FXTCFDESC Performance Asc DESCRICAO

Relationships

Close relationships within degrees of separation