data_warehouse.yaml

# This file contains Data Warehouse configuration generated from the ElasticGraph schema.
#
# Generated by `bundle exec rake schema_artifacts:dump`.
# DO NOT EDIT BY HAND. Any edits will be lost the next time the rake task is run.
---
tables:
  addresses:
    table_schema: |-
      CREATE TABLE IF NOT EXISTS addresses (
        id STRING,
        full_address STRING,
        timestamps STRUCT<created_at TIMESTAMP>,
        geo_location STRUCT<lat FLOAT, lon FLOAT>,
        shapes ARRAY<STRUCT<type STRING, coordinates ARRAY<FLOAT>>>,
        manufacturer_id STRING
      )
  components:
    table_schema: |-
      CREATE TABLE IF NOT EXISTS components (
        id STRING,
        name STRING,
        created_at TIMESTAMP,
        position STRUCT<x FLOAT, y FLOAT>,
        tags ARRAY<STRING>,
        widget_name STRING,
        widget_tags ARRAY<STRING>,
        widget_workspace_id3 STRING,
        widget_size STRING,
        widget_cost STRUCT<currency STRING, amount_cents INT>,
        part_ids ARRAY<STRING>,
        owner_ids ARRAY<STRING>,
        owner_id STRING
      )
  electrical_parts:
    table_schema: |-
      CREATE TABLE IF NOT EXISTS electrical_parts (
        id STRING,
        name STRING,
        created_at TIMESTAMP,
        voltage INT,
        manufacturer_id STRING
      )
  manufacturers:
    table_schema: |-
      CREATE TABLE IF NOT EXISTS manufacturers (
        id STRING,
        name STRING,
        created_at TIMESTAMP
      )
  mechanical_parts:
    table_schema: |-
      CREATE TABLE IF NOT EXISTS mechanical_parts (
        id STRING,
        name STRING,
        created_at TIMESTAMP,
        material STRING,
        manufacturer_id STRING
      )
  sponsors:
    table_schema: |-
      CREATE TABLE IF NOT EXISTS sponsors (
        id STRING,
        name STRING
      )
  teams:
    table_schema: |-
      CREATE TABLE IF NOT EXISTS teams (
        id STRING,
        league STRING,
        country_code STRING,
        formed_on DATE,
        current_name STRING,
        past_names ARRAY<STRING>,
        won_championships_at ARRAY<TIMESTAMP>,
        details STRUCT<uniform_colors ARRAY<STRING>, count INT>,
        stadium_location STRUCT<lat FLOAT, lon FLOAT>,
        forbes_valuations ARRAY<BIGINT>,
        forbes_valuation_moneys_nested ARRAY<STRUCT<currency STRING, amount_cents INT>>,
        forbes_valuation_moneys_object ARRAY<STRUCT<currency STRING, amount_cents INT>>,
        current_players_nested ARRAY<STRUCT<name STRING, nicknames ARRAY<STRING>, affiliations STRUCT<sponsorships_nested ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>, sponsorships_object ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>>, seasons_nested ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>, seasons_object ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>>>,
        current_players_object ARRAY<STRUCT<name STRING, nicknames ARRAY<STRING>, affiliations STRUCT<sponsorships_nested ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>, sponsorships_object ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>>, seasons_nested ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>, seasons_object ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>>>,
        seasons_nested ARRAY<STRUCT<the_record STRUCT<win_count INT, loss_count INT, last_win_date DATE, first_win_on DATE>, year INT, notes ARRAY<STRING>, count INT, started_at TIMESTAMP, won_games_at ARRAY<TIMESTAMP>, was_shortened BOOLEAN, players_nested ARRAY<STRUCT<name STRING, nicknames ARRAY<STRING>, affiliations STRUCT<sponsorships_nested ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>, sponsorships_object ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>>, seasons_nested ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>, seasons_object ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>>>, players_object ARRAY<STRUCT<name STRING, nicknames ARRAY<STRING>, affiliations STRUCT<sponsorships_nested ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>, sponsorships_object ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>>, seasons_nested ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>, seasons_object ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>>>>>,
        seasons_object ARRAY<STRUCT<the_record STRUCT<win_count INT, loss_count INT, last_win_date DATE, first_win_on DATE>, year INT, notes ARRAY<STRING>, count INT, started_at TIMESTAMP, won_games_at ARRAY<TIMESTAMP>, was_shortened BOOLEAN, players_nested ARRAY<STRUCT<name STRING, nicknames ARRAY<STRING>, affiliations STRUCT<sponsorships_nested ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>, sponsorships_object ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>>, seasons_nested ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>, seasons_object ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>>>, players_object ARRAY<STRUCT<name STRING, nicknames ARRAY<STRING>, affiliations STRUCT<sponsorships_nested ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>, sponsorships_object ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>>, seasons_nested ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>, seasons_object ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>>>>>,
        the_nested_fields STRUCT<forbes_valuation_moneys ARRAY<STRUCT<currency STRING, amount_cents INT>>, current_players ARRAY<STRUCT<name STRING, nicknames ARRAY<STRING>, affiliations STRUCT<sponsorships_nested ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>, sponsorships_object ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>>, seasons_nested ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>, seasons_object ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>>>, the_seasons ARRAY<STRUCT<the_record STRUCT<win_count INT, loss_count INT, last_win_date DATE, first_win_on DATE>, year INT, notes ARRAY<STRING>, count INT, started_at TIMESTAMP, won_games_at ARRAY<TIMESTAMP>, was_shortened BOOLEAN, players_nested ARRAY<STRUCT<name STRING, nicknames ARRAY<STRING>, affiliations STRUCT<sponsorships_nested ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>, sponsorships_object ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>>, seasons_nested ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>, seasons_object ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>>>, players_object ARRAY<STRUCT<name STRING, nicknames ARRAY<STRING>, affiliations STRUCT<sponsorships_nested ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>, sponsorships_object ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>>, seasons_nested ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>, seasons_object ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>>>>>>,
        nested_fields2 STRUCT<forbes_valuation_moneys ARRAY<STRUCT<currency STRING, amount_cents INT>>, current_players ARRAY<STRUCT<name STRING, nicknames ARRAY<STRING>, affiliations STRUCT<sponsorships_nested ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>, sponsorships_object ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>>, seasons_nested ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>, seasons_object ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>>>, the_seasons ARRAY<STRUCT<the_record STRUCT<win_count INT, loss_count INT, last_win_date DATE, first_win_on DATE>, year INT, notes ARRAY<STRING>, count INT, started_at TIMESTAMP, won_games_at ARRAY<TIMESTAMP>, was_shortened BOOLEAN, players_nested ARRAY<STRUCT<name STRING, nicknames ARRAY<STRING>, affiliations STRUCT<sponsorships_nested ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>, sponsorships_object ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>>, seasons_nested ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>, seasons_object ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>>>, players_object ARRAY<STRUCT<name STRING, nicknames ARRAY<STRING>, affiliations STRUCT<sponsorships_nested ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>, sponsorships_object ARRAY<STRUCT<sponsor_id STRING, annual_total STRUCT<currency STRING, amount_cents INT>>>>, seasons_nested ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>, seasons_object ARRAY<STRUCT<year INT, games_played INT, awards ARRAY<STRING>>>>>>>>
      )
  widget_currencies:
    table_schema: |-
      CREATE TABLE IF NOT EXISTS widget_currencies (
        id STRING,
        name STRING,
        introduced_on DATE,
        primary_continent STRING,
        details STRUCT<unit STRING, symbol STRING>,
        widget_names2 ARRAY<STRING>,
        widget_tags ARRAY<STRING>,
        widget_fee_currencies ARRAY<STRING>,
        widget_options STRUCT<sizes ARRAY<STRING>, colors ARRAY<STRING>>,
        nested_fields STRUCT<max_widget_cost INT>,
        oldest_widget_created_at TIMESTAMP,
        max_weight_in_ng BIGINT
      )
  widget_records:
    table_schema: |-
      CREATE TABLE IF NOT EXISTS widget_records (
        id STRING,
        workspace_id2 STRING,
        amount_cents INT,
        cost STRUCT<currency STRING, amount_cents INT>,
        cost_currency_unit STRING,
        cost_currency_name STRING,
        cost_currency_symbol STRING,
        cost_currency_primary_continent STRING,
        cost_currency_introduced_on DATE,
        name STRING,
        internal_name STRING,
        name_text STRING,
        description STRING,
        created_at TIMESTAMP,
        created_at_time_of_day STRING,
        created_on DATE,
        release_timestamps ARRAY<TIMESTAMP>,
        release_dates ARRAY<DATE>,
        component_ids ARRAY<STRING>,
        options STRUCT<size STRING, the_sighs STRING, color STRING, is_draft BOOLEAN>,
        internal_details STRUCT<name STRING>,
        the_opts STRUCT<size STRING, the_sighs STRING, color STRING, is_draft BOOLEAN>,
        inventor STRUCT<name STRING, nationality STRING, stock_ticker STRING, __typename STRING>,
        named_inventor STRUCT<name STRING, nationality STRING, stock_ticker STRING, __typename STRING>,
        weight_in_ng_str BIGINT,
        weight_in_ng BIGINT,
        tags ARRAY<STRING>,
        amounts ARRAY<INT>,
        fees ARRAY<STRUCT<currency STRING, amount_cents INT>>,
        metadata STRING,
        workspace_name STRING
      )