OFPROPOSTA

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
OFPROPOSTACOMPL.CODCOLIGADA OFPROPOSTACOMPL_OFPROPOSTAR
IDPROPOSTA int 4 null
OFPROPOSTACOMPL.IDPROPOSTA OFPROPOSTACOMPL_OFPROPOSTAR
NOME varchar 100 √ null
EPLANILHASEXP.NOME Implied ConstraintR
CODCOLIGADACFO DCODCOLIGADA 2 null
CODCFO varchar 25 null
DATA datetime 16,3 √ null
STATUS char 1 √ null
CHAPA DCHAPA 16 null
DESCRICAO MEMO 2147483647 √ null
VALIDADE datetime 16,3 √ null
VALOR RMDVALOR2 17,2 √ null
CAMPOLIVREC1 varchar 60 √ null
CAMPOLIVREC2 varchar 60 √ null
CAMPOLIVREN1 RMDVALOR4 17,4 √ null
CAMPOLIVREN2 RMDVALOR4 17,4 √ 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)
PKOFPROPOSTA Primary key Asc/Asc CODCOLIGADA + IDPROPOSTA

Relationships

Close relationships within degrees of separation