forked from bcgov/cas-ggircs
-
Notifications
You must be signed in to change notification settings - Fork 0
/
sqitch.plan
86 lines (85 loc) · 18.4 KB
/
sqitch.plan
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
%syntax-version=1.0.0
%project=ggircs
%uri=https://github.com/bcgov/cas-ggircs
swrs/public/schema 2019-07-19T18:45:38Z Matthieu Foucault <[email protected]> # Add a schema for SWRS load
swrs/public/table/naics_mapping [swrs/public/schema] 2019-05-28T19:00:38Z Dylan Leard <[email protected]> # added naics_mapping table to schema ggircs_swrs
swrs/public/table/fuel_mapping [swrs/public/schema] 2019-05-23T21:43:54Z Dylan Leard <[email protected]> # add fuel mapping table to schema ggircs_swrs
swrs/public/table/fuel_carbon_tax_details [swrs/public/schema] 2019-06-21T17:15:03Z Dylan Leard <[email protected]> # add fuel carbon tax details table
swrs/public/table/naics_category [swrs/public/schema] 2019-06-24T23:03:05Z Dylan Leard <[email protected]> # add table naics_category to schema ggircs_swrs
swrs/public/table/naics_naics_category [swrs/public/schema] 2019-06-24T23:11:21Z Dylan Leard <[email protected]> # add through table naics_naics_category to schema ggircs_swrs
swrs/public/table/naics_category_type [swrs/public/schema] 2019-07-03T21:30:35Z Dylan Leard <[email protected]> # add naics category type table to schema ggircs
swrs/public/table/carbon_tax_rate_mapping [swrs/public/schema] 2019-05-28T23:02:37Z Dylan Leard <[email protected]> # add carbon tax rate table to schema ggircs_swrs
swrs/public/table/report [swrs/public/schema] 2019-06-03T22:45:25Z Dylan Leard <[email protected]> # add table report to schema ggircs
swrs/public/table/organisation [swrs/public/table/report] 2019-06-03T23:01:20Z Dylan Leard <[email protected]> # add table organisation to schema ggircs
swrs/public/table/facility [swrs/public/table/report swrs/public/table/organisation] 2019-06-04T17:15:20Z Dylan Leard <[email protected]> # add table facility to schema ggircs
swrs/public/table/activity [swrs/public/table/report swrs/public/table/facility] 2019-06-04T17:24:09Z Dylan Leard <[email protected]> # add table activity to schema ggircs
swrs/public/table/unit [swrs/public/table/activity] 2019-06-04T17:29:28Z Dylan Leard <[email protected]> # add table unit to schema ggircs
swrs/public/table/identifier [swrs/public/table/report swrs/public/table/facility] 2019-06-04T17:35:55Z Dylan Leard <[email protected]> # add table identifier to schema ggircs
swrs/public/table/naics [swrs/public/table/report swrs/public/table/facility swrs/public/table/naics_mapping] 2019-06-04T17:41:34Z Dylan Leard <[email protected]> # add table naics to schema ggircs
swrs/public/table/fuel [swrs/public/table/report swrs/public/table/unit swrs/public/table/fuel_mapping] 2019-06-04T18:01:26Z Dylan Leard <[email protected]> # add table fuel to schema ggircs
swrs/public/table/emission [swrs/public/table/activity swrs/public/table/facility swrs/public/table/fuel swrs/public/table/naics swrs/public/table/organisation swrs/public/table/report swrs/public/table/unit] 2019-06-04T17:46:17Z Dylan Leard <[email protected]> # add table emission to schema ggircs
swrs/public/table/permit [swrs/public/table/facility] 2019-06-04T18:10:43Z Dylan Leard <[email protected]> # add table permit to schema ggircs
swrs/public/table/parent_organisation [swrs/public/table/report swrs/public/table/organisation] 2019-06-04T18:24:19Z Dylan Leard <[email protected]> # add table parent_organisation to schema ggircs
swrs/public/table/address [swrs/public/table/report swrs/public/table/facility swrs/public/table/organisation swrs/public/table/parent_organisation] 2019-06-04T18:35:34Z Dylan Leard <[email protected]> # add table address to schema ggircs
swrs/public/table/contact [swrs/public/table/report swrs/public/table/address swrs/public/table/facility] 2019-06-04T18:29:57Z Dylan Leard <[email protected]> # add table contact to schema ggircs
swrs/public/table/additional_data [swrs/public/table/report swrs/public/table/activity] 2019-06-04T18:45:22Z Dylan Leard <[email protected]> # add table descriptor to schema ggircs
swrs/public/table/measured_emission_factor [swrs/public/table/fuel] 2019-06-04T18:51:37Z Dylan Leard <[email protected]> # add table measured_emission_factor to schema ggircs
swrs/public/table/fuel_charge [swrs/public/schema] 2019-06-19T23:35:41Z Dylan Leard <[email protected]> # add table fuel_charge to schema ggircs_swrs
swrs/public/table/implied_emission_factor [swrs/public/schema] 2019-05-30T17:34:31Z Dylan Leard <[email protected]> # DEPRECATED add implied emission factor table to schema ggircs_swrs
swrs/public/view/naics_category_mapping [swrs/public/table/naics swrs/public/table/naics_category swrs/public/table/naics_naics_category] 2019-06-25T23:02:46Z Dylan Leard <[email protected]> # add view naics_mapping to schema ggircs
swrs/public/view/pro_rated_carbon_tax_rate [swrs/public/schema swrs/public/table/fuel swrs/public/table/report] 2019-05-29T19:30:58Z Dylan Leard <[email protected]> # add pro rated carbon rate view to schema ggircs
swrs/public/view/pro_rated_fuel_charge [swrs/public/table/report swrs/public/table/fuel swrs/public/table/fuel_mapping swrs/public/table/fuel_charge] 2019-06-20T00:15:00Z Dylan Leard <[email protected]> # add view pro_rated_fuel_charge to schema ggircs
swrs/public/view/pro_rated_implied_emission_factor [swrs/public/schema swrs/public/table/fuel swrs/public/table/report] 2019-05-30T18:38:14Z Dylan Leard <[email protected]> # DEPRECATED add pro-rated implied emission factor view to schema ggircs
swrs/public/view/carbon_tax_calculation [swrs/public/schema swrs/public/table/fuel swrs/public/table/report] 2019-05-30T20:10:33Z Dylan Leard <[email protected]> # add carbon tax calculation view to schema ggircs
swrs/public/view/attributable_emission [swrs/public/schema] 2019-06-17T23:23:16Z Dylan Leard <[email protected]> # add view attributable emission to schema ggircs
swrs/public/view/attributable_emissions_with_details [swrs/public/schema] 2019-06-17T23:13:02Z Dylan Leard <[email protected]> # add view attributable emissions with details to schema ggircs
swrs/public/view/report_with_org [swrs/public/schema] 2019-06-17T23:13:54Z Dylan Leard <[email protected]> # add view report with org to schema ggircs
swrs/public/view/facility_details [swrs/public/schema swrs/public/table/facility swrs/public/table/organisation swrs/public/table/naics swrs/public/table/naics_mapping swrs/public/table/identifier] 2019-06-28T20:01:36Z Hamza Javed <[email protected]> # Build a view for facility detail
swrs/extract/schema 2019-07-19T18:29:40Z Matthieu Foucault <[email protected]> # Add a schema for SWRS extract
swrs/extract/table/ghgr_import [swrs/extract/schema] 2019-04-24T22:45:47Z Dylan Leard <[email protected]> # add table ghgr_import to schema ggircs_swrs_extract
swrs/transform/schema 2019-07-19T18:44:30Z Matthieu Foucault <[email protected]> # Add a schema for SWRS transform
swrs/transform/materialized_view/report [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-04-25T21:07:39Z Dylan Leard <[email protected]> # add materialized view report to schema ggircs_swrs
swrs/transform/materialized_view/organisation [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-04-29T20:14:13Z Dylan Leard <[email protected]> # add materialized view organisation to schema ggrics_swrs
swrs/transform/materialized_view/facility [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-04-29T22:24:35Z Dylan Leard <[email protected]> # add materialized view facility to schema ggrics_swrs
swrs/transform/materialized_view/activity [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-04-29T23:51:13Z Hamza Javed <[email protected]> # Create a materialized view for activity and subactivity from report
swrs/transform/materialized_view/flat [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-04-30T18:11:08Z Dylan Leard <[email protected]> # add materialized view flat to schema ggircs_swrs
swrs/transform/materialized_view/unit [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-05-02T19:54:25Z Dylan Leard <[email protected]> # add materialized view unit to schema ggircs_swrs
swrs/transform/materialized_view/identifier [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-04-30T23:33:13Z Dylan Leard <[email protected]> # add materialized view identifier to schema ggircs_swrs
swrs/transform/materialized_view/naics [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-05-01T23:52:03Z Dylan Leard <[email protected]> # add materialized view naics to schema ggircs_swrs
swrs/transform/materialized_view/emission [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-05-03T17:27:02Z Dylan Leard <[email protected]> # add materialized view emission to schema ggircs_swrs
swrs/transform/materialized_view/fuel [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-05-02T22:17:16Z Dylan Leard <[email protected]> # add materialized view fuel to schema ggircs_swrs
swrs/transform/materialized_view/permit [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-05-09T18:51:00Z Dylan Leard <[email protected]> # add materialized view permit to schema ggircs_swrs
swrs/transform/table/ignore_organisation [swrs/transform/schema] 2019-05-09T00:21:15Z Alec Wenzowski <[email protected]> # Add a list of swrs_organisation_id values to ignore
swrs/transform/view/final_report [swrs/transform/materialized_view/report swrs/transform/table/ignore_organisation] 2019-05-03T18:47:28Z Dylan Leard <[email protected]> # add materialized view final_report to schema ggircs_swrs
swrs/transform/materialized_view/parent_organisation [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-05-08T22:44:21Z Dylan Leard <[email protected]> # add materialized view parent_organisation to ggircs_swrs
swrs/transform/materialized_view/contact [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-05-08T20:37:31Z Dylan Leard <[email protected]> # add materialized view contact to schema ggircs_swrs
swrs/transform/materialized_view/address [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-05-03T20:18:07Z Dylan Leard <[email protected]> # add materialized view address to schema ggircs_swrs
swrs/transform/materialized_view/additional_data [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-05-07T18:18:40Z Hamza Javed <[email protected]> # Add Materialized View for descriptors for activities and subactivities
swrs/transform/materialized_view/measured_emission_factor [swrs/transform/schema swrs/extract/table/ghgr_import] 2019-05-14T17:44:59Z Dylan Leard <[email protected]> # add materialized view measured_emission_factor to sqitch plan
swrs/transform/function/transform [swrs/extract/table/ghgr_import swrs/transform/materialized_view/report swrs/transform/view/final_report swrs/transform/materialized_view/facility swrs/transform/materialized_view/organisation swrs/transform/materialized_view/address swrs/transform/materialized_view/contact swrs/transform/materialized_view/naics swrs/transform/materialized_view/identifier swrs/transform/materialized_view/permit swrs/transform/materialized_view/parent_organisation swrs/transform/materialized_view/activity swrs/transform/materialized_view/unit swrs/transform/materialized_view/fuel swrs/transform/materialized_view/emission swrs/transform/materialized_view/additional_data] 2019-05-23T16:31:06Z Dylan Leard <[email protected]> # added function transform to schema ggircs_swrs
swrs/transform/function/load_report [swrs/transform/materialized_view/report swrs/transform/view/final_report] 2019-07-02T17:00:57Z Dylan Leard <[email protected]> # add function load_report to schema ggircs_swrs
swrs/transform/function/load_organisation [swrs/transform/materialized_view/report swrs/transform/materialized_view/organisation swrs/transform/view/final_report] 2019-07-02T17:17:12Z Dylan Leard <[email protected]> # add function load_organisation to schema ggircs_swrs
swrs/transform/function/load_facility [swrs/transform/materialized_view/facility] 2019-06-20T23:47:20Z Hamza Javed <[email protected]> # Adding function to export facility to GGIRCS
swrs/transform/function/load_activity [swrs/transform/materialized_view/report swrs/transform/materialized_view/facility swrs/transform/view/final_report swrs/transform/materialized_view/activity] 2019-07-02T20:00:47Z Dylan Leard <[email protected]> # add function load_activity to schema ggircs_swrs
swrs/transform/function/load_unit [swrs/transform/view/final_report swrs/transform/materialized_view/activity swrs/transform/materialized_view/unit] 2019-07-02T20:12:20Z Dylan Leard <[email protected]> # add function load_unit to schema ggircs_swrs
swrs/transform/function/load_identifier [swrs/transform/materialized_view/report swrs/transform/materialized_view/facility swrs/transform/view/final_report swrs/transform/materialized_view/identifier] 2019-07-02T20:21:51Z Dylan Leard <[email protected]> # add function load_identifier to schema ggircs_swrs
swrs/transform/function/load_naics [swrs/transform/materialized_view/report swrs/transform/materialized_view/facility swrs/transform/view/final_report swrs/public/table/naics_mapping swrs/transform/materialized_view/naics] 2019-07-02T20:28:04Z Dylan Leard <[email protected]> # add function load_naics to schema ggircs_swrs
swrs/transform/function/load_fuel [swrs/transform/materialized_view/report swrs/transform/view/final_report swrs/transform/materialized_view/unit swrs/public/table/fuel_mapping swrs/transform/materialized_view/fuel] 2019-07-02T20:34:11Z Dylan Leard <[email protected]> # add function load_fuel to schema ggircs_swrs
swrs/transform/function/load_emission [swrs/transform/materialized_view/report swrs/transform/materialized_view/organisation swrs/transform/materialized_view/facility swrs/transform/materialized_view/activity swrs/transform/materialized_view/unit swrs/transform/materialized_view/naics swrs/transform/materialized_view/fuel swrs/transform/view/final_report swrs/public/table/fuel_mapping swrs/transform/materialized_view/emission] 2019-07-02T20:41:10Z Dylan Leard <[email protected]> # add function load_emission to schema ggircs_swrs
swrs/transform/function/load_permit [swrs/transform/materialized_view/facility swrs/transform/view/final_report swrs/transform/materialized_view/permit] 2019-07-02T20:47:20Z Dylan Leard <[email protected]> # add function load_permit to schema ggircs_swrs
swrs/transform/function/load_parent_organisation [swrs/transform/materialized_view/report swrs/transform/materialized_view/organisation swrs/transform/view/final_report swrs/transform/materialized_view/parent_organisation] 2019-07-02T20:51:55Z Dylan Leard <[email protected]> # add function load_parent_organisation to schema ggircs_swrs
swrs/transform/function/load_address [swrs/transform/materialized_view/report swrs/transform/materialized_view/organisation swrs/transform/materialized_view/facility swrs/transform/materialized_view/parent_organisation swrs/transform/view/final_report swrs/transform/materialized_view/address] 2019-07-02T20:57:23Z Dylan Leard <[email protected]> # add function load_address to schema ggircs_swrs
swrs/transform/function/load_contact [swrs/transform/materialized_view/report swrs/transform/materialized_view/organisation swrs/transform/materialized_view/facility swrs/transform/materialized_view/address swrs/transform/view/final_report swrs/transform/materialized_view/contact] 2019-07-02T21:35:14Z Dylan Leard <[email protected]> # add function load_contact to schema ggircs_swrs
swrs/transform/function/load_additional_data [swrs/transform/materialized_view/report swrs/transform/materialized_view/activity swrs/transform/view/final_report swrs/transform/materialized_view/additional_data] 2019-07-02T21:53:47Z Dylan Leard <[email protected]> # add function export_addtional_data_to_ggircs to schema ggircs_swrs
swrs/transform/function/load_measured_emission_factor [swrs/transform/materialized_view/fuel swrs/transform/view/final_report swrs/transform/materialized_view/measured_emission_factor] 2019-07-02T21:59:19Z Dylan Leard <[email protected]> # add function load_measured_emission_factor to schema ggircs_swrs
swrs/transform/function/clone_schema [swrs/transform/schema] 2019-07-19T22:56:08Z Matthieu Foucault <[email protected]> # Add a function to clone a schema
swrs/transform/function/load_carbon_tax_rate_mapping [swrs/transform/schema swrs/public/table/carbon_tax_rate_mapping] 2019-07-24T18:02:41Z Matthieu Foucault <[email protected]> # Add a function to load the carbon_tax_rate_mapping data
swrs/transform/function/load_fuel_carbon_tax_details [swrs/transform/schema swrs/public/table/fuel_carbon_tax_details] 2019-07-24T18:03:08Z Matthieu Foucault <[email protected]> # Add a function to load the fuel_carbon_tax_details data
swrs/transform/function/load_fuel_charge [swrs/transform/schema swrs/public/table/fuel_charge] 2019-07-24T18:03:43Z Matthieu Foucault <[email protected]> # Add a function to load the fuel_charge data
swrs/transform/function/load_fuel_mapping [swrs/transform/schema swrs/public/table/fuel_mapping] 2019-07-24T18:09:36Z Matthieu Foucault <[email protected]> # Add a function to load the fuel_mapping data
swrs/transform/function/load_implied_emission_factor [swrs/transform/schema swrs/public/table/implied_emission_factor] 2019-07-24T18:10:39Z Matthieu Foucault <[email protected]> # Add a function to load the implied_emission_factor data
swrs/transform/function/load_naics_category_type [swrs/transform/schema swrs/public/table/naics_category_type] 2019-07-24T18:11:44Z Matthieu Foucault <[email protected]> # Add a function to load the naics_category_type data
swrs/transform/function/load_naics_category [swrs/transform/schema swrs/public/table/naics_category] 2019-07-24T21:31:42Z Matthieu Foucault <[email protected]> # Add a function to load the naics_category data
swrs/transform/function/load_naics_mapping [swrs/transform/schema swrs/public/table/naics_mapping] 2019-07-24T21:32:11Z Matthieu Foucault <[email protected]> # Add a function to load the naics_mapping data
swrs/transform/function/load_naics_naics_category [swrs/transform/schema swrs/public/table/naics_naics_category] 2019-07-24T21:33:07Z Matthieu Foucault <[email protected]> # Add a function to load the naics_naics_category data
swrs/transform/function/load [swrs/transform/function/clone_schema swrs/extract/table/ghgr_import swrs/transform/materialized_view/report swrs/transform/view/final_report swrs/transform/materialized_view/facility swrs/transform/materialized_view/organisation swrs/transform/materialized_view/address swrs/transform/materialized_view/contact swrs/transform/materialized_view/naics swrs/transform/materialized_view/identifier swrs/transform/materialized_view/permit swrs/transform/materialized_view/parent_organisation swrs/transform/materialized_view/activity swrs/transform/materialized_view/unit swrs/transform/materialized_view/fuel swrs/transform/materialized_view/emission swrs/transform/materialized_view/additional_data] 2019-05-13T20:26:20Z Hamza Javed <[email protected]> # Add a function that exports all materialized views to tables