Revision 517
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 1060 | 1060 |
heightaccuracy double precision, |
| 1061 | 1061 |
taxonarea double precision, |
| 1062 | 1062 |
emb_individualplant integer, |
| 1063 |
authorcode character varying(20)
|
|
| 1063 |
sourceid character varying(20)
|
|
| 1064 | 1064 |
); |
| 1065 | 1065 |
|
| 1066 | 1066 |
|
| ... | ... | |
| 1563 | 1563 |
|
| 1564 | 1564 |
CREATE TABLE plot ( |
| 1565 | 1565 |
plot_id integer NOT NULL, |
| 1566 |
authorcode character varying(30),
|
|
| 1566 |
sourceid character varying(30),
|
|
| 1567 | 1567 |
reference_id integer, |
| 1568 | 1568 |
parent_id integer, |
| 1569 | 1569 |
reallatitude double precision, |
| ... | ... | |
| 1646 | 1646 |
previous_id integer, |
| 1647 | 1647 |
plot_id integer NOT NULL, |
| 1648 | 1648 |
project_id integer, |
| 1649 |
authorcode character varying(30),
|
|
| 1649 |
sourceid character varying(30),
|
|
| 1650 | 1650 |
dateaccuracy character varying(30), |
| 1651 | 1651 |
covermethod_id integer, |
| 1652 | 1652 |
coverdispersion character varying(30), |
| ... | ... | |
| 2301 | 2301 |
CREATE TABLE stem ( |
| 2302 | 2302 |
stem_id integer NOT NULL, |
| 2303 | 2303 |
individualplant_id integer NOT NULL, |
| 2304 |
authorcode character varying(20),
|
|
| 2304 |
sourceid character varying(20),
|
|
| 2305 | 2305 |
xposition double precision, |
| 2306 | 2306 |
yposition double precision, |
| 2307 | 2307 |
health character varying(50), |
| ... | ... | |
| 3991 | 3991 |
-- |
| 3992 | 3992 |
|
| 3993 | 3993 |
ALTER TABLE ONLY individualplant |
| 3994 |
ADD CONSTRAINT individualplant_keys UNIQUE (aggregateoccurrence_id, authorcode);
|
|
| 3994 |
ADD CONSTRAINT individualplant_keys UNIQUE (aggregateoccurrence_id, sourceid);
|
|
| 3995 | 3995 |
|
| 3996 | 3996 |
|
| 3997 | 3997 |
-- |
| ... | ... | |
| 4135 | 4135 |
-- |
| 4136 | 4136 |
|
| 4137 | 4137 |
ALTER TABLE ONLY plot |
| 4138 |
ADD CONSTRAINT plot_keys UNIQUE (reference_id, parent_id, authorcode);
|
|
| 4138 |
ADD CONSTRAINT plot_keys UNIQUE (reference_id, parent_id, sourceid);
|
|
| 4139 | 4139 |
|
| 4140 | 4140 |
|
| 4141 | 4141 |
-- |
| ... | ... | |
| 4151 | 4151 |
-- |
| 4152 | 4152 |
|
| 4153 | 4153 |
ALTER TABLE ONLY plotevent |
| 4154 |
ADD CONSTRAINT plotevent_keys UNIQUE (plot_id, project_id, authorcode);
|
|
| 4154 |
ADD CONSTRAINT plotevent_keys UNIQUE (plot_id, project_id, sourceid);
|
|
| 4155 | 4155 |
|
| 4156 | 4156 |
|
| 4157 | 4157 |
-- |
| ... | ... | |
| 4303 | 4303 |
-- |
| 4304 | 4304 |
|
| 4305 | 4305 |
ALTER TABLE ONLY stem |
| 4306 |
ADD CONSTRAINT stem_keys UNIQUE (individualplant_id, authorcode);
|
|
| 4306 |
ADD CONSTRAINT stem_keys UNIQUE (individualplant_id, sourceid);
|
|
| 4307 | 4307 |
|
| 4308 | 4308 |
|
| 4309 | 4309 |
-- |
Also available in: Unified diff
VegBIEN: Renamed authorcode to sourceid