Developer Resources

Screening Management

The Screenings table is the top-level entity in the DST database. Each screening represents a complete dam screening assessment for one dam. All other data — hazard characterization, failure mode analysis, consequences, and risk results — is associated with a single screening.

Screenings

5 colsImplemented

Top-level entity representing a complete dam screening assessment.

Column

Type

Constraints

Id

UUID

PK= gen_random_uuid()

Code

VARCHAR(10)

UQIDX

Name

VARCHAR(200)

CreatedAt

TIMESTAMP

= CURRENT_TIMESTAMP

UpdatedAt

TIMESTAMP

= CURRENT_TIMESTAMP

Notes

1. The Code column is a 6-character alphanumeric string used for URL routing (e.g., /screening/Xk9mP2/pfm-01).
2. Unique index on Code ensures no two screenings share the same URL code.