SPARCELACONT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SCONTRATOLOGCONT.CODCOLIGADA FKSCONTRATOLOGCONT_SPARCELACOR
SPARCELABOLSACONT.CODCOLIGADA FKSPARCBOLSACONT_SPARCELACONTR
SPARCELASERVICOCONT.CODCOLIGADA FKSPARCELASERVCONT_SPARCELCONTR
COPERACAO.CODCOLIGADA FKSPARCELACONT_COPERACAOR
SCONTRATO.CODCOLIGADA FKSPARCELACONT_SCONTRATOR
IDPARCELACONT int 4 null
SCONTRATOLOGCONT.IDPARCELACONT FKSCONTRATOLOGCONT_SPARCELACOR
SPARCELABOLSACONT.IDPARCELACONT FKSPARCBOLSACONT_SPARCELACONTR
SPARCELASERVICOCONT.IDPARCELACONT FKSPARCELASERVCONT_SPARCELCONTR
RA varchar 20 √ null
SCONTRATO.RA FKSPARCELACONT_SCONTRATOR
CODCONTRATO varchar 20 √ null
SCONTRATO.CODCONTRATO FKSPARCELACONT_SCONTRATOR
IDPERLET int 4 √ null
SCONTRATO.IDPERLET FKSPARCELACONT_SCONTRATOR
MESANO datetime 16,3 null
IDOPERACAO int 4 √ null
COPERACAO.IDOPERACAO FKSPARCELACONT_COPERACAOR
VALORSERVICO RMDVALOR4 17,4 null
DESCONTO RMDVALOR4 17,4 √ null
VALORBOLSA RMDVALOR4 17,4 √ null
STATUSCONT varchar 1 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
ORIGEM varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSPARCELACONT Primary key Asc/Asc CODCOLIGADA + IDPARCELACONT
IDX_SPARCELACONT Performance Asc/Asc/Asc/Asc CODCOLIGADA + RA + CODCONTRATO + IDPERLET
IDX_SPARCELACONT_COPERACAO Performance Asc/Asc CODCOLIGADA + IDOPERACAO

Relationships

Close relationships within degrees of separation