PSM_AssetContent (ver6.0.0)
This table stores the content for each managed asset in PSM_Asset. Determined by the associated PSM_Asset is_binary column, a record may contain either BLOB_content or CLOB_content but not both.
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. |
Status | 6.0.0 | Char(1) | For Custom Pages: 'D'==Draft or 'A'==Active. 'A' indicates the currently published page. Only one 'A' record allowed for each unique Asset_ID. Required. |