Skip to main content
Skip table of contents

AssetCourseAssoc (ver21.4.0)

This table stores the course association details for an asset type. A foreign key for assetId (mapped to the id of the asset table) and courseDcid (mapped to the dcid of the courses table) is in place for data integrity.

Column Name

Initial Version

Data Type


ASSETID21.4.0NUMBER(19,0)The primary key of Asset table. FK has been created which maps to ASSET.ID. Required. Indexed.
COURSESDCID21.4.0NUMBER(10,0)Reference to the DCID of the course record associated with this asset type. Required. Indexed.
ID21.4.0NUMBER(19,0)The unique sequential number generated by the application. Indexed. Required.
WhenCreated21.4.0TIMESTAMP(6)The date and time the record was created. Defaults to system date. Required.
WhenModified21.4.0TIMESTAMP(6)The date and time the record was modified. Defaults to system date. Required.
WhoCreated21.4.0VARCHAR2(100 CHAR)The name of the person who created the record. Defaults to user. Required.
WhoModifed21.4.0VARCHAR2(100 CHAR)The name of the person who modified the record. Defaults to the user. Required.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.