PSM_AssetContentArchive (ver6.0.0)
This table holds prior versions of assets. Any time a new version of the AssetContent is saved, the previous active contents from PSM_AssetContent will be stored in this table.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Asset_ID | 6.0.0 | Number(19,0) | Internal number for the associated PSM_Asset record. Required. |
BLOB_Content | 6.0.0 | BLOB | Binary Content (image, pdf, zip, etc) |
CLOB_Content | 6.0.0 | CLOB | Text Content (html, css, javascript, etc) |
Created_By | 6.0.0 | Varchar2(64) | PSM_Account.Username of the person creating the record. Required. |
Created_Ts | 6.0.0 | Date | Date and time the record was created. Defaults to system date. Required. |
ID | 6.0.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
LastModified_By | 6.0.0 | Varchar2(64) | PSM_Account.Username of the person updating the record. Required. |
LastModified_Ts | 6.0.0 | Date | Date and time the record was modified. Defaults to system date. Required. |