Project

General

Profile

« Previous | Next » 

Revision 14294

schemas/public_.sql: analytical_stem: synced to analytical_stem_view

View differences:

trunk/schemas/vegbien.my.sql
3281 3281
    `speciesBinomialWithMorphospecies__@VegCore__@vegpath.org` varchar(255),
3282 3282
    `[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org` growthform,
3283 3283
    `reproductiveCondition__@DwC__@vegpath.org` varchar(255),
3284
    threatened_bien int(11),
3285 3284
    cultivated_bien int(11),
3286 3285
    `cultivatedBasis_bien` varchar(255),
3287 3286
    `occurrenceRemarks__@DwC__@vegpath.org` varchar(255),
......
3702 3701

  
3703 3702

  
3704 3703
--
3705
-- Name: COLUMN analytical_stem.threatened_bien; Type: COMMENT; Schema: public; Owner: -
3706
--
3707

  
3708

  
3709

  
3710

  
3711
--
3712 3704
-- Name: COLUMN analytical_stem.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
3713 3705
--
3714 3706

  
trunk/schemas/public_.sql
5541 5541
    "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" text,
5542 5542
    "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" growthform,
5543 5543
    "reproductiveCondition__@DwC__@vegpath.org" text,
5544
    threatened_bien integer,
5545 5544
    cultivated_bien integer,
5546 5545
    "cultivatedBasis_bien" text,
5547 5546
    "occurrenceRemarks__@DwC__@vegpath.org" text,
......
5969 5968

  
5970 5969

  
5971 5970
--
5972
-- Name: COLUMN analytical_stem.threatened_bien; Type: COMMENT; Schema: public; Owner: -
5973
--
5974

  
5975
COMMENT ON COLUMN analytical_stem.threatened_bien IS 'whether the taxon is on the IUCN Red List of Threatened Species';
5976

  
5977

  
5978
--
5979 5971
-- Name: COLUMN analytical_stem.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
5980 5972
--
5981 5973

  
trunk/schemas/vegbien.sql
5541 5541
    "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" text,
5542 5542
    "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" growthform,
5543 5543
    "reproductiveCondition__@DwC__@vegpath.org" text,
5544
    threatened_bien integer,
5545 5544
    cultivated_bien integer,
5546 5545
    "cultivatedBasis_bien" text,
5547 5546
    "occurrenceRemarks__@DwC__@vegpath.org" text,
......
5969 5968

  
5970 5969

  
5971 5970
--
5972
-- Name: COLUMN analytical_stem.threatened_bien; Type: COMMENT; Schema: public; Owner: -
5973
--
5974

  
5975
COMMENT ON COLUMN analytical_stem.threatened_bien IS 'whether the taxon is on the IUCN Red List of Threatened Species';
5976

  
5977

  
5978
--
5979 5971
-- Name: COLUMN analytical_stem.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
5980 5972
--
5981 5973

  

Also available in: Unified diff