UPLOADED_FILES

0 rows


Description

Contains details of uploaded system and customer files. Does not contain the actual file content.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
UPLOADED_FILE_ID int 4 null
CAMPAIGNS.CAMPAIGN_IMAGE_FILE_ID Defined in XML R
CUSTOMER_SIGNED_WAIVERS.SIGNED_WAIVER_FILE_ID Defined in XML R
CUSTOMER_SIGNED_WAIVERS.UPLOADED_FILE_ID Defined in XML R
CUSTOMER_WAIVERS.UPLOADED_FILE_ID Defined in XML R
EVENT_TYPES.DISPLAY_IMAGE_ID Defined in XML R
FACILITIES.CAPTIVATE_APP_IMAGE_ID Defined in XML R
FACILITY_TYPES.AVAILABLE_ICON_FILE_ID Defined in XML R
FACILITY_TYPES.BOOKED_ICON_FILE_ID Defined in XML R
FACILITY_TYPES.CLOSED_ICON_FILE_ID Defined in XML R
LOCKER_ROOMS.ICON_FILE_ID Defined in XML R
POS_PRODUCTS.IMAGE_FILE_ID Defined in XML R
RESERVATION_GROUPS.DISPLAY_IMAGE_ID Defined in XML R
TRANSACTION_STAGES.SIGNED_WAIVER_FILE_ID Defined in XML R
TRANSACTION_STAGES.WAIVER_FILE_ID Defined in XML R
WORKSTATIONS.BIRTHDAY_ALERT_SOUND_FILE_ID Defined in XML R
WORKSTATIONS.EQUIPMENT_CUSTOMER_MAX_EXCEEDED_SOUND_FILE_ID Defined in XML R
WORKSTATIONS.EQUIPMENT_INVENTORY_SHORT_SOUND_FILE_ID Defined in XML R
WORKSTATIONS.EQUIPMENT_PREREQUISITE_MISSING_SOUND_FILE_ID Defined in XML R
WORKSTATIONS.EQUIPMENT_SIGN_IN_SOUND_FILE_ID Defined in XML R
WORKSTATIONS.EQUIPMENT_SIGN_OUT_SOUND_FILE_ID Defined in XML R
WORKSTATIONS.PASS_AT_LAST_USE_SOUND_FILE_ID Defined in XML R
WORKSTATIONS.PASS_DEBIT_BALANCE_GREATER_THAN_SOUND_FILE_ID Defined in XML R
WORKSTATIONS.PASS_EXPIRY_WITHIN_DAYS_SOUND_FILE_ID Defined in XML R
WORKSTATIONS.PASS_INVALID_SOUND_FILE_ID Defined in XML R
WORKSTATIONS.PASS_MULTIPLE_SELECT_SOUND_FILE_ID Defined in XML R
WORKSTATIONS.PASS_SCANNED_SAME_DAY_SOUND_FILE_ID Defined in XML R
WORKSTATIONS.PASS_VALID_SOUND_FILE_ID Defined in XML R
WORKSTATIONS.STAFF_OR_CUSTOMER_NOTES_ALERT_SOUND_FILE_ID Defined in XML R

The ID of the uploaded file
DISPLAY_NAME varchar 50 √ null

The display name of the uploaded file if one was provided, otherwise contains a system-generated value
CONTENT_TYPE varchar 100 √ null

The content type of the uploaded file
FILE_SIZE_BYTES int 4 √ null

The size of the uploaded file in bytes
HREF_TEXT varchar 100 √ null

The text that should be displayed when presenting the file as a clickable web site link
CUSTOMER_ID int 4 √ null
CUSTOMERS.CUSTOMER_ID Defined in XML R

The ID of the customer that the uploaded file is related to
FILE_EXTENSION varchar 50 √ null

The file extension of the uploaded file
USE_AS_MAP_ICON varchar 5 √ null

Whether the uploaded file is an image and can be used as a map icon (Yes / No)
IMAGE_WIDTH int 4 √ null

The image width if the uploaded file is an image
IMAGE_HEIGHT int 4 √ null

The image height if the uploaded file is an image
UPLOADED_BY_SYSTEMUSER_ID int 4 √ null
SYSTEM_USERS.SYSTEMUSER_ID Defined in XML R

The ID of the system user who uploaded the file
UPLOADED_DATE_TIME datetime 16,3 √ null

The date and time that the file was uploaded
ENABLE_FOR_INSTRUCTOR_EMAIL_ATTACHMENT varchar 5 √ null

Whether the uploaded file can be selected as an email attachment for instructor emails (Yes / No)
SITE_ID int 4 √ null
SITES.SITE_ID Defined in XML R

The ID of the site that the uploaded file is specific to
FILE_NAME varchar 200 √ null

The file name of the uploaded file if applicable
ROW_VERSION binary 8 √ null

System timestamp (for internal use)
LAST_SYNC_TIME datetime 16,3 (getdate())

Date and time Hub record was last modified
ACTIVE_HUB_PROCESS_ID bigint 8 √ null

The Hub sync process ID
ORG_ID int 4 null

Your organization’s unique identifier in the Active Net system

Indexes

Constraint Name Type Sort Column(s)
UPLOADED_FILES_UPLOADED_FILE_ID_ORG_ID_PK Primary key Asc/Asc UPLOADED_FILE_ID + ORG_ID
UPLOADED_FILES_CUSTOMER_ID_IX Performance Asc CUSTOMER_ID
UPLOADED_FILES_ROW_VERSION_IX Performance Asc ROW_VERSION
UPLOADED_FILES_SITE_ID_IX Performance Asc SITE_ID
UPLOADED_FILES_UPLOADED_BY_SYSTEMUSER_ID_IX Performance Asc UPLOADED_BY_SYSTEMUSER_ID

Relationships

Close relationships within degrees of separation