Revision 5617
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 103 | 103 |
|
| 104 | 104 |
|
| 105 | 105 |
-- |
| 106 |
-- Name: taxonomic_status; Type: TYPE; Schema: public; Owner: - |
|
| 107 |
-- |
|
| 108 |
|
|
| 109 |
|
|
| 110 |
|
|
| 111 |
|
|
| 112 |
-- |
|
| 106 | 113 |
-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: - |
| 107 | 114 |
-- |
| 108 | 115 |
|
| ... | ... | |
| 200 | 207 |
sourceaccessioncode text, |
| 201 | 208 |
concept_reference_id int(11), |
| 202 | 209 |
creationdate date, |
| 210 |
taxonstatus text, |
|
| 203 | 211 |
accepted_label_id int(11), |
| 204 | 212 |
matched_label_id int(11), |
| 205 | 213 |
matched_label_fit_fraction double precision, |
| schemas/vegbien.sql | ||
|---|---|---|
| 29 | 29 |
-- Name: TYPE establishmentmeans_dwc; Type: COMMENT; Schema: public; Owner: - |
| 30 | 30 |
-- |
| 31 | 31 |
|
| 32 |
COMMENT ON TYPE establishmentmeans_dwc IS 'See http://rs.tdwg.org/dwc/terms/#establishmentMeans';
|
|
| 32 |
COMMENT ON TYPE establishmentmeans_dwc IS 'See http://tnrs.iplantcollaborative.org/instructions.html#Status';
|
|
| 33 | 33 |
|
| 34 | 34 |
|
| 35 | 35 |
-- |
| ... | ... | |
| 250 | 250 |
|
| 251 | 251 |
|
| 252 | 252 |
-- |
| 253 |
-- Name: taxonomic_status; Type: TYPE; Schema: public; Owner: - |
|
| 254 |
-- |
|
| 255 |
|
|
| 256 |
CREATE TYPE taxonomic_status AS ENUM ( |
|
| 257 |
'No opinion', |
|
| 258 |
'Accepted', |
|
| 259 |
'Synonym', |
|
| 260 |
'Illegitimate', |
|
| 261 |
'Invalid' |
|
| 262 |
); |
|
| 263 |
|
|
| 264 |
|
|
| 265 |
-- |
|
| 253 | 266 |
-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: - |
| 254 | 267 |
-- |
| 255 | 268 |
|
| ... | ... | |
| 499 | 512 |
sourceaccessioncode text, |
| 500 | 513 |
concept_reference_id integer, |
| 501 | 514 |
creationdate date, |
| 515 |
taxonstatus taxonomic_status, |
|
| 502 | 516 |
accepted_label_id integer, |
| 503 | 517 |
matched_label_id integer, |
| 504 | 518 |
matched_label_fit_fraction double precision, |
Also available in: Unified diff
schemas/vegbien.sql: taxonlabel: Added taxonstatus, with taxonomic_status enum