Revision 7634
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 2725 | 2725 |
-- |
| 2726 | 2726 |
|
| 2727 | 2727 |
CREATE TABLE provider_count ( |
| 2728 |
level varchar(255) NOT NULL,
|
|
| 2729 |
provider varchar(255) NOT NULL,
|
|
| 2730 |
count varchar(255),
|
|
| 2728 |
dataprovider varchar(255) NOT NULL,
|
|
| 2729 |
dataset varchar(255) NOT NULL,
|
|
| 2730 |
records varchar(255),
|
|
| 2731 | 2731 |
sourcetype varchar(255), |
| 2732 | 2732 |
observationtype varchar(255) |
| 2733 | 2733 |
); |
| ... | ... | |
| 4776 | 4776 |
-- |
| 4777 | 4777 |
|
| 4778 | 4778 |
ALTER TABLE provider_count |
| 4779 |
ADD CONSTRAINT provider_count_pkey PRIMARY KEY (level, provider);
|
|
| 4779 |
ADD CONSTRAINT provider_count_pkey PRIMARY KEY (dataprovider, dataset);
|
|
| 4780 | 4780 |
|
| 4781 | 4781 |
|
| 4782 | 4782 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: provider_count_view: Group data by dataprovider and dataset, rather than by each separately, to satisfy the GBIF attribution requirements as described by Brad