SCONTRATOBOLSACONTCOMPETENCIA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODBOLSA varchar 10 null
QTDMESESCOMPETENCIA int 4 null
ORIGEM varchar 1 null
MESANOBASE datetime 16,3 √ null
IDCONTRATOCONT int 4 null
SCONTRATOCONT.IDCONTRATOCONT FKSCONTRATOBOLSACONTCOMPETENCR
PARCELAFINAL int 4 √ null
IDBOLSACONTCOMPETENCIA int 4 null
SPARCELABOLSASERVICOCONT.IDBOLSACONTCOMPETENCIA FKBOLSERVCONT_BOLCONTCOMPTR
CODCOLIGADA DCODCOLIGADA 2 null
SPARCELABOLSASERVICOCONT.CODCOLIGADA FKBOLSERVCONT_BOLCONTCOMPTR
SCONTRATOCONT.CODCOLIGADA FKSCONTRATOBOLSACONTCOMPETENCR
DTINICIO datetime 16,3 √ null
VALOR RMDVALOR4 17,4 null
DTFIM datetime 16,3 √ null
DTCOMPFINALBOLSA datetime 16,3 √ null
PARCELAINICIAL int 4 √ null
CODSERVICO varchar 10 null
DTCOMPINICIALBOLSA datetime 16,3 √ 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)
PKSCONTRATOBOLSACONTCOMPETENC Primary key Asc/Asc CODCOLIGADA + IDBOLSACONTCOMPETENCIA
IXIDCONTRATOCONT Performance Asc/Asc CODCOLIGADA + IDCONTRATOCONT

Relationships

Close relationships within degrees of separation