EMODCONTR

37 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODPERLET varchar 6 null
EGRUPOMOD.CODPERLET FKEGRUPOMOD_EMODCONTRR
EMODCONPC.CODPERLET FKEMODCONPC_EMODCONTRR
EPLANOSWEB.CODPERLET FKEPLANOSWEB_EMODCONTRR
UGRUPOMOD.CODPERLET FKUGRUPOMOD_EMODCONTRR
EPERLET.CODPERLET FKEMODCONTR_EPERLETR
CODMOD varchar 10 null
EGRUPOMOD.MODCONT FKEGRUPOMOD_EMODCONTRR
EMODCONPC.MODELO FKEMODCONPC_EMODCONTRR
EPLANOSWEB.CODMOD FKEPLANOSWEB_EMODCONTRR
UGRUPOMOD.MODCONT FKUGRUPOMOD_EMODCONTRR
DESCRICAO MEMO 2147483647 √ null
VALORTOTAL RMDVALOR2 17,2 √ null
NPARCELAS int 4 √ null
CONTRATO MEMO 2147483647 √ null
RECIBONASS MEMO 2147483647 √ null
RECIBOASS MEMO 2147483647 √ null
IMPREC int 4 √ null
IMPCONT int 4 √ null
VALORDESC RMDVALOR2 17,2 √ null
PERCDESC RMDVALOR4 17,4 √ null
VALIDADE_INI datetime 16,3 √ null
VALIDADE_FIM datetime 16,3 √ null
NCOTAS int 4 √ null
NSERVICOS int 4 √ null
AGRUPARSERVICOS varchar 1 √ null
CODBOL int 4 √ null
ETIPOBOLS.CODBOLSA FKEMODCONTR_ETIPOBOLSR
AUTOMATICO varchar 1 √ null
RELCONTRATO varchar 6 √ null
RELRECIBONASS varchar 6 √ null
RELRECIBOASS varchar 6 √ null
USAPACPLAN varchar 1 √ 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)
PKEMODCONTR Primary key Asc/Asc CODPERLET + CODMOD
MODELO Performance Asc CODMOD

Relationships

Close relationships within degrees of separation