Create the Hydrograph Manipulation table and add foreign keys to existing tables. Below are possible columns, constraints. and relationships, please confirm all with @trietmnj:
- hydrograph manipulation columns
- file_type: enum ('water_level', 'wave')
- filename: string
- name: string not null
- description: string
- start_date: date
- end_date: date
- tides: float
- depth_limiations: float
- alpha: float
- beta: float
- reach: foreign _key
- savepoint: foreign_key
- each savepoint will need 2 h5 attached. 1 water level h5 file and 1 waves h5 file
- @trietmnj what output data from the hydrograph run will we need to store. Based off this we can think about if this is stored in this table or a separate table
Create handlers to: