SCHEMA NAME = FoodmartDataSource_public
CREATE FOREIGN TABLE account (
        account_id integer NOT NULL OPTIONS (NAMEINSOURCE '"account_id"', NATIVE_TYPE 'int4'),
        account_parent integer OPTIONS (NAMEINSOURCE '"account_parent"', NATIVE_TYPE 'int4'),
        account_description string(30) OPTIONS (NAMEINSOURCE '"account_description"', NATIVE_TYPE 'varchar'),
        account_type string(30) NOT NULL OPTIONS (NAMEINSOURCE '"account_type"', NATIVE_TYPE 'varchar'),
        account_rollup string(30) NOT NULL OPTIONS (NAMEINSOURCE '"account_rollup"', NATIVE_TYPE 'varchar'),
        custom_members string(255) OPTIONS (NAMEINSOURCE '"custom_members"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."account"', UPDATABLE true);

CREATE FOREIGN TABLE agg_c_10_sales_fact_1997 (
        month_of_year short NOT NULL OPTIONS (NAMEINSOURCE '"month_of_year"', NATIVE_TYPE 'int2'),
        quarter string(30) NOT NULL OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar'),
        the_year short NOT NULL OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        customer_count integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_count"', NATIVE_TYPE 'int4'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_c_10_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_c_14_sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        month_of_year short NOT NULL OPTIONS (NAMEINSOURCE '"month_of_year"', NATIVE_TYPE 'int2'),
        quarter string(30) NOT NULL OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar'),
        the_year short NOT NULL OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_c_14_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_c_special_sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        time_month short NOT NULL OPTIONS (NAMEINSOURCE '"time_month"', NATIVE_TYPE 'int2'),
        time_quarter string(30) NOT NULL OPTIONS (NAMEINSOURCE '"time_quarter"', NATIVE_TYPE 'varchar'),
        time_year short NOT NULL OPTIONS (NAMEINSOURCE '"time_year"', NATIVE_TYPE 'int2'),
        store_sales_sum bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales_sum"', NATIVE_TYPE 'numeric'),
        store_cost_sum bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost_sum"', NATIVE_TYPE 'numeric'),
        unit_sales_sum bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales_sum"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_c_special_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_g_ms_pcat_sales_fact_1997 (
        gender string(30) NOT NULL OPTIONS (NAMEINSOURCE '"gender"', NATIVE_TYPE 'varchar'),
        marital_status string(30) NOT NULL OPTIONS (NAMEINSOURCE '"marital_status"', NATIVE_TYPE 'varchar'),
        product_family string(30) OPTIONS (NAMEINSOURCE '"product_family"', NATIVE_TYPE 'varchar'),
        product_department string(30) OPTIONS (NAMEINSOURCE '"product_department"', NATIVE_TYPE 'varchar'),
        product_category string(30) OPTIONS (NAMEINSOURCE '"product_category"', NATIVE_TYPE 'varchar'),
        month_of_year short NOT NULL OPTIONS (NAMEINSOURCE '"month_of_year"', NATIVE_TYPE 'int2'),
        quarter string(30) NOT NULL OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar'),
        the_year short NOT NULL OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        customer_count integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_count"', NATIVE_TYPE 'int4'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_g_ms_pcat_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_l_03_sales_fact_1997 (
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_l_03_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_l_04_sales_fact_1997 (
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        customer_count integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_count"', NATIVE_TYPE 'int4'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_l_04_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_l_05_sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_l_05_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_lc_06_sales_fact_1997 (
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        city string(30) NOT NULL OPTIONS (NAMEINSOURCE '"city"', NATIVE_TYPE 'varchar'),
        state_province string(30) NOT NULL OPTIONS (NAMEINSOURCE '"state_province"', NATIVE_TYPE 'varchar'),
        country string(30) NOT NULL OPTIONS (NAMEINSOURCE '"country"', NATIVE_TYPE 'varchar'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_lc_06_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_lc_100_sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        quarter string(30) NOT NULL OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar'),
        the_year short NOT NULL OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_lc_100_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_ll_01_sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_ll_01_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_pl_01_sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        store_sales_sum bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales_sum"', NATIVE_TYPE 'numeric'),
        store_cost_sum bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost_sum"', NATIVE_TYPE 'numeric'),
        unit_sales_sum bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales_sum"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_pl_01_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE category (
        category_id string(30) NOT NULL OPTIONS (NAMEINSOURCE '"category_id"', NATIVE_TYPE 'varchar'),
        category_parent string(30) OPTIONS (NAMEINSOURCE '"category_parent"', NATIVE_TYPE 'varchar'),
        category_description string(30) NOT NULL OPTIONS (NAMEINSOURCE '"category_description"', NATIVE_TYPE 'varchar'),
        category_rollup string(30) OPTIONS (NAMEINSOURCE '"category_rollup"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."category"', UPDATABLE true);

CREATE FOREIGN TABLE currency (
        currency_id integer NOT NULL OPTIONS (NAMEINSOURCE '"currency_id"', NATIVE_TYPE 'int4'),
        "date" date NOT NULL OPTIONS (NAMEINSOURCE '"date"', NATIVE_TYPE 'date'),
        currency string(30) NOT NULL OPTIONS (NAMEINSOURCE '"currency"', NATIVE_TYPE 'varchar'),
        conversion_ratio bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"conversion_ratio"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."currency"', UPDATABLE true);

CREATE FOREIGN TABLE customer (
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        account_num long NOT NULL OPTIONS (NAMEINSOURCE '"account_num"', NATIVE_TYPE 'int8'),
        lname string(30) NOT NULL OPTIONS (NAMEINSOURCE '"lname"', NATIVE_TYPE 'varchar'),
        fname string(30) NOT NULL OPTIONS (NAMEINSOURCE '"fname"', NATIVE_TYPE 'varchar'),
        mi string(30) OPTIONS (NAMEINSOURCE '"mi"', NATIVE_TYPE 'varchar'),
        address1 string(30) OPTIONS (NAMEINSOURCE '"address1"', NATIVE_TYPE 'varchar'),
        address2 string(30) OPTIONS (NAMEINSOURCE '"address2"', NATIVE_TYPE 'varchar'),
        address3 string(30) OPTIONS (NAMEINSOURCE '"address3"', NATIVE_TYPE 'varchar'),
        address4 string(30) OPTIONS (NAMEINSOURCE '"address4"', NATIVE_TYPE 'varchar'),
        city string(30) OPTIONS (NAMEINSOURCE '"city"', NATIVE_TYPE 'varchar'),
        state_province string(30) OPTIONS (NAMEINSOURCE '"state_province"', NATIVE_TYPE 'varchar'),
        postal_code string(30) NOT NULL OPTIONS (NAMEINSOURCE '"postal_code"', NATIVE_TYPE 'varchar'),
        country string(30) NOT NULL OPTIONS (NAMEINSOURCE '"country"', NATIVE_TYPE 'varchar'),
        customer_region_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_region_id"', NATIVE_TYPE 'int4'),
        phone1 string(30) NOT NULL OPTIONS (NAMEINSOURCE '"phone1"', NATIVE_TYPE 'varchar'),
        phone2 string(30) NOT NULL OPTIONS (NAMEINSOURCE '"phone2"', NATIVE_TYPE 'varchar'),
        birthdate date NOT NULL OPTIONS (NAMEINSOURCE '"birthdate"', NATIVE_TYPE 'date'),
        marital_status string(30) NOT NULL OPTIONS (NAMEINSOURCE '"marital_status"', NATIVE_TYPE 'varchar'),
        yearly_income string(30) NOT NULL OPTIONS (NAMEINSOURCE '"yearly_income"', NATIVE_TYPE 'varchar'),
        gender string(30) NOT NULL OPTIONS (NAMEINSOURCE '"gender"', NATIVE_TYPE 'varchar'),
        total_children short NOT NULL OPTIONS (NAMEINSOURCE '"total_children"', NATIVE_TYPE 'int2'),
        num_children_at_home short NOT NULL OPTIONS (NAMEINSOURCE '"num_children_at_home"', NATIVE_TYPE 'int2'),
        education string(30) NOT NULL OPTIONS (NAMEINSOURCE '"education"', NATIVE_TYPE 'varchar'),
        date_accnt_opened date NOT NULL OPTIONS (NAMEINSOURCE '"date_accnt_opened"', NATIVE_TYPE 'date'),
        member_card string(30) OPTIONS (NAMEINSOURCE '"member_card"', NATIVE_TYPE 'varchar'),
        occupation string(30) OPTIONS (NAMEINSOURCE '"occupation"', NATIVE_TYPE 'varchar'),
        houseowner string(30) OPTIONS (NAMEINSOURCE '"houseowner"', NATIVE_TYPE 'varchar'),
        num_cars_owned integer OPTIONS (NAMEINSOURCE '"num_cars_owned"', NATIVE_TYPE 'int4'),
        fullname string(60) NOT NULL OPTIONS (NAMEINSOURCE '"fullname"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."customer"', UPDATABLE true);

CREATE FOREIGN TABLE customer_sales (
        customer_fullname string(60) OPTIONS (NAMEINSOURCE '"customer_fullname"', NATIVE_TYPE 'varchar'),
        store_sales bigdecimal(131089,2147483647) OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."customer_sales"', UPDATABLE true);

CREATE FOREIGN TABLE days (
        "day" integer NOT NULL OPTIONS (NAMEINSOURCE '"day"', NATIVE_TYPE 'int4'),
        week_day string(30) NOT NULL OPTIONS (NAMEINSOURCE '"week_day"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."days"', UPDATABLE true);

CREATE FOREIGN TABLE department (
        department_id integer NOT NULL OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4'),
        department_description string(30) NOT NULL OPTIONS (NAMEINSOURCE '"department_description"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."department"', UPDATABLE true);

CREATE FOREIGN TABLE employee (
        employee_id integer NOT NULL OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4'),
        full_name string(30) NOT NULL OPTIONS (NAMEINSOURCE '"full_name"', NATIVE_TYPE 'varchar'),
        first_name string(30) NOT NULL OPTIONS (NAMEINSOURCE '"first_name"', NATIVE_TYPE 'varchar'),
        last_name string(30) NOT NULL OPTIONS (NAMEINSOURCE '"last_name"', NATIVE_TYPE 'varchar'),
        position_id integer OPTIONS (NAMEINSOURCE '"position_id"', NATIVE_TYPE 'int4'),
        position_title string(30) OPTIONS (NAMEINSOURCE '"position_title"', NATIVE_TYPE 'varchar'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        department_id integer NOT NULL OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4'),
        birth_date date NOT NULL OPTIONS (NAMEINSOURCE '"birth_date"', NATIVE_TYPE 'date'),
        hire_date timestamp OPTIONS (NAMEINSOURCE '"hire_date"', NATIVE_TYPE 'timestamp'),
        end_date timestamp OPTIONS (NAMEINSOURCE '"end_date"', NATIVE_TYPE 'timestamp'),
        salary bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"salary"', NATIVE_TYPE 'numeric'),
        supervisor_id integer OPTIONS (NAMEINSOURCE '"supervisor_id"', NATIVE_TYPE 'int4'),
        education_level string(30) NOT NULL OPTIONS (NAMEINSOURCE '"education_level"', NATIVE_TYPE 'varchar'),
        marital_status string(30) NOT NULL OPTIONS (NAMEINSOURCE '"marital_status"', NATIVE_TYPE 'varchar'),
        gender string(30) NOT NULL OPTIONS (NAMEINSOURCE '"gender"', NATIVE_TYPE 'varchar'),
        management_role string(30) OPTIONS (NAMEINSOURCE '"management_role"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."employee"', UPDATABLE true);

CREATE FOREIGN TABLE employee_closure (
        employee_id integer NOT NULL OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4'),
        supervisor_id integer NOT NULL OPTIONS (NAMEINSOURCE '"supervisor_id"', NATIVE_TYPE 'int4'),
        distance integer OPTIONS (NAMEINSOURCE '"distance"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."employee_closure"', UPDATABLE true);

CREATE FOREIGN TABLE expense_fact (
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        account_id integer NOT NULL OPTIONS (NAMEINSOURCE '"account_id"', NATIVE_TYPE 'int4'),
        exp_date timestamp NOT NULL OPTIONS (NAMEINSOURCE '"exp_date"', NATIVE_TYPE 'timestamp'),
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        category_id string(30) NOT NULL OPTIONS (NAMEINSOURCE '"category_id"', NATIVE_TYPE 'varchar'),
        currency_id integer NOT NULL OPTIONS (NAMEINSOURCE '"currency_id"', NATIVE_TYPE 'int4'),
        amount bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"amount"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."expense_fact"', UPDATABLE true);

CREATE FOREIGN TABLE i_account_id (
        account_id integer OPTIONS (NAMEINSOURCE '"account_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_account_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_account_parent (
        account_parent integer OPTIONS (NAMEINSOURCE '"account_parent"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_account_parent"', UPDATABLE true);

CREATE FOREIGN TABLE i_category_id (
        category_id string(30) OPTIONS (NAMEINSOURCE '"category_id"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_category_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_category_parent (
        category_parent string(30) OPTIONS (NAMEINSOURCE '"category_parent"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_category_parent"', UPDATABLE true);

CREATE FOREIGN TABLE i_currency (
        currency_id integer OPTIONS (NAMEINSOURCE '"currency_id"', NATIVE_TYPE 'int4'),
        "date" date OPTIONS (NAMEINSOURCE '"date"', NATIVE_TYPE 'date')
) OPTIONS (NAMEINSOURCE '"public"."i_currency"', UPDATABLE true);

CREATE FOREIGN TABLE i_cust_acct_num (
        account_num long OPTIONS (NAMEINSOURCE '"account_num"', NATIVE_TYPE 'int8')
) OPTIONS (NAMEINSOURCE '"public"."i_cust_acct_num"', UPDATABLE true);

CREATE FOREIGN TABLE i_cust_child_home (
        num_children_at_home short OPTIONS (NAMEINSOURCE '"num_children_at_home"', NATIVE_TYPE 'int2')
) OPTIONS (NAMEINSOURCE '"public"."i_cust_child_home"', UPDATABLE true);

CREATE FOREIGN TABLE i_cust_postal_code (
        postal_code string(30) OPTIONS (NAMEINSOURCE '"postal_code"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_cust_postal_code"', UPDATABLE true);

CREATE FOREIGN TABLE i_cust_region_id (
        customer_region_id integer OPTIONS (NAMEINSOURCE '"customer_region_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_cust_region_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_customer_fname (
        fname string(30) OPTIONS (NAMEINSOURCE '"fname"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_customer_fname"', UPDATABLE true);

CREATE FOREIGN TABLE i_customer_id (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_customer_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_customer_lname (
        lname string(30) OPTIONS (NAMEINSOURCE '"lname"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_customer_lname"', UPDATABLE true);

CREATE FOREIGN TABLE i_department_id (
        department_id integer OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_department_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_empl_closure (
        supervisor_id integer OPTIONS (NAMEINSOURCE '"supervisor_id"', NATIVE_TYPE 'int4'),
        employee_id integer OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_empl_closure"', UPDATABLE true);

CREATE FOREIGN TABLE i_empl_closure_emp (
        employee_id integer OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_empl_closure_emp"', UPDATABLE true);

CREATE FOREIGN TABLE i_empl_dept_id (
        department_id integer OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_empl_dept_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_empl_store_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_empl_store_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_empl_super_id (
        supervisor_id integer OPTIONS (NAMEINSOURCE '"supervisor_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_empl_super_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_employee_id (
        employee_id integer OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_employee_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_expense_acct_id (
        account_id integer OPTIONS (NAMEINSOURCE '"account_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_expense_acct_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_expense_store_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_expense_store_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_expense_time_id (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_expense_time_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_97_prod_id (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_97_prod_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_97_store_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_97_store_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_97_time_id (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_97_time_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_97_wrhse_id (
        warehouse_id integer OPTIONS (NAMEINSOURCE '"warehouse_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_97_wrhse_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_98_prod_id (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_98_prod_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_98_store_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_98_store_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_98_time_id (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_98_time_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_98_wrhse_id (
        warehouse_id integer OPTIONS (NAMEINSOURCE '"warehouse_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_98_wrhse_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_position_id (
        position_id integer OPTIONS (NAMEINSOURCE '"position_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_position_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_prod_brand_name (
        brand_name string(60) OPTIONS (NAMEINSOURCE '"brand_name"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_prod_brand_name"', UPDATABLE true);

CREATE FOREIGN TABLE i_prod_class_id (
        product_class_id integer OPTIONS (NAMEINSOURCE '"product_class_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_prod_class_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_product_id (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_product_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_product_name (
        product_name string(60) OPTIONS (NAMEINSOURCE '"product_name"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_product_name"', UPDATABLE true);

CREATE FOREIGN TABLE i_product_SKU (
        SKU long OPTIONS (NAMEINSOURCE '"SKU"', NATIVE_TYPE 'int8')
) OPTIONS (NAMEINSOURCE '"public"."i_product_SKU"', UPDATABLE true);

CREATE FOREIGN TABLE i_promo_dist_id (
        promotion_district_id integer OPTIONS (NAMEINSOURCE '"promotion_district_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_promo_dist_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_promotion_id (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_promotion_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_rsrv_empl_dept (
        department_id integer OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_rsrv_empl_dept"', UPDATABLE true);

CREATE FOREIGN TABLE i_rsrv_empl_id (
        employee_id integer OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_rsrv_empl_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_rsrv_empl_store (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_rsrv_empl_store"', UPDATABLE true);

CREATE FOREIGN TABLE i_rsrv_empl_sup (
        supervisor_id integer OPTIONS (NAMEINSOURCE '"supervisor_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_rsrv_empl_sup"', UPDATABLE true);

CREATE FOREIGN TABLE i_salary_employee (
        employee_id integer OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_salary_employee"', UPDATABLE true);

CREATE FOREIGN TABLE i_salary_pay_date (
        pay_date timestamp OPTIONS (NAMEINSOURCE '"pay_date"', NATIVE_TYPE 'timestamp')
) OPTIONS (NAMEINSOURCE '"public"."i_salary_pay_date"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97c14cust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97c14cust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97c14prod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97c14prod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97c14promo (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97c14promo"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97c14store (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97c14store"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_gender (
        gender string(30) OPTIONS (NAMEINSOURCE '"gender"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_gender"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_ms (
        marital_status string(30) OPTIONS (NAMEINSOURCE '"marital_status"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_ms"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_pcat (
        product_category string(30) OPTIONS (NAMEINSOURCE '"product_category"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_pcat"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_pdept (
        product_department string(30) OPTIONS (NAMEINSOURCE '"product_department"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_pdept"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_pfam (
        product_family string(30) OPTIONS (NAMEINSOURCE '"product_family"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_pfam"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_tmonth (
        month_of_year short OPTIONS (NAMEINSOURCE '"month_of_year"', NATIVE_TYPE 'int2')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_tmonth"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_tquarter (
        quarter string(30) OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_tquarter"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_tyear (
        the_year short OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_tyear"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97l05cust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97l05cust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97l05prod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97l05prod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97l05promo (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97l05promo"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97l05store (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97l05store"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97lc100cust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97lc100cust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97lc100prod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97lc100prod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97ll01cust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97ll01cust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97ll01prod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97ll01prod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97ll01time (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97ll01time"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97pl01cust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97pl01cust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97pl01prod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97pl01prod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97pl01time (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97pl01time"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97speccust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97speccust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97specprod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97specprod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97specpromo (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97specpromo"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97specstore (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97specstore"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_1998_prod_id (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_1998_prod_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_1998_promo (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_1998_promo"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_1998_store (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_1998_store"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_1998_time_id (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_1998_time_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_97_cust_id (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_97_cust_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_97_prod_id (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_97_prod_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_97_promo_id (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_97_promo_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_97_store_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_97_store_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_97_time_id (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_97_time_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_98_cust_id (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_98_cust_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_dec98_cust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_dec98_cust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_dec98_prod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_dec98_prod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_dec98_promo (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_dec98_promo"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_dec98_store (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_dec98_store"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_dec98_time (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_dec98_time"', UPDATABLE true);

CREATE FOREIGN TABLE i_store_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_store_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_store_raggd_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_store_raggd_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_store_region_id (
        region_id integer OPTIONS (NAMEINSOURCE '"region_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_store_region_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_store_rggd_reg (
        region_id integer OPTIONS (NAMEINSOURCE '"region_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_store_rggd_reg"', UPDATABLE true);

CREATE FOREIGN TABLE i_time_day (
        the_date timestamp OPTIONS (NAMEINSOURCE '"the_date"', NATIVE_TYPE 'timestamp')
) OPTIONS (NAMEINSOURCE '"public"."i_time_day"', UPDATABLE true);

CREATE FOREIGN TABLE i_time_id (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_time_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_time_month (
        month_of_year short OPTIONS (NAMEINSOURCE '"month_of_year"', NATIVE_TYPE 'int2')
) OPTIONS (NAMEINSOURCE '"public"."i_time_month"', UPDATABLE true);

CREATE FOREIGN TABLE i_time_quarter (
        quarter string(30) OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_time_quarter"', UPDATABLE true);

CREATE FOREIGN TABLE i_time_year (
        the_year short OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2')
) OPTIONS (NAMEINSOURCE '"public"."i_time_year"', UPDATABLE true);

CREATE FOREIGN TABLE inventory_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        warehouse_id integer OPTIONS (NAMEINSOURCE '"warehouse_id"', NATIVE_TYPE 'int4'),
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        units_ordered integer OPTIONS (NAMEINSOURCE '"units_ordered"', NATIVE_TYPE 'int4'),
        units_shipped integer OPTIONS (NAMEINSOURCE '"units_shipped"', NATIVE_TYPE 'int4'),
        warehouse_sales bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"warehouse_sales"', NATIVE_TYPE 'numeric'),
        warehouse_cost bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"warehouse_cost"', NATIVE_TYPE 'numeric'),
        supply_time short OPTIONS (NAMEINSOURCE '"supply_time"', NATIVE_TYPE 'int2'),
        store_invoice bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"store_invoice"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."inventory_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE inventory_fact_1998 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        warehouse_id integer OPTIONS (NAMEINSOURCE '"warehouse_id"', NATIVE_TYPE 'int4'),
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        units_ordered integer OPTIONS (NAMEINSOURCE '"units_ordered"', NATIVE_TYPE 'int4'),
        units_shipped integer OPTIONS (NAMEINSOURCE '"units_shipped"', NATIVE_TYPE 'int4'),
        warehouse_sales bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"warehouse_sales"', NATIVE_TYPE 'numeric'),
        warehouse_cost bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"warehouse_cost"', NATIVE_TYPE 'numeric'),
        supply_time short OPTIONS (NAMEINSOURCE '"supply_time"', NATIVE_TYPE 'int2'),
        store_invoice bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"store_invoice"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."inventory_fact_1998"', UPDATABLE true);

CREATE FOREIGN TABLE monthly_profit (
        the_date timestamp OPTIONS (NAMEINSOURCE '"the_date"', NATIVE_TYPE 'timestamp'),
        the_year short OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2'),
        the_month string(30) OPTIONS (NAMEINSOURCE '"the_month"', NATIVE_TYPE 'varchar'),
        the_quarter string(30) OPTIONS (NAMEINSOURCE '"the_quarter"', NATIVE_TYPE 'varchar'),
        time_by_day_month_of_year short OPTIONS (NAMEINSOURCE '"time_by_day_month_of_year"', NATIVE_TYPE 'int2'),
        store_sales bigdecimal(131089,2147483647) OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        profit bigdecimal(131089,2147483647) OPTIONS (NAMEINSOURCE '"profit"', NATIVE_TYPE 'numeric'),
        store_state string(30) OPTIONS (NAMEINSOURCE '"store_state"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."monthly_profit"', UPDATABLE true);

CREATE FOREIGN TABLE position (
        position_id integer NOT NULL OPTIONS (NAMEINSOURCE '"position_id"', NATIVE_TYPE 'int4'),
        position_title string(30) NOT NULL OPTIONS (NAMEINSOURCE '"position_title"', NATIVE_TYPE 'varchar'),
        pay_type string(30) NOT NULL OPTIONS (NAMEINSOURCE '"pay_type"', NATIVE_TYPE 'varchar'),
        min_scale bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"min_scale"', NATIVE_TYPE 'numeric'),
        max_scale bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"max_scale"', NATIVE_TYPE 'numeric'),
        management_role string(30) NOT NULL OPTIONS (NAMEINSOURCE '"management_role"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."position"', UPDATABLE true);

CREATE FOREIGN TABLE product (
        product_class_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_class_id"', NATIVE_TYPE 'int4'),
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        brand_name string(60) OPTIONS (NAMEINSOURCE '"brand_name"', NATIVE_TYPE 'varchar'),
        product_name string(60) NOT NULL OPTIONS (NAMEINSOURCE '"product_name"', NATIVE_TYPE 'varchar'),
        sku long NOT NULL OPTIONS (NAMEINSOURCE '"sku"', NATIVE_TYPE 'int8'),
        srp bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"srp"', NATIVE_TYPE 'numeric'),
        gross_weight float OPTIONS (NAMEINSOURCE '"gross_weight"', NATIVE_TYPE 'float4'),
        net_weight float OPTIONS (NAMEINSOURCE '"net_weight"', NATIVE_TYPE 'float4'),
        recyclable_package boolean OPTIONS (NAMEINSOURCE '"recyclable_package"', NATIVE_TYPE 'bool'),
        low_fat boolean OPTIONS (NAMEINSOURCE '"low_fat"', NATIVE_TYPE 'bool'),
        units_per_case short OPTIONS (NAMEINSOURCE '"units_per_case"', NATIVE_TYPE 'int2'),
        cases_per_pallet short OPTIONS (NAMEINSOURCE '"cases_per_pallet"', NATIVE_TYPE 'int2'),
        shelf_width float OPTIONS (NAMEINSOURCE '"shelf_width"', NATIVE_TYPE 'float4'),
        shelf_height float OPTIONS (NAMEINSOURCE '"shelf_height"', NATIVE_TYPE 'float4'),
        shelf_depth float OPTIONS (NAMEINSOURCE '"shelf_depth"', NATIVE_TYPE 'float4')
) OPTIONS (NAMEINSOURCE '"public"."product"', UPDATABLE true);

CREATE FOREIGN TABLE product_class (
        product_class_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_class_id"', NATIVE_TYPE 'int4'),
        product_subcategory string(30) OPTIONS (NAMEINSOURCE '"product_subcategory"', NATIVE_TYPE 'varchar'),
        product_category string(30) OPTIONS (NAMEINSOURCE '"product_category"', NATIVE_TYPE 'varchar'),
        product_department string(30) OPTIONS (NAMEINSOURCE '"product_department"', NATIVE_TYPE 'varchar'),
        product_family string(30) OPTIONS (NAMEINSOURCE '"product_family"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."product_class"', UPDATABLE true);

CREATE FOREIGN TABLE product_sales (
        product_product_name string(60) OPTIONS (NAMEINSOURCE '"product_product_name"', NATIVE_TYPE 'varchar'),
        store_sales bigdecimal(131089,2147483647) OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        product_product_id integer OPTIONS (NAMEINSOURCE '"product_product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."product_sales"', UPDATABLE true);

CREATE FOREIGN TABLE promotion (
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        promotion_district_id integer OPTIONS (NAMEINSOURCE '"promotion_district_id"', NATIVE_TYPE 'int4'),
        promotion_name string(30) OPTIONS (NAMEINSOURCE '"promotion_name"', NATIVE_TYPE 'varchar'),
        media_type string(30) OPTIONS (NAMEINSOURCE '"media_type"', NATIVE_TYPE 'varchar'),
        cost bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"cost"', NATIVE_TYPE 'numeric'),
        start_date timestamp OPTIONS (NAMEINSOURCE '"start_date"', NATIVE_TYPE 'timestamp'),
        end_date timestamp OPTIONS (NAMEINSOURCE '"end_date"', NATIVE_TYPE 'timestamp')
) OPTIONS (NAMEINSOURCE '"public"."promotion"', UPDATABLE true);

CREATE FOREIGN TABLE promotion_sales (
        promotion_promotion_name string(30) OPTIONS (NAMEINSOURCE '"promotion_promotion_name"', NATIVE_TYPE 'varchar'),
        store_sales bigdecimal(131089,2147483647) OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        promotion_promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."promotion_sales"', UPDATABLE true);

CREATE FOREIGN TABLE region (
        region_id integer NOT NULL OPTIONS (NAMEINSOURCE '"region_id"', NATIVE_TYPE 'int4'),
        sales_city string(30) OPTIONS (NAMEINSOURCE '"sales_city"', NATIVE_TYPE 'varchar'),
        sales_state_province string(30) OPTIONS (NAMEINSOURCE '"sales_state_province"', NATIVE_TYPE 'varchar'),
        sales_district string(30) OPTIONS (NAMEINSOURCE '"sales_district"', NATIVE_TYPE 'varchar'),
        sales_region string(30) OPTIONS (NAMEINSOURCE '"sales_region"', NATIVE_TYPE 'varchar'),
        sales_country string(30) OPTIONS (NAMEINSOURCE '"sales_country"', NATIVE_TYPE 'varchar'),
        sales_district_id integer OPTIONS (NAMEINSOURCE '"sales_district_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."region"', UPDATABLE true);

CREATE FOREIGN TABLE reserve_employee (
        employee_id integer NOT NULL OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4'),
        full_name string(30) NOT NULL OPTIONS (NAMEINSOURCE '"full_name"', NATIVE_TYPE 'varchar'),
        first_name string(30) NOT NULL OPTIONS (NAMEINSOURCE '"first_name"', NATIVE_TYPE 'varchar'),
        last_name string(30) NOT NULL OPTIONS (NAMEINSOURCE '"last_name"', NATIVE_TYPE 'varchar'),
        position_id integer OPTIONS (NAMEINSOURCE '"position_id"', NATIVE_TYPE 'int4'),
        position_title string(30) OPTIONS (NAMEINSOURCE '"position_title"', NATIVE_TYPE 'varchar'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        department_id integer NOT NULL OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4'),
        birth_date timestamp NOT NULL OPTIONS (NAMEINSOURCE '"birth_date"', NATIVE_TYPE 'timestamp'),
        hire_date timestamp OPTIONS (NAMEINSOURCE '"hire_date"', NATIVE_TYPE 'timestamp'),
        end_date timestamp OPTIONS (NAMEINSOURCE '"end_date"', NATIVE_TYPE 'timestamp'),
        salary bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"salary"', NATIVE_TYPE 'numeric'),
        supervisor_id integer OPTIONS (NAMEINSOURCE '"supervisor_id"', NATIVE_TYPE 'int4'),
        education_level string(30) NOT NULL OPTIONS (NAMEINSOURCE '"education_level"', NATIVE_TYPE 'varchar'),
        marital_status string(30) NOT NULL OPTIONS (NAMEINSOURCE '"marital_status"', NATIVE_TYPE 'varchar'),
        gender string(30) NOT NULL OPTIONS (NAMEINSOURCE '"gender"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."reserve_employee"', UPDATABLE true);

CREATE FOREIGN TABLE salary (
        pay_date timestamp NOT NULL OPTIONS (NAMEINSOURCE '"pay_date"', NATIVE_TYPE 'timestamp'),
        employee_id integer NOT NULL OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4'),
        department_id integer NOT NULL OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4'),
        currency_id integer NOT NULL OPTIONS (NAMEINSOURCE '"currency_id"', NATIVE_TYPE 'int4'),
        salary_paid bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"salary_paid"', NATIVE_TYPE 'numeric'),
        overtime_paid bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"overtime_paid"', NATIVE_TYPE 'numeric'),
        vacation_accrued float NOT NULL OPTIONS (NAMEINSOURCE '"vacation_accrued"', NATIVE_TYPE 'float4'),
        vacation_used float NOT NULL OPTIONS (NAMEINSOURCE '"vacation_used"', NATIVE_TYPE 'float4')
) OPTIONS (NAMEINSOURCE '"public"."salary"', UPDATABLE true);

CREATE FOREIGN TABLE sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE sales_fact_1998 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."sales_fact_1998"', UPDATABLE true);

CREATE FOREIGN TABLE sales_fact_dec_1998 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."sales_fact_dec_1998"', UPDATABLE true);

CREATE FOREIGN TABLE store (
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        store_type string(30) OPTIONS (NAMEINSOURCE '"store_type"', NATIVE_TYPE 'varchar'),
        region_id integer OPTIONS (NAMEINSOURCE '"region_id"', NATIVE_TYPE 'int4'),
        store_name string(30) OPTIONS (NAMEINSOURCE '"store_name"', NATIVE_TYPE 'varchar'),
        store_number integer OPTIONS (NAMEINSOURCE '"store_number"', NATIVE_TYPE 'int4'),
        store_street_address string(30) OPTIONS (NAMEINSOURCE '"store_street_address"', NATIVE_TYPE 'varchar'),
        store_city string(30) OPTIONS (NAMEINSOURCE '"store_city"', NATIVE_TYPE 'varchar'),
        store_state string(30) OPTIONS (NAMEINSOURCE '"store_state"', NATIVE_TYPE 'varchar'),
        store_postal_code string(30) OPTIONS (NAMEINSOURCE '"store_postal_code"', NATIVE_TYPE 'varchar'),
        store_country string(30) OPTIONS (NAMEINSOURCE '"store_country"', NATIVE_TYPE 'varchar'),
        store_manager string(30) OPTIONS (NAMEINSOURCE '"store_manager"', NATIVE_TYPE 'varchar'),
        store_phone string(30) OPTIONS (NAMEINSOURCE '"store_phone"', NATIVE_TYPE 'varchar'),
        store_fax string(30) OPTIONS (NAMEINSOURCE '"store_fax"', NATIVE_TYPE 'varchar'),
        first_opened_date timestamp OPTIONS (NAMEINSOURCE '"first_opened_date"', NATIVE_TYPE 'timestamp'),
        last_remodel_date timestamp OPTIONS (NAMEINSOURCE '"last_remodel_date"', NATIVE_TYPE 'timestamp'),
        store_sqft integer OPTIONS (NAMEINSOURCE '"store_sqft"', NATIVE_TYPE 'int4'),
        grocery_sqft integer OPTIONS (NAMEINSOURCE '"grocery_sqft"', NATIVE_TYPE 'int4'),
        frozen_sqft integer OPTIONS (NAMEINSOURCE '"frozen_sqft"', NATIVE_TYPE 'int4'),
        meat_sqft integer OPTIONS (NAMEINSOURCE '"meat_sqft"', NATIVE_TYPE 'int4'),
        coffee_bar boolean OPTIONS (NAMEINSOURCE '"coffee_bar"', NATIVE_TYPE 'bool'),
        video_store boolean OPTIONS (NAMEINSOURCE '"video_store"', NATIVE_TYPE 'bool'),
        salad_bar boolean OPTIONS (NAMEINSOURCE '"salad_bar"', NATIVE_TYPE 'bool'),
        prepared_food boolean OPTIONS (NAMEINSOURCE '"prepared_food"', NATIVE_TYPE 'bool'),
        florist boolean OPTIONS (NAMEINSOURCE '"florist"', NATIVE_TYPE 'bool')
) OPTIONS (NAMEINSOURCE '"public"."store"', UPDATABLE true);

CREATE FOREIGN TABLE store_ragged (
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        store_type string(30) OPTIONS (NAMEINSOURCE '"store_type"', NATIVE_TYPE 'varchar'),
        region_id integer OPTIONS (NAMEINSOURCE '"region_id"', NATIVE_TYPE 'int4'),
        store_name string(30) OPTIONS (NAMEINSOURCE '"store_name"', NATIVE_TYPE 'varchar'),
        store_number integer OPTIONS (NAMEINSOURCE '"store_number"', NATIVE_TYPE 'int4'),
        store_street_address string(30) OPTIONS (NAMEINSOURCE '"store_street_address"', NATIVE_TYPE 'varchar'),
        store_city string(30) OPTIONS (NAMEINSOURCE '"store_city"', NATIVE_TYPE 'varchar'),
        store_state string(30) OPTIONS (NAMEINSOURCE '"store_state"', NATIVE_TYPE 'varchar'),
        store_postal_code string(30) OPTIONS (NAMEINSOURCE '"store_postal_code"', NATIVE_TYPE 'varchar'),
        store_country string(30) OPTIONS (NAMEINSOURCE '"store_country"', NATIVE_TYPE 'varchar'),
        store_manager string(30) OPTIONS (NAMEINSOURCE '"store_manager"', NATIVE_TYPE 'varchar'),
        store_phone string(30) OPTIONS (NAMEINSOURCE '"store_phone"', NATIVE_TYPE 'varchar'),
        store_fax string(30) OPTIONS (NAMEINSOURCE '"store_fax"', NATIVE_TYPE 'varchar'),
        first_opened_date timestamp OPTIONS (NAMEINSOURCE '"first_opened_date"', NATIVE_TYPE 'timestamp'),
        last_remodel_date timestamp OPTIONS (NAMEINSOURCE '"last_remodel_date"', NATIVE_TYPE 'timestamp'),
        store_sqft integer OPTIONS (NAMEINSOURCE '"store_sqft"', NATIVE_TYPE 'int4'),
        grocery_sqft integer OPTIONS (NAMEINSOURCE '"grocery_sqft"', NATIVE_TYPE 'int4'),
        frozen_sqft integer OPTIONS (NAMEINSOURCE '"frozen_sqft"', NATIVE_TYPE 'int4'),
        meat_sqft integer OPTIONS (NAMEINSOURCE '"meat_sqft"', NATIVE_TYPE 'int4'),
        coffee_bar boolean OPTIONS (NAMEINSOURCE '"coffee_bar"', NATIVE_TYPE 'bool'),
        video_store boolean OPTIONS (NAMEINSOURCE '"video_store"', NATIVE_TYPE 'bool'),
        salad_bar boolean OPTIONS (NAMEINSOURCE '"salad_bar"', NATIVE_TYPE 'bool'),
        prepared_food boolean OPTIONS (NAMEINSOURCE '"prepared_food"', NATIVE_TYPE 'bool'),
        florist boolean OPTIONS (NAMEINSOURCE '"florist"', NATIVE_TYPE 'bool')
) OPTIONS (NAMEINSOURCE '"public"."store_ragged"', UPDATABLE true);

CREATE FOREIGN TABLE time_by_day (
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        the_date timestamp OPTIONS (NAMEINSOURCE '"the_date"', NATIVE_TYPE 'timestamp'),
        the_day string(30) OPTIONS (NAMEINSOURCE '"the_day"', NATIVE_TYPE 'varchar'),
        the_month string(30) OPTIONS (NAMEINSOURCE '"the_month"', NATIVE_TYPE 'varchar'),
        the_year short OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2'),
        day_of_month short OPTIONS (NAMEINSOURCE '"day_of_month"', NATIVE_TYPE 'int2'),
        week_of_year integer OPTIONS (NAMEINSOURCE '"week_of_year"', NATIVE_TYPE 'int4'),
        month_of_year short OPTIONS (NAMEINSOURCE '"month_of_year"', NATIVE_TYPE 'int2'),
        quarter string(30) OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar'),
        fiscal_period string(30) OPTIONS (NAMEINSOURCE '"fiscal_period"', NATIVE_TYPE 'varchar'),
        day_of_week integer OPTIONS (NAMEINSOURCE '"day_of_week"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."time_by_day"', UPDATABLE true);

CREATE FOREIGN TABLE warehouse (
        warehouse_id integer NOT NULL OPTIONS (NAMEINSOURCE '"warehouse_id"', NATIVE_TYPE 'int4'),
        warehouse_class_id integer OPTIONS (NAMEINSOURCE '"warehouse_class_id"', NATIVE_TYPE 'int4'),
        stores_id integer OPTIONS (NAMEINSOURCE '"stores_id"', NATIVE_TYPE 'int4'),
        warehouse_name string(60) OPTIONS (NAMEINSOURCE '"warehouse_name"', NATIVE_TYPE 'varchar'),
        wa_address1 string(30) OPTIONS (NAMEINSOURCE '"wa_address1"', NATIVE_TYPE 'varchar'),
        wa_address2 string(30) OPTIONS (NAMEINSOURCE '"wa_address2"', NATIVE_TYPE 'varchar'),
        wa_address3 string(30) OPTIONS (NAMEINSOURCE '"wa_address3"', NATIVE_TYPE 'varchar'),
        wa_address4 string(30) OPTIONS (NAMEINSOURCE '"wa_address4"', NATIVE_TYPE 'varchar'),
        warehouse_city string(30) OPTIONS (NAMEINSOURCE '"warehouse_city"', NATIVE_TYPE 'varchar'),
        warehouse_state_province string(30) OPTIONS (NAMEINSOURCE '"warehouse_state_province"', NATIVE_TYPE 'varchar'),
        warehouse_postal_code string(30) OPTIONS (NAMEINSOURCE '"warehouse_postal_code"', NATIVE_TYPE 'varchar'),
        warehouse_country string(30) OPTIONS (NAMEINSOURCE '"warehouse_country"', NATIVE_TYPE 'varchar'),
        warehouse_owner_name string(30) OPTIONS (NAMEINSOURCE '"warehouse_owner_name"', NATIVE_TYPE 'varchar'),
        warehouse_phone string(30) OPTIONS (NAMEINSOURCE '"warehouse_phone"', NATIVE_TYPE 'varchar'),
        warehouse_fax string(30) OPTIONS (NAMEINSOURCE '"warehouse_fax"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."warehouse"', UPDATABLE true);

CREATE FOREIGN TABLE warehouse_class (
        warehouse_class_id integer NOT NULL OPTIONS (NAMEINSOURCE '"warehouse_class_id"', NATIVE_TYPE 'int4'),
        description string(30) OPTIONS (NAMEINSOURCE '"description"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."warehouse_class"', UPDATABLE true);

SCHEMA NAME = FoodmartDataSourceJNDI_public
CREATE FOREIGN TABLE account (
        account_id integer NOT NULL OPTIONS (NAMEINSOURCE '"account_id"', NATIVE_TYPE 'int4'),
        account_parent integer OPTIONS (NAMEINSOURCE '"account_parent"', NATIVE_TYPE 'int4'),
        account_description string(30) OPTIONS (NAMEINSOURCE '"account_description"', NATIVE_TYPE 'varchar'),
        account_type string(30) NOT NULL OPTIONS (NAMEINSOURCE '"account_type"', NATIVE_TYPE 'varchar'),
        account_rollup string(30) NOT NULL OPTIONS (NAMEINSOURCE '"account_rollup"', NATIVE_TYPE 'varchar'),
        custom_members string(255) OPTIONS (NAMEINSOURCE '"custom_members"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."account"', UPDATABLE true);

CREATE FOREIGN TABLE agg_c_10_sales_fact_1997 (
        month_of_year short NOT NULL OPTIONS (NAMEINSOURCE '"month_of_year"', NATIVE_TYPE 'int2'),
        quarter string(30) NOT NULL OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar'),
        the_year short NOT NULL OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        customer_count integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_count"', NATIVE_TYPE 'int4'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_c_10_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_c_14_sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        month_of_year short NOT NULL OPTIONS (NAMEINSOURCE '"month_of_year"', NATIVE_TYPE 'int2'),
        quarter string(30) NOT NULL OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar'),
        the_year short NOT NULL OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_c_14_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_c_special_sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        time_month short NOT NULL OPTIONS (NAMEINSOURCE '"time_month"', NATIVE_TYPE 'int2'),
        time_quarter string(30) NOT NULL OPTIONS (NAMEINSOURCE '"time_quarter"', NATIVE_TYPE 'varchar'),
        time_year short NOT NULL OPTIONS (NAMEINSOURCE '"time_year"', NATIVE_TYPE 'int2'),
        store_sales_sum bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales_sum"', NATIVE_TYPE 'numeric'),
        store_cost_sum bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost_sum"', NATIVE_TYPE 'numeric'),
        unit_sales_sum bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales_sum"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_c_special_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_g_ms_pcat_sales_fact_1997 (
        gender string(30) NOT NULL OPTIONS (NAMEINSOURCE '"gender"', NATIVE_TYPE 'varchar'),
        marital_status string(30) NOT NULL OPTIONS (NAMEINSOURCE '"marital_status"', NATIVE_TYPE 'varchar'),
        product_family string(30) OPTIONS (NAMEINSOURCE '"product_family"', NATIVE_TYPE 'varchar'),
        product_department string(30) OPTIONS (NAMEINSOURCE '"product_department"', NATIVE_TYPE 'varchar'),
        product_category string(30) OPTIONS (NAMEINSOURCE '"product_category"', NATIVE_TYPE 'varchar'),
        month_of_year short NOT NULL OPTIONS (NAMEINSOURCE '"month_of_year"', NATIVE_TYPE 'int2'),
        quarter string(30) NOT NULL OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar'),
        the_year short NOT NULL OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        customer_count integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_count"', NATIVE_TYPE 'int4'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_g_ms_pcat_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_l_03_sales_fact_1997 (
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_l_03_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_l_04_sales_fact_1997 (
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        customer_count integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_count"', NATIVE_TYPE 'int4'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_l_04_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_l_05_sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_l_05_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_lc_06_sales_fact_1997 (
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        city string(30) NOT NULL OPTIONS (NAMEINSOURCE '"city"', NATIVE_TYPE 'varchar'),
        state_province string(30) NOT NULL OPTIONS (NAMEINSOURCE '"state_province"', NATIVE_TYPE 'varchar'),
        country string(30) NOT NULL OPTIONS (NAMEINSOURCE '"country"', NATIVE_TYPE 'varchar'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_lc_06_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_lc_100_sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        quarter string(30) NOT NULL OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar'),
        the_year short NOT NULL OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_lc_100_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_ll_01_sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_ll_01_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE agg_pl_01_sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        store_sales_sum bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales_sum"', NATIVE_TYPE 'numeric'),
        store_cost_sum bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost_sum"', NATIVE_TYPE 'numeric'),
        unit_sales_sum bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales_sum"', NATIVE_TYPE 'numeric'),
        fact_count integer NOT NULL OPTIONS (NAMEINSOURCE '"fact_count"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."agg_pl_01_sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE category (
        category_id string(30) NOT NULL OPTIONS (NAMEINSOURCE '"category_id"', NATIVE_TYPE 'varchar'),
        category_parent string(30) OPTIONS (NAMEINSOURCE '"category_parent"', NATIVE_TYPE 'varchar'),
        category_description string(30) NOT NULL OPTIONS (NAMEINSOURCE '"category_description"', NATIVE_TYPE 'varchar'),
        category_rollup string(30) OPTIONS (NAMEINSOURCE '"category_rollup"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."category"', UPDATABLE true);

CREATE FOREIGN TABLE currency (
        currency_id integer NOT NULL OPTIONS (NAMEINSOURCE '"currency_id"', NATIVE_TYPE 'int4'),
        "date" date NOT NULL OPTIONS (NAMEINSOURCE '"date"', NATIVE_TYPE 'date'),
        currency string(30) NOT NULL OPTIONS (NAMEINSOURCE '"currency"', NATIVE_TYPE 'varchar'),
        conversion_ratio bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"conversion_ratio"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."currency"', UPDATABLE true);

CREATE FOREIGN TABLE customer (
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        account_num long NOT NULL OPTIONS (NAMEINSOURCE '"account_num"', NATIVE_TYPE 'int8'),
        lname string(30) NOT NULL OPTIONS (NAMEINSOURCE '"lname"', NATIVE_TYPE 'varchar'),
        fname string(30) NOT NULL OPTIONS (NAMEINSOURCE '"fname"', NATIVE_TYPE 'varchar'),
        mi string(30) OPTIONS (NAMEINSOURCE '"mi"', NATIVE_TYPE 'varchar'),
        address1 string(30) OPTIONS (NAMEINSOURCE '"address1"', NATIVE_TYPE 'varchar'),
        address2 string(30) OPTIONS (NAMEINSOURCE '"address2"', NATIVE_TYPE 'varchar'),
        address3 string(30) OPTIONS (NAMEINSOURCE '"address3"', NATIVE_TYPE 'varchar'),
        address4 string(30) OPTIONS (NAMEINSOURCE '"address4"', NATIVE_TYPE 'varchar'),
        city string(30) OPTIONS (NAMEINSOURCE '"city"', NATIVE_TYPE 'varchar'),
        state_province string(30) OPTIONS (NAMEINSOURCE '"state_province"', NATIVE_TYPE 'varchar'),
        postal_code string(30) NOT NULL OPTIONS (NAMEINSOURCE '"postal_code"', NATIVE_TYPE 'varchar'),
        country string(30) NOT NULL OPTIONS (NAMEINSOURCE '"country"', NATIVE_TYPE 'varchar'),
        customer_region_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_region_id"', NATIVE_TYPE 'int4'),
        phone1 string(30) NOT NULL OPTIONS (NAMEINSOURCE '"phone1"', NATIVE_TYPE 'varchar'),
        phone2 string(30) NOT NULL OPTIONS (NAMEINSOURCE '"phone2"', NATIVE_TYPE 'varchar'),
        birthdate date NOT NULL OPTIONS (NAMEINSOURCE '"birthdate"', NATIVE_TYPE 'date'),
        marital_status string(30) NOT NULL OPTIONS (NAMEINSOURCE '"marital_status"', NATIVE_TYPE 'varchar'),
        yearly_income string(30) NOT NULL OPTIONS (NAMEINSOURCE '"yearly_income"', NATIVE_TYPE 'varchar'),
        gender string(30) NOT NULL OPTIONS (NAMEINSOURCE '"gender"', NATIVE_TYPE 'varchar'),
        total_children short NOT NULL OPTIONS (NAMEINSOURCE '"total_children"', NATIVE_TYPE 'int2'),
        num_children_at_home short NOT NULL OPTIONS (NAMEINSOURCE '"num_children_at_home"', NATIVE_TYPE 'int2'),
        education string(30) NOT NULL OPTIONS (NAMEINSOURCE '"education"', NATIVE_TYPE 'varchar'),
        date_accnt_opened date NOT NULL OPTIONS (NAMEINSOURCE '"date_accnt_opened"', NATIVE_TYPE 'date'),
        member_card string(30) OPTIONS (NAMEINSOURCE '"member_card"', NATIVE_TYPE 'varchar'),
        occupation string(30) OPTIONS (NAMEINSOURCE '"occupation"', NATIVE_TYPE 'varchar'),
        houseowner string(30) OPTIONS (NAMEINSOURCE '"houseowner"', NATIVE_TYPE 'varchar'),
        num_cars_owned integer OPTIONS (NAMEINSOURCE '"num_cars_owned"', NATIVE_TYPE 'int4'),
        fullname string(60) NOT NULL OPTIONS (NAMEINSOURCE '"fullname"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."customer"', UPDATABLE true);

CREATE FOREIGN TABLE customer_sales (
        customer_fullname string(60) OPTIONS (NAMEINSOURCE '"customer_fullname"', NATIVE_TYPE 'varchar'),
        store_sales bigdecimal(131089,2147483647) OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."customer_sales"', UPDATABLE true);

CREATE FOREIGN TABLE days (
        "day" integer NOT NULL OPTIONS (NAMEINSOURCE '"day"', NATIVE_TYPE 'int4'),
        week_day string(30) NOT NULL OPTIONS (NAMEINSOURCE '"week_day"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."days"', UPDATABLE true);

CREATE FOREIGN TABLE department (
        department_id integer NOT NULL OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4'),
        department_description string(30) NOT NULL OPTIONS (NAMEINSOURCE '"department_description"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."department"', UPDATABLE true);

CREATE FOREIGN TABLE employee (
        employee_id integer NOT NULL OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4'),
        full_name string(30) NOT NULL OPTIONS (NAMEINSOURCE '"full_name"', NATIVE_TYPE 'varchar'),
        first_name string(30) NOT NULL OPTIONS (NAMEINSOURCE '"first_name"', NATIVE_TYPE 'varchar'),
        last_name string(30) NOT NULL OPTIONS (NAMEINSOURCE '"last_name"', NATIVE_TYPE 'varchar'),
        position_id integer OPTIONS (NAMEINSOURCE '"position_id"', NATIVE_TYPE 'int4'),
        position_title string(30) OPTIONS (NAMEINSOURCE '"position_title"', NATIVE_TYPE 'varchar'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        department_id integer NOT NULL OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4'),
        birth_date date NOT NULL OPTIONS (NAMEINSOURCE '"birth_date"', NATIVE_TYPE 'date'),
        hire_date timestamp OPTIONS (NAMEINSOURCE '"hire_date"', NATIVE_TYPE 'timestamp'),
        end_date timestamp OPTIONS (NAMEINSOURCE '"end_date"', NATIVE_TYPE 'timestamp'),
        salary bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"salary"', NATIVE_TYPE 'numeric'),
        supervisor_id integer OPTIONS (NAMEINSOURCE '"supervisor_id"', NATIVE_TYPE 'int4'),
        education_level string(30) NOT NULL OPTIONS (NAMEINSOURCE '"education_level"', NATIVE_TYPE 'varchar'),
        marital_status string(30) NOT NULL OPTIONS (NAMEINSOURCE '"marital_status"', NATIVE_TYPE 'varchar'),
        gender string(30) NOT NULL OPTIONS (NAMEINSOURCE '"gender"', NATIVE_TYPE 'varchar'),
        management_role string(30) OPTIONS (NAMEINSOURCE '"management_role"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."employee"', UPDATABLE true);

CREATE FOREIGN TABLE employee_closure (
        employee_id integer NOT NULL OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4'),
        supervisor_id integer NOT NULL OPTIONS (NAMEINSOURCE '"supervisor_id"', NATIVE_TYPE 'int4'),
        distance integer OPTIONS (NAMEINSOURCE '"distance"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."employee_closure"', UPDATABLE true);

CREATE FOREIGN TABLE expense_fact (
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        account_id integer NOT NULL OPTIONS (NAMEINSOURCE '"account_id"', NATIVE_TYPE 'int4'),
        exp_date timestamp NOT NULL OPTIONS (NAMEINSOURCE '"exp_date"', NATIVE_TYPE 'timestamp'),
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        category_id string(30) NOT NULL OPTIONS (NAMEINSOURCE '"category_id"', NATIVE_TYPE 'varchar'),
        currency_id integer NOT NULL OPTIONS (NAMEINSOURCE '"currency_id"', NATIVE_TYPE 'int4'),
        amount bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"amount"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."expense_fact"', UPDATABLE true);

CREATE FOREIGN TABLE i_account_id (
        account_id integer OPTIONS (NAMEINSOURCE '"account_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_account_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_account_parent (
        account_parent integer OPTIONS (NAMEINSOURCE '"account_parent"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_account_parent"', UPDATABLE true);

CREATE FOREIGN TABLE i_category_id (
        category_id string(30) OPTIONS (NAMEINSOURCE '"category_id"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_category_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_category_parent (
        category_parent string(30) OPTIONS (NAMEINSOURCE '"category_parent"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_category_parent"', UPDATABLE true);

CREATE FOREIGN TABLE i_currency (
        currency_id integer OPTIONS (NAMEINSOURCE '"currency_id"', NATIVE_TYPE 'int4'),
        "date" date OPTIONS (NAMEINSOURCE '"date"', NATIVE_TYPE 'date')
) OPTIONS (NAMEINSOURCE '"public"."i_currency"', UPDATABLE true);

CREATE FOREIGN TABLE i_cust_acct_num (
        account_num long OPTIONS (NAMEINSOURCE '"account_num"', NATIVE_TYPE 'int8')
) OPTIONS (NAMEINSOURCE '"public"."i_cust_acct_num"', UPDATABLE true);

CREATE FOREIGN TABLE i_cust_child_home (
        num_children_at_home short OPTIONS (NAMEINSOURCE '"num_children_at_home"', NATIVE_TYPE 'int2')
) OPTIONS (NAMEINSOURCE '"public"."i_cust_child_home"', UPDATABLE true);

CREATE FOREIGN TABLE i_cust_postal_code (
        postal_code string(30) OPTIONS (NAMEINSOURCE '"postal_code"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_cust_postal_code"', UPDATABLE true);

CREATE FOREIGN TABLE i_cust_region_id (
        customer_region_id integer OPTIONS (NAMEINSOURCE '"customer_region_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_cust_region_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_customer_fname (
        fname string(30) OPTIONS (NAMEINSOURCE '"fname"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_customer_fname"', UPDATABLE true);

CREATE FOREIGN TABLE i_customer_id (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_customer_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_customer_lname (
        lname string(30) OPTIONS (NAMEINSOURCE '"lname"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_customer_lname"', UPDATABLE true);

CREATE FOREIGN TABLE i_department_id (
        department_id integer OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_department_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_empl_closure (
        supervisor_id integer OPTIONS (NAMEINSOURCE '"supervisor_id"', NATIVE_TYPE 'int4'),
        employee_id integer OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_empl_closure"', UPDATABLE true);

CREATE FOREIGN TABLE i_empl_closure_emp (
        employee_id integer OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_empl_closure_emp"', UPDATABLE true);

CREATE FOREIGN TABLE i_empl_dept_id (
        department_id integer OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_empl_dept_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_empl_store_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_empl_store_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_empl_super_id (
        supervisor_id integer OPTIONS (NAMEINSOURCE '"supervisor_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_empl_super_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_employee_id (
        employee_id integer OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_employee_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_expense_acct_id (
        account_id integer OPTIONS (NAMEINSOURCE '"account_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_expense_acct_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_expense_store_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_expense_store_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_expense_time_id (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_expense_time_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_97_prod_id (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_97_prod_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_97_store_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_97_store_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_97_time_id (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_97_time_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_97_wrhse_id (
        warehouse_id integer OPTIONS (NAMEINSOURCE '"warehouse_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_97_wrhse_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_98_prod_id (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_98_prod_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_98_store_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_98_store_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_98_time_id (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_98_time_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_inv_98_wrhse_id (
        warehouse_id integer OPTIONS (NAMEINSOURCE '"warehouse_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_inv_98_wrhse_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_position_id (
        position_id integer OPTIONS (NAMEINSOURCE '"position_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_position_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_prod_brand_name (
        brand_name string(60) OPTIONS (NAMEINSOURCE '"brand_name"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_prod_brand_name"', UPDATABLE true);

CREATE FOREIGN TABLE i_prod_class_id (
        product_class_id integer OPTIONS (NAMEINSOURCE '"product_class_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_prod_class_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_product_id (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_product_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_product_name (
        product_name string(60) OPTIONS (NAMEINSOURCE '"product_name"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_product_name"', UPDATABLE true);

CREATE FOREIGN TABLE i_product_SKU (
        SKU long OPTIONS (NAMEINSOURCE '"SKU"', NATIVE_TYPE 'int8')
) OPTIONS (NAMEINSOURCE '"public"."i_product_SKU"', UPDATABLE true);

CREATE FOREIGN TABLE i_promo_dist_id (
        promotion_district_id integer OPTIONS (NAMEINSOURCE '"promotion_district_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_promo_dist_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_promotion_id (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_promotion_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_rsrv_empl_dept (
        department_id integer OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_rsrv_empl_dept"', UPDATABLE true);

CREATE FOREIGN TABLE i_rsrv_empl_id (
        employee_id integer OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_rsrv_empl_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_rsrv_empl_store (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_rsrv_empl_store"', UPDATABLE true);

CREATE FOREIGN TABLE i_rsrv_empl_sup (
        supervisor_id integer OPTIONS (NAMEINSOURCE '"supervisor_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_rsrv_empl_sup"', UPDATABLE true);

CREATE FOREIGN TABLE i_salary_employee (
        employee_id integer OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_salary_employee"', UPDATABLE true);

CREATE FOREIGN TABLE i_salary_pay_date (
        pay_date timestamp OPTIONS (NAMEINSOURCE '"pay_date"', NATIVE_TYPE 'timestamp')
) OPTIONS (NAMEINSOURCE '"public"."i_salary_pay_date"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97c14cust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97c14cust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97c14prod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97c14prod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97c14promo (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97c14promo"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97c14store (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97c14store"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_gender (
        gender string(30) OPTIONS (NAMEINSOURCE '"gender"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_gender"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_ms (
        marital_status string(30) OPTIONS (NAMEINSOURCE '"marital_status"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_ms"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_pcat (
        product_category string(30) OPTIONS (NAMEINSOURCE '"product_category"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_pcat"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_pdept (
        product_department string(30) OPTIONS (NAMEINSOURCE '"product_department"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_pdept"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_pfam (
        product_family string(30) OPTIONS (NAMEINSOURCE '"product_family"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_pfam"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_tmonth (
        month_of_year short OPTIONS (NAMEINSOURCE '"month_of_year"', NATIVE_TYPE 'int2')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_tmonth"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_tquarter (
        quarter string(30) OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_tquarter"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97gmp_tyear (
        the_year short OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97gmp_tyear"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97l05cust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97l05cust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97l05prod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97l05prod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97l05promo (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97l05promo"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97l05store (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97l05store"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97lc100cust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97lc100cust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97lc100prod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97lc100prod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97ll01cust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97ll01cust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97ll01prod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97ll01prod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97ll01time (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97ll01time"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97pl01cust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97pl01cust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97pl01prod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97pl01prod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97pl01time (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97pl01time"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97speccust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97speccust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97specprod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97specprod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97specpromo (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97specpromo"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls97specstore (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls97specstore"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_1998_prod_id (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_1998_prod_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_1998_promo (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_1998_promo"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_1998_store (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_1998_store"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_1998_time_id (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_1998_time_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_97_cust_id (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_97_cust_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_97_prod_id (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_97_prod_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_97_promo_id (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_97_promo_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_97_store_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_97_store_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_97_time_id (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_97_time_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_98_cust_id (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_98_cust_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_dec98_cust (
        customer_id integer OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_dec98_cust"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_dec98_prod (
        product_id integer OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_dec98_prod"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_dec98_promo (
        promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_dec98_promo"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_dec98_store (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_dec98_store"', UPDATABLE true);

CREATE FOREIGN TABLE i_sls_dec98_time (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_sls_dec98_time"', UPDATABLE true);

CREATE FOREIGN TABLE i_store_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_store_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_store_raggd_id (
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_store_raggd_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_store_region_id (
        region_id integer OPTIONS (NAMEINSOURCE '"region_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_store_region_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_store_rggd_reg (
        region_id integer OPTIONS (NAMEINSOURCE '"region_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_store_rggd_reg"', UPDATABLE true);

CREATE FOREIGN TABLE i_time_day (
        the_date timestamp OPTIONS (NAMEINSOURCE '"the_date"', NATIVE_TYPE 'timestamp')
) OPTIONS (NAMEINSOURCE '"public"."i_time_day"', UPDATABLE true);

CREATE FOREIGN TABLE i_time_id (
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."i_time_id"', UPDATABLE true);

CREATE FOREIGN TABLE i_time_month (
        month_of_year short OPTIONS (NAMEINSOURCE '"month_of_year"', NATIVE_TYPE 'int2')
) OPTIONS (NAMEINSOURCE '"public"."i_time_month"', UPDATABLE true);

CREATE FOREIGN TABLE i_time_quarter (
        quarter string(30) OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."i_time_quarter"', UPDATABLE true);

CREATE FOREIGN TABLE i_time_year (
        the_year short OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2')
) OPTIONS (NAMEINSOURCE '"public"."i_time_year"', UPDATABLE true);

CREATE FOREIGN TABLE inventory_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        warehouse_id integer OPTIONS (NAMEINSOURCE '"warehouse_id"', NATIVE_TYPE 'int4'),
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        units_ordered integer OPTIONS (NAMEINSOURCE '"units_ordered"', NATIVE_TYPE 'int4'),
        units_shipped integer OPTIONS (NAMEINSOURCE '"units_shipped"', NATIVE_TYPE 'int4'),
        warehouse_sales bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"warehouse_sales"', NATIVE_TYPE 'numeric'),
        warehouse_cost bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"warehouse_cost"', NATIVE_TYPE 'numeric'),
        supply_time short OPTIONS (NAMEINSOURCE '"supply_time"', NATIVE_TYPE 'int2'),
        store_invoice bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"store_invoice"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."inventory_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE inventory_fact_1998 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        warehouse_id integer OPTIONS (NAMEINSOURCE '"warehouse_id"', NATIVE_TYPE 'int4'),
        store_id integer OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        units_ordered integer OPTIONS (NAMEINSOURCE '"units_ordered"', NATIVE_TYPE 'int4'),
        units_shipped integer OPTIONS (NAMEINSOURCE '"units_shipped"', NATIVE_TYPE 'int4'),
        warehouse_sales bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"warehouse_sales"', NATIVE_TYPE 'numeric'),
        warehouse_cost bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"warehouse_cost"', NATIVE_TYPE 'numeric'),
        supply_time short OPTIONS (NAMEINSOURCE '"supply_time"', NATIVE_TYPE 'int2'),
        store_invoice bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"store_invoice"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."inventory_fact_1998"', UPDATABLE true);

CREATE FOREIGN TABLE monthly_profit (
        the_date timestamp OPTIONS (NAMEINSOURCE '"the_date"', NATIVE_TYPE 'timestamp'),
        the_year short OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2'),
        the_month string(30) OPTIONS (NAMEINSOURCE '"the_month"', NATIVE_TYPE 'varchar'),
        the_quarter string(30) OPTIONS (NAMEINSOURCE '"the_quarter"', NATIVE_TYPE 'varchar'),
        time_by_day_month_of_year short OPTIONS (NAMEINSOURCE '"time_by_day_month_of_year"', NATIVE_TYPE 'int2'),
        store_sales bigdecimal(131089,2147483647) OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        profit bigdecimal(131089,2147483647) OPTIONS (NAMEINSOURCE '"profit"', NATIVE_TYPE 'numeric'),
        store_state string(30) OPTIONS (NAMEINSOURCE '"store_state"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."monthly_profit"', UPDATABLE true);

CREATE FOREIGN TABLE position (
        position_id integer NOT NULL OPTIONS (NAMEINSOURCE '"position_id"', NATIVE_TYPE 'int4'),
        position_title string(30) NOT NULL OPTIONS (NAMEINSOURCE '"position_title"', NATIVE_TYPE 'varchar'),
        pay_type string(30) NOT NULL OPTIONS (NAMEINSOURCE '"pay_type"', NATIVE_TYPE 'varchar'),
        min_scale bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"min_scale"', NATIVE_TYPE 'numeric'),
        max_scale bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"max_scale"', NATIVE_TYPE 'numeric'),
        management_role string(30) NOT NULL OPTIONS (NAMEINSOURCE '"management_role"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."position"', UPDATABLE true);

CREATE FOREIGN TABLE product (
        product_class_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_class_id"', NATIVE_TYPE 'int4'),
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        brand_name string(60) OPTIONS (NAMEINSOURCE '"brand_name"', NATIVE_TYPE 'varchar'),
        product_name string(60) NOT NULL OPTIONS (NAMEINSOURCE '"product_name"', NATIVE_TYPE 'varchar'),
        sku long NOT NULL OPTIONS (NAMEINSOURCE '"sku"', NATIVE_TYPE 'int8'),
        srp bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"srp"', NATIVE_TYPE 'numeric'),
        gross_weight float OPTIONS (NAMEINSOURCE '"gross_weight"', NATIVE_TYPE 'float4'),
        net_weight float OPTIONS (NAMEINSOURCE '"net_weight"', NATIVE_TYPE 'float4'),
        recyclable_package boolean OPTIONS (NAMEINSOURCE '"recyclable_package"', NATIVE_TYPE 'bool'),
        low_fat boolean OPTIONS (NAMEINSOURCE '"low_fat"', NATIVE_TYPE 'bool'),
        units_per_case short OPTIONS (NAMEINSOURCE '"units_per_case"', NATIVE_TYPE 'int2'),
        cases_per_pallet short OPTIONS (NAMEINSOURCE '"cases_per_pallet"', NATIVE_TYPE 'int2'),
        shelf_width float OPTIONS (NAMEINSOURCE '"shelf_width"', NATIVE_TYPE 'float4'),
        shelf_height float OPTIONS (NAMEINSOURCE '"shelf_height"', NATIVE_TYPE 'float4'),
        shelf_depth float OPTIONS (NAMEINSOURCE '"shelf_depth"', NATIVE_TYPE 'float4')
) OPTIONS (NAMEINSOURCE '"public"."product"', UPDATABLE true);

CREATE FOREIGN TABLE product_class (
        product_class_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_class_id"', NATIVE_TYPE 'int4'),
        product_subcategory string(30) OPTIONS (NAMEINSOURCE '"product_subcategory"', NATIVE_TYPE 'varchar'),
        product_category string(30) OPTIONS (NAMEINSOURCE '"product_category"', NATIVE_TYPE 'varchar'),
        product_department string(30) OPTIONS (NAMEINSOURCE '"product_department"', NATIVE_TYPE 'varchar'),
        product_family string(30) OPTIONS (NAMEINSOURCE '"product_family"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."product_class"', UPDATABLE true);

CREATE FOREIGN TABLE product_sales (
        product_product_name string(60) OPTIONS (NAMEINSOURCE '"product_product_name"', NATIVE_TYPE 'varchar'),
        store_sales bigdecimal(131089,2147483647) OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        product_product_id integer OPTIONS (NAMEINSOURCE '"product_product_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."product_sales"', UPDATABLE true);

CREATE FOREIGN TABLE promotion (
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        promotion_district_id integer OPTIONS (NAMEINSOURCE '"promotion_district_id"', NATIVE_TYPE 'int4'),
        promotion_name string(30) OPTIONS (NAMEINSOURCE '"promotion_name"', NATIVE_TYPE 'varchar'),
        media_type string(30) OPTIONS (NAMEINSOURCE '"media_type"', NATIVE_TYPE 'varchar'),
        cost bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE '"cost"', NATIVE_TYPE 'numeric'),
        start_date timestamp OPTIONS (NAMEINSOURCE '"start_date"', NATIVE_TYPE 'timestamp'),
        end_date timestamp OPTIONS (NAMEINSOURCE '"end_date"', NATIVE_TYPE 'timestamp')
) OPTIONS (NAMEINSOURCE '"public"."promotion"', UPDATABLE true);

CREATE FOREIGN TABLE promotion_sales (
        promotion_promotion_name string(30) OPTIONS (NAMEINSOURCE '"promotion_promotion_name"', NATIVE_TYPE 'varchar'),
        store_sales bigdecimal(131089,2147483647) OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        promotion_promotion_id integer OPTIONS (NAMEINSOURCE '"promotion_promotion_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."promotion_sales"', UPDATABLE true);

CREATE FOREIGN TABLE region (
        region_id integer NOT NULL OPTIONS (NAMEINSOURCE '"region_id"', NATIVE_TYPE 'int4'),
        sales_city string(30) OPTIONS (NAMEINSOURCE '"sales_city"', NATIVE_TYPE 'varchar'),
        sales_state_province string(30) OPTIONS (NAMEINSOURCE '"sales_state_province"', NATIVE_TYPE 'varchar'),
        sales_district string(30) OPTIONS (NAMEINSOURCE '"sales_district"', NATIVE_TYPE 'varchar'),
        sales_region string(30) OPTIONS (NAMEINSOURCE '"sales_region"', NATIVE_TYPE 'varchar'),
        sales_country string(30) OPTIONS (NAMEINSOURCE '"sales_country"', NATIVE_TYPE 'varchar'),
        sales_district_id integer OPTIONS (NAMEINSOURCE '"sales_district_id"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."region"', UPDATABLE true);

CREATE FOREIGN TABLE reserve_employee (
        employee_id integer NOT NULL OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4'),
        full_name string(30) NOT NULL OPTIONS (NAMEINSOURCE '"full_name"', NATIVE_TYPE 'varchar'),
        first_name string(30) NOT NULL OPTIONS (NAMEINSOURCE '"first_name"', NATIVE_TYPE 'varchar'),
        last_name string(30) NOT NULL OPTIONS (NAMEINSOURCE '"last_name"', NATIVE_TYPE 'varchar'),
        position_id integer OPTIONS (NAMEINSOURCE '"position_id"', NATIVE_TYPE 'int4'),
        position_title string(30) OPTIONS (NAMEINSOURCE '"position_title"', NATIVE_TYPE 'varchar'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        department_id integer NOT NULL OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4'),
        birth_date timestamp NOT NULL OPTIONS (NAMEINSOURCE '"birth_date"', NATIVE_TYPE 'timestamp'),
        hire_date timestamp OPTIONS (NAMEINSOURCE '"hire_date"', NATIVE_TYPE 'timestamp'),
        end_date timestamp OPTIONS (NAMEINSOURCE '"end_date"', NATIVE_TYPE 'timestamp'),
        salary bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"salary"', NATIVE_TYPE 'numeric'),
        supervisor_id integer OPTIONS (NAMEINSOURCE '"supervisor_id"', NATIVE_TYPE 'int4'),
        education_level string(30) NOT NULL OPTIONS (NAMEINSOURCE '"education_level"', NATIVE_TYPE 'varchar'),
        marital_status string(30) NOT NULL OPTIONS (NAMEINSOURCE '"marital_status"', NATIVE_TYPE 'varchar'),
        gender string(30) NOT NULL OPTIONS (NAMEINSOURCE '"gender"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."reserve_employee"', UPDATABLE true);

CREATE FOREIGN TABLE salary (
        pay_date timestamp NOT NULL OPTIONS (NAMEINSOURCE '"pay_date"', NATIVE_TYPE 'timestamp'),
        employee_id integer NOT NULL OPTIONS (NAMEINSOURCE '"employee_id"', NATIVE_TYPE 'int4'),
        department_id integer NOT NULL OPTIONS (NAMEINSOURCE '"department_id"', NATIVE_TYPE 'int4'),
        currency_id integer NOT NULL OPTIONS (NAMEINSOURCE '"currency_id"', NATIVE_TYPE 'int4'),
        salary_paid bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"salary_paid"', NATIVE_TYPE 'numeric'),
        overtime_paid bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"overtime_paid"', NATIVE_TYPE 'numeric'),
        vacation_accrued float NOT NULL OPTIONS (NAMEINSOURCE '"vacation_accrued"', NATIVE_TYPE 'float4'),
        vacation_used float NOT NULL OPTIONS (NAMEINSOURCE '"vacation_used"', NATIVE_TYPE 'float4')
) OPTIONS (NAMEINSOURCE '"public"."salary"', UPDATABLE true);

CREATE FOREIGN TABLE sales_fact_1997 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."sales_fact_1997"', UPDATABLE true);

CREATE FOREIGN TABLE sales_fact_1998 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."sales_fact_1998"', UPDATABLE true);

CREATE FOREIGN TABLE sales_fact_dec_1998 (
        product_id integer NOT NULL OPTIONS (NAMEINSOURCE '"product_id"', NATIVE_TYPE 'int4'),
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        customer_id integer NOT NULL OPTIONS (NAMEINSOURCE '"customer_id"', NATIVE_TYPE 'int4'),
        promotion_id integer NOT NULL OPTIONS (NAMEINSOURCE '"promotion_id"', NATIVE_TYPE 'int4'),
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        store_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_sales"', NATIVE_TYPE 'numeric'),
        store_cost bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"store_cost"', NATIVE_TYPE 'numeric'),
        unit_sales bigdecimal(10,2147483647) NOT NULL OPTIONS (NAMEINSOURCE '"unit_sales"', NATIVE_TYPE 'numeric')
) OPTIONS (NAMEINSOURCE '"public"."sales_fact_dec_1998"', UPDATABLE true);

CREATE FOREIGN TABLE store (
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        store_type string(30) OPTIONS (NAMEINSOURCE '"store_type"', NATIVE_TYPE 'varchar'),
        region_id integer OPTIONS (NAMEINSOURCE '"region_id"', NATIVE_TYPE 'int4'),
        store_name string(30) OPTIONS (NAMEINSOURCE '"store_name"', NATIVE_TYPE 'varchar'),
        store_number integer OPTIONS (NAMEINSOURCE '"store_number"', NATIVE_TYPE 'int4'),
        store_street_address string(30) OPTIONS (NAMEINSOURCE '"store_street_address"', NATIVE_TYPE 'varchar'),
        store_city string(30) OPTIONS (NAMEINSOURCE '"store_city"', NATIVE_TYPE 'varchar'),
        store_state string(30) OPTIONS (NAMEINSOURCE '"store_state"', NATIVE_TYPE 'varchar'),
        store_postal_code string(30) OPTIONS (NAMEINSOURCE '"store_postal_code"', NATIVE_TYPE 'varchar'),
        store_country string(30) OPTIONS (NAMEINSOURCE '"store_country"', NATIVE_TYPE 'varchar'),
        store_manager string(30) OPTIONS (NAMEINSOURCE '"store_manager"', NATIVE_TYPE 'varchar'),
        store_phone string(30) OPTIONS (NAMEINSOURCE '"store_phone"', NATIVE_TYPE 'varchar'),
        store_fax string(30) OPTIONS (NAMEINSOURCE '"store_fax"', NATIVE_TYPE 'varchar'),
        first_opened_date timestamp OPTIONS (NAMEINSOURCE '"first_opened_date"', NATIVE_TYPE 'timestamp'),
        last_remodel_date timestamp OPTIONS (NAMEINSOURCE '"last_remodel_date"', NATIVE_TYPE 'timestamp'),
        store_sqft integer OPTIONS (NAMEINSOURCE '"store_sqft"', NATIVE_TYPE 'int4'),
        grocery_sqft integer OPTIONS (NAMEINSOURCE '"grocery_sqft"', NATIVE_TYPE 'int4'),
        frozen_sqft integer OPTIONS (NAMEINSOURCE '"frozen_sqft"', NATIVE_TYPE 'int4'),
        meat_sqft integer OPTIONS (NAMEINSOURCE '"meat_sqft"', NATIVE_TYPE 'int4'),
        coffee_bar boolean OPTIONS (NAMEINSOURCE '"coffee_bar"', NATIVE_TYPE 'bool'),
        video_store boolean OPTIONS (NAMEINSOURCE '"video_store"', NATIVE_TYPE 'bool'),
        salad_bar boolean OPTIONS (NAMEINSOURCE '"salad_bar"', NATIVE_TYPE 'bool'),
        prepared_food boolean OPTIONS (NAMEINSOURCE '"prepared_food"', NATIVE_TYPE 'bool'),
        florist boolean OPTIONS (NAMEINSOURCE '"florist"', NATIVE_TYPE 'bool')
) OPTIONS (NAMEINSOURCE '"public"."store"', UPDATABLE true);

CREATE FOREIGN TABLE store_ragged (
        store_id integer NOT NULL OPTIONS (NAMEINSOURCE '"store_id"', NATIVE_TYPE 'int4'),
        store_type string(30) OPTIONS (NAMEINSOURCE '"store_type"', NATIVE_TYPE 'varchar'),
        region_id integer OPTIONS (NAMEINSOURCE '"region_id"', NATIVE_TYPE 'int4'),
        store_name string(30) OPTIONS (NAMEINSOURCE '"store_name"', NATIVE_TYPE 'varchar'),
        store_number integer OPTIONS (NAMEINSOURCE '"store_number"', NATIVE_TYPE 'int4'),
        store_street_address string(30) OPTIONS (NAMEINSOURCE '"store_street_address"', NATIVE_TYPE 'varchar'),
        store_city string(30) OPTIONS (NAMEINSOURCE '"store_city"', NATIVE_TYPE 'varchar'),
        store_state string(30) OPTIONS (NAMEINSOURCE '"store_state"', NATIVE_TYPE 'varchar'),
        store_postal_code string(30) OPTIONS (NAMEINSOURCE '"store_postal_code"', NATIVE_TYPE 'varchar'),
        store_country string(30) OPTIONS (NAMEINSOURCE '"store_country"', NATIVE_TYPE 'varchar'),
        store_manager string(30) OPTIONS (NAMEINSOURCE '"store_manager"', NATIVE_TYPE 'varchar'),
        store_phone string(30) OPTIONS (NAMEINSOURCE '"store_phone"', NATIVE_TYPE 'varchar'),
        store_fax string(30) OPTIONS (NAMEINSOURCE '"store_fax"', NATIVE_TYPE 'varchar'),
        first_opened_date timestamp OPTIONS (NAMEINSOURCE '"first_opened_date"', NATIVE_TYPE 'timestamp'),
        last_remodel_date timestamp OPTIONS (NAMEINSOURCE '"last_remodel_date"', NATIVE_TYPE 'timestamp'),
        store_sqft integer OPTIONS (NAMEINSOURCE '"store_sqft"', NATIVE_TYPE 'int4'),
        grocery_sqft integer OPTIONS (NAMEINSOURCE '"grocery_sqft"', NATIVE_TYPE 'int4'),
        frozen_sqft integer OPTIONS (NAMEINSOURCE '"frozen_sqft"', NATIVE_TYPE 'int4'),
        meat_sqft integer OPTIONS (NAMEINSOURCE '"meat_sqft"', NATIVE_TYPE 'int4'),
        coffee_bar boolean OPTIONS (NAMEINSOURCE '"coffee_bar"', NATIVE_TYPE 'bool'),
        video_store boolean OPTIONS (NAMEINSOURCE '"video_store"', NATIVE_TYPE 'bool'),
        salad_bar boolean OPTIONS (NAMEINSOURCE '"salad_bar"', NATIVE_TYPE 'bool'),
        prepared_food boolean OPTIONS (NAMEINSOURCE '"prepared_food"', NATIVE_TYPE 'bool'),
        florist boolean OPTIONS (NAMEINSOURCE '"florist"', NATIVE_TYPE 'bool')
) OPTIONS (NAMEINSOURCE '"public"."store_ragged"', UPDATABLE true);

CREATE FOREIGN TABLE time_by_day (
        time_id integer NOT NULL OPTIONS (NAMEINSOURCE '"time_id"', NATIVE_TYPE 'int4'),
        the_date timestamp OPTIONS (NAMEINSOURCE '"the_date"', NATIVE_TYPE 'timestamp'),
        the_day string(30) OPTIONS (NAMEINSOURCE '"the_day"', NATIVE_TYPE 'varchar'),
        the_month string(30) OPTIONS (NAMEINSOURCE '"the_month"', NATIVE_TYPE 'varchar'),
        the_year short OPTIONS (NAMEINSOURCE '"the_year"', NATIVE_TYPE 'int2'),
        day_of_month short OPTIONS (NAMEINSOURCE '"day_of_month"', NATIVE_TYPE 'int2'),
        week_of_year integer OPTIONS (NAMEINSOURCE '"week_of_year"', NATIVE_TYPE 'int4'),
        month_of_year short OPTIONS (NAMEINSOURCE '"month_of_year"', NATIVE_TYPE 'int2'),
        quarter string(30) OPTIONS (NAMEINSOURCE '"quarter"', NATIVE_TYPE 'varchar'),
        fiscal_period string(30) OPTIONS (NAMEINSOURCE '"fiscal_period"', NATIVE_TYPE 'varchar'),
        day_of_week integer OPTIONS (NAMEINSOURCE '"day_of_week"', NATIVE_TYPE 'int4')
) OPTIONS (NAMEINSOURCE '"public"."time_by_day"', UPDATABLE true);

CREATE FOREIGN TABLE warehouse (
        warehouse_id integer NOT NULL OPTIONS (NAMEINSOURCE '"warehouse_id"', NATIVE_TYPE 'int4'),
        warehouse_class_id integer OPTIONS (NAMEINSOURCE '"warehouse_class_id"', NATIVE_TYPE 'int4'),
        stores_id integer OPTIONS (NAMEINSOURCE '"stores_id"', NATIVE_TYPE 'int4'),
        warehouse_name string(60) OPTIONS (NAMEINSOURCE '"warehouse_name"', NATIVE_TYPE 'varchar'),
        wa_address1 string(30) OPTIONS (NAMEINSOURCE '"wa_address1"', NATIVE_TYPE 'varchar'),
        wa_address2 string(30) OPTIONS (NAMEINSOURCE '"wa_address2"', NATIVE_TYPE 'varchar'),
        wa_address3 string(30) OPTIONS (NAMEINSOURCE '"wa_address3"', NATIVE_TYPE 'varchar'),
        wa_address4 string(30) OPTIONS (NAMEINSOURCE '"wa_address4"', NATIVE_TYPE 'varchar'),
        warehouse_city string(30) OPTIONS (NAMEINSOURCE '"warehouse_city"', NATIVE_TYPE 'varchar'),
        warehouse_state_province string(30) OPTIONS (NAMEINSOURCE '"warehouse_state_province"', NATIVE_TYPE 'varchar'),
        warehouse_postal_code string(30) OPTIONS (NAMEINSOURCE '"warehouse_postal_code"', NATIVE_TYPE 'varchar'),
        warehouse_country string(30) OPTIONS (NAMEINSOURCE '"warehouse_country"', NATIVE_TYPE 'varchar'),
        warehouse_owner_name string(30) OPTIONS (NAMEINSOURCE '"warehouse_owner_name"', NATIVE_TYPE 'varchar'),
        warehouse_phone string(30) OPTIONS (NAMEINSOURCE '"warehouse_phone"', NATIVE_TYPE 'varchar'),
        warehouse_fax string(30) OPTIONS (NAMEINSOURCE '"warehouse_fax"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."warehouse"', UPDATABLE true);

CREATE FOREIGN TABLE warehouse_class (
        warehouse_class_id integer NOT NULL OPTIONS (NAMEINSOURCE '"warehouse_class_id"', NATIVE_TYPE 'int4'),
        description string(30) OPTIONS (NAMEINSOURCE '"description"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"public"."warehouse_class"', UPDATABLE true);