| CoursesSeq |
int identity |
4 |
|
√ |
null |
|
CourseClasses.CoursesSeq
|
FK_CourseClasses_Courses R
|
|
Courses.CommissionLinkCoursesSeq
|
FK_CommissionLinkCoursesSeq_Courses R
|
|
Courses.CoursesSeq
|
FK_Courses_LinkedCoursesSeq R
|
|
CourseStaff.CoursesSeq
|
FK_CourseStaff_Courses R
|
|
StudentCourses.CoursesSeq
|
FK_StudentCourses_Courses R
|
|
|
Courses.CoursesSeq
|
FK_Courses_LinkedCoursesSeq R
|
|
|
| FileType |
varchar |
5 |
|
|
('A') |
|
|
|
| CourseCampus |
varchar |
3 |
|
|
('') |
|
|
|
| CourseCode |
varchar |
15 |
|
|
null |
|
|
|
| Description |
varchar |
100 |
√ |
|
('') |
|
|
|
| ClassificationCode |
varchar |
15 |
|
|
('') |
|
|
|
| CourseCost |
money |
21,4 |
√ |
|
null |
|
|
|
| Deposit |
money |
21,4 |
√ |
|
null |
|
|
|
| InstalmentType |
varchar |
1 |
|
|
('') |
|
|
|
| InstalmentNumber |
smallint |
2 |
√ |
|
null |
|
|
|
| InstalmentAmount |
money |
21,4 |
√ |
|
null |
|
|
|
| CourseHoldFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| CertificateFlag |
bit |
1 |
|
|
((1)) |
|
|
|
| FeeCode |
varchar |
15 |
|
|
('') |
|
|
|
| DepartmentCode |
varchar |
8 |
|
|
('') |
|
|
|
| CourseNote |
varchar |
2000 |
√ |
|
('') |
|
|
|
| ProgramCode |
varchar |
15 |
|
|
('') |
|
|
|
| StartDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| EndDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| DurationWeeks |
smallint |
2 |
√ |
|
null |
|
|
|
| ValedictionDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| CRICOSCode |
varchar |
15 |
|
|
('') |
|
|
|
| OSHCMonths |
smallint |
2 |
√ |
|
null |
|
|
|
| FirstInstallPercent |
decimal |
7,2 |
√ |
|
null |
|
|
|
| LinkedCoursesSeq |
int |
4 |
√ |
|
null |
|
|
|
| ActiveFlag |
bit |
1 |
|
|
((1)) |
|
|
|
| CourseAgentCommissionControlSeqDefault |
int |
4 |
√ |
|
null |
|
|
|
| EnrolmentOpenDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| EnrolmentClosedDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| AlternateFinishDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| FilingNumber |
varchar |
30 |
|
|
('') |
|
|
|
| CommissionLinkCoursesSeq |
int |
4 |
√ |
|
null |
|
|
Courses.CoursesSeq
|
FK_CommissionLinkCoursesSeq_Courses R
|
|
|
