bety icon indicating copy to clipboard operation
bety copied to clipboard

covariates: Finish making key

Open gsrohde opened this issue 11 years ago • 1 comments

  • [x] Fix rows with NULL trait_id
  • [ ] Add not-NULL constraints

(trait_id, variable_id) is constrained to be unique, but the constituent columns should be constrained to be non-NULL.

Currently, 9 rows have NULL in the trait_id column.

The constraint to add are:

ALTER TABLE covariates ALTER COLUMN trait_id SET NOT NULL;
ALTER TABLE covariates ALTER COLUMN variable_id SET NOT NULL;

gsrohde avatar Feb 02 '15 20:02 gsrohde

I removed the rows with trait_id = null

delete from covariates where trait_id is null

dlebauer avatar Jul 12 '16 19:07 dlebauer