USITMAT

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODSITMAT varchar 2 null
EPARAMGLB.STATUSTRANC FKEPARAMGLB_USITMATR
UALUCURSO.STATUS FKUALUCURSO_USITMATR
UALUCURSO.STATUSANT FKUALUCURSO_USITMAT1R
UHISTMATALUN.STATUS FKUHISTMATALUN_USITMATR
UHISTMATALUNEXT.STATUS FKUHISTMATALUNEXT_USITMATR
UMATALUN.STATUS FKUMATALUN_USITMATR
UMATRICPL.STATUS FKUMATRICPL_USITMATR
DESCRICAO varchar 30 √ null
HISTORICO varchar 1 √ null
BOLETIM varchar 1 √ null
CMAT varchar 1 √ null
CONTCR varchar 1 √ null
ATA varchar 1 √ null
BMP int 4 √ null
INCTUR varchar 1 √ null
MDSTMAT varchar 1 √ null
STATUSMAT varchar 2 √ null
VALIDAPRE varchar 1 √ null
ALUNO varchar 1 √ null
ALUPERLETIVO varchar 1 √ null
DISCIPLINA varchar 1 √ null
CADNOTA varchar 1 √ null
NIVELS smallint 2 √ null
MATRICULA varchar 1 √ null
DISCEMCURSO varchar 1 √ null
PERMITEMATRICPERLET varchar 1 √ null
MODSTATPERLET varchar 1 √ null
NOVOSTATPERLET varchar 2 √ null
MODSTATALUNO varchar 1 √ null
NOVOSTATALUNO varchar 2 √ null
INDICATRANSF varchar 1 √ null
APROVADO varchar 1 √ null
CR varchar 1 √ null
CANCELALANC varchar 1 √ null
REMATRICULA varchar 1 √ null
MDSTANTIGODISC varchar 1 √ null
CONTCRTES varchar 1 √ null
EXIGECONTRATO varchar 1 √ ('N')
CANCELACONTRATO varchar 1 √ ('N')
CONCCURSO varchar 1 √ null
DISPONIVELWEB varchar 1 √ null
NOTASFALTASWEB varchar 1 √ null
LISTAGENSWEB varchar 1 √ null
CURSOATIVO varchar 1 √ ('N')
PERLETATIVO varchar 1 √ ('N')
DESATIVAUSUARIO varchar 1 √ null
CANCUSUARIOBIB BOOLEAN 1 √ null
DIARIO varchar 1 √ ('S')
PERALUINCEXCDISC varchar 1 √ null
PERALUMATRICWEB varchar 1 √ null
ATIVAUSUARIOBIB varchar 1 √ null
CANCUSUARIOCORPORE varchar 1 √ null
PERALUMATRICWEBDEBITOFINAN 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)
PKUSITMAT Primary key Asc CODSITMAT

Relationships

Close relationships within degrees of separation