Project

General

Profile

« Previous | Next » 

Revision 6152

schemas/vegbien.sql: referencetype: Added terms from reference.referencetype closed list in VegBank data dictionary. Cited sources in comment.

View differences:

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&params=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