SCOMPLDISC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SCOMPLDISCPUBLIC.CODCOLIGADA FKSCOMPLDISCPUBLIC_SCOMPLDISCR
STIPOCOMPLEMENTODISC.CODCOLIGADA FKSCOMPLDISC_STIPOCOMPLDISCR
SITINERARIOFORMATIVO.CODCOLIGADA FKSCOMPLDISC_SITINERARIOFORMAR
SDISCIPLINA.CODCOLIGADA FKSCOMPLDISC_SDISCIPLINAR
SPLETIVO.CODCOLIGADA FKSCOMPLDISC_SPLETIVOR
CODDISC varchar 20 null
SCOMPLDISCPUBLIC.CODDISC FKSCOMPLDISCPUBLIC_SCOMPLDISCR
SDISCIPLINA.CODDISC FKSCOMPLDISC_SDISCIPLINAR
IDCOMPLDISC int 4 null
SCOMPLDISCPUBLIC.IDCOMPLDISC FKSCOMPLDISCPUBLIC_SCOMPLDISCR
DATA datetime 16,3 null
TIPO varchar 2 √ null
STIPOCOMPLEMENTODISC.CODCOMPLEMENTO FKSCOMPLDISC_STIPOCOMPLDISCR
AULA varchar 10 √ null
DESCRICAO MEMO 2147483647 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DISPONIVELALUNOS varchar 1 √ null
IDPERLET int 4 √ null
SPLETIVO.IDPERLET FKSCOMPLDISC_SPLETIVOR
CODITINERARIOFORMATIVO int 4 √ null
SITINERARIOFORMATIVO.CODITINERARIOFORMATIVO FKSCOMPLDISC_SITINERARIOFORMAR

Indexes

Constraint Name Type Sort Column(s)
PKSCOMPLDISC Primary key Asc/Asc/Asc CODCOLIGADA + CODDISC + IDCOMPLDISC

Relationships

Close relationships within degrees of separation