Revision 430
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 142 | 142 |
collection_id integer NOT NULL, |
| 143 | 143 |
individualplant_id integer NOT NULL, |
| 144 | 144 |
reference_id integer NOT NULL, |
| 145 |
code text NOT NULL,
|
|
| 146 |
catalognumber text
|
|
| 145 |
code character varying(255) NOT NULL,
|
|
| 146 |
catalognumber character varying(255)
|
|
| 147 | 147 |
); |
| 148 | 148 |
|
| 149 | 149 |
|
| ... | ... | |
| 2606 | 2606 |
CREATE TABLE trait ( |
| 2607 | 2607 |
trait_id integer NOT NULL, |
| 2608 | 2608 |
stemobservation_id integer NOT NULL, |
| 2609 |
type character varying NOT NULL, |
|
| 2610 |
value character varying |
|
| 2609 |
type character varying(255) NOT NULL,
|
|
| 2610 |
value character varying(255)
|
|
| 2611 | 2611 |
); |
| 2612 | 2612 |
|
| 2613 | 2613 |
|
Also available in: Unified diff
vegbien.sql: Use character varying(255) instead of text or character varying in new tables and columns