Project

General

Profile

« Previous | Next » 

Revision 575

Added by Aaron Marcuse-Kubitza about 13 years ago

vegbien.sql: Made several fields optional, adding defaults where needed

View differences:

schemas/vegbien.for_ERD.my.sql
111 111 
CREATE TABLE location
112 112 
(
113 113 
  location_id int(11) NOT NULL AUTO_INCREMENT,
114 
  authorlocationcode character varying(30),
114 
  authorlocationcode character varying(30) NOT NULL DEFAULT '',
115 115 
  reference_id int(11),
116 116 
  parent_id int(11),
117 117 
  reallatitude double precision,
118 118 
  reallongitude double precision,
119 119 
  locationaccuracy double precision,
120 
  confidentialitystatus int(11) NOT NULL,
120 
  confidentialitystatus int(11) NOT NULL DEFAULT 0,
121 121 
  confidentialityreason character varying(200),
122 122 
  latitude double precision,
123 123 
  longitude double precision,
......
291 291 
  taxondetermination_id int(11) NOT NULL AUTO_INCREMENT,
292 292 
  taxonoccurrence_id int(11) NOT NULL,
293 293 
  plantconcept_id int(11) NOT NULL,
294 
  party_id int(11) NOT NULL,
294 
  party_id int(11),
295 295 
  role_id int(11) NOT NULL,
296 296 
  determinationtype character varying(30),
297 297 
  reference_id int(11),
298 
  originaldetermination int(1) NOT NULL,
299 
  currentdetermination int(1) NOT NULL,
298 
  originaldetermination int(1) NOT NULL DEFAULT false,
299 
  currentdetermination int(1) NOT NULL DEFAULT false,
300 300 
  taxonfit character varying(50),
301 301 
  taxonconfidence character varying(50),
302 302 
  grouptype character varying(20),
schemas/vegbien.for_wiki.sql
1 1 
CREATE TABLE location
2 2 
(
3 3 
  location_id serial NOT NULL,
4 
  authorlocationcode character varying(30),
4 
  authorlocationcode character varying(30) NOT NULL DEFAULT ''::character varying,
5 5 
  reference_id integer,
6 6 
  parent_id integer,
7 7 
  reallatitude double precision,
8 8 
  reallongitude double precision,
9 9 
  locationaccuracy double precision,
10 
  confidentialitystatus integer NOT NULL,
10 
  confidentialitystatus integer NOT NULL DEFAULT 0,
11 11 
  confidentialityreason character varying(200),
12 12 
  latitude double precision,
13 13 
  longitude double precision,
......
115 115 
  taxondetermination_id serial NOT NULL,
116 116 
  taxonoccurrence_id integer NOT NULL,
117 117 
  plantconcept_id integer NOT NULL,
118 
  party_id integer NOT NULL,
118 
  party_id integer,
119 119 
  role_id integer NOT NULL,
120 120 
  determinationtype character varying(30),
121 121 
  reference_id integer,
122 
  originaldetermination boolean NOT NULL,
123 
  currentdetermination boolean NOT NULL,
122 
  originaldetermination boolean NOT NULL DEFAULT false,
123 
  currentdetermination boolean NOT NULL DEFAULT false,
124 124 
  taxonfit character varying(50),
125 125 
  taxonconfidence character varying(50),
126 126 
  grouptype character varying(20),
schemas/vegbien.for_ERD.sql
111 111 
CREATE TABLE location
112 112 
(
113 113 
  location_id serial NOT NULL,
114 
  authorlocationcode character varying(30),
114 
  authorlocationcode character varying(30) NOT NULL DEFAULT ''::character varying,
115 115 
  reference_id integer,
116 116 
  parent_id integer,
117 117 
  reallatitude double precision,
118 118 
  reallongitude double precision,
119 119 
  locationaccuracy double precision,
120 
  confidentialitystatus integer NOT NULL,
120 
  confidentialitystatus integer NOT NULL DEFAULT 0,
121 121 
  confidentialityreason character varying(200),
122 122 
  latitude double precision,
123 123 
  longitude double precision,
......
291 291 
  taxondetermination_id serial NOT NULL,
292 292 
  taxonoccurrence_id integer NOT NULL,
293 293 
  plantconcept_id integer NOT NULL,
294 
  party_id integer NOT NULL,
294 
  party_id integer,
295 295 
  role_id integer NOT NULL,
296 296 
  determinationtype character varying(30),
297 297 
  reference_id integer,
298 
  originaldetermination boolean NOT NULL,
299 
  currentdetermination boolean NOT NULL,
298 
  originaldetermination boolean NOT NULL DEFAULT false,
299 
  currentdetermination boolean NOT NULL DEFAULT false,
300 300 
  taxonfit character varying(50),
301 301 
  taxonconfidence character varying(50),
302 302 
  grouptype character varying(20),
schemas/vegbien.sql
1124 1124 

  		




  1125
  1125
  
    
CREATE TABLE location (


  		




  1126
  1126
  
    
    location_id integer NOT NULL,


  		




  1127
  
  
    
    authorlocationcode character varying(30),


  		




  
  1127
  
    
    authorlocationcode character varying(30) DEFAULT ''::character varying NOT NULL,


  		




  1128
  1128
  
    
    reference_id integer,


  		




  1129
  1129
  
    
    parent_id integer,


  		




  1130
  1130
  
    
    reallatitude double precision,


  		




  1131
  1131
  
    
    reallongitude double precision,


  		




  1132
  1132
  
    
    locationaccuracy double precision,


  		




  1133
  
  
    
    confidentialitystatus integer NOT NULL,


  		




  
  1133
  
    
    confidentialitystatus integer DEFAULT 0 NOT NULL,


  		




  1134
  1134
  
    
    confidentialityreason character varying(200),


  		




  1135
  
  
    
    latitude double precision,


  		




  1136
  
  
    
    longitude double precision,


  		




  
  1135
  
    
    latitude double precision DEFAULT 'NaN'::double precision NOT NULL,


  		




  
  1136
  
    
    longitude double precision DEFAULT 'NaN'::double precision NOT NULL,


  		




  1137
  1137
  
    
    authore character varying(20),


  		




  1138
  1138
  
    
    authorn character varying(20),


  		




  1139
  1139
  
    
    authorzone character varying(20),


  		




  ......




  1773
  1773
  
    
    plantstatus_id integer NOT NULL,


  		




  1774
  1774
  
    
    plantconcept_id integer NOT NULL,


  		




  1775
  1775
  
    
    reference_id integer,


  		




  1776
  
  
    
    plantconceptstatus character varying(20) NOT NULL,


  		




  
  1776
  
    
    plantconceptstatus character varying(20) DEFAULT 'undetermined'::character varying NOT NULL,


  		




  1777
  1777
  
    
    plantpartycomments text,


  		




  1778
  1778
  
    
    plantparentname character varying(200),


  		




  1779
  1779
  
    
    plantparentconcept_id integer,


  		




  1780
  1780
  
    
    plantparent_id integer,


  		




  1781
  1781
  
    
    plantlevel character varying(80),


  		




  1782
  
  
    
    party_id integer NOT NULL,


  		




  1783
  
  
    
    startdate timestamp with time zone NOT NULL,


  		




  
  1782
  
    
    party_id integer,


  		




  
  1783
  
    
    startdate timestamp with time zone,


  		




  1784
  1784
  
    
    stopdate timestamp with time zone,


  		




  1785
  1785
  
    
    accessioncode character varying(255)


  		




  1786
  1786
  
    
);


  		




  ......




  2515
  2515
  
    
    taxondetermination_id integer NOT NULL,


  		




  2516
  2516
  
    
    taxonoccurrence_id integer NOT NULL,


  		




  2517
  2517
  
    
    plantconcept_id integer NOT NULL,


  		




  2518
  
  
    
    party_id integer NOT NULL,


  		




  
  2518
  
    
    party_id integer,


  		




  2519
  2519
  
    
    role_id integer NOT NULL,


  		




  2520
  2520
  
    
    determinationtype character varying(30),


  		




  2521
  2521
  
    
    reference_id integer,


  		




  2522
  
  
    
    originaldetermination boolean NOT NULL,


  		




  2523
  
  
    
    currentdetermination boolean NOT NULL,


  		




  
  2522
  
    
    originaldetermination boolean DEFAULT false NOT NULL,


  		




  
  2523
  
    
    currentdetermination boolean DEFAULT false NOT NULL,


  		




  2524
  2524
  
    
    taxonfit character varying(50),


  		




  2525
  2525
  
    
    taxonconfidence character varying(50),


  		




  2526
  2526
  
    
    grouptype character varying(20),


  		












Also available in:  Unified diff