{"type":"rich","version":"1.0","provider_name":"phorkie","provider_url":"https:\/\/p.cweiske.de\/","title":"Drupal 9.4 + paragraphs: Database table structure","author_name":"Christian Weiske","cache_age":86400,"width":900,"height":900,"html":"\n\n
\n
\n
\n \n
\n\n\n
    \n
  • Pages (articles\/events) are stored in node<\/tt> table and have a nid<\/tt>, which you see in the URL when editing it.<\/li>\n
  • Paragraphs are added to a node in one or more fields of type "paragraph". In my case, the field is called field_paragraphs<\/tt>, and the table is node__field_paragraphs<\/tt>. Mapping happens via entity_id<\/tt>, which is the node.nid<\/tt>. They have a field_paragraphs_target_id<\/tt> field.<\/li>\n
  • Generic paragraph data (type,language,revision) are stored in paragraphs_item_field_data<\/tt>, associated via node__field_paragraphs.field_paragraphs_target_id<\/tt> = paragraphs_item_field_data.id<\/tt>.<\/li>\n
  • Parent relations are stored in paragraphs_item_field_data<\/tt> (parent type + id), also associated via node__field_paragraphs.field_paragraphs_target_id<\/tt> = paragraphs_item_field_data.id<\/tt>.<\/li>\n
  • Field data of such a paragraph, e.g. a text, is in paragraph__field_text<\/tt>. Same association via the field_paragaphs_target_id<\/tt>.<\/li>\n<\/ul>\n<\/div>\n\n <\/div>\n
    \n view raw source<\/a>\n README.rst<\/a>\n <\/div>\n<\/div>\n<\/div>\n"}