Does anyone know where I can find a detailed explanation of the database model and its table fields? I’ve been exploring the Home Assistant Events | Home Assistant Data Science Portal, but all I can find are the column types (int, timestamp, str, etc.), which isn’t very helpful.
There’s a reference saying, “Further details about the database schema are available in the official documentation” but again, it’s just “create table” types without any real explanation of the actual data model or how the table fields relate to each other. (WTH 
)
Am I missing something, or is this information just not available?
Thanks in advance!
EDIT:
The documentation is filled with notes about changes that can be misleading, such as: “The created field is no longer stored in the events table to avoid duplicating data in the database, as it was always the same as time_fired_ts.”
Wouldn’t it be more straightforward to just update the documentation and remove these “now it works differently” explanations that only add to the confusion?