Files

Columns

Name

Type

ReadOnly

References

Description

id [KEY]

String

True

The id column for the table Files.

Etag

String

False

The Etag column for the table Files.

createdBy_application_displayName

String

False

The createdBy_application_displayName column for the table Files.

createdBy_application_id

String

False

The createdBy_application_id column for the table Files.

createdDateTime

Datetime

False

The createdDateTime column for the table Files.

description

String

False

The description column for the table Files.

lastModifiedBy_application_displayName

String

False

The lastModifiedBy_application_displayName column for the table Files.

lastModifiedBy_application_id

String

False

The lastModifiedBy_application_id column for the table Files.

lastModifiedDateTime

Datetime

False

The lastModifiedDateTime column for the table Files.

name

String

False

The name column for the table Files.

parentReference_driveId

String

False

The parentReference_driveId column for the table Files.

parentReference_driveType

String

False

The parentReference_driveType column for the table Files.

parentReference_id

String

False

The parentReference_id column for the table Files.

parentReference_name

String

False

The parentReference_name column for the table Files.

parentReference_path

String

False

The parentReference_path column for the table Files.

parentReference_shareId

String

False

The parentReference_shareId column for the table Files.

parentReference_sharepointIds_listId

String

False

The parentReference_sharepointIds_listId column for the table Files.

parentReference_sharepointIds_listItemId

String

False

The parentReference_sharepointIds_listItemId column for the table Files.

parentReference_sharepointIds_listItemUniqueId

String

False

The parentReference_sharepointIds_listItemUniqueId column for the table Files.

parentReference_sharepointIds_siteId

String

False

The parentReference_sharepointIds_siteId column for the table Files.

parentReference_sharepointIds_siteUrl

String

False

The parentReference_sharepointIds_siteUrl column for the table Files.

parentReference_sharepointIds_tenantId

String

False

The parentReference_sharepointIds_tenantId column for the table Files.

parentReference_sharepointIds_webId

String

False

The parentReference_sharepointIds_webId column for the table Files.

parentReference_siteId

String

False

The parentReference_siteId column for the table Files.

webUrl

String

False

The webUrl column for the table Files.

audio_album

String

False

The audio_album column for the table Files.

audio_albumArtist

String

False

The audio_albumArtist column for the table Files.

audio_artist

String

False

The audio_artist column for the table Files.

audio_bitrate

Long

False

The audio_bitrate column for the table Files.

audio_composers

String

False

The audio_composers column for the table Files.

audio_copyright

String

False

The audio_copyright column for the table Files.

audio_disc

Int

False

The audio_disc column for the table Files.

audio_discCount

Int

False

The audio_discCount column for the table Files.

audio_duration

Long

False

The audio_duration column for the table Files.

audio_genre

String

False

The audio_genre column for the table Files.

audio_hasDrm

Bool

False

The audio_hasDrm column for the table Files.

audio_isVariableBitrate

Bool

False

The audio_isVariableBitrate column for the table Files.

audio_title

String

False

The audio_title column for the table Files.

audio_track

Int

False

The audio_track column for the table Files.

audio_trackCount

Int

False

The audio_trackCount column for the table Files.

audio_year

Int

False

The audio_year column for the table Files.

content

String

False

The content column for the table Files.

cTag

String

False

The cTag column for the table Files.

deleted_state

String

False

The deleted_state column for the table Files.

file_hashes_crc32Hash

String

False

The file_hashes_crc32Hash column for the table Files.

file_hashes_quickXorHash

String

False

The file_hashes_quickXorHash column for the table Files.

file_hashes_sha1Hash

String

False

The file_hashes_sha1Hash column for the table Files.

file_hashes_sha256Hash

String

False

The file_hashes_sha256Hash column for the table Files.

file_mimeType

String

False

The file_mimeType column for the table Files.

file_processingMetadata

Bool

False

The file_processingMetadata column for the table Files.

fileSystemInfo_createdDateTime

Datetime

False

The fileSystemInfo_createdDateTime column for the table Files.

fileSystemInfo_lastAccessedDateTime

Datetime

False

The fileSystemInfo_lastAccessedDateTime column for the table Files.

fileSystemInfo_lastModifiedDateTime

Datetime

False

The fileSystemInfo_lastModifiedDateTime column for the table Files.

folder_childCount

Int

False

The folder_childCount column for the table Files.

folder_view_sortBy

String

False

The folder_view_sortBy column for the table Files.

folder_view_sortOrder

String

False

The folder_view_sortOrder column for the table Files.

folder_view_viewType

String

False

The folder_view_viewType column for the table Files.

image_height

Int

False

The image_height column for the table Files.

image_width

Int

False

The image_width column for the table Files.

location_altitude

Double

False

The location_altitude column for the table Files.

location_latitude

Double

False

The location_latitude column for the table Files.

location_longitude

Double

False

The location_longitude column for the table Files.

package_type

String

False

The package_type column for the table Files.

pendingOperations_pendingContentUpdate_queuedDateTime

Datetime

False

The pendingOperations_pendingContentUpdate_queuedDateTime column for the table Files.

photo_cameraMake

String

False

The photo_cameraMake column for the table Files.

photo_cameraModel

String

False

The photo_cameraModel column for the table Files.