Revision 6152
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 96 | 96 |
|
| 97 | 97 |
|
| 98 | 98 |
-- |
| 99 |
-- Name: TYPE referencetype; Type: COMMENT; Schema: public; Owner: - |
|
| 100 |
-- |
|
| 101 |
|
|
| 102 |
|
|
| 103 |
|
|
| 104 |
|
|
| 105 |
-- |
|
| 99 | 106 |
-- Name: relationship; Type: TYPE; Schema: public; Owner: - |
| 100 | 107 |
-- |
| 101 | 108 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 220 | 220 |
'herbarium', |
| 221 | 221 |
'primary database', |
| 222 | 222 |
'aggregator', |
| 223 |
'website', |
|
| 224 |
'journal', |
|
| 225 | 223 |
'book', |
| 224 |
'article', |
|
| 225 |
'chapter', |
|
| 226 |
'conference proceedings', |
|
| 226 | 227 |
'dissertation', |
| 228 |
'edited book', |
|
| 229 |
'generic', |
|
| 230 |
'journal', |
|
| 231 |
'manuscript', |
|
| 232 |
'personal communication', |
|
| 233 |
'presentation', |
|
| 234 |
'report', |
|
| 227 | 235 |
'thesis', |
| 228 |
'report', |
|
| 229 |
'article' |
|
| 236 |
'website' |
|
| 230 | 237 |
); |
| 231 | 238 |
|
| 232 | 239 |
|
| 233 | 240 |
-- |
| 241 |
-- Name: TYPE referencetype; Type: COMMENT; Schema: public; Owner: - |
|
| 242 |
-- |
|
| 243 |
|
|
| 244 |
COMMENT ON TYPE referencetype IS 'From <https://projects.nceas.ucsb.edu/nceas/attachments/download/428/bien_web_datasource_schema.sql>, <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1300&entity=dba_fielddescription¶ms=1300>, <http://vegbiendev.nceas.ucsb.edu/phppgadmin/display.php?server=localhost%3A5432%3Aallow&database=vegbien&schema=VegBank&table=reference&subject=table#referencetype>'; |
|
| 245 |
|
|
| 246 |
|
|
| 247 |
-- |
|
| 234 | 248 |
-- Name: relationship; Type: TYPE; Schema: public; Owner: - |
| 235 | 249 |
-- |
| 236 | 250 |
|
Also available in: Unified diff
schemas/vegbien.sql: referencetype: Added terms from reference.referencetype closed list in VegBank data dictionary. Cited sources in comment.