SubjectAssessmentVELSDomains


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SubjectAssessmentVELSDomainsSeq int identity 4 √ null
SubjectAssessmentVELSDomainDimensions.SubjectAssessmentVELSDomainsSeq FK_SubjectAssessmentVELSDomainDimensions_SubjectAssessmentVELSDomains R
SubjectAssessmentVELSStrandsSeq int 4 null
SubjectAssessmentVELSStrands.SubjectAssessmentVELSStrandsSeq FK_SubjectAssessmentVELSDomains_SubjectAssessmentVELSStrands R
DomainCode varchar 15 √ null
DomainDescription varchar 100 ('')
DomainSummariseFlag bit 1 ((0))
AustralianCurriculumFlag bit 1 ((0))
ActiveFlag bit 1 ((1))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_SubjectAssessmentVELSDomains Primary key Asc SubjectAssessmentVELSDomainsSeq
AK_SubjectAssessmentVELSDomains_Main Must be unique Asc/Asc SubjectAssessmentVELSStrandsSeq + DomainCode

Relationships

Close relationships within degrees of separation