Revision 5859
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1584 | 1584 |
|
| 1585 | 1585 |
|
| 1586 | 1586 |
-- |
| 1587 |
-- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1588 |
-- |
|
| 1589 |
|
|
| 1590 |
CREATE TABLE coordinates ( |
|
| 1591 |
coordinates_id int(11) NOT NULL, |
|
| 1592 |
creator_id int(11) NOT NULL, |
|
| 1593 |
latitude_deg double precision NOT NULL, |
|
| 1594 |
longitude_deg double precision NOT NULL, |
|
| 1595 |
verbatimlatitude text, |
|
| 1596 |
verbatimlongitude text, |
|
| 1597 |
verbatimcoordinates text, |
|
| 1598 |
footprintgeometry_dwc text, |
|
| 1599 |
coordsaccuracy_deg double precision |
|
| 1600 |
); |
|
| 1601 |
|
|
| 1602 |
|
|
| 1603 |
-- |
|
| 1604 |
-- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: - |
|
| 1605 |
-- |
|
| 1606 |
|
|
| 1607 |
|
|
| 1608 |
|
|
| 1609 |
|
|
| 1610 |
-- |
|
| 1611 |
-- Name: COLUMN coordinates.coordsaccuracy_deg; Type: COMMENT; Schema: public; Owner: - |
|
| 1612 |
-- |
|
| 1613 |
|
|
| 1614 |
|
|
| 1615 |
|
|
| 1616 |
|
|
| 1617 |
-- |
|
| 1618 |
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1619 |
-- |
|
| 1620 |
|
|
| 1621 |
|
|
| 1622 |
|
|
| 1623 |
|
|
| 1624 |
-- |
|
| 1625 |
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1626 |
-- |
|
| 1627 |
|
|
| 1628 |
|
|
| 1629 |
|
|
| 1630 |
|
|
| 1631 |
-- |
|
| 1587 | 1632 |
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1588 | 1633 |
-- |
| 1589 | 1634 |
|
| ... | ... | |
| 2973 | 3018 |
|
| 2974 | 3019 |
|
| 2975 | 3020 |
-- |
| 3021 |
-- Name: coordinates_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3022 |
-- |
|
| 3023 |
|
|
| 3024 |
|
|
| 3025 |
|
|
| 3026 |
|
|
| 3027 |
-- |
|
| 2976 | 3028 |
-- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: - |
| 2977 | 3029 |
-- |
| 2978 | 3030 |
|
| ... | ... | |
| 3421 | 3473 |
|
| 3422 | 3474 |
|
| 3423 | 3475 |
-- |
| 3476 |
-- Name: coordinates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3477 |
-- |
|
| 3478 |
|
|
| 3479 |
ALTER TABLE coordinates |
|
| 3480 |
ADD CONSTRAINT coordinates_pkey PRIMARY KEY (coordinates_id); |
|
| 3481 |
|
|
| 3482 |
|
|
| 3483 |
-- |
|
| 3424 | 3484 |
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3425 | 3485 |
-- |
| 3426 | 3486 |
|
| ... | ... | |
| 3950 | 4010 |
|
| 3951 | 4011 |
|
| 3952 | 4012 |
-- |
| 4013 |
-- Name: coordinates_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4014 |
-- |
|
| 4015 |
|
|
| 4016 |
|
|
| 4017 |
|
|
| 4018 |
|
|
| 4019 |
-- |
|
| 3953 | 4020 |
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3954 | 4021 |
-- |
| 3955 | 4022 |
|
| ... | ... | |
| 4660 | 4727 |
|
| 4661 | 4728 |
|
| 4662 | 4729 |
-- |
| 4730 |
-- Name: coordinates_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4731 |
-- |
|
| 4732 |
|
|
| 4733 |
|
|
| 4734 |
|
|
| 4735 |
|
|
| 4736 |
-- |
|
| 4663 | 4737 |
-- Name: coverindex_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4664 | 4738 |
-- |
| 4665 | 4739 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added coordinates table