Strapi media type not showing up in Supabase
Hello everyone. I am currently building a project with Strapi and Supabase. Unlike the usual approach of using the Strapi API, I am basically just utilizing it as a simple GUI interface to change the Supabase data. In other words when you change something within the CMS, that triggers a change to Supabase, however, the frontend just calls Supabase directly.
I have a problem at the moment that Strapi has a "media" field type, which does not show up at all within Supabase. For example I have a blog post component with title, urlSlug, description etc. All of those work as expected and are written to the database as text, varchar etc, however, when I add an image, it does not show as a column within the blog post table at all. I presume that it is because there is no such Data Type as "media" within Supabase. If I create a custom type, would that solve the issue? I also do not know with what fields it should be created even if it does. The images themselves are not uploaded to Supabase. I use Cloudinary and I do not host the images myself. When an image is uploaded, a new row is created in a 'files' table. All I need is if possible to get the id of the file from that 'media' type that doesn't show up for some reason. I should then be able get the image with that 'id' from the 'files' table.
I have a problem at the moment that Strapi has a "media" field type, which does not show up at all within Supabase. For example I have a blog post component with title, urlSlug, description etc. All of those work as expected and are written to the database as text, varchar etc, however, when I add an image, it does not show as a column within the blog post table at all. I presume that it is because there is no such Data Type as "media" within Supabase. If I create a custom type, would that solve the issue? I also do not know with what fields it should be created even if it does. The images themselves are not uploaded to Supabase. I use Cloudinary and I do not host the images myself. When an image is uploaded, a new row is created in a 'files' table. All I need is if possible to get the id of the file from that 'media' type that doesn't show up for some reason. I should then be able get the image with that 'id' from the 'files' table.
