Structure
erDiagram
SESSION {
int session_id PK, FK
int obsblock_id FK
}
OBSBLOCK {
int obsblock_id PK, FK
int spectrum_id FK
int flag
}
SPECTRUM {
int spectrum_id PK, FK
int flag
}
SPECTRUM_DATA {
int spectrum_id PK, FK
list flags
list frequencies
list intensities
}
SESSION ||--|{ OBSBLOCK : "has one or more"
OBSBLOCK ||--|{ SPECTRUM : "has one or more"
SPECTRUM ||--|| SPECTRUM_DATA : "has one"