bety
bety copied to clipboard
treatments value constraints: needed cleanup and decisions
control
- [ ] Decide how to handle cases where control is NULL
- [ ] Add not NULL constraint
- [ ] Decide what other constraints apply to control
- [ ] Add them
Details
control is NULL in 190 rows.
From the Uniqueness portion of the constraints spreadsheet: "there must be a control for each (citation_id, site_id) tuple". "A control" means a treatment for which control = true
. The meaning of this is not clear, however, since site_id
and citation_id
are not columns of this table.