Revision 11480
Added by Aaron Marcuse-Kubitza about 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 833 | 833 |
`aggregateOrganismObservationID` varchar(255), |
| 834 | 834 |
`individualObservationID` varchar(255), |
| 835 | 835 |
`individualCode` varchar(255), |
| 836 |
`authorStemCode` varchar(255) |
|
| 836 |
`authorStemCode` varchar(255), |
|
| 837 |
row_num int(11) NOT NULL |
|
| 837 | 838 |
); |
| 838 | 839 |
|
| 839 | 840 |
|
| ... | ... | |
| 965 | 966 |
|
| 966 | 967 |
|
| 967 | 968 |
-- |
| 969 |
-- Name: analytical_stem_row_num_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 970 |
-- |
|
| 971 |
|
|
| 972 |
|
|
| 973 |
|
|
| 974 |
|
|
| 975 |
-- |
|
| 976 |
-- Name: analytical_stem_row_num_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 977 |
-- |
|
| 978 |
|
|
| 979 |
|
|
| 980 |
|
|
| 981 |
|
|
| 982 |
-- |
|
| 983 |
-- Name: analytical_stem_row_num_seq; Type: SEQUENCE SET; Schema: public; Owner: - |
|
| 984 |
-- |
|
| 985 |
|
|
| 986 |
|
|
| 987 |
|
|
| 988 |
-- |
|
| 968 | 989 |
-- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 969 | 990 |
-- |
| 970 | 991 |
|
| ... | ... | |
| 3617 | 3638 |
|
| 3618 | 3639 |
|
| 3619 | 3640 |
-- |
| 3641 |
-- Name: row_num; Type: DEFAULT; Schema: public; Owner: - |
|
| 3642 |
-- |
|
| 3643 |
|
|
| 3644 |
|
|
| 3645 |
|
|
| 3646 |
|
|
| 3647 |
-- |
|
| 3620 | 3648 |
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: - |
| 3621 | 3649 |
-- |
| 3622 | 3650 |
|
| ... | ... | |
| 4503 | 4531 |
|
| 4504 | 4532 |
|
| 4505 | 4533 |
-- |
| 4534 |
-- Name: analytical_stem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4535 |
-- |
|
| 4536 |
|
|
| 4537 |
ALTER TABLE analytical_stem |
|
| 4538 |
ADD CONSTRAINT analytical_stem_pkey PRIMARY KEY (row_num); |
|
| 4539 |
|
|
| 4540 |
|
|
| 4541 |
-- |
|
| 4506 | 4542 |
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4507 | 4543 |
-- |
| 4508 | 4544 |
|
Also available in: Unified diff
schemas/vegbien.sql: analytical_stem: added row_num, which can serve as the taxon_observation ID (DwC occurrenceID)