Revision 5400
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 783 | 783 |
creator_id int(11) NOT NULL, |
| 784 | 784 |
creationdate timestamp NULL, |
| 785 | 785 |
canon_concept_id int(11), |
| 786 |
canon_concept_fit_fraction double precision, |
|
| 786 | 787 |
parent_id int(11), |
| 787 | 788 |
taxonname text, |
| 788 | 789 |
rank text, |
| ... | ... | |
| 828 | 829 |
|
| 829 | 830 |
|
| 830 | 831 |
-- |
| 832 |
-- Name: COLUMN taxonconcept.canon_concept_fit_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 833 |
-- |
|
| 834 |
|
|
| 835 |
|
|
| 836 |
|
|
| 837 |
|
|
| 838 |
-- |
|
| 831 | 839 |
-- Name: COLUMN taxonconcept.parent_id; Type: COMMENT; Schema: public; Owner: - |
| 832 | 840 |
-- |
| 833 | 841 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1117 | 1117 |
creator_id integer NOT NULL, |
| 1118 | 1118 |
creationdate timestamp with time zone, |
| 1119 | 1119 |
canon_concept_id integer, |
| 1120 |
canon_concept_fit_fraction double precision, |
|
| 1120 | 1121 |
parent_id integer, |
| 1121 | 1122 |
taxonname text, |
| 1122 | 1123 |
rank taxonrank, |
| ... | ... | |
| 1130 | 1131 |
species text, |
| 1131 | 1132 |
description text, |
| 1132 | 1133 |
accessioncode text, |
| 1134 |
CONSTRAINT taxonconcept_canon_concept_fit_fraction_range CHECK (((canon_concept_fit_fraction >= (0)::double precision) AND (canon_concept_fit_fraction <= (1)::double precision))), |
|
| 1133 | 1135 |
CONSTRAINT taxonconcept_required_key CHECK ((((((taxonname IS NOT NULL) OR (identifyingtaxonomicname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR ((parent_id IS NOT NULL) AND ((creationdate IS NOT NULL) OR (author IS NOT NULL))))) |
| 1134 | 1136 |
); |
| 1135 | 1137 |
|
| ... | ... | |
| 1175 | 1177 |
|
| 1176 | 1178 |
|
| 1177 | 1179 |
-- |
| 1180 |
-- Name: COLUMN taxonconcept.canon_concept_fit_fraction; Type: COMMENT; Schema: public; Owner: - |
|
| 1181 |
-- |
|
| 1182 |
|
|
| 1183 |
COMMENT ON COLUMN taxonconcept.canon_concept_fit_fraction IS 'The closeness of fit of the canon_concept.'; |
|
| 1184 |
|
|
| 1185 |
|
|
| 1186 |
-- |
|
| 1178 | 1187 |
-- Name: COLUMN taxonconcept.parent_id; Type: COMMENT; Schema: public; Owner: - |
| 1179 | 1188 |
-- |
| 1180 | 1189 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Added canon_concept_fit_fraction to store the closeness of fit of the canon_concept