Revision 5865
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 215 | 215 |
|
| 216 | 216 |
|
| 217 | 217 |
-- |
| 218 |
-- Name: make_analytical_db(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 218 |
-- Name: make_analytical_stem(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 219 | 219 |
-- |
| 220 | 220 |
|
| 221 | 221 |
|
| ... | ... | |
| 257 | 257 |
|
| 258 | 258 |
|
| 259 | 259 |
-- |
| 260 |
-- Name: sync_analytical_db_to_view(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 260 |
-- Name: sync_analytical_stem_to_view(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 261 | 261 |
-- |
| 262 | 262 |
|
| 263 | 263 |
|
| ... | ... | |
| 499 | 499 |
|
| 500 | 500 |
|
| 501 | 501 |
-- |
| 502 |
-- Name: analytical_db; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 502 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 503 | 503 |
-- |
| 504 | 504 |
|
| 505 |
CREATE TABLE analytical_db (
|
|
| 505 |
CREATE TABLE analytical_stem (
|
|
| 506 | 506 |
`institutionCode` text, |
| 507 | 507 |
country text, |
| 508 | 508 |
`stateProvince` text, |
| ... | ... | |
| 1303 | 1303 |
|
| 1304 | 1304 |
|
| 1305 | 1305 |
-- |
| 1306 |
-- Name: analytical_db_view; Type: VIEW; Schema: public; Owner: -
|
|
| 1306 |
-- Name: analytical_stem_view; Type: VIEW; Schema: public; Owner: -
|
|
| 1307 | 1307 |
-- |
| 1308 | 1308 |
|
| 1309 | 1309 |
|
Also available in: Unified diff
schemas/vegbien.sql: Renamed analytical_db to analytical_stem since this contains just the individual stems, not the aggregated data in the main analytical DB