Revision 544
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.for_ERD.my.sql | ||
|---|---|---|
| 255 | 255 |
CONSTRAINT specimen_keys UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc ) |
| 256 | 256 |
); |
| 257 | 257 |
|
| 258 |
CREATE TABLE voucher |
|
| 259 |
( |
|
| 260 |
voucher_id int(11) NOT NULL AUTO_INCREMENT, |
|
| 261 |
taxonoccurrence_id int(11), |
|
| 262 |
specimen_id int(11), |
|
| 263 |
accessioncode character varying(255), |
|
| 264 |
CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id ), |
|
| 265 |
CONSTRAINT voucher_specimen_id FOREIGN KEY (specimen_id) |
|
| 266 |
REFERENCES specimen (specimen_id) MATCH SIMPLE |
|
| 267 |
ON UPDATE CASCADE ON DELETE CASCADE, |
|
| 268 |
CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) |
|
| 269 |
REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE |
|
| 270 |
ON UPDATE CASCADE ON DELETE CASCADE, |
|
| 271 |
CONSTRAINT voucher_keys UNIQUE (taxonoccurrence_id , specimen_id ) |
|
| 272 |
); |
|
| 273 |
|
|
| 258 | 274 |
CREATE TABLE taxondetermination -- VegBank's taxoninterpretation table. |
| 259 | 275 |
( |
| 260 | 276 |
taxondetermination_id int(11) NOT NULL AUTO_INCREMENT, |
| schemas/vegbien.for_wiki.sql | ||
|---|---|---|
| 100 | 100 |
taxonoccurrence_id integer, |
| 101 | 101 |
); |
| 102 | 102 |
|
| 103 |
CREATE TABLE voucher |
|
| 104 |
( |
|
| 105 |
voucher_id serial NOT NULL, |
|
| 106 |
taxonoccurrence_id integer, |
|
| 107 |
specimen_id integer, |
|
| 108 |
accessioncode character varying(255), |
|
| 109 |
); |
|
| 110 |
|
|
| 103 | 111 |
CREATE TABLE taxondetermination -- VegBank's taxoninterpretation table. |
| 104 | 112 |
( |
| 105 | 113 |
taxondetermination_id serial NOT NULL, |
| schemas/vegbien_empty.sql | ||
|---|---|---|
| 83 | 83 |
TRUNCATE userrecordowner CASCADE; |
| 84 | 84 |
TRUNCATE userregionalexp CASCADE; |
| 85 | 85 |
TRUNCATE usr CASCADE; |
| 86 |
TRUNCATE voucher CASCADE; |
|
| schemas/vegbien.for_ERD.sql | ||
|---|---|---|
| 255 | 255 |
CONSTRAINT specimen_keys UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc ) |
| 256 | 256 |
); |
| 257 | 257 |
|
| 258 |
CREATE TABLE voucher |
|
| 259 |
( |
|
| 260 |
voucher_id serial NOT NULL, |
|
| 261 |
taxonoccurrence_id integer, |
|
| 262 |
specimen_id integer, |
|
| 263 |
accessioncode character varying(255), |
|
| 264 |
CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id ), |
|
| 265 |
CONSTRAINT voucher_specimen_id FOREIGN KEY (specimen_id) |
|
| 266 |
REFERENCES specimen (specimen_id) MATCH SIMPLE |
|
| 267 |
ON UPDATE CASCADE ON DELETE CASCADE, |
|
| 268 |
CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) |
|
| 269 |
REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE |
|
| 270 |
ON UPDATE CASCADE ON DELETE CASCADE, |
|
| 271 |
CONSTRAINT voucher_keys UNIQUE (taxonoccurrence_id , specimen_id ) |
|
| 272 |
); |
|
| 273 |
|
|
| 258 | 274 |
CREATE TABLE taxondetermination -- VegBank's taxoninterpretation table. |
| 259 | 275 |
( |
| 260 | 276 |
taxondetermination_id serial NOT NULL, |
| schemas/vegbien.sql | ||
|---|---|---|
| 3155 | 3155 |
ALTER SEQUENCE usr_usr_id_seq OWNED BY usr.usr_id; |
| 3156 | 3156 |
|
| 3157 | 3157 |
|
| 3158 |
SET default_with_oids = false; |
|
| 3159 |
|
|
| 3158 | 3160 |
-- |
| 3161 |
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3162 |
-- |
|
| 3163 |
|
|
| 3164 |
CREATE TABLE voucher ( |
|
| 3165 |
voucher_id integer NOT NULL, |
|
| 3166 |
taxonoccurrence_id integer, |
|
| 3167 |
specimen_id integer, |
|
| 3168 |
accessioncode character varying(255) |
|
| 3169 |
); |
|
| 3170 |
|
|
| 3171 |
|
|
| 3172 |
-- |
|
| 3173 |
-- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3174 |
-- |
|
| 3175 |
|
|
| 3176 |
CREATE SEQUENCE voucher_voucher_id_seq |
|
| 3177 |
START WITH 1 |
|
| 3178 |
INCREMENT BY 1 |
|
| 3179 |
NO MINVALUE |
|
| 3180 |
NO MAXVALUE |
|
| 3181 |
CACHE 1; |
|
| 3182 |
|
|
| 3183 |
|
|
| 3184 |
-- |
|
| 3185 |
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3186 |
-- |
|
| 3187 |
|
|
| 3188 |
ALTER SEQUENCE voucher_voucher_id_seq OWNED BY voucher.voucher_id; |
|
| 3189 |
|
|
| 3190 |
|
|
| 3191 |
-- |
|
| 3159 | 3192 |
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: - |
| 3160 | 3193 |
-- |
| 3161 | 3194 |
|
| ... | ... | |
| 3716 | 3749 |
|
| 3717 | 3750 |
|
| 3718 | 3751 |
-- |
| 3752 |
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3753 |
-- |
|
| 3754 |
|
|
| 3755 |
ALTER TABLE voucher ALTER COLUMN voucher_id SET DEFAULT nextval('voucher_voucher_id_seq'::regclass);
|
|
| 3756 |
|
|
| 3757 |
|
|
| 3758 |
-- |
|
| 3719 | 3759 |
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3720 | 3760 |
-- |
| 3721 | 3761 |
|
| ... | ... | |
| 4500 | 4540 |
|
| 4501 | 4541 |
|
| 4502 | 4542 |
-- |
| 4543 |
-- Name: voucher_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4544 |
-- |
|
| 4545 |
|
|
| 4546 |
ALTER TABLE ONLY voucher |
|
| 4547 |
ADD CONSTRAINT voucher_keys UNIQUE (taxonoccurrence_id, specimen_id); |
|
| 4548 |
|
|
| 4549 |
|
|
| 4550 |
-- |
|
| 4551 |
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4552 |
-- |
|
| 4553 |
|
|
| 4554 |
ALTER TABLE ONLY voucher |
|
| 4555 |
ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id); |
|
| 4556 |
|
|
| 4557 |
|
|
| 4558 |
-- |
|
| 4503 | 4559 |
-- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4504 | 4560 |
-- |
| 4505 | 4561 |
|
| ... | ... | |
| 6658 | 6714 |
|
| 6659 | 6715 |
|
| 6660 | 6716 |
-- |
| 6717 |
-- Name: voucher_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6718 |
-- |
|
| 6719 |
|
|
| 6720 |
ALTER TABLE ONLY voucher |
|
| 6721 |
ADD CONSTRAINT voucher_specimen_id FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6722 |
|
|
| 6723 |
|
|
| 6724 |
-- |
|
| 6725 |
-- Name: voucher_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6726 |
-- |
|
| 6727 |
|
|
| 6728 |
ALTER TABLE ONLY voucher |
|
| 6729 |
ADD CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6730 |
|
|
| 6731 |
|
|
| 6732 |
-- |
|
| 6661 | 6733 |
-- PostgreSQL database dump complete |
| 6662 | 6734 |
-- |
| 6663 | 6735 |
|
Also available in: Unified diff
vegbien.sql: Added voucher table