SCONTRATOCONT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SCONTRATOBOLSACONT.CODCOLIGADA FKSCONTRATOBOLSACONT_SCTRCONTR
SCONTRATOBOLSACONTCOMPETENCIA.CODCOLIGADA FKSCONTRATOBOLSACONTCOMPETENCR
SCONTRATOLOGCONT.CODCOLIGADA FKSCONTRATOLOGCONT_SCONTRATOCR
SCONTRATOSERVICOCONT.CODCOLIGADA FKSCONTRATOSERVICOCONT_SCONTRAR
COPERACAO.CODCOLIGADA FKSCONTRATOCONT_COPERACAOR
SCONTRATO.CODCOLIGADA FKSCONTRATOCONT_SCONTRATOR
IDCONTRATOCONT int 4 null
SCONTRATOBOLSACONT.IDCONTRATOCONT FKSCONTRATOBOLSACONT_SCTRCONTR
SCONTRATOBOLSACONTCOMPETENCIA.IDCONTRATOCONT FKSCONTRATOBOLSACONTCOMPETENCR
SCONTRATOLOGCONT.IDCONTRATOCONT FKSCONTRATOLOGCONT_SCONTRATOCR
SCONTRATOSERVICOCONT.IDCONTRATOCONT FKSCONTRATOSERVICOCONT_SCONTRAR
CODCONTRATO varchar 20 null
SCONTRATO.CODCONTRATO FKSCONTRATOCONT_SCONTRATOR
IDPERLET int 4 null
SCONTRATO.IDPERLET FKSCONTRATOCONT_SCONTRATOR
RA varchar 20 null
SCONTRATO.RA FKSCONTRATOCONT_SCONTRATOR
ORIGEM varchar 1 null
STATUSCONT varchar 1 null
IDOPERACAO int 4 √ null
COPERACAO.IDOPERACAO FKSCONTRATOCONT_COPERACAOR
VALORSERVICO RMDVALOR4 17,4 null
DESCONTO RMDVALOR4 17,4 √ null
VALORBOLSA RMDVALOR4 17,4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
MESANO DDATETIME 16,3 √ null
NOVOMODELO varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSCONTRATOCONT Primary key Asc/Asc CODCOLIGADA + IDCONTRATOCONT
IDX_SCONTRATOCONT Performance Asc/Asc/Asc/Asc CODCOLIGADA + RA + CODCONTRATO + IDPERLET
IXSCONTRATOCONTIDOP Performance Asc/Asc CODCOLIGADA + IDOPERACAO

Relationships

Close relationships within degrees of separation