TCTEMOV

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TCTE.CODCOLIGADA FKTCTE_TCTEMOVR
TCTEAQUAVIARIO.CODCOLIGADA FKTCTEAQUAVIARIO_TCTEMOVR
TCTEBALSA.CODCOLIGADA FKTCTEBALSA_TCTEMOVR
TCTECARGAPERIGOSA.CODCOLIGADA FKTCTECARGAPERIGOSA_TCTEMOVR
TCTEEMISSOR.CODCOLIGADA FKTCTEEMISSOR_TCTEMOVR
TCTEFLUXOCARGA.CODCOLIGADA FKTCTEFLUXOCARGA_TCTEMOVR
TCTEMOTORISTA.CODCOLIGADA FKTCTEMOTORISTA_TCTEMOVR
TCTEOS.CODCOLIGADA FKTCTEOS_TCTEMOVR
TCTEPRODPREDOMINANTE.CODCOLIGADA FK_TPRODUTOPREDOMINANTE_TCTEMOR
TMDFEINFPAGAMENTOFRETE.CODCOLIGADA FKTMDFEINFPAGAMENTOFRETE_TCTER
TMOV.CODCOLIGADA FKTCTEMOV_TMOVR
IDMOV int 4 null
TMOV.IDMOV FKTCTEMOV_TMOVR
IDCTE int 4 null
TCTE.IDCTE FKTCTE_TCTEMOVR
TCTEAQUAVIARIO.IDCTE FKTCTEAQUAVIARIO_TCTEMOVR
TCTEBALSA.IDCTE FKTCTEBALSA_TCTEMOVR
TCTECARGAPERIGOSA.IDCTE FKTCTECARGAPERIGOSA_TCTEMOVR
TCTEEMISSOR.IDCTE FKTCTEEMISSOR_TCTEMOVR
TCTEFLUXOCARGA.IDCTE FKTCTEFLUXOCARGA_TCTEMOVR
TCTEMOTORISTA.IDCTE FKTCTEMOTORISTA_TCTEMOVR
TCTEOS.IDCTE FKTCTEOS_TCTEMOVR
TCTEPRODPREDOMINANTE.IDCTE FK_TPRODUTOPREDOMINANTE_TCTEMOR
TMDFEINFPAGAMENTOFRETE.IDCTE FKTMDFEINFPAGAMENTOFRETE_TCTER
TIPO varchar 1 √ 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)
PKTCTEMOV Primary key Asc/Asc CODCOLIGADA + IDCTE

Relationships

Close relationships within degrees of separation