OFOBJLOCAL

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
OFOBJINSTAL.CODCOLIGADACFO FKOFOBJINSTAL_OFOBJLOCALR
FCFO.CODCOLIGADA FKOFOBJLOCAL_FCFOR
CODCFO varchar 25 null
OFOBJINSTAL.CODCFO FKOFOBJINSTAL_OFOBJLOCALR
FCFO.CODCFO FKOFOBJLOCAL_FCFOR
IDLOCAL int 4 null
OFOBJINSTAL.IDLOCAL FKOFOBJINSTAL_OFOBJLOCALR
DESCRICAO varchar 60 null
RUA varchar 100 √ null
NUMERO varchar 8 √ null
COMPLEMENTO DCOMPLEMENTO 60 √ null
BAIRRO DBAIRRO 80 √ null
CIDADE DCIDADE 32 √ null
CODETD varchar 2 √ null
GETD.CODETD Implied ConstraintR
CEP DCEP 9 √ null
TELEFONE varchar 15 √ null
CONTATO varchar 30 √ null
OBSERVACAO text 2147483647 √ 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)
PKOFOBJLOCAL Primary key Asc/Asc/Asc CODCOLIGADA + CODCFO + IDLOCAL

Relationships

Close relationships within degrees of separation