Revision 11476
Added by Aaron Marcuse-Kubitza about 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1428 | 1428 |
|
| 1429 | 1429 |
|
| 1430 | 1430 |
-- |
| 1431 |
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1432 |
-- |
|
| 1433 |
|
|
| 1434 |
CREATE TABLE stratum ( |
|
| 1435 |
stratum_id int(11) NOT NULL, |
|
| 1436 |
source_id int(11) NOT NULL, |
|
| 1437 |
stratumname varchar(255) NOT NULL, |
|
| 1438 |
stratumheight double precision, |
|
| 1439 |
stratumbase double precision, |
|
| 1440 |
stratumcover double precision, |
|
| 1441 |
area double precision, |
|
| 1442 |
method_id int(11) |
|
| 1443 |
); |
|
| 1444 |
|
|
| 1445 |
|
|
| 1446 |
-- |
|
| 1447 |
-- Name: plot.**; Type: VIEW; Schema: public; Owner: - |
|
| 1448 |
-- |
|
| 1449 |
|
|
| 1450 |
|
|
| 1451 |
|
|
| 1452 |
|
|
| 1453 |
-- |
|
| 1431 | 1454 |
-- Name: sourcelist; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1432 | 1455 |
-- |
| 1433 | 1456 |
|
| ... | ... | |
| 1517 | 1540 |
|
| 1518 | 1541 |
|
| 1519 | 1542 |
-- |
| 1520 |
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1521 |
-- |
|
| 1522 |
|
|
| 1523 |
CREATE TABLE stratum ( |
|
| 1524 |
stratum_id int(11) NOT NULL, |
|
| 1525 |
source_id int(11) NOT NULL, |
|
| 1526 |
stratumname varchar(255) NOT NULL, |
|
| 1527 |
stratumheight double precision, |
|
| 1528 |
stratumbase double precision, |
|
| 1529 |
stratumcover double precision, |
|
| 1530 |
area double precision, |
|
| 1531 |
method_id int(11) |
|
| 1532 |
); |
|
| 1533 |
|
|
| 1534 |
|
|
| 1535 |
-- |
|
| 1536 | 1543 |
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1537 | 1544 |
-- |
| 1538 | 1545 |
|
| ... | ... | |
| 2760 | 2767 |
|
| 2761 | 2768 |
|
| 2762 | 2769 |
-- |
| 2763 |
-- Name: plot.**; Type: VIEW; Schema: public; Owner: - |
|
| 2764 |
-- |
|
| 2765 |
|
|
| 2766 |
|
|
| 2767 |
|
|
| 2768 |
|
|
| 2769 |
-- |
|
| 2770 | 2770 |
-- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2771 | 2771 |
-- |
| 2772 | 2772 |
|
| ... | ... | |
| 7522 | 7522 |
|
| 7523 | 7523 |
|
| 7524 | 7524 |
-- |
| 7525 |
-- Name: sourcelist; Type: ACL; Schema: public; Owner: -
|
|
| 7525 |
-- Name: stratum; Type: ACL; Schema: public; Owner: -
|
|
| 7526 | 7526 |
-- |
| 7527 | 7527 |
|
| 7528 | 7528 |
|
| ... | ... | |
| 7532 | 7532 |
|
| 7533 | 7533 |
|
| 7534 | 7534 |
-- |
| 7535 |
-- Name: specimenreplicate; Type: ACL; Schema: public; Owner: -
|
|
| 7535 |
-- Name: plot.**; Type: ACL; Schema: public; Owner: -
|
|
| 7536 | 7536 |
-- |
| 7537 | 7537 |
|
| 7538 | 7538 |
|
| ... | ... | |
| 7542 | 7542 |
|
| 7543 | 7543 |
|
| 7544 | 7544 |
-- |
| 7545 |
-- Name: stemobservation; Type: ACL; Schema: public; Owner: -
|
|
| 7545 |
-- Name: sourcelist; Type: ACL; Schema: public; Owner: -
|
|
| 7546 | 7546 |
-- |
| 7547 | 7547 |
|
| 7548 | 7548 |
|
| ... | ... | |
| 7552 | 7552 |
|
| 7553 | 7553 |
|
| 7554 | 7554 |
-- |
| 7555 |
-- Name: stratum; Type: ACL; Schema: public; Owner: -
|
|
| 7555 |
-- Name: specimenreplicate; Type: ACL; Schema: public; Owner: -
|
|
| 7556 | 7556 |
-- |
| 7557 | 7557 |
|
| 7558 | 7558 |
|
| ... | ... | |
| 7562 | 7562 |
|
| 7563 | 7563 |
|
| 7564 | 7564 |
-- |
| 7565 |
-- Name: stemobservation; Type: ACL; Schema: public; Owner: - |
|
| 7566 |
-- |
|
| 7567 |
|
|
| 7568 |
|
|
| 7569 |
|
|
| 7570 |
|
|
| 7571 |
|
|
| 7572 |
|
|
| 7573 |
|
|
| 7574 |
-- |
|
| 7565 | 7575 |
-- Name: taxondetermination; Type: ACL; Schema: public; Owner: - |
| 7566 | 7576 |
-- |
| 7567 | 7577 |
|
| ... | ... | |
| 7893 | 7903 |
|
| 7894 | 7904 |
|
| 7895 | 7905 |
-- |
| 7896 |
-- Name: plot.**; Type: ACL; Schema: public; Owner: - |
|
| 7897 |
-- |
|
| 7898 |
|
|
| 7899 |
|
|
| 7900 |
|
|
| 7901 |
|
|
| 7902 |
|
|
| 7903 |
|
|
| 7904 |
|
|
| 7905 |
-- |
|
| 7906 | 7906 |
-- Name: projectcontributor; Type: ACL; Schema: public; Owner: - |
| 7907 | 7907 |
-- |
| 7908 | 7908 |
|
Also available in: Unified diff
schemas/vegbien.sql: analytical_stem_view: use plot.** to obtain plot-related fields, so that the same code does not need to be maintained in both analytical_stem_view and plot.**