Revision 7189
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1241 | 1241 |
aggregateoccurrence_id int(11), |
| 1242 | 1242 |
overallheight_m double precision, |
| 1243 | 1243 |
overallheightaccuracy_m double precision, |
| 1244 |
collectionnumber varchar(255),
|
|
| 1244 |
authorplantcode varchar(255),
|
|
| 1245 | 1245 |
stemcount int(11), |
| 1246 | 1246 |
plant_id int(11), |
| 1247 | 1247 |
accessioncode varchar(255) |
| ... | ... | |
| 1256 | 1256 |
|
| 1257 | 1257 |
|
| 1258 | 1258 |
-- |
| 1259 |
-- Name: COLUMN plantobservation.collectionnumber; Type: COMMENT; Schema: public; Owner: -
|
|
| 1259 |
-- Name: COLUMN plantobservation.authorplantcode; Type: COMMENT; Schema: public; Owner: -
|
|
| 1260 | 1260 |
-- |
| 1261 | 1261 |
|
| 1262 | 1262 |
|
Also available in: Unified diff
schemas/vegbien.sql: plantobservation: Renamed collectionnumber to authorplantcode since this number, which identifies the plant, is actually different from the collectionnumber that identifies the specimen collected from it. This distinction is meaningful for plots data, but generally not for specimens data.