SCONCESSAOBOLSA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SCONCESSAOBOLSACOMPL.CODCOLIGADA FKSCONCESSAOBOLSACOMPL_SCONCESR
SCONCESSAOBOLSAHABALUNO.CODCOLIGADA FKSCONCBOLSAHABAL_SCONCBOLSAR
SCONCESSAOBOLSAHABFILIAL.CODCOLIGADA FKSCONCBOLSAHABFILIAL_SCONCBOLR
SCONCESSAOBOLSASERVICO.CODCOLIGADA FKSCONCBOLSASERV_SCONCBOLSAR
SALUNO.CODCOLIGADA FKSCONCESSAOBOLSA_SALUNOR
SBOLSA.CODCOLIGADA FKSCONCESSAOBOLSA_SBOLSAR
RA varchar 20 null
SALUNO.RA FKSCONCESSAOBOLSA_SALUNOR
CODBOLSA varchar 10 null
SBOLSA.CODBOLSA FKSCONCESSAOBOLSA_SBOLSAR
DTINICIO datetime 16,3 √ null
DTFIM datetime 16,3 √ null
DESCONTO RMDVALOR4 17,4 √ null
TIPODESC varchar 1 √ null
OBS MEMO 2147483647 √ null
ORDEMBOLSA int 4 √ null
PARCELAINICIAL int 4 √ null
PARCELAFINAL int 4 √ null
INSEREBOLSA varchar 1 √ null
TODOSSERVICOS varchar 1 √ null
CODUSUARIO varchar 20 √ null
GUSUARIO.CODUSUARIO FKSCONCESSAOBOLSA_GUSUARIOR
DATACONCESSAO DDATE 16,3 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDCONCESSAOBOLSA int 4 null
SCONCESSAOBOLSACOMPL.IDCONCESSAOBOLSA FKSCONCESSAOBOLSACOMPL_SCONCESR
SCONCESSAOBOLSAHABALUNO.IDCONCESSAOBOLSA FKSCONCBOLSAHABAL_SCONCBOLSAR
SCONCESSAOBOLSAHABFILIAL.IDCONCESSAOBOLSA FKSCONCBOLSAHABFILIAL_SCONCBOLR
SCONCESSAOBOLSASERVICO.IDCONCESSAOBOLSA FKSCONCBOLSASERV_SCONCBOLSAR
ORDEMAPLICDESCANTECIPACAO varchar 1 √ ('A')
AFETABASECALCULO varchar 1 √ ('N')

Indexes

Constraint Name Type Sort Column(s)
PKSCONCESSAOBOLSA Primary key Asc/Asc CODCOLIGADA + IDCONCESSAOBOLSA
SXSCONCESSAOBOLSA Performance Asc/Asc/Asc CODCOLIGADA + RA + CODBOLSA

Relationships

Close relationships within degrees of separation