Revision 575
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), |
|
| 1127 |
authorlocationcode character varying(30) DEFAULT ''::character varying NOT NULL,
|
|
| 1128 | 1128 |
reference_id integer, |
| 1129 | 1129 |
parent_id integer, |
| 1130 | 1130 |
reallatitude double precision, |
| 1131 | 1131 |
reallongitude double precision, |
| 1132 | 1132 |
locationaccuracy double precision, |
| 1133 |
confidentialitystatus integer NOT NULL, |
|
| 1133 |
confidentialitystatus integer DEFAULT 0 NOT NULL,
|
|
| 1134 | 1134 |
confidentialityreason character varying(200), |
| 1135 |
latitude double precision, |
|
| 1136 |
longitude double precision, |
|
| 1135 |
latitude double precision DEFAULT 'NaN'::double precision NOT NULL,
|
|
| 1136 |
longitude double precision DEFAULT 'NaN'::double precision NOT NULL,
|
|
| 1137 | 1137 |
authore character varying(20), |
| 1138 | 1138 |
authorn character varying(20), |
| 1139 | 1139 |
authorzone character varying(20), |
| ... | ... | |
| 1773 | 1773 |
plantstatus_id integer NOT NULL, |
| 1774 | 1774 |
plantconcept_id integer NOT NULL, |
| 1775 | 1775 |
reference_id integer, |
| 1776 |
plantconceptstatus character varying(20) NOT NULL, |
|
| 1776 |
plantconceptstatus character varying(20) DEFAULT 'undetermined'::character varying NOT NULL,
|
|
| 1777 | 1777 |
plantpartycomments text, |
| 1778 | 1778 |
plantparentname character varying(200), |
| 1779 | 1779 |
plantparentconcept_id integer, |
| 1780 | 1780 |
plantparent_id integer, |
| 1781 | 1781 |
plantlevel character varying(80), |
| 1782 |
party_id integer NOT NULL,
|
|
| 1783 |
startdate timestamp with time zone NOT NULL,
|
|
| 1782 |
party_id integer, |
|
| 1783 |
startdate timestamp with time zone, |
|
| 1784 | 1784 |
stopdate timestamp with time zone, |
| 1785 | 1785 |
accessioncode character varying(255) |
| 1786 | 1786 |
); |
| ... | ... | |
| 2515 | 2515 |
taxondetermination_id integer NOT NULL, |
| 2516 | 2516 |
taxonoccurrence_id integer NOT NULL, |
| 2517 | 2517 |
plantconcept_id integer NOT NULL, |
| 2518 |
party_id integer NOT NULL,
|
|
| 2518 |
party_id integer, |
|
| 2519 | 2519 |
role_id integer NOT NULL, |
| 2520 | 2520 |
determinationtype character varying(30), |
| 2521 | 2521 |
reference_id integer, |
| 2522 |
originaldetermination boolean NOT NULL, |
|
| 2523 |
currentdetermination boolean NOT NULL, |
|
| 2522 |
originaldetermination boolean DEFAULT false NOT NULL,
|
|
| 2523 |
currentdetermination boolean DEFAULT false NOT NULL,
|
|
| 2524 | 2524 |
taxonfit character varying(50), |
| 2525 | 2525 |
taxonconfidence character varying(50), |
| 2526 | 2526 |
grouptype character varying(20), |
Also available in: Unified diff
vegbien.sql: Made several fields optional, adding defaults where needed