Revision 5622
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 82 | 82 |
|
| 83 | 83 |
|
| 84 | 84 |
-- |
| 85 |
-- Name: relationship; Type: TYPE; Schema: public; Owner: - |
|
| 86 |
-- |
|
| 87 |
|
|
| 88 |
|
|
| 89 |
|
|
| 90 |
|
|
| 91 |
-- |
|
| 85 | 92 |
-- Name: role; Type: TYPE; Schema: public; Owner: - |
| 86 | 93 |
-- |
| 87 | 94 |
|
| ... | ... | |
| 2437 | 2444 |
|
| 2438 | 2445 |
CREATE TABLE taxonlabel_relationship ( |
| 2439 | 2446 |
descendant_id int(11) NOT NULL, |
| 2440 |
ancestor_id int(11) NOT NULL |
|
| 2447 |
ancestor_id int(11) NOT NULL, |
|
| 2448 |
relationship text DEFAULT 'is included in' NOT NULL |
|
| 2441 | 2449 |
); |
| 2442 | 2450 |
|
| 2443 | 2451 |
|
| ... | ... | |
| 2449 | 2457 |
|
| 2450 | 2458 |
|
| 2451 | 2459 |
-- |
| 2460 |
-- Name: COLUMN taxonlabel_relationship.relationship; Type: COMMENT; Schema: public; Owner: - |
|
| 2461 |
-- |
|
| 2462 |
|
|
| 2463 |
|
|
| 2464 |
|
|
| 2465 |
|
|
| 2466 |
-- |
|
| 2452 | 2467 |
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2453 | 2468 |
-- |
| 2454 | 2469 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 199 | 199 |
|
| 200 | 200 |
|
| 201 | 201 |
-- |
| 202 |
-- Name: relationship; Type: TYPE; Schema: public; Owner: - |
|
| 203 |
-- |
|
| 204 |
|
|
| 205 |
CREATE TYPE relationship AS ENUM ( |
|
| 206 |
'is congruent to', |
|
| 207 |
'is not congruent to', |
|
| 208 |
'is included in', |
|
| 209 |
'is not included in', |
|
| 210 |
'overlaps', |
|
| 211 |
'does not overlap', |
|
| 212 |
'is child taxon of', |
|
| 213 |
'is anamorph of', |
|
| 214 |
'is teleomorph of', |
|
| 215 |
'is hybrid child of', |
|
| 216 |
'is ambiregnal of', |
|
| 217 |
'is vernacular for' |
|
| 218 |
); |
|
| 219 |
|
|
| 220 |
|
|
| 221 |
-- |
|
| 202 | 222 |
-- Name: role; Type: TYPE; Schema: public; Owner: - |
| 203 | 223 |
-- |
| 204 | 224 |
|
| ... | ... | |
| 3133 | 3153 |
|
| 3134 | 3154 |
CREATE TABLE taxonlabel_relationship ( |
| 3135 | 3155 |
descendant_id integer NOT NULL, |
| 3136 |
ancestor_id integer NOT NULL |
|
| 3156 |
ancestor_id integer NOT NULL, |
|
| 3157 |
relationship relationship DEFAULT 'is included in'::relationship NOT NULL |
|
| 3137 | 3158 |
); |
| 3138 | 3159 |
|
| 3139 | 3160 |
|
| ... | ... | |
| 3145 | 3166 |
|
| 3146 | 3167 |
|
| 3147 | 3168 |
-- |
| 3169 |
-- Name: COLUMN taxonlabel_relationship.relationship; Type: COMMENT; Schema: public; Owner: - |
|
| 3170 |
-- |
|
| 3171 |
|
|
| 3172 |
COMMENT ON COLUMN taxonlabel_relationship.relationship IS 'The type of relationship.'; |
|
| 3173 |
|
|
| 3174 |
|
|
| 3175 |
-- |
|
| 3148 | 3176 |
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 3149 | 3177 |
-- |
| 3150 | 3178 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonlabel_relationship: Added relationship, with relationship enum