Project

General

Profile

« Previous | Next » 

Revision 10258

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/bien_web/bien_web.schema.sql: regenerated using bin/my2pg, to remove the *_index dummy columns so they don't create lots of OMIT#... staging table columns

View differences:

bien_web.schema.sql
55 55 
  "collector" varchar(150) DEFAULT NULL,
56 56 
  "collectionNumber" varchar(50) DEFAULT NULL,
57 57 
  "identifiedBy" varchar(150) DEFAULT NULL,
58 
  "observationDate" date DEFAULT NULL,
58 
  "observationDate" text/*date*/ DEFAULT NULL,
59 59 
  "plotCode" varchar(100) DEFAULT NULL,
60 60 
  "plotAreaHa" double precision DEFAULT NULL,
61 61 
  "plotMinDbh" decimal(5,1) DEFAULT NULL,
......
78 78 
  "traitUnit" varchar(100) DEFAULT NULL,
79 79 
  "traitMethod" varchar(255) DEFAULT NULL,
80 80 
  PRIMARY KEY ("observationID"),
81 
  "observationID_index" boolean,
82 
  "dataSourceID_index" boolean,
83 
  "dataSourceName_index" boolean,
84 
  "dataSourceNamePrimary_index" boolean,
85 
  "plotID_index" boolean,
86 
  "observationType_index" boolean,
87 
  "bien2_taxonomyID_index" boolean,
88 
  "bien2_DBPlotID_index" boolean,
89 
  "bien2_ObservationID_index" boolean,
90 
  "bien2_OccurID_index" boolean,
91 
  "taxonAuthorityVerbatim_index" boolean,
92 
  "higherPlantGroup_index" boolean,
93 
  "family_index" boolean,
94 
  "genus_index" boolean,
95 
  "species_index" boolean,
96 
  "taxon_index" boolean,
97 
  "taxonAuthor_index" boolean,
98 
  "taxonMorphospecies_index" boolean,
99 
  "rank_index" boolean,
100 
  "acceptance_index" boolean,
101 
  "country_index" boolean,
102 
  "stateProvince_index" boolean,
103 
  "collector_index" boolean,
104 
  "identifiedBy_index" boolean,
105 
  "plotCode_index" boolean,
106 
  "plotAreaHa_index" boolean,
107 
  "plotMinDbh_index" boolean,
108 
  "plotMethod_index" boolean,
109 
  "isValidLatLong_index" boolean,
110 
  "isGeovalid_index" boolean,
111 
  "isNewWorld_index" boolean,
112 
  "isCultivated_index" boolean,
113 
  "isCultivatedReason_index" boolean,
114 
  "bien2_TraitObservationID_index" boolean,
115 
  "traitName_index" boolean,
116 
  "traitMethod_index" boolean,
117 
  "traitUnit_index" boolean
81 
  /*KEY "observationID" ("observationID")*/CHECK (true),
82 
  /*KEY "dataSourceID" ("dataSourceID")*/CHECK (true),
83 
  /*KEY "dataSourceName" ("dataSourceName")*/CHECK (true),
84 
  /*KEY "dataSourceNamePrimary" ("dataSourceNamePrimary")*/CHECK (true),
85 
  /*KEY "plotID" ("plotID")*/CHECK (true),
86 
  /*KEY "observationType" ("observationType")*/CHECK (true),
87 
  /*KEY "bien2_taxonomyID" ("bien2_taxonomyID")*/CHECK (true),
88 
  /*KEY "bien2_DBPlotID" ("bien2_DBPlotID")*/CHECK (true),
89 
  /*KEY "bien2_ObservationID" ("bien2_ObservationID")*/CHECK (true),
90 
  /*KEY "bien2_OccurID" ("bien2_OccurID")*/CHECK (true),
91 
  /*KEY "taxonAuthorityVerbatim" ("taxonAuthorityVerbatim")*/CHECK (true),
92 
  /*KEY "higherPlantGroup" ("higherPlantGroup")*/CHECK (true),
93 
  /*KEY "family" ("family")*/CHECK (true),
94 
  /*KEY "genus" ("genus")*/CHECK (true),
95 
  /*KEY "species" ("species")*/CHECK (true),
96 
  /*KEY "taxon" ("taxon")*/CHECK (true),
97 
  /*KEY "taxonAuthor" ("taxonAuthor")*/CHECK (true),
98 
  /*KEY "taxonMorphospecies" ("taxonMorphospecies")*/CHECK (true),
99 
  /*KEY "rank" ("rank")*/CHECK (true),
100 
  /*KEY "acceptance" ("acceptance")*/CHECK (true),
101 
  /*KEY "country" ("country")*/CHECK (true),
102 
  /*KEY "stateProvince" ("stateProvince")*/CHECK (true),
103 
  /*KEY "collector" ("collector")*/CHECK (true),
104 
  /*KEY "identifiedBy" ("identifiedBy")*/CHECK (true),
105 
  /*KEY "plotCode" ("plotCode")*/CHECK (true),
106 
  /*KEY "plotAreaHa" ("plotAreaHa")*/CHECK (true),
107 
  /*KEY "plotMinDbh" ("plotMinDbh")*/CHECK (true),
108 
  /*KEY "plotMethod" ("plotMethod")*/CHECK (true),
109 
  /*KEY "isValidLatLong" ("isValidLatLong")*/CHECK (true),
110 
  /*KEY "isGeovalid" ("isGeovalid")*/CHECK (true),
111 
  /*KEY "isNewWorld" ("isNewWorld")*/CHECK (true),
112 
  /*KEY "isCultivated" ("isCultivated")*/CHECK (true),
113 
  /*KEY "isCultivatedReason" ("isCultivatedReason")*/CHECK (true),
114 
  /*KEY "bien2_TraitObservationID" ("bien2_TraitObservationID")*/CHECK (true),
115 
  /*KEY "traitName" ("traitName")*/CHECK (true),
116 
  /*KEY "traitMethod" ("traitMethod")*/CHECK (true),
117 
  /*KEY "traitUnit" ("traitUnit")*/CHECK (true)
118 118 
);
119 119 
/*!40101 SET character_set_client = @saved_cs_client */;
120 120 
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

Also available in: Unified diff