FileManagerFiles
A listing of all avaialable images and files within an account's gallery.
テーブル固有の情報
FileManagerFiles ではSELECT、INSERT、UPDATE、およびDELETE がサポートされています。
Select
SELECT * FROM FileManagerFiles
Insert
INSERT には、Name、FolderId、およびFileData を指定する必要があります。
INSERT INTO FileManagerFiles (Name, FolderID, FileData) VALUES ('myNewFolder', 'myFolderID', 'myBase64EncodedFileData')
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | True |
The unique id given to the file. |
FolderId | Integer | False |
The id of the folder. |
Type | String | True |
The type of file in the gallery: Image or file. |
Name | String | False |
The name of the file. |
FullSizeUrl | String | True |
The url of the full-size file. |
ThumbnailUrl | String | True |
The url of the thumbnail preview. |
Size | Integer | True |
The size of the file in bytes. |
CreatedAt | Datetime | True |
The date and time a file was added to the gallery. |
CreatedBy | String | True |
The username of the profile that uploaded the file. |
Width | Integer | True |
The width of the image. |
Height | Integer | True |
The height of an image. |
FileData | String | False |
When adding a new file, the base64-encoded file. Required for INSERT statement. |