I've been away from Drupal too long, sucked into WordPress. My company has an ongoing problem with the org chart - specifically it's advertising. I think I can use Drupal to manage this, but I have a lot of rust and haven't worked intensely with it in years (when 8 was current).

The Database I've sketched out uses a UUID approach to coordinate it's contents with outside databases it must stay in sync with, including the aforementioned WordPress site which I will be getting post information from. I'm trying to keep fields on only one table if feasible.

I'm going to go over some of the structure I designed without considering Drupal as the administrating program, so I am open to letting this change as long as I can get the same end result. Note also that this design is informed by schema.org entries for Medical Organizations - of which my company is one (and a fairly large one)

Everything is an Entity. This is the only table with an autoincrement field. Any entry created on any other table starts with an entity entry. For example, if I'm adding a provider the Entity table holds the mappings to the other databases, the entry name and a schema.org description, the person table contains information about the provider's name (given name, surname, which comes first since we have providers with Asian names, gender, etc), and the provider table contains information on whether they accepting new patients, the URL to their scheduler, their NPI (think social security number for medical professionals).

The provider table also cross-references with locations with additional information about which days the provider is at that location and which one is their primary. Another cross reference is which hospitals they have admission privileges to, and another maps which organizations they belong to. Yet another details their education, and their certifications, and the insurances they accept.

The UUID comes into play because hospitals also have insurance company contracts. So that table needs to be joinable with providers or hospitals.

So when I have an edit view of a provider I want the form to present this information cleanly without the user needing to go through multiple forms

I think Drupal can do this out of the box. If not out of the box I have written modules before, but in that event why use Drupal instead of just standing this up in Laravel or Symfony? I'm looking something that is resilient, but I don't want to spend more than a month on this if I can help it.

Hello,

Working a new Drupal site 11 site. And did some testing. When I embed more than 20 images from the media library in CKEditor field (full html).

All the embedded images are shown in CK editor.
But when I switch to the frontend only the fist 20 images are shown are shown. The other content (text) shows correct but images (after number 20) are stripped from the page (also from the html).

Switched the theme to Olivero (to test if this was theme related) but th same problem occurred. Played somewhat with the CKeditor setting (disabled/enabled html corrections).

Checked the logs (php/mysql/apache / console) but saw no error messages.

Any ideas/suggestions what can cause this?