Database structure

Database Structure Schema...

Right-click the figure then select 'open in new tab' to view the larger figure.

Solar Event
Represents any transient activity happening at the Sun. We are planning to include at least three types of events: flares, filament eruptions, and coronal mass ejections. The design of the database allows us to add any other events too.
Observation
This part is designed to record any observational session and corresponding physical measures into the database.
Active region over time
This part is designed to handle any active regions and their descriptors at certain times, as well as the related data products.

All three major entities ("Solar Event", "Active region over time", and "Observation") have relations between them. Major entities have such attributes as position boxes and time diapasons, which makes it easy to associate them with each other. The database handles all major terms (objects) currently used in solar physics which allows us to integrate any observational data, metadata, data products, as well as the related simulation and modeling results.