#56240sys_file_metadata does used TCA-types but no type column exists
Description
FAL-Records have a type-property which is between 0-5 (unknown, text, image, audio, video, software) that is stored in the sys_file table.
The sys_file_metadata table uses a type-property which is not existing in sys_file_metadata to switch between the different TCA-Types. This seems to be an artifact of the extraction of sys_file_metadata from sys_file to me.
The TCA types of sys_file_metadata should switch based on the type in the referenced sys_file record or the type should be mirrored into sys_file metadata.
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.