Revision 545
Added by Aaron Marcuse-Kubitza almost 13 years ago
| 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) |
Also available in: Unified diff
vegbien.sql: Made voucher fields NOT NULL