TPRDCFOCOLAB

59 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TUNDPRDCFOCOLAB.CODCOLPRD FKTUNDPRDCFOCOLAB_TPRDCFOCOLABR
IDPRD int 4 null
TUNDPRDCFOCOLAB.IDPRD FKTUNDPRDCFOCOLAB_TPRDCFOCOLABR
TPRODUTO.IDPRD FKTPRDCFOCOLAB_TPRODUTOR
CODCOLCFO DCODCOLIGADA 2 null
TUNDPRDCFOCOLAB.CODCOLCFO FKTUNDPRDCFOCOLAB_TPRDCFOCOLABR
FCFO.CODCOLIGADA FKTPRDCFOCOLAB_FCFOR
CODCFO varchar 25 null
TUNDPRDCFOCOLAB.CODCFO FKTUNDPRDCFOCOLAB_TPRDCFOCOLABR
FCFO.CODCFO FKTPRDCFOCOLAB_FCFOR
CODPRDFORNECEDOR varchar 60 null
TUNDPRDCFOCOLAB.CODPRDFORNECEDOR FKTUNDPRDCFOCOLAB_TPRDCFOCOLABR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DATACONTROLE datetime 16,3 √ null
XCONTROLELICENCASAPP.DATACONTROLE Implied ConstraintR

Indexes

Constraint Name Type Sort Column(s)
PKTPRDCFOCOLAB Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDPRD + CODCOLCFO + CODCFO + CODPRDFORNECEDOR

Relationships

Close relationships within degrees of separation