bety

bety copied to clipboard

add migration to drop valid_ensemble_runtype constraitn

1

This constraint should be removed: ``` sql ALTER TABLE ensembles ALTER COLUMN runtype SET NOT NULL, ADD CONSTRAINT valid_ensemble_runtype CHECK (runtype IN ('ensemble', 'sensitivity analysis', 'MCMC', 'pda.emulator')); ``` To drop...

dlebauer

It looks like these are cases where the level, n, and stat columns have been re-purposed to represent dates, with year = level, month = n, and day = stat....

gsrohde

ONGOING It is anticipated that some of the database constraints will make errors more likely when inserting or updating data via the Rails interface. This is a list of validations...

gsrohde

- [ ] Decide what constraints to use For now, these constraints will be added: ``` sql ALTER TABLE workflows ALTER COLUMN folder SET NOT NULL; ALTER TABLE workflows ADD...

gsrohde

#### description - [ ] Fix value that isn't whitespace-normalized - [ ] Add constraint #### units - [ ] Decide if any constraints are possible besides whitespace-normalization and not...

gsrohde

users value constraints: needed cleanup and decisions

1

#### area - [ ] Decide on constraints - [ ] Add to migration #### salt - [ ] Eliminate NULLs - [ ] Add not null constraint #### remember_token,...

gsrohde

treatments value constraints: needed cleanup and decisions

1

#### control - [ ] Decide how to handle cases where control is NULL - [ ] Add not NULL constraint - [ ] Decide what other constraints apply to...

gsrohde

-1 is valid for model_id for workflows

8

-1 is used for those models that have no entry in the database but still have all the required pieces, thus -1 is a valid value when writing to the...

robkooper

species value constraints: needed cleanup and decisions

14

### Constraints #### spcd - [x] Decide on range - spcd is a foreign key to FIA database. okay to set as integer, range 0-10000 - [x] Implement constraint ####...

gsrohde

sites value constraints: needed cleanup and decisions

4

#### city, state, country - [ ] Decide on constraints - issue #201 provides information on removing duplicates, and source of standardized names - [ ] Add them #### soil...

gsrohde