Revision 6283
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 109 | 109 |
|
| 110 | 110 |
|
| 111 | 111 |
-- |
| 112 |
-- Name: TYPE role; Type: COMMENT; Schema: public; Owner: - |
|
| 113 |
-- |
|
| 114 |
|
|
| 115 |
|
|
| 116 |
|
|
| 117 |
|
|
| 118 |
-- |
|
| 112 | 119 |
-- Name: sourcetype; Type: TYPE; Schema: public; Owner: - |
| 113 | 120 |
-- |
| 114 | 121 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 250 | 250 |
|
| 251 | 251 |
CREATE TYPE role AS ENUM ( |
| 252 | 252 |
'unknown', |
| 253 |
'author', |
|
| 253 | 254 |
'collector', |
| 255 |
'computer', |
|
| 256 |
'contributor', |
|
| 257 |
'custodian/steward', |
|
| 258 |
'editor', |
|
| 254 | 259 |
'identifier', |
| 255 |
'computer', |
|
| 256 |
'contributor' |
|
| 260 |
'originator', |
|
| 261 |
'performer', |
|
| 262 |
'principal investigator', |
|
| 263 |
'recipient', |
|
| 264 |
'reviewer', |
|
| 265 |
'technician' |
|
| 257 | 266 |
); |
| 258 | 267 |
|
| 259 | 268 |
|
| 260 | 269 |
-- |
| 270 |
-- Name: TYPE role; Type: COMMENT; Schema: public; Owner: - |
|
| 271 |
-- |
|
| 272 |
|
|
| 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.'; |
|
| 274 |
|
|
| 275 |
|
|
| 276 |
-- |
|
| 261 | 277 |
-- Name: sourcetype; Type: TYPE; Schema: public; Owner: - |
| 262 | 278 |
-- |
| 263 | 279 |
|
Also available in: Unified diff
schemas/vegbien.sql: role enum: Added VegBank data dictionary values from <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1331&entity=dba_fielddescription¶ms=1331>