Revision 474
Added by Aaron Marcuse-Kubitza about 13 years ago
schemas/vegbien.sql | ||
---|---|---|
1089 | 1089 |
stemheightaccuracy double precision, |
1090 | 1090 |
stemtaxonarea double precision, |
1091 | 1091 |
emb_individualplant integer, |
1092 |
code character varying(20) |
|
1092 |
authorcode character varying(20)
|
|
1093 | 1093 |
); |
1094 | 1094 |
|
1095 | 1095 |
|
... | ... | |
3891 | 3891 |
-- |
3892 | 3892 |
|
3893 | 3893 |
ALTER TABLE ONLY individualplant |
3894 |
ADD CONSTRAINT individualplant_keys UNIQUE (collectiveobservation_id, code); |
|
3894 |
ADD CONSTRAINT individualplant_keys UNIQUE (collectiveobservation_id, authorcode);
|
|
3895 | 3895 |
|
3896 | 3896 |
|
3897 | 3897 |
-- |
Also available in: Unified diff
vegbien.sql: Renamed individualplant.code to authorcode