SCOMPLDISCPUBLIC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
LPUBLIC.CODCOLIGADA FKSCOMPLDISCPUBLIC_LPUBLICR
SCOMPLDISC.CODCOLIGADA FKSCOMPLDISCPUBLIC_SCOMPLDISCR
SPROFESSOR.CODCOLIGADA FKSCOMPLDISCPUBLIC_SPROFESSORR
CODDISC varchar 20 null
SCOMPLDISC.CODDISC FKSCOMPLDISCPUBLIC_SCOMPLDISCR
IDCOMPLDISC int 4 null
SCOMPLDISC.IDCOMPLDISC FKSCOMPLDISCPUBLIC_SCOMPLDISCR
CODPUBLIC int 4 null
LPUBLIC.CODIGO FKSCOMPLDISCPUBLIC_LPUBLICR
CODPROF varchar 10 √ null
SPROFESSOR.CODPROF FKSCOMPLDISCPUBLIC_SPROFESSORR
DATAVINCULACAO DDATETIME 16,3 √ null
QTDEXEMPLARES int 4 √ null
QTDEXEMPLARESVINC int 4 √ 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)
PKSCOMPLDISCPUBLIC Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODDISC + IDCOMPLDISC + CODPUBLIC

Relationships

Close relationships within degrees of separation