Project

General

Profile

« Previous | Next » 

Revision 1034

vegbien.sql: method, plotmethod: Added comments to fields

View differences:

schemas/vegbien.my.sql
1276 1276

  
1277 1277

  
1278 1278
--
1279
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
1280
--
1281

  
1282

  
1283

  
1284

  
1285
--
1286
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
1287
--
1288

  
1289

  
1290

  
1291

  
1292
--
1293
-- Name: COLUMN method.observationmeasureunits; Type: COMMENT; Schema: public; Owner: -
1294
--
1295

  
1296

  
1297

  
1298

  
1299
--
1300
-- Name: COLUMN method.taxonclassincluded; Type: COMMENT; Schema: public; Owner: -
1301
--
1302

  
1303

  
1304

  
1305

  
1306
--
1307
-- Name: COLUMN method.taxonclassexcluded; Type: COMMENT; Schema: public; Owner: -
1308
--
1309

  
1310

  
1311

  
1312

  
1313
--
1279 1314
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1280 1315
--
1281 1316

  
......
1794 1829

  
1795 1830

  
1796 1831
--
1832
-- Name: COLUMN plotmethod.name; Type: COMMENT; Schema: public; Owner: -
1833
--
1834

  
1835

  
1836

  
1837

  
1838
--
1839
-- Name: COLUMN plotmethod.shape; Type: COMMENT; Schema: public; Owner: -
1840
--
1841

  
1842

  
1843

  
1844

  
1845
--
1797 1846
-- Name: plotmethod_plotmethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1798 1847
--
1799 1848

  
schemas/vegbien.sql
1465 1465

  
1466 1466

  
1467 1467
--
1468
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
1469
--
1470

  
1471
COMMENT ON COLUMN method.observationtype IS 'values: aggregate, individual, both';
1472

  
1473

  
1474
--
1475
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
1476
--
1477

  
1478
COMMENT ON COLUMN method.observationmeasure IS 'e.g. count, cover, presence, points-intercepted, distance-intercepted';
1479

  
1480

  
1481
--
1482
-- Name: COLUMN method.observationmeasureunits; Type: COMMENT; Schema: public; Owner: -
1483
--
1484

  
1485
COMMENT ON COLUMN method.observationmeasureunits IS 'e.g. percent, individual, cm, m';
1486

  
1487

  
1488
--
1489
-- Name: COLUMN method.taxonclassincluded; Type: COMMENT; Schema: public; Owner: -
1490
--
1491

  
1492
COMMENT ON COLUMN method.taxonclassincluded IS 'e.g. tree, shrub, liana, vine, herb, hemiepiphyte, epiphyte, grass, forb';
1493

  
1494

  
1495
--
1496
-- Name: COLUMN method.taxonclassexcluded; Type: COMMENT; Schema: public; Owner: -
1497
--
1498

  
1499
COMMENT ON COLUMN method.taxonclassexcluded IS 'e.g. tree, shrub, liana, vine, herb, hemiepiphyte, epiphyte, grass, forb';
1500

  
1501

  
1502
--
1468 1503
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1469 1504
--
1470 1505

  
......
2068 2103

  
2069 2104

  
2070 2105
--
2106
-- Name: COLUMN plotmethod.name; Type: COMMENT; Schema: public; Owner: -
2107
--
2108

  
2109
COMMENT ON COLUMN plotmethod.name IS 'e.g. "1 ha treeplot". "0.1 ha transect", "line-intercept plot", "point centered quarter"';
2110

  
2111

  
2112
--
2113
-- Name: COLUMN plotmethod.shape; Type: COMMENT; Schema: public; Owner: -
2114
--
2115

  
2116
COMMENT ON COLUMN plotmethod.shape IS 'e.g. square, rectangle, circle, line, point, other';
2117

  
2118

  
2119
--
2071 2120
-- Name: plotmethod_plotmethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2072 2121
--
2073 2122

  

Also available in: Unified diff