EPERLET

20 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODPERLET varchar 6 null
EALTNOTA.CODPERLET Implied ConstraintR
EALUATIV.PERLETIVO FKEALUATIV_EPERLETR
EALUBOLSA.PERLETIVO FKEALUBOLSA_EPERLETR
EALUDOC.PERLETIVO FKEALUDOC_EPERLETR
EALUMATER.PERLETIVO FKEALUMATER_EPERLETR
EALUOCOR.CODPERLET FKEALUOCOR_EPERLETR
EALUPONTO.PERLETIVO FKEALUPONTO_EPERLETR
EALUSERV.PERLETIVO FKEALUSERV_EPERLETR
ECFPERLET.CODPERLET FKECFPERLET_EPERLETR
ECURPERLET.CODPERLET FKECURPERLET_EPERLETR
EDISPPROF.CODPERLET FKEDISPPROF_EPERLETR
EETAPAS.CODPERLET FKEETAPAS_EPERLETR
EGRADE.CODPERLET FKEGRADE_EPERLETR
ELRENTMAT.CODPERLET Implied ConstraintR
EMODCONTR.CODPERLET FKEMODCONTR_EPERLETR
EMOVMATRI.CODPERLET FKEMOVMATRI_EPERLETR
EPARAMGLB.CODPERLET Implied ConstraintR
EPARCELAPORDATA.CODPERLET FKEPARCELAPORDATA_EPERLETR
EPLANILHASEXP.CODPERLET FKEPLANILHASEXP_EPERLETR
EPONTOAL.PERLETIVO FKEPONTOAL_EPERLETR
EPONTOALAM.PERLETIVO FKEPONTOALAM_EPERLETR
EREMATRIC.CODPERLET FKEREMATRIC_EPERLETR
ESRVEVENT.PERLETIVO FKESRVEVENT_EPERLETR
ETURMISTA.CODPERLET FKETURMISTA_EPERLETR
LPARCELAPORDATA.CODPERLET FKLPARCELAPORDATA_EPERLETR
NENQUETEETURMA_TEMP1000.CODPERLET Implied ConstraintR
UATVCOMPALUNO.CODPERLET FKUATVCOMPALUNO_EPERLETR
UBATALUNO.PERLETIVO FKUBATALUNO_EPERLETR
UETAPAS.CODPERLET FKUETAPASEPERLETR
UMATRICPL.PERLETIVO FKUMATRICPL_EPERLETR
UMATTURMA.CODPERLET FKUMATTURMA_EPERLETR
UPROCSEL.PERLETIVO FKUPROCSEL_EPERLETR
USERVPER.PERLETIVO FKUSERVPER_EPERLETR
NOMEPERLET varchar 20 √ null
SABELETIVO varchar 1 √ null
NUMDIAS int 4 √ null
CARGAHOR RMDVALOR2 17,2 √ null
OBS MEMO 2147483647 √ null
DATAEMISHIST datetime 16,3 √ null
DTINICIO datetime 16,3 √ null
DTFIM datetime 16,3 √ null
DTPREVFIM datetime 16,3 √ null
SITUACAO varchar 1 √ null
DTALT datetime 16,3 √ null
HRALT datetime 16,3 √ null
USUARIO varchar 20 √ null
TIPOETAPA varchar 1 √ null
CALENDARIO varchar 16 √ null
DATALIMNUMAUTO datetime 16,3 √ null
DTLIMITEMATRICULA datetime 16,3 √ null
ENCERRADOPGTO varchar 1 √ null
DTLIMITETRANCAMENTO 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)
PKEPERLET Primary key Asc CODPERLET

Relationships

Close relationships within degrees of separation