BOPCAOVERSAO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA smallint 2 null
BHISTRESPPROVA.CODCOLIGADA FKBHISTRESPPROVA_BOPCAOVERSAOR
BREVISAO.CODCOLIGADA FKBOPCAOVERSAO_BREVISAOR
BQUESTAOVERSAO.CODCOLIGADA FKBOPCAOVERSAO_BQUESTAOVERSAOR
IDOPCVERSAO int 4 null
BHISTRESPPROVA.IDOPCVERSAO FKBHISTRESPPROVA_BOPCAOVERSAOR
IDQUESTVERSAO int 4 null
BQUESTAOVERSAO.IDQUESTVERSAO FKBOPCAOVERSAO_BQUESTAOVERSAOR
IDREVISAO int 4 null
BREVISAO.IDREVISAO FKBOPCAOVERSAO_BREVISAOR
CODAREA varchar 16 null
CODMATERIA varchar 16 null
CODQUESTAO varchar 16 null
CODOPCAO varchar 16 null
INDCORRETA varchar 1 √ null
PERCPESO numeric 17,4 √ null
TEXTOOPCAO text 2147483647 √ null
CODIDIOMA int 4 √ null
VIDIOMA.CODIDIOMA Implied ConstraintR
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)
PKBOPCAOVERSAO Primary key Asc/Asc CODCOLIGADA + IDOPCVERSAO
U_BOPCAOVERSAOID Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDREVISAO + CODAREA + CODMATERIA + CODQUESTAO + CODOPCAO + CODIDIOMA

Relationships

Close relationships within degrees of separation