Revision 580
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.for_ERD.sql | ||
|---|---|---|
| 114 | 114 |
authorlocationcode character varying(30) NOT NULL DEFAULT ''::character varying, |
| 115 | 115 |
reference_id integer, |
| 116 | 116 |
parent_id integer, |
| 117 |
reallatitude double precision, |
|
| 118 |
reallongitude double precision, |
|
| 117 |
reallatitude double precision NOT NULL DEFAULT 'NaN'::double precision,
|
|
| 118 |
reallongitude double precision NOT NULL DEFAULT 'NaN'::double precision,
|
|
| 119 | 119 |
locationaccuracy double precision, |
| 120 | 120 |
confidentialitystatus integer NOT NULL DEFAULT 0, |
| 121 | 121 |
confidentialityreason character varying(200), |
| 122 |
latitude double precision, |
|
| 123 |
longitude double precision, |
|
| 122 |
publiclatitude double precision,
|
|
| 123 |
publiclongitude double precision,
|
|
| 124 | 124 |
"... (truncated) ..." integer, |
| 125 | 125 |
accessioncode character varying(255), |
| 126 | 126 |
sublocationxposition double precision, |
Also available in: Unified diff
vegbien.sql: Renamed location.latitude and longitude to publiclatitude, publiclongitude to reflect that they are not the actual lat/long. Switched to requiring reallatitude/reallongitude.