UBATALUNO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDPONTO int 4 null
CODCOLIGADA DCODCOLIGADA 2 null
EALUNOS.CODCOLIGADA FKUBATALUNO_EALUNOSR
MATALUNO varchar 10 null
EALUNOS.MATRICULA FKUBATALUNO_EALUNOSR
PERLETIVO varchar 6 null
EPERLET.CODPERLET FKUBATALUNO_EPERLETR
DATA datetime 16,3 null
HORA datetime 16,3 null
TIPO varchar 1 null
CATRACA varchar 10 √ null
EIMPAUTCAT.CATRACA Implied ConstraintR
STATUS varchar 1 √ null
USUARIO varchar 20 √ null
DTALTERACAO datetime 16,3 √ null
OBS varchar 100 √ null
IDLOGIMP int 4 √ null
ULOGIMPCATRACA.IDLOGIMP FKUBATALUNO_ULOGIMPCATRACAR
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)
PKUBATALUNO Primary key Asc IDPONTO
UXBATALUNODATA Performance Asc/Asc CODCOLIGADA + DATA
UXBATALUNOMAT Performance Asc/Asc CODCOLIGADA + MATALUNO

Relationships

Close relationships within degrees of separation