Revision 6285
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 250 | 250 |
|
| 251 | 251 |
CREATE TYPE role AS ENUM ( |
| 252 | 252 |
'unknown', |
| 253 |
'advisor', |
|
| 253 | 254 |
'author', |
| 255 |
'co-principal investigator', |
|
| 254 | 256 |
'collector', |
| 255 | 257 |
'computer', |
| 258 |
'contact', |
|
| 256 | 259 |
'contributor', |
| 257 | 260 |
'custodian/steward', |
| 258 | 261 |
'editor', |
| ... | ... | |
| 270 | 273 |
-- Name: TYPE role; Type: COMMENT; Schema: public; Owner: - |
| 271 | 274 |
-- |
| 272 | 275 |
|
| 273 |
COMMENT ON TYPE role IS 'From <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1331&entity=dba_fielddescription¶ms=1331> and misc terms.'; |
|
| 276 |
COMMENT ON TYPE role IS 'From <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1331&entity=dba_fielddescription¶ms=1331>, <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=projectcontributor&entity=dba_tabledescription&where=where_tablename#ROLE_ID>, and misc terms.';
|
|
| 274 | 277 |
|
| 275 | 278 |
|
| 276 | 279 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: role: Added values from projectcontributor.ROLE_ID <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=projectcontributor&entity=dba_tabledescription&where=where_tablename#ROLE_ID>