Project

General

Profile

« Previous | Next » 

Revision 570

Added by Aaron Marcuse-Kubitza almost 13 years ago

VegBIEN: Renamed sourceid to author*code

View differences:

vegbien.for_wiki.sql
1 1 
CREATE TABLE location
2 2 
(
3 3 
  location_id serial NOT NULL,
4 
  sourceid character varying(30),
4 
  authorlocationcode character varying(30),
5 5 
  reference_id integer,
6 6 
  parent_id integer,
7 7 
  reallatitude double precision,
......
24 24 
  previous_id integer,
25 25 
  location_id integer NOT NULL,
26 26 
  project_id integer,
27 
  sourceid character varying(30),
27 
  authoreventcode character varying(30),
28 28 
  "... (truncated) ..." integer,
29 29 
  accessioncode character varying(255),
30 30 
);
......
65 65 
  overallheight double precision,
66 66 
  overallheightaccuracy double precision,
67 67 
  emb_individualplant integer,
68 
  sourceid character varying(20),
68 
  authorplantcode character varying(20),
69 69 
  accessioncode character varying(255),
70 70 
  stemcount integer,
71 71 
);
......
74 74 
(
75 75 
  stem_id serial NOT NULL,
76 76 
  individualplant_id integer NOT NULL,
77 
  sourceid character varying(20),
77 
  authorstemcode character varying(20),
78 78 
  xposition double precision,
79 79 
  yposition double precision,
80 80 
  health character varying(50),

Also available in: Unified diff