Revision 6885
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 437 | 437 |
|
| 438 | 438 |
|
| 439 | 439 |
-- |
| 440 |
-- Name: sync_taxon_trait_to_view(); Type: FUNCTION; Schema: public; Owner: - |
|
| 441 |
-- |
|
| 442 |
|
|
| 443 |
|
|
| 444 |
|
|
| 445 |
|
|
| 446 |
-- |
|
| 440 | 447 |
-- Name: taxondetermination_set_iscurrent(); Type: FUNCTION; Schema: public; Owner: - |
| 441 | 448 |
-- |
| 442 | 449 |
|
| ... | ... | |
| 3038 | 3045 |
|
| 3039 | 3046 |
|
| 3040 | 3047 |
-- |
| 3048 |
-- Name: taxon_trait; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3049 |
-- |
|
| 3050 |
|
|
| 3051 |
CREATE TABLE taxon_trait ( |
|
| 3052 |
`scientificName` varchar(255) NOT NULL, |
|
| 3053 |
`measurementType` varchar(255) NOT NULL, |
|
| 3054 |
`measurementValue` varchar(255), |
|
| 3055 |
`measurementUnit` varchar(255) |
|
| 3056 |
); |
|
| 3057 |
|
|
| 3058 |
|
|
| 3059 |
-- |
|
| 3060 |
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3061 |
-- |
|
| 3062 |
|
|
| 3063 |
CREATE TABLE trait ( |
|
| 3064 |
trait_id int(11) NOT NULL, |
|
| 3065 |
taxonoccurrence_id int(11) NOT NULL, |
|
| 3066 |
name varchar(255) NOT NULL, |
|
| 3067 |
value varchar(255), |
|
| 3068 |
units varchar(255) |
|
| 3069 |
); |
|
| 3070 |
|
|
| 3071 |
|
|
| 3072 |
-- |
|
| 3073 |
-- Name: taxon_trait_view; Type: VIEW; Schema: public; Owner: - |
|
| 3074 |
-- |
|
| 3075 |
|
|
| 3076 |
|
|
| 3077 |
|
|
| 3078 |
|
|
| 3079 |
-- |
|
| 3041 | 3080 |
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 3042 | 3081 |
-- |
| 3043 | 3082 |
|
| ... | ... | |
| 3369 | 3408 |
|
| 3370 | 3409 |
|
| 3371 | 3410 |
-- |
| 3372 |
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3373 |
-- |
|
| 3374 |
|
|
| 3375 |
CREATE TABLE trait ( |
|
| 3376 |
trait_id int(11) NOT NULL, |
|
| 3377 |
taxonoccurrence_id int(11) NOT NULL, |
|
| 3378 |
name varchar(255) NOT NULL, |
|
| 3379 |
value varchar(255), |
|
| 3380 |
units varchar(255) |
|
| 3381 |
); |
|
| 3382 |
|
|
| 3383 |
|
|
| 3384 |
-- |
|
| 3385 | 3411 |
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 3386 | 3412 |
-- |
| 3387 | 3413 |
|
| ... | ... | |
| 4270 | 4296 |
|
| 4271 | 4297 |
|
| 4272 | 4298 |
-- |
| 4299 |
-- Data for Name: taxon_trait; Type: TABLE DATA; Schema: public; Owner: - |
|
| 4300 |
-- |
|
| 4301 |
|
|
| 4302 |
|
|
| 4303 |
|
|
| 4304 |
-- |
|
| 4273 | 4305 |
-- Data for Name: taxonalt; Type: TABLE DATA; Schema: public; Owner: - |
| 4274 | 4306 |
-- |
| 4275 | 4307 |
|
| ... | ... | |
| 4832 | 4864 |
|
| 4833 | 4865 |
|
| 4834 | 4866 |
-- |
| 4867 |
-- Name: taxon_trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4868 |
-- |
|
| 4869 |
|
|
| 4870 |
ALTER TABLE taxon_trait |
|
| 4871 |
ADD CONSTRAINT taxon_trait_pkey PRIMARY KEY (`scientificName`, `measurementType`); |
|
| 4872 |
|
|
| 4873 |
|
|
| 4874 |
-- |
|
| 4835 | 4875 |
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4836 | 4876 |
-- |
| 4837 | 4877 |
|
| ... | ... | |
| 7247 | 7287 |
|
| 7248 | 7288 |
|
| 7249 | 7289 |
-- |
| 7290 |
-- Name: taxon_trait; Type: ACL; Schema: public; Owner: - |
|
| 7291 |
-- |
|
| 7292 |
|
|
| 7293 |
|
|
| 7294 |
|
|
| 7295 |
|
|
| 7296 |
|
|
| 7297 |
|
|
| 7298 |
|
|
| 7299 |
-- |
|
| 7300 |
-- Name: trait; Type: ACL; Schema: public; Owner: - |
|
| 7301 |
-- |
|
| 7302 |
|
|
| 7303 |
|
|
| 7304 |
|
|
| 7305 |
|
|
| 7306 |
|
|
| 7307 |
|
|
| 7308 |
|
|
| 7309 |
-- |
|
| 7310 |
-- Name: taxon_trait_view; Type: ACL; Schema: public; Owner: - |
|
| 7311 |
-- |
|
| 7312 |
|
|
| 7313 |
|
|
| 7314 |
|
|
| 7315 |
|
|
| 7316 |
|
|
| 7317 |
|
|
| 7318 |
|
|
| 7319 |
-- |
|
| 7250 | 7320 |
-- Name: taxonalt; Type: ACL; Schema: public; Owner: - |
| 7251 | 7321 |
-- |
| 7252 | 7322 |
|
| ... | ... | |
| 7337 | 7407 |
|
| 7338 | 7408 |
|
| 7339 | 7409 |
-- |
| 7340 |
-- Name: trait; Type: ACL; Schema: public; Owner: - |
|
| 7341 |
-- |
|
| 7342 |
|
|
| 7343 |
|
|
| 7344 |
|
|
| 7345 |
|
|
| 7346 |
|
|
| 7347 |
|
|
| 7348 |
|
|
| 7349 |
-- |
|
| 7350 | 7410 |
-- Name: userdefined; Type: ACL; Schema: public; Owner: - |
| 7351 | 7411 |
-- |
| 7352 | 7412 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added taxon_trait materialized view