Drupal 9.4 + paragraphs: Database table structure
- Pages (articles/events) are stored in node table and have a nid, which you see in the URL when editing it.
- Paragraphs are added to a node in one or more fields of type "paragraph". In my case, the field is called field_paragraphs, and the table is node__field_paragraphs. Mapping happens via entity_id, which is the node.nid. They have a field_paragraphs_target_id field.
- Generic paragraph data (type,language,revision) are stored in paragraphs_item_field_data, associated via node__field_paragraphs.field_paragraphs_target_id = paragraphs_item_field_data.id.
- Parent relations are stored in paragraphs_item_field_data (parent type + id), also associated via node__field_paragraphs.field_paragraphs_target_id = paragraphs_item_field_data.id.
- Field data of such a paragraph, e.g. a text, is in paragraph__field_text. Same association via the field_paragaphs_target_id.
