MediaiBox.Cms.Api.Database.Migrations.BasicObjects
Creation of tables related to media content.
Below is the list of tables:
Tables
FLASHES
Legacy MibServer2 table. No longer used.
FLASHES_MULTIPLEFILES
Legacy MibServer2 table. No longer used.
IMAGES
Tables responsible for storing image metadata.
Columns
FILENAME
Original image file name.
EXT
Image file extension:
- .jpg
- .jpeg
- .png
- .gif
FILESIZE
Image file size.
WIDTH
Image width
HEIGHT
Image height
SUFFIX
Hash to form part of the file location name.
STRUCTURED
Informs whether you will use structured folders or not.
- 0 - The folder structure will not be used
- 1 - The folder structure will be used (/00/00/00)
STORAGEAREA
Informs which type of storage will be used to upload the image file. For more information about storagearea settings, click here.
PROFILE
Which profile is used to process the image. If there is no profile, the column value is null.
MULTIPLEFILES
Column is not used for image
UPLOADCOMPLETE
Informs whether the file was uploaded successfully.
- 1 - successfully uploaded;
- 0 - There was a problem with the upload process;
- NULL - The file is in the process of being uploaded
TYPE_ID
Stores relevant business information for each team. Can be filled in by the operator or DMM through agent.
RELATIVE_URL
When uploading the image, mibapi will create the relative url.
EXTERNAL_URL
Stores the image URL. If this column is filled in, mibapi will return this URL and ignore the relative URL.
MIB_ASSET_UNIQUE_ID
Unique media ID. Prevents replicated media from being uploaded.
IMAGES_MULTIPLEFILES
This table is not used for image. Legacy MibServer2 table. No longer used.
LINKS
Legacy MibServer2 table. No longer used.
MMEDIAS
Tables responsible for storing media metadata.
FILENAME
Original media file name.
EXT
Media file extension:
- .mp4
- .mpd
- .m3u8
- .ism
- .ismc
- .ismv
- .isma
- .ismf
FILESIZE
Media file size.
WIDTH
Image width
HEIGHT
Image height
DURATION
Media time duration
SUFFIX
Hash to form part of the file location name.
STRUCTURED
Informs whether you will use structured folders or not.
- 0 - The folder structure will not be used
- 1 - The folder structure will be used (/00/00/00)
STORAGEAREA
Informs which type of storage will be used to upload the media file. For more information about storagearea settings, click here.
DRMSEED
Column used to store encryption data. Currently no longer used.
DRMPRIVATEKEY
Column used to store encryption data. Currently no longer used.
DRMPUBLICKEY
Column used to store encryption data. Currently no longer used.
DRMKEYID
Column used to store encryption data. Currently no longer used.
DRMAESKEY
Column used to store encryption data. Currently no longer used.
IDREF
Stores relevant business information for each team. Can be filled in by the operator or DMM through agent.
PROFILE
Profile ID used to encode the media.
QUALITY_ID
Stores relevant business information for each team. Can be filled in by the operator or DMM through agent.
TYPE_ID
Stores relevant business information for each team. Can be filled in by the operator or DMM through agent.
UPLOADCOMPLETE
Informs whether the file/chunks was uploaded successfully.
- 1 - successfully uploaded;
- 0 - There was a problem with the upload process;
- NULL - The file is in the process of being uploaded
LANGUAGE_LIST
Stores the list of media languages.
RELATIVE_URL
When uploading the media, mibapi will create the relative url.
PLAYBACK_RELATIVE_URL
When uploading the media, mibapi will create the playback relative url.
MIB_ASSET_UNIQUE_ID
Unique media ID. Prevents replicated media from being uploaded.
MULTIPLEFILES
Informs if the media has more than one related file/chunks.
- 0 - The media has no related files.
- 1 - The media has related files.
MMEDIAS_MULTIPLEFILES
PARENTID
Related MMEDIAS Record ID
FILESIZE
Media file size.
FILENAME
File name.
EXT
File extension
TEXTS
Legacy MibServer2 table. No longer used.