poke-cli/card_data/pipelines/poke_cli_dbt/models/sources.yml at 144f679880cdd00ef64c39fd339ad9bbb1e49a41 · digitalghost-dev/poke-cli · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
version: 2

sources:
  - name: staging
    description: "Staging schema containing raw data loaded from extract pipeline"
    tables:
      - name: series
        description: "Pokemon card series data"
        columns:
          - name: id
            description: "Unique series identifier"
          - name: name
            description: "Series name"
          - name: logo
            description: "Series logo URL"

      - name: sets
        description: "Pokemon card sets data"
        columns:
          - name: series_id
            description: "Foreign key to series"
          - name: set_id
            description: "Unique set identifier"
          - name: set_name
            description: "Set name"
          - name: official_card_count
            description: "Official number of cards in set"
          - name: total_card_count
            description: "Total number of cards including variants"
          - name: logo
            description: "Set logo URL"
          - name: symbol
            description: "Set symbol URL"

      - name: cards
        description: "Pokemon cards data"
        columns:
          - name: id
            description: "Unique card identifier"
          - name: name
            description: "Card name"
          - name: category
            description: "Card category (Pokemon, Trainer, Energy)"
          - name: hp
            description: "Card HP value"
          - name: image
            description: "Card image URL"
          - name: rarity
            description: "Card rarity"
          - name: types
            description: "Card types (comma-separated)"
          - name: localId
            description: "Card local ID within the set"
          - name: illustrator
            description: "Card illustrator"
          - name: regulationMark
            description: "Regulation mark"
          - name: retreat
            description: "Retreat cost (numeric)"
          - name: stage
            description: "Evolution stage"
          - name: legal_standard
            description: "Legal status in Standard"
          - name: legal_expanded
            description: "Legal status in Expanded"
          - name: set_cardCount_official
            description: "Official card count for the set"
          - name: set_cardCount_total
            description: "Total card count including variants"
          - name: set_id
            description: "Foreign key to set"
          - name: set_logo
            description: "Set logo URL"
          - name: set_name
            description: "Set name"
          - name: set_symbol
            description: "Set symbol URL"
          - name: attacks_json
            description: "Raw attacks JSON"
          - name: attack_1_name
            description: "First attack name"
          - name: attack_1_damage
            description: "First attack damage"
          - name: attack_1_effect
            description: "First attack effect"
          - name: attack_1_cost
            description: "First attack energy cost"
          - name: attack_2_name
            description: "Second attack name"
          - name: attack_2_damage
            description: "Second attack damage"
          - name: attack_2_effect
            description: "Second attack effect"
          - name: attack_2_cost
            description: "Second attack energy cost"
          - name: attack_3_name
            description: "Third attack name"
          - name: attack_3_damage
            description: "Third attack damage"
          - name: attack_3_effect
            description: "Third attack effect"
          - name: attack_3_cost
            description: "Third attack energy cost"

      - name: standings
        description: "Player standings data for tournaments"
        columns:
          - name: rank
            description: "Player rank in the tournament"
          - name: name
            description: "Player name"
          - name: points
            description: "Player points"
          - name: record
            description: "Player win/loss record"
          - name: opp_win_percent
            description: "Opponent win percentage"
          - name: opp_opp_win_percent
            description: "Opponent's opponent win percentage"
          - name: deck
            description: "Deck name used by player"
          - name: decklist
            description: "Decklist URL"
          - name: country
            description: "Player country code"
          - name: tournament_id
            description: "Foreign key to tournaments"

      - name: tournaments
        description: "Tournament metadata"
        columns:
          - name: tournament_id
            description: "Unique tournament identifier"
          - name: location
            description: "Tournament location"
          - name: start_date
            description: "Tournament start date"
          - name: end_date
            description: "Tournament end date"
          - name: type
            description: "Tournament type"
          - name: player_quantity
            description: "Number of players in the tournament"
          - name: text_date
            description: "Tournament date in text format"
          - name: country_code
            description: "Country ISO code"
          - name: logo
            description: "Tournament type logo URL"
          - name: latitude
            description: "Tournament city latitude"
          - name: longitude
            description: "Tournament city longitude"

      - name: country_codes
        description: "Country code to country name mapping with geographic centroids"
        columns:
          - name: code
            description: "ISO country code"
          - name: country_name
            description: "Full country name"

      - name: pricing_data
        description: "Card pricing data"
        meta:
          dagster:
            asset_key: ["load_pricing_data"]
        columns:
          - name: product_id
            description: "Product ID"
          - name: name
            description: "Card name"
          - name: card_number
            description: "Card number"
          - name: market_price
            description: "Market price"