Developer Resources

Schema Reference

The DST database currently contains 5 implemented tables across 2 modules. This page provides an overview of the complete schema. Click any table in the diagram below to view its detailed column definitions.

Table Relationships

Screenings5 columns

1 : N

Pfm0135 columns

1 : 1 · CASCADE

Pfm01_DstSrp6 columnsPfm01_UserSrp5 columnsPfm01_ActiveSrp5 columns

Modules

Screening Management

Core screening entities and URL routing. 1 table:

• Screenings — Top-level entity representing a complete dam screening assessment

PFM-01: Overtopping Erosion

Overtopping erosion failure mode evaluation with the three-table SRP pattern. 4 tables:

• Pfm01 — PFM-01 location entity (35 columns)
• Pfm01_DstSrp — DST-calculated SRP curves and nodal probabilities
• Pfm01_UserSrp — User-defined SRP curves
• Pfm01_ActiveSrp — Active SRP cache synced from DstSrp or UserSrp