Revision 545
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.for_ERD.my.sql | ||
|---|---|---|
| 258 | 258 |
CREATE TABLE voucher |
| 259 | 259 |
( |
| 260 | 260 |
voucher_id int(11) NOT NULL AUTO_INCREMENT, |
| 261 |
taxonoccurrence_id int(11), |
|
| 262 |
specimen_id int(11), |
|
| 261 |
taxonoccurrence_id int(11) NOT NULL,
|
|
| 262 |
specimen_id int(11) NOT NULL,
|
|
| 263 | 263 |
accessioncode character varying(255), |
| 264 | 264 |
CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id ), |
| 265 | 265 |
CONSTRAINT voucher_specimen_id FOREIGN KEY (specimen_id) |
| schemas/vegbien.for_wiki.sql | ||
|---|---|---|
| 103 | 103 |
CREATE TABLE voucher |
| 104 | 104 |
( |
| 105 | 105 |
voucher_id serial NOT NULL, |
| 106 |
taxonoccurrence_id integer, |
|
| 107 |
specimen_id integer, |
|
| 106 |
taxonoccurrence_id integer NOT NULL,
|
|
| 107 |
specimen_id integer NOT NULL,
|
|
| 108 | 108 |
accessioncode character varying(255), |
| 109 | 109 |
); |
| 110 | 110 |
|
| schemas/vegbien.for_ERD.sql | ||
|---|---|---|
| 258 | 258 |
CREATE TABLE voucher |
| 259 | 259 |
( |
| 260 | 260 |
voucher_id serial NOT NULL, |
| 261 |
taxonoccurrence_id integer, |
|
| 262 |
specimen_id integer, |
|
| 261 |
taxonoccurrence_id integer NOT NULL,
|
|
| 262 |
specimen_id integer NOT NULL,
|
|
| 263 | 263 |
accessioncode character varying(255), |
| 264 | 264 |
CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id ), |
| 265 | 265 |
CONSTRAINT voucher_specimen_id FOREIGN KEY (specimen_id) |
| schemas/vegbien.sql | ||
|---|---|---|
| 3163 | 3163 |
|
| 3164 | 3164 |
CREATE TABLE voucher ( |
| 3165 | 3165 |
voucher_id integer NOT NULL, |
| 3166 |
taxonoccurrence_id integer, |
|
| 3167 |
specimen_id integer, |
|
| 3166 |
taxonoccurrence_id integer NOT NULL,
|
|
| 3167 |
specimen_id integer NOT NULL,
|
|
| 3168 | 3168 |
accessioncode character varying(255) |
| 3169 | 3169 |
); |
| 3170 | 3170 |
|
Also available in: Unified diff
vegbien.sql: Made voucher fields NOT NULL