Revision 3213
Added by Aaron Marcuse-Kubitza over 12 years ago
vegbien.my.sql | ||
---|---|---|
340 | 340 |
CREATE TABLE commdetermination ( |
341 | 341 |
commdetermination_id int(11) NOT NULL, |
342 | 342 |
commclass_id int(11) NOT NULL, |
343 |
commconcept_id int(11), |
|
343 |
commconcept_id int(11) NOT NULL,
|
|
344 | 344 |
commcode text, |
345 | 345 |
commname text, |
346 | 346 |
classfit text, |
Also available in: Unified diff
schemas/vegbien.sql: commdetermination: Made commconcept_id NOT NULL because it doesn't make sense to have a commdetermination on nothing. Note that the commname field in commdetermination is not used for making determinations (and may need to be removed to avoid confusion); commname.commname is used instead.