TTCN

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TCNT.CODCOLIGADA FKTCNT_TTCNR
TTCNWFLUIG.CODCOLIGADA FKTTCNWFLUIG_TTCNR
GCOLIGADA.CODCOLIGADA FKTTCN_GCOLR
TCPG.CODCOLIGADA FKTTCN_TCPGR
CODTCN varchar 5 null
TCNT.CODTCN FKTCNT_TTCNR
TTCNWFLUIG.CODTCN FKTTCNWFLUIG_TTCNR
DESCRICAO varchar 40 √ null
DATAVALIDADE datetime 16,3 √ null
CODCPG varchar 5 √ null
TCPG.CODCPG FKTTCN_TCPGR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
AFETARORCAMENTO smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTTCN Primary key Asc/Asc CODCOLIGADA + CODTCN
TXTCNCOD Performance Asc CODTCN

Relationships

Close relationships within degrees of separation