This article outlines the database structure for the MMv4 digdel_object database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- name
Name of the digital object.
varcahr(255) | indexed
- type
Type of digital object
varcahr(255) | Values: file or webpage | indexed
- url
URL to the digital file
varcahr(255) | indexed
- active
If this field contains a value less than one, then the digital object is inactive. Only active digital objects will be purchase and downloadable from the storefront.
int(10) | unsigned | Values: 0/timestamp | indexed
- instructions
Download instructions that will appear in the customer's download area.
text
- access_hours
Amount, if any, extra hours the digital object will remain available for the customer to download
int(10) | indexed
- access_limit
Amount, if any, extra download attempts for this digital object.
int(10) | indexed
- owner
System ID number of the store admin that owns this digital object, if any. If 0, all store admins will have access to this digital object.
int(10) | default: 0 | indexed
- filesize
Size of the digital object.
bigint(20) | indexed
- display_order
Order in which the digital objects will be displayed in the customer's download area.
int(10) | indexed
- umlimited_access
This specifies that the digital_object will never expire.
int(10) | indexed
- release_date
Date associated with a "Pre-order" type digital object This date is when the digital object will become available.
int(10) | indexed
- and_or
Specifies whether any of the zone rules or all of them apply to this digital object.
char(1) | indexed
- zone_message
Custom message that will be displayed to the customer if their geographical location is not permitted to download the specific digital object.
text
|
