CCONT

1205 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CCONTRAT.CODCOLIGADA FKCCONTRAT_CCONTR
CPARTIDA.CODCOLIGADA FKCCONT_CPARTIDAR
COPERACAO.CODCOLIGADA FKCCONT_COPERACAOR
IDCONT int 4 null
CCONTRAT.IDCONT FKCCONTRAT_CCONTR
IDOPERACAO int 4 null
COPERACAO.IDOPERACAO FKCCONT_COPERACAOR
IDPARTIDA int 4 null
CPARTIDA.IDPARTIDA FKCCONT_CPARTIDAR
VALOR RMDVALOR2 17,2 √ null
STATUS varchar 3 √ null
TIPO smallint 2 √ null
TCODIGO.TIPO Implied ConstraintR
VALOR2 RMDVALOR4 17,4 √ null
IDESTORNOCONT int 4 √ null
IDGRUPOCONT int 4 √ null
VERSAOANTERIOR bit 1 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DOCUMENTO_AGP varchar 20 √ null
COMPLEMENTO_AGP varchar 250 √ null

Indexes

Constraint Name Type Sort Column(s)
PKCCONT Primary key Asc/Asc CODCOLIGADA + IDCONT
CXCONTOPERACAO Performance Asc/Asc IDOPERACAO + CODCOLIGADA
CXCONTPARTIDA Performance Asc/Asc IDPARTIDA + CODCOLIGADA
CXESTORNOCONT Performance Asc/Asc CODCOLIGADA + IDESTORNOCONT
CXIDPARTIDA_CCONT Performance Asc/Asc CODCOLIGADA + IDPARTIDA

Check Constraints

Constraint Name Constraint
CK__CCONT__STATUS__044B2D68 ([STATUS]='C' OR [STATUS]='I' OR [STATUS]='E')
CK__CCONT__TIPO__053F51A1 ([TIPO]=(1) OR [TIPO]=(2) OR [TIPO]=(3))

Relationships

Close relationships within degrees of separation