OFOBJINSTAL

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
OFOBJOFICINA.CODCOLIGADA FKOFOBJINSTAL_OFOBJOFICINAR
IDINSTAL int 4 null
CODCOLIGADACFO DCODCOLIGADANULL 2 √ null
OFOBJLOCAL.CODCOLIGADA FKOFOBJINSTAL_OFOBJLOCALR
FCFO.CODCOLIGADA FKOFOBJINSTAL_FCFOR
CODCFO varchar 25 √ null
FCFO.CODCFO FKOFOBJINSTAL_FCFOR
OFOBJLOCAL.CODCFO FKOFOBJINSTAL_OFOBJLOCALR
IDLOCAL int 4 √ null
OFOBJLOCAL.IDLOCAL FKOFOBJINSTAL_OFOBJLOCALR
CODCOLIGADAOBJ DCODCOLIGADA 2 null
IDOBJOF varchar 20 null
OFOBJOFICINA.IDOBJOF FKOFOBJINSTAL_OFOBJOFICINAR
IDVENDEDOR int 4 √ null
PPESSOA.CODIGO FKOFOBJINSTAL_PPESSOAVENDR
IDTECNICO int 4 √ null
PPESSOA.CODIGO FKOFOBJINSTAL_PPESSOATECR
DATASISTEMA datetime 16,3 √ null
DATAINSTALACAO datetime 16,3 √ null
EXCLUIDO DLOGICO 2 null
HISTORICO varchar 255 √ 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)
PKOFOBJINSTAL Primary key Asc/Asc CODCOLIGADA + IDINSTAL
OXOFOBJINSTAL Performance Asc/Asc CODCOLIGADAOBJ + IDOBJOF

Relationships

Close relationships within degrees of separation