From 2309c313b648e06b3c441ab8aafd845939dedc48 Mon Sep 17 00:00:00 2001
From: Kapil Viren Ahuja <kvahuja@users.noreply.github.com>
Date: Sat, 25 Feb 2017 18:34:41 +0530
Subject: fixing last bit of model (refactoring phase 1) (#19)

---
 queries/participant.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'queries/participant.sql')

diff --git a/queries/participant.sql b/queries/participant.sql
index d1d81ce..b7685a9 100644
--- a/queries/participant.sql
+++ b/queries/participant.sql
@@ -1,7 +1,7 @@
 SELECT
 
 id AS "apiId",
-relationships->'player'->'data'->>'id' AS "playerId",
+relationships->'player'->'data'->>'id' AS "player_apiId",
 
 attributes->>'actor' AS "hero",
 (attributes->'stats'->>'assists')::int AS "assists",
@@ -25,4 +25,4 @@ attributes->'stats'->'itemSells' AS "itemSells",
 attributes->'stats'->'itemUses' AS "itemUses",
 attributes->'stats'->'items' AS "items"
 
-FROM "participant"
+FROM participant
-- 
cgit v1.3.1

