Project

General

Profile

« Previous | Next » 

Revision 4827

schemas/vegbien.sql: stemobservation: Added tag, tags

View differences:

schemas/vegbien.my.sql
2279 2279
    sourceaccessioncode text,
2280 2280
    plantobservation_id int(11) NOT NULL,
2281 2281
    authorstemcode text,
2282
    tag text,
2283
    tags text,
2282 2284
    xposition_m double precision,
2283 2285
    yposition_m double precision,
2284 2286
    diameterbreastheight_m double precision,
......
2301 2303

  
2302 2304

  
2303 2305
--
2306
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public; Owner: -
2307
--
2308

  
2309

  
2310

  
2311

  
2312
--
2304 2313
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2305 2314
--
2306 2315

  
schemas/vegbien.sql
2801 2801
    sourceaccessioncode text,
2802 2802
    plantobservation_id integer NOT NULL,
2803 2803
    authorstemcode text,
2804
    tag text,
2805
    tags text,
2804 2806
    xposition_m double precision,
2805 2807
    yposition_m double precision,
2806 2808
    diameterbreastheight_m double precision,
......
2823 2825

  
2824 2826

  
2825 2827
--
2828
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public; Owner: -
2829
--
2830

  
2831
COMMENT ON COLUMN stemobservation.tags IS 'Stores all tags when multiple tags provided. Older tags go first.';
2832

  
2833

  
2834
--
2826 2835
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2827 2836
--
2828 2837

  

Also available in: Unified diff