DAIDF

53 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DDISPOSITIVOEXTRAVIADO.CODCOLIGADA FKDDISPOSITIVOEXTRAVIADO_DAIDFR
DITMAIDF.CODCOLIGADA FKDITMAIDF_DAIDFR
DLAF.CODCOLIGADA FKDLAF_DAIDFR
DLAFHISTORICO.CODCOLIGADA FKDLAFHISTORICO_DAIDFR
TMOV.CODCOLIGADA FKTMOV_DAIDFR
GFILIAL.CODCOLIGADA FKDAIDF_GILIALR
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKDAIDF_GILIALR
IDAIDF smallint 2 null
DDISPOSITIVOEXTRAVIADO.IDAIDF FKDDISPOSITIVOEXTRAVIADO_DAIDFR
DITMAIDF.IDAIDF FKDITMAIDF_DAIDFR
DLAF.IDAIDF FKDLAF_DAIDFR
DLAFHISTORICO.IDAIDF FKDLAFHISTORICO_DAIDFR
TMOV.IDAIDF FKTMOV_DAIDFR
TIPODISPOSITIVO varchar 2 √ null
NROAIDF varchar 30 √ null
DATAAUTORIZACAO datetime 16,3 √ null
ORGAORESPONSAVEL smallint 2 null
CODCOLCFO smallint 2 √ null
FCFO.CODCOLIGADA FKDAIDF_FCFOR
CODCFO varchar 25 √ null
FCFO.CODCFO FKDAIDF_FCFOR
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)
PKDAIDF Primary key Asc/Asc CODCOLIGADA + IDAIDF
DXDAIDF Must be unique Asc/Asc/Asc/Asc CODCOLIGADA + CODFILIAL + NROAIDF + ORGAORESPONSAVEL

Relationships

Close relationships within degrees of separation