Revision 582
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.sql | ||
|---|---|---|
| 1124 | 1124 |
|
| 1125 | 1125 |
CREATE TABLE location ( |
| 1126 | 1126 |
location_id integer NOT NULL, |
| 1127 |
authorlocationcode character varying(30) DEFAULT ''::character varying NOT NULL,
|
|
| 1127 |
authorlocationcode character varying(30), |
|
| 1128 | 1128 |
reference_id integer, |
| 1129 | 1129 |
parent_id integer, |
| 1130 |
reallatitude double precision DEFAULT 'NaN'::double precision NOT NULL,
|
|
| 1131 |
reallongitude double precision DEFAULT 'NaN'::double precision NOT NULL,
|
|
| 1130 |
reallatitude double precision, |
|
| 1131 |
reallongitude double precision, |
|
| 1132 | 1132 |
locationaccuracy double precision, |
| 1133 | 1133 |
confidentialitystatus integer DEFAULT 0 NOT NULL, |
| 1134 | 1134 |
confidentialityreason character varying(200), |
| ... | ... | |
| 4051 | 4051 |
|
| 4052 | 4052 |
|
| 4053 | 4053 |
-- |
| 4054 |
-- Name: location_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4054 |
-- Name: location_keys_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4055 | 4055 |
-- |
| 4056 | 4056 |
|
| 4057 | 4057 |
ALTER TABLE ONLY location |
| 4058 |
ADD CONSTRAINT location_keys UNIQUE (reference_id, authorlocationcode, reallatitude, reallongitude);
|
|
| 4058 |
ADD CONSTRAINT location_keys_code UNIQUE (reference_id, authorlocationcode);
|
|
| 4059 | 4059 |
|
| 4060 | 4060 |
|
| 4061 | 4061 |
-- |
| 4062 |
-- Name: location_keys_subplot; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4062 |
-- Name: location_keys_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4063 | 4063 |
-- |
| 4064 | 4064 |
|
| 4065 | 4065 |
ALTER TABLE ONLY location |
| 4066 |
ADD CONSTRAINT location_keys_subplot UNIQUE (parent_id, authorlocationcode, reallatitude, reallongitude);
|
|
| 4066 |
ADD CONSTRAINT location_keys_coords UNIQUE (reference_id, reallatitude, reallongitude);
|
|
| 4067 | 4067 |
|
| 4068 | 4068 |
|
| 4069 | 4069 |
-- |
| 4070 |
-- Name: location_keys_subplot_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4071 |
-- |
|
| 4072 |
|
|
| 4073 |
ALTER TABLE ONLY location |
|
| 4074 |
ADD CONSTRAINT location_keys_subplot_code UNIQUE (parent_id, authorlocationcode); |
|
| 4075 |
|
|
| 4076 |
|
|
| 4077 |
-- |
|
| 4078 |
-- Name: location_keys_subplot_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4079 |
-- |
|
| 4080 |
|
|
| 4081 |
ALTER TABLE ONLY location |
|
| 4082 |
ADD CONSTRAINT location_keys_subplot_coords UNIQUE (parent_id, sublocationxposition, sublocationyposition); |
|
| 4083 |
|
|
| 4084 |
|
|
| 4085 |
-- |
|
| 4070 | 4086 |
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4071 | 4087 |
-- |
| 4072 | 4088 |
|
Also available in: Unified diff
vegbien.sql: Do location duplicate elimination independently on code or lat/long, allowing duplicate entries with NULLs to exist when a location is incompletely specified