Revision 5610
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2516 | 2516 |
|
| 2517 | 2517 |
|
| 2518 | 2518 |
-- |
| 2519 |
-- Name: taxonusage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2520 |
-- |
|
| 2521 |
|
|
| 2522 |
CREATE TABLE taxonusage ( |
|
| 2523 |
taxonusage_id int(11) NOT NULL, |
|
| 2524 |
taxonlabel_id int(11) NOT NULL, |
|
| 2525 |
taxonstatus text, |
|
| 2526 |
taxon text, |
|
| 2527 |
classsystem text, |
|
| 2528 |
acceptedsynonym text, |
|
| 2529 |
party_id int(11), |
|
| 2530 |
taxonstatus_id int(11), |
|
| 2531 |
usagestart date, |
|
| 2532 |
usagestop date |
|
| 2533 |
); |
|
| 2534 |
|
|
| 2535 |
|
|
| 2536 |
-- |
|
| 2537 |
-- Name: taxonusage_taxonusage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2538 |
-- |
|
| 2539 |
|
|
| 2540 |
|
|
| 2541 |
|
|
| 2542 |
|
|
| 2543 |
-- |
|
| 2544 |
-- Name: taxonusage_taxonusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2545 |
-- |
|
| 2546 |
|
|
| 2547 |
|
|
| 2548 |
|
|
| 2549 |
|
|
| 2550 |
-- |
|
| 2551 | 2519 |
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2552 | 2520 |
-- |
| 2553 | 2521 |
|
| ... | ... | |
| 3032 | 3000 |
|
| 3033 | 3001 |
|
| 3034 | 3002 |
-- |
| 3035 |
-- Name: taxonusage_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3036 |
-- |
|
| 3037 |
|
|
| 3038 |
|
|
| 3039 |
|
|
| 3040 |
|
|
| 3041 |
-- |
|
| 3042 | 3003 |
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: - |
| 3043 | 3004 |
-- |
| 3044 | 3005 |
|
| ... | ... | |
| 3587 | 3548 |
|
| 3588 | 3549 |
|
| 3589 | 3550 |
-- |
| 3590 |
-- Name: taxonusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3591 |
-- |
|
| 3592 |
|
|
| 3593 |
ALTER TABLE taxonusage |
|
| 3594 |
ADD CONSTRAINT taxonusage_pkey PRIMARY KEY (taxonusage_id); |
|
| 3595 |
|
|
| 3596 |
|
|
| 3597 |
-- |
|
| 3598 | 3551 |
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3599 | 3552 |
-- |
| 3600 | 3553 |
|
| ... | ... | |
| 5045 | 4998 |
|
| 5046 | 4999 |
|
| 5047 | 5000 |
-- |
| 5048 |
-- Name: taxonusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5049 |
-- |
|
| 5050 |
|
|
| 5051 |
|
|
| 5052 |
|
|
| 5053 |
|
|
| 5054 |
-- |
|
| 5055 |
-- Name: taxonusage_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5056 |
-- |
|
| 5057 |
|
|
| 5058 |
|
|
| 5059 |
|
|
| 5060 |
|
|
| 5061 |
-- |
|
| 5062 |
-- Name: taxonusage_taxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5063 |
-- |
|
| 5064 |
|
|
| 5065 |
ALTER TABLE taxonusage |
|
| 5066 |
ADD CONSTRAINT taxonusage_taxonstatus_id_fkey FOREIGN KEY (taxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5067 |
|
|
| 5068 |
|
|
| 5069 |
-- |
|
| 5070 | 5001 |
-- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5071 | 5002 |
-- |
| 5072 | 5003 |
|
| schemas/filter_ERD.csv | ||
|---|---|---|
| 1 | 1 |
"PostgreSQL","MySQL","Comments" |
| 2 | 2 |
,,"fkeys to heavily-linked tables" |
| 3 | 3 |
"^ALTER TABLE (?:commclass)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES \b[^;]*;",,outward |
| 4 |
"^ALTER TABLE (?:taxoncorrelation|taxonlineage|taxonusage)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES taxonlabel\b[^;]*;",,inward
|
|
| 4 |
"^ALTER TABLE (?:taxoncorrelation|taxonlineage)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES taxonlabel\b[^;]*;",,inward |
|
| 5 | 5 |
"^ALTER TABLE \b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES coverindex\b[^;]*;",,inward |
| 6 | 6 |
"^ALTER TABLE (?!method)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES method\b[^;]*;",,inward |
| 7 | 7 |
"^ALTER TABLE (?!party|address|telephone)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES party\b[^;]*;",,inward |
| schemas/vegbien.sql | ||
|---|---|---|
| 3226 | 3226 |
|
| 3227 | 3227 |
|
| 3228 | 3228 |
-- |
| 3229 |
-- Name: taxonusage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3230 |
-- |
|
| 3231 |
|
|
| 3232 |
CREATE TABLE taxonusage ( |
|
| 3233 |
taxonusage_id integer NOT NULL, |
|
| 3234 |
taxonlabel_id integer NOT NULL, |
|
| 3235 |
taxonstatus text, |
|
| 3236 |
taxon text, |
|
| 3237 |
classsystem text, |
|
| 3238 |
acceptedsynonym text, |
|
| 3239 |
party_id integer, |
|
| 3240 |
taxonstatus_id integer, |
|
| 3241 |
usagestart date, |
|
| 3242 |
usagestop date |
|
| 3243 |
); |
|
| 3244 |
|
|
| 3245 |
|
|
| 3246 |
-- |
|
| 3247 |
-- Name: taxonusage_taxonusage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3248 |
-- |
|
| 3249 |
|
|
| 3250 |
CREATE SEQUENCE taxonusage_taxonusage_id_seq |
|
| 3251 |
START WITH 1 |
|
| 3252 |
INCREMENT BY 1 |
|
| 3253 |
NO MINVALUE |
|
| 3254 |
NO MAXVALUE |
|
| 3255 |
CACHE 1; |
|
| 3256 |
|
|
| 3257 |
|
|
| 3258 |
-- |
|
| 3259 |
-- Name: taxonusage_taxonusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3260 |
-- |
|
| 3261 |
|
|
| 3262 |
ALTER SEQUENCE taxonusage_taxonusage_id_seq OWNED BY taxonusage.taxonusage_id; |
|
| 3263 |
|
|
| 3264 |
|
|
| 3265 |
-- |
|
| 3266 | 3229 |
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 3267 | 3230 |
-- |
| 3268 | 3231 |
|
| ... | ... | |
| 3767 | 3730 |
|
| 3768 | 3731 |
|
| 3769 | 3732 |
-- |
| 3770 |
-- Name: taxonusage_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3771 |
-- |
|
| 3772 |
|
|
| 3773 |
ALTER TABLE taxonusage ALTER COLUMN taxonusage_id SET DEFAULT nextval('taxonusage_taxonusage_id_seq'::regclass);
|
|
| 3774 |
|
|
| 3775 |
|
|
| 3776 |
-- |
|
| 3777 | 3733 |
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: - |
| 3778 | 3734 |
-- |
| 3779 | 3735 |
|
| ... | ... | |
| 4322 | 4278 |
|
| 4323 | 4279 |
|
| 4324 | 4280 |
-- |
| 4325 |
-- Name: taxonusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4326 |
-- |
|
| 4327 |
|
|
| 4328 |
ALTER TABLE ONLY taxonusage |
|
| 4329 |
ADD CONSTRAINT taxonusage_pkey PRIMARY KEY (taxonusage_id); |
|
| 4330 |
|
|
| 4331 |
|
|
| 4332 |
-- |
|
| 4333 | 4281 |
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4334 | 4282 |
-- |
| 4335 | 4283 |
|
| ... | ... | |
| 5817 | 5765 |
|
| 5818 | 5766 |
|
| 5819 | 5767 |
-- |
| 5820 |
-- Name: taxonusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5821 |
-- |
|
| 5822 |
|
|
| 5823 |
ALTER TABLE ONLY taxonusage |
|
| 5824 |
ADD CONSTRAINT taxonusage_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5825 |
|
|
| 5826 |
|
|
| 5827 |
-- |
|
| 5828 |
-- Name: taxonusage_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5829 |
-- |
|
| 5830 |
|
|
| 5831 |
ALTER TABLE ONLY taxonusage |
|
| 5832 |
ADD CONSTRAINT taxonusage_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5833 |
|
|
| 5834 |
|
|
| 5835 |
-- |
|
| 5836 |
-- Name: taxonusage_taxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5837 |
-- |
|
| 5838 |
|
|
| 5839 |
ALTER TABLE ONLY taxonusage |
|
| 5840 |
ADD CONSTRAINT taxonusage_taxonstatus_id_fkey FOREIGN KEY (taxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5841 |
|
|
| 5842 |
|
|
| 5843 |
-- |
|
| 5844 | 5768 |
-- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5845 | 5769 |
-- |
| 5846 | 5770 |
|
Also available in: Unified diff
schemas/vegbien.sql: Deleted taxonusage table per today's conference call, where it was decided that it was not needed