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 | Description |
|---|---|---|---|
| ASSETID | 21.4.0 | NUMBER(19,0) | The primary key of Asset table. FK has been created which maps to ASSET.ID. Required. Indexed. |
| COURSESDCID | 21.4.0 | NUMBER(10,0) | Reference to the DCID of the course record associated with this asset type. Required. Indexed. |
| ID | 21.4.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
| WhenCreated | 21.4.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 21.4.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. Required. |
| WhoCreated | 21.4.0 | VARCHAR2(100 CHAR) | The name of the person who created the record. Defaults to user. Required. |
| WhoModifed | 21.4.0 | VARCHAR2(100 CHAR) | The name of the person who modified the record. Defaults to the user. Required. |