Revision 6060
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1180 | 1180 |
|
| 1181 | 1181 |
|
| 1182 | 1182 |
-- |
| 1183 |
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1184 |
-- |
|
| 1185 |
|
|
| 1186 |
CREATE TABLE specimenreplicate ( |
|
| 1187 |
specimenreplicate_id int(11) NOT NULL, |
|
| 1188 |
reference_id int(11) NOT NULL, |
|
| 1189 |
sourceaccessioncode text, |
|
| 1190 |
plantobservation_id int(11), |
|
| 1191 |
institution_id int(11), |
|
| 1192 |
collectioncode_dwc text, |
|
| 1193 |
catalognumber_dwc text, |
|
| 1194 |
description text, |
|
| 1195 |
specimen_id int(11), |
|
| 1196 |
accessioncode text |
|
| 1197 |
); |
|
| 1198 |
|
|
| 1199 |
|
|
| 1200 |
-- |
|
| 1201 |
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: - |
|
| 1202 |
-- |
|
| 1203 |
|
|
| 1204 |
|
|
| 1205 |
|
|
| 1206 |
|
|
| 1207 |
-- |
|
| 1208 |
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: - |
|
| 1209 |
-- |
|
| 1210 |
|
|
| 1211 |
|
|
| 1212 |
|
|
| 1213 |
|
|
| 1214 |
-- |
|
| 1215 |
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: - |
|
| 1216 |
-- |
|
| 1217 |
|
|
| 1218 |
|
|
| 1219 |
|
|
| 1220 |
|
|
| 1221 |
-- |
|
| 1222 | 1183 |
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1223 | 1184 |
-- |
| 1224 | 1185 |
|
| ... | ... | |
| 2859 | 2820 |
|
| 2860 | 2821 |
|
| 2861 | 2822 |
-- |
| 2823 |
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2824 |
-- |
|
| 2825 |
|
|
| 2826 |
CREATE TABLE specimenreplicate ( |
|
| 2827 |
specimenreplicate_id int(11) NOT NULL, |
|
| 2828 |
reference_id int(11) NOT NULL, |
|
| 2829 |
sourceaccessioncode text, |
|
| 2830 |
plantobservation_id int(11), |
|
| 2831 |
institution_id int(11), |
|
| 2832 |
collectioncode_dwc text, |
|
| 2833 |
catalognumber_dwc text, |
|
| 2834 |
description text, |
|
| 2835 |
specimen_id int(11), |
|
| 2836 |
accessioncode text |
|
| 2837 |
); |
|
| 2838 |
|
|
| 2839 |
|
|
| 2840 |
-- |
|
| 2841 |
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: - |
|
| 2842 |
-- |
|
| 2843 |
|
|
| 2844 |
|
|
| 2845 |
|
|
| 2846 |
|
|
| 2847 |
-- |
|
| 2848 |
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: - |
|
| 2849 |
-- |
|
| 2850 |
|
|
| 2851 |
|
|
| 2852 |
|
|
| 2853 |
|
|
| 2854 |
-- |
|
| 2855 |
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: - |
|
| 2856 |
-- |
|
| 2857 |
|
|
| 2858 |
|
|
| 2859 |
|
|
| 2860 |
|
|
| 2861 |
-- |
|
| 2862 | 2862 |
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2863 | 2863 |
-- |
| 2864 | 2864 |
|
Also available in: Unified diff
schemas/vegbien.sql: analytical_stem_view: Removed join on specimenreplicate, because it isn't used in the analytical DB. Each specimen will still get an entry in analytical_*, because it gets its own location.