Revision 7147
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 2248 | 2248 |
notesmgt boolean, |
| 2249 | 2249 |
revisions boolean, |
| 2250 | 2250 |
determinationdate date, |
| 2251 |
accessioncode text |
|
| 2251 |
accessioncode text, |
|
| 2252 |
CONSTRAINT taxondetermination_computer_min_fit CHECK (((NOT (determinationtype = 'computer'::text)) OR ((taxonfit)::double precision >= (0.8)::double precision))) |
|
| 2252 | 2253 |
); |
| 2253 | 2254 |
|
| 2254 | 2255 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination: Added CHECK constraint to allow only taxondeterminations with a minimum fit fraction of 80%, analogous to taxonlabel's taxonlabel_1_matched_label_min_fit() trigger