OFCONTRATO

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MPRJ.CODCOLIGADA FKMPRJ_OFCONTRATOR
OFCONTRATOCOMPL.CODCOLIGADA FKOFCONTRATOCOMPL_OFCONTRATOR
OFOBJCONTRATO.CODCOLIGADA FKOFOBJCONTRATO_OFCONTRATOR
OFORDEMSERVICO.CODCOLIGADA FKOFORDEMSERVICO_OFCONTRATOR
TCNT.CODCOLIGADA FKOFCONTRATO_TCNTR
IDCNTOF int 4 null
MPRJ.IDCNTOF FKMPRJ_OFCONTRATOR
OFCONTRATOCOMPL.IDCNTOF FKOFCONTRATOCOMPL_OFCONTRATOR
OFOBJCONTRATO.IDCNTOF FKOFOBJCONTRATO_OFCONTRATOR
OFORDEMSERVICO.IDCNTOF FKOFORDEMSERVICO_OFCONTRATOR
CODCOLCFO DCODCOLIGADA 2 null
CODCFO varchar 25 null
NUMCNTOF varchar 40 null
DESCRICAO varchar 100 √ null
OBSERVACAO MEMO 2147483647 √ null
STATUS varchar 1 √ null
CODTMV varchar 10 √ null
PERIODICIDADE int 4 √ null
INICIO datetime 16,3 null
FINAL datetime 16,3 null
CAMPOLIVREC1 varchar 60 √ null
CAMPOLIVREC2 varchar 60 √ null
CAMPOLIVREC3 varchar 60 √ null
CAMPOLIVREC4 varchar 60 √ null
CAMPOLIVREC5 varchar 60 √ null
VALOR RMDVALOR4 17,4 √ null
TEMPORESPOSTA int 4 √ null
CONDICOESESPECIAIS MEMO 2147483647 √ null
ABRANGENCIA int 4 √ null
IDCNT int 4 √ null
TCNT.IDCNT FKOFCONTRATO_TCNTR
UTILIZACLICNTNUCLEUS DLOGICO 2 (0)
TERCEIRIZACAO DLOGICO 2 (0)
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)
PKOFCONTRATO Primary key Asc/Asc CODCOLIGADA + IDCNTOF

Relationships

Close relationships within degrees of separation