Asset version
Overview
The asset version object represents the file information for a specific version of a file for a given asset The active asset version's file details are duplicated in the asset object to reduce API and querying complexity
i.e. to get the file details of the active version of a given asset, one simply has to query the asset itself. This has also been done to make upgrades easier as this asset version feature has been added later.
| Object name | asset_version |
|---|---|
| Table name | psys_asset_version |
| Path | /preside-objects/assetManager/asset_version.cfc |
Properties
property name="asset" relationship="many-to-one" relatedTo="asset" required=true uniqueindexes="assetversion|1" ondelete="cascade-if-no-cycle-check" onupdate="cascade-if-no-cycle-check";
property name="version_number" type="numeric" dbtype="int" required=true uniqueindexes="assetversion|2";
property name="storage_path" type="string" dbtype="varchar" maxLength=255 required=true uniqueindexes="assetversionpath";
property name="asset_url" type="string" dbtype="varchar" maxLength=1024 required=false;
property name="size" type="numeric" dbtype="int" required=true;
property name="asset_type" type="string" dbtype="varchar" maxLength=10 required=true;
property name="raw_text_content" type="string" dbtype="longtext";
property name="width" type="numeric" dbtype="int" required=false;
property name="height" type="numeric" dbtype="int" required=false;
property name="focal_point" type="string" dbtype="varchar" maxLength=15 required=false;
property name="crop_hint" type="string" dbtype="varchar" maxLength=30 required=false;
property name="resize_no_crop" type="boolean" dbtype="boolean" default=false;
property name="is_trashed" type="boolean" dbtype="boolean" required=false default=false;
property name="trashed_path" type="string" dbtype="varchar" maxLength=255 required=false;
property name="created_by" relationship="many-to-one" relatedTo="security_user" required=false generator="loggedInUserId" ondelete="set-null-if-no-cycle-check" onupdate="cascade-if-no-cycle-check";
property name="updated_by" relationship="many-to-one" relatedTo="security_user" required=false generator="loggedInUserId" ondelete="set-null-if-no-cycle-check" onupdate="cascade-if-no-cycle-check";