SCONTRATOSERVICO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SSERVICO.CODCOLIGADA FKSCONTRATOSERVICO_SSERVICOR
SCONTRATO.CODCOLIGADA FKSCONTRATOSERVICO_SCONTRATOR
RA varchar 20 null
SCONTRATO.RA FKSCONTRATOSERVICO_SCONTRATOR
CODCONTRATO varchar 20 null
SCONTRATO.CODCONTRATO FKSCONTRATOSERVICO_SCONTRATOR
IDPERLET int 4 null
SCONTRATO.IDPERLET FKSCONTRATOSERVICO_SCONTRATOR
CODSERVICO varchar 10 null
SSERVICO.CODSERVICO FKSCONTRATOSERVICO_SSERVICOR
VALOR RMDVALOR4 17,4 null
DESCONTO RMDVALOR4 17,4 √ 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)
PKSCONTRATOSERVICO Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + RA + CODCONTRATO + IDPERLET + CODSERVICO
IXSCONTRATOSERVICO Performance Asc/Asc/Asc/Asc CODCOLIGADA + RA + CODCONTRATO + IDPERLET

Relationships

Close relationships within degrees of separation