Entity CourseAttachment

Description of Entity CourseAttachment

It is for uploading an external document, e.g. MS Word (.docx), where the uploaded document will be stored in the Sage EasyPay Enterprise database.


List of all Dependencies of the Entity CourseAttachment

Name

Code

Class Name

Relation_216783

Relation_216783

Reference


List of Attributes of the Entity CourseAttachment

Name

Code

Course Code

CourseCode

CourseAttachSysId

CourseAttachSysId

Remarks

CourseAttachRemarks

CourseAttachment

CourseAttachment

File Type

CourseAttachFileType


Entity Attribute Course Code of the Entity CourseAttachment

Card of Attribute Course Code of the Entity CourseAttachment

Name

Course Code

Code

CourseCode

Data Type

char(20)

Mandatory

Yes


Description of Attribute Course Code of the Entity CourseAttachment

Shows the code for the course. This is the primary key for the Course table.


Entity Attribute CourseAttachSysId of the Entity CourseAttachment

Card of Attribute CourseAttachSysId of the Entity CourseAttachment

Name

CourseAttachSysId

Code

CourseAttachSysId

Data Type

integer

Mandatory

Yes


Description of Attribute CourseAttachSysId of the Entity CourseAttachment

A system generated identity. It is blind to the user. This is the primary key for the CourseAttachment table.


Entity Attribute Remarks of the Entity CourseAttachment

Card of Attribute Remarks of the Entity CourseAttachment

Name

Remarks

Code

CourseAttachRemarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity CourseAttachment

Stores any remarks about the course attachment.


Entity Attribute CourseAttachment of the Entity CourseAttachment

Card of Attribute CourseAttachment of the Entity CourseAttachment

Name

CourseAttachment

Code

CourseAttachment

Data Type

long binary

Mandatory

No


Description of Attribute CourseAttachment of the Entity CourseAttachment

Shows the course attachment.


Entity Attribute File Type of the Entity CourseAttachment

Card of Attribute File Type of the Entity CourseAttachment

Name

File Type

Code

CourseAttachFileType

Data Type

char(20)

Mandatory

No


Description of Attribute File Type of the Entity CourseAttachment

Shows the type of attachment file for the course.
Example: PDF (.pdf) / Word document (.docx) / Text file (.txt) etc