Revision 5770
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 901 | 901 |
plantobservation_id int(11) NOT NULL, |
| 902 | 902 |
creator_id int(11) NOT NULL, |
| 903 | 903 |
sourceaccessioncode text, |
| 904 |
aggregateoccurrence_id int(11) NOT NULL,
|
|
| 904 |
aggregateoccurrence_id int(11), |
|
| 905 | 905 |
overallheight_m double precision, |
| 906 | 906 |
overallheightaccuracy_m double precision, |
| 907 | 907 |
collectionnumber text, |
Also available in: Unified diff
schemas/vegbien.sql: plantobservation: Made taxonoccurrence_id optional when sourceaccessioncode is specified, so that aggregateoccurrence doesn't get pruned away in datasource tables that link just a stemobservation to a plantobservation (and therefore don't provide a taxonoccurrence to satisfy the previous taxonoccurrence_id NOT NULL constraint)