Revision 7295
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 2293 | 2293 |
notesmgt boolean, |
| 2294 | 2294 |
revisions boolean, |
| 2295 | 2295 |
determinationdate date, |
| 2296 |
accessioncode text, |
|
| 2297 |
CONSTRAINT taxondetermination_computer_min_fit CHECK (CASE WHEN (determinationtype = 'computer'::text) THEN ((taxonfit)::double precision >= (0.8)::double precision) ELSE true END) |
|
| 2296 |
accessioncode text |
|
| 2298 | 2297 |
); |
| 2299 | 2298 |
|
| 2300 | 2299 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination: Removed taxondetermination_computer_min_fit CHECK constraint, whose functionality is now duplicated by unscrubbed_taxondetermination_view's Max_score filter condition. The score threshold value should only be maintained in one place, namely unscrubbed_taxondetermination_view.