<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<oembed><type>rich</type><version>1.0</version><provider_name>phorkie</provider_name><provider_url>https://p.cweiske.de/</provider_url><title>Drupal 9.4 + paragraphs: Database table structure</title><author_name>Christian Weiske</author_name><cache_age>86400</cache_age><width>900</width><height>900</height><html>&lt;!-- embedding all files of https://p.cweiske.de/906 --&gt;
&lt;link rel="stylesheet" href="https://p.cweiske.de/css/embed.css"/&gt;
&lt;div class="phork" id="906"&gt;
    &lt;div class="phork-file"&gt;
 &lt;div class="phork-content"&gt;
  
&lt;div class="document"&gt;


&lt;ul class="simple"&gt;
&lt;li&gt;Pages (articles/events) are stored in &lt;tt class="docutils literal"&gt;node&lt;/tt&gt; table and have a &lt;tt class="docutils literal"&gt;nid&lt;/tt&gt;, which you see in the URL when editing it.&lt;/li&gt;
&lt;li&gt;Paragraphs are added to a node in one or more fields of type &amp;quot;paragraph&amp;quot;. In my case, the field is called &lt;tt class="docutils literal"&gt;field_paragraphs&lt;/tt&gt;, and the table is &lt;tt class="docutils literal"&gt;node__field_paragraphs&lt;/tt&gt;. Mapping happens via &lt;tt class="docutils literal"&gt;entity_id&lt;/tt&gt;, which is the &lt;tt class="docutils literal"&gt;node.nid&lt;/tt&gt;. They have a &lt;tt class="docutils literal"&gt;field_paragraphs_target_id&lt;/tt&gt; field.&lt;/li&gt;
&lt;li&gt;Generic paragraph data (type,language,revision) are stored in &lt;tt class="docutils literal"&gt;paragraphs_item_field_data&lt;/tt&gt;, associated via &lt;tt class="docutils literal"&gt;node__field_paragraphs.field_paragraphs_target_id&lt;/tt&gt; = &lt;tt class="docutils literal"&gt;paragraphs_item_field_data.id&lt;/tt&gt;.&lt;/li&gt;
&lt;li&gt;Parent relations are stored in &lt;tt class="docutils literal"&gt;paragraphs_item_field_data&lt;/tt&gt; (parent type + id), also associated via &lt;tt class="docutils literal"&gt;node__field_paragraphs.field_paragraphs_target_id&lt;/tt&gt; = &lt;tt class="docutils literal"&gt;paragraphs_item_field_data.id&lt;/tt&gt;.&lt;/li&gt;
&lt;li&gt;Field data of such a paragraph, e.g. a text, is in &lt;tt class="docutils literal"&gt;paragraph__field_text&lt;/tt&gt;. Same association via the &lt;tt class="docutils literal"&gt;field_paragaphs_target_id&lt;/tt&gt;.&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;

 &lt;/div&gt;
 &lt;div class="phork-meta"&gt;
  &lt;a href="https://p.cweiske.de/906/rev-raw/169aad94540ea6bbff91cdafc6533ad898eeccd9/README.rst" style="float: right"&gt;view raw source&lt;/a&gt;
  &lt;a href="https://p.cweiske.de/906#README.rst"&gt;README.rst&lt;/a&gt;
 &lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
</html></oembed>
