Revision 475
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.sql | ||
|---|---|---|
| 2225 | 2225 |
CREATE TABLE stemobservation ( |
| 2226 | 2226 |
stemobservation_id integer NOT NULL, |
| 2227 | 2227 |
individualplant_id integer NOT NULL, |
| 2228 |
stemcode character varying(20),
|
|
| 2228 |
authorcode character varying(20),
|
|
| 2229 | 2229 |
stemxposition double precision, |
| 2230 | 2230 |
stemyposition double precision, |
| 2231 | 2231 |
stemhealth character varying(50), |
| ... | ... | |
| 4179 | 4179 |
-- |
| 4180 | 4180 |
|
| 4181 | 4181 |
ALTER TABLE ONLY stemobservation |
| 4182 |
ADD CONSTRAINT stemobservation_keys UNIQUE (individualplant_id, stemcode);
|
|
| 4182 |
ADD CONSTRAINT stemobservation_keys UNIQUE (individualplant_id, authorcode);
|
|
| 4183 | 4183 |
|
| 4184 | 4184 |
|
| 4185 | 4185 |
-- |
Also available in: Unified diff
VegBIEN: Renamed stemobservation.stemcode to authorcode