Revision 1036
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 18 | 18 |
|
| 19 | 19 |
|
| 20 | 20 |
-- |
| 21 |
-- Name: methodtraitname_appliesto; Type: TYPE; Schema: public; Owner: - |
|
| 22 |
-- |
|
| 23 |
|
|
| 24 |
|
|
| 25 |
|
|
| 26 |
|
|
| 27 |
-- |
|
| 28 | 21 |
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: - |
| 29 | 22 |
-- |
| 30 | 23 |
|
| ... | ... | |
| 1262 | 1255 |
name text NOT NULL, |
| 1263 | 1256 |
description text, |
| 1264 | 1257 |
accessioncode text, |
| 1258 |
lengthunits text, |
|
| 1265 | 1259 |
mindiameter double precision, |
| 1266 | 1260 |
minheight double precision, |
| 1267 | 1261 |
maxdiameter double precision, |
| ... | ... | |
| 1276 | 1270 |
|
| 1277 | 1271 |
|
| 1278 | 1272 |
-- |
| 1273 |
-- Name: COLUMN method.lengthunits; Type: COMMENT; Schema: public; Owner: - |
|
| 1274 |
-- |
|
| 1275 |
|
|
| 1276 |
|
|
| 1277 |
|
|
| 1278 |
|
|
| 1279 |
-- |
|
| 1279 | 1280 |
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: - |
| 1280 | 1281 |
-- |
| 1281 | 1282 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 18 | 18 |
SET search_path = public, pg_catalog; |
| 19 | 19 |
|
| 20 | 20 |
-- |
| 21 |
-- Name: methodtraitname_appliesto; Type: TYPE; Schema: public; Owner: - |
|
| 22 |
-- |
|
| 23 |
|
|
| 24 |
CREATE TYPE methodtraitname_appliesto AS ENUM ( |
|
| 25 |
'locationevent', |
|
| 26 |
'taxonoccurrence' |
|
| 27 |
); |
|
| 28 |
|
|
| 29 |
|
|
| 30 |
-- |
|
| 31 | 21 |
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: - |
| 32 | 22 |
-- |
| 33 | 23 |
|
| ... | ... | |
| 1451 | 1441 |
name text NOT NULL, |
| 1452 | 1442 |
description text, |
| 1453 | 1443 |
accessioncode text, |
| 1444 |
lengthunits text, |
|
| 1454 | 1445 |
mindiameter double precision, |
| 1455 | 1446 |
minheight double precision, |
| 1456 | 1447 |
maxdiameter double precision, |
| ... | ... | |
| 1465 | 1456 |
|
| 1466 | 1457 |
|
| 1467 | 1458 |
-- |
| 1459 |
-- Name: COLUMN method.lengthunits; Type: COMMENT; Schema: public; Owner: - |
|
| 1460 |
-- |
|
| 1461 |
|
|
| 1462 |
COMMENT ON COLUMN method.lengthunits IS 'Units for all length- or area-related measurements, e.g. m. **Any measurements not in these units must be converted, e.g. ha -> m^2.**'; |
|
| 1463 |
|
|
| 1464 |
|
|
| 1465 |
-- |
|
| 1468 | 1466 |
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: - |
| 1469 | 1467 |
-- |
| 1470 | 1468 |
|
Also available in: Unified diff
vegbien.sql: method: Added lengthunits field