🧜 Image Embeds

🧜 Image Embeds

This is the image embeds mermaid database diagram.

classDiagram direction TB %%======== Tables =============== class fu_image_embeds { id: INT [AI, PK, NN, IX] image_title: VARCHAR - 255 [NN, UQ. FT] image_description: TEXT [NN, UQ, FT] embed_code: TEXT [NN, UQ, FT] date_added: DATETIME [NN, IX] release_date: DATE [NN, IX] status: ENUM('draft', 'published', 'archived') fu_image_galleries_id: INT [NN, IX] fu_image_models_id: INT [NN, IX] fu_content_licenses_id: INT [NN, IX] } %% The image gallery an image is part of. class fu_image_galleries { id: INT [PK, AI, NN, IX] title: VARCHAR - 255 [NN, UQ, FT] date_added: DATETIME [NN, IX] } %% The AI model that generated the images. class fu_image_models { id: INT [PK, AI, NN, IX] model: VARCHAR - 128 [NN, UQ, FT] link: VARCHAR - 255 } %% Licences content is released under class fu_content_licenses { id: INT [PK, AI, NN, IX] license: VARCHAR - 128 [NN, UQ, FT] license_link: VARCHAR - 255 [NN, UQ, IX] } %%=============================== %%======== Relationships ======== fu_image_embeds "0..*" --> "1" fu_image_galleries : belongs to fu_image_embeds "0..*" --> "1" fu_image_models : generated by fu_image_embeds "0..*" --> "1" fu_content_licenses : licensed under %%===============================

Legend

Keys

  • PK - Primary Key
  • FK - Foreign Key

Constraints

  • AI - Auto Increment
  • NN - Not Null
  • UQ - Unique
  • CK - Check Constraint
  • DV - Default Value

Performance

  • IX - Indexed Column
  • FT - Full-Text Index