Revision 6085
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 3251 | 3251 |
|
| 3252 | 3252 |
|
| 3253 | 3253 |
-- |
| 3254 |
-- Name: threatened_taxonlabel; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3255 |
-- |
|
| 3256 |
|
|
| 3257 |
CREATE TABLE threatened_taxonlabel ( |
|
| 3258 |
taxonlabel_id int(11) NOT NULL |
|
| 3259 |
); |
|
| 3260 |
|
|
| 3261 |
|
|
| 3262 |
-- |
|
| 3263 |
-- Name: threatened_taxonlabel_view; Type: VIEW; Schema: public; Owner: - |
|
| 3264 |
-- |
|
| 3265 |
|
|
| 3266 |
|
|
| 3267 |
|
|
| 3268 |
|
|
| 3269 |
-- |
|
| 3254 | 3270 |
-- Name: tnrs_input_name; Type: VIEW; Schema: public; Owner: - |
| 3255 | 3271 |
-- |
| 3256 | 3272 |
|
| ... | ... | |
| 4165 | 4181 |
|
| 4166 | 4182 |
|
| 4167 | 4183 |
-- |
| 4184 |
-- Data for Name: threatened_taxonlabel; Type: TABLE DATA; Schema: public; Owner: - |
|
| 4185 |
-- |
|
| 4186 |
|
|
| 4187 |
|
|
| 4188 |
|
|
| 4189 |
-- |
|
| 4168 | 4190 |
-- Data for Name: trait; Type: TABLE DATA; Schema: public; Owner: - |
| 4169 | 4191 |
-- |
| 4170 | 4192 |
|
| ... | ... | |
| 4751 | 4773 |
|
| 4752 | 4774 |
|
| 4753 | 4775 |
-- |
| 4776 |
-- Name: threatened_taxonlabel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4777 |
-- |
|
| 4778 |
|
|
| 4779 |
ALTER TABLE threatened_taxonlabel |
|
| 4780 |
ADD CONSTRAINT threatened_taxonlabel_pkey PRIMARY KEY (taxonlabel_id); |
|
| 4781 |
|
|
| 4782 |
|
|
| 4783 |
-- |
|
| 4754 | 4784 |
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4755 | 4785 |
-- |
| 4756 | 4786 |
|
| ... | ... | |
| 6270 | 6300 |
|
| 6271 | 6301 |
|
| 6272 | 6302 |
-- |
| 6303 |
-- Name: threatened_taxonlabel_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6304 |
-- |
|
| 6305 |
|
|
| 6306 |
|
|
| 6307 |
|
|
| 6308 |
|
|
| 6309 |
-- |
|
| 6273 | 6310 |
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6274 | 6311 |
-- |
| 6275 | 6312 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added threatened_taxonlabel derived table with generating view threatened_taxonlabel_view