StudentCourses


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentCoursesSeq int identity 4 √ null
StudentCourseCharges.StudentCoursesSeq FK_StudentCourseCharges_StudentCourses R
StudentCourses.PriorStudentCoursesSeq FK_StudentCourses_PriorStudentCoursesSeq R
ID int 4 null
Community.ID FK_StudentCourses_ID R
CoursesSeq int 4 null
Courses.CoursesSeq FK_StudentCourses_Courses R
CourseColumn smallint 2 ((0))
CourseStatus varchar 15 ('')
CourseStatusDate datetime 16,3 √ null
CourseStatusDescription varchar 255 ('')
EnquiryDate datetime 16,3 √ null
ApplicationDate datetime 16,3 √ null
EnrolDate datetime 16,3 √ null
CompletedDate datetime 16,3 √ null
DeferredOnDate datetime 16,3 √ null
DeferredTillDate datetime 16,3 √ null
CertificateIssuedFlag bit 1 ((0))
StudentCourseNote varchar 255 ('')
CourseAgentCommissionRulesSeq int 4 √ null
CommissionPayableFlag bit 1 ((1))
PriorStudentCoursesSeq int 4 √ null
StudentCourses.StudentCoursesSeq FK_StudentCourses_PriorStudentCoursesSeq R
OverrideCommissionRate decimal 9,4 √ null
InvoiceNumber varchar 20 ('')
InvoiceDate datetime 16,3 √ null
InvoiceClaimedAmount money 21,4 √ null
AgentID int 4 √ null
Community.ID FK_StudentCourses_Community_AgentID R
CourseAgentCommissionControlSeq int 4 √ null
CourseAgentCommissionControl.CourseAgentCommissionControlSeq FK_StudentCourses_CourseAgentCommissionControl R
CourseAgentSortOrder int 4 √ null
CommissionAlertFlag bit 1 ((0))
CommissionAlertMessage varchar 500 ('')
InvoicePaidAmount money 21,4 √ null
CommissionAuthorisedID int 4 √ null
Community.ID FK_StudentCourses_Community R
CommissionAuthorisedDate datetime 16,3 √ null
PostingNumber int 4 ((0))
CreditorTransactionSeq int 4 ((0))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_StudentCourses Primary key Asc StudentCoursesSeq
AK_StudentCourses_ID_CoursesSeq Performance Asc/Asc ID + CoursesSeq
AK_StudentCourses_PriorCoursesSeq Performance Asc PriorStudentCoursesSeq

Relationships

Close relationships within degrees of separation