-
Notifications
You must be signed in to change notification settings - Fork 0
/
create table
6 lines (6 loc) · 1.44 KB
/
create table
1
2
3
4
5
6
create table awardscoaches (coachID STRING, award STRING, year INT,lgID STRING,note STRING);
create table awardsplayers (playerID STRING,award STRING,year INT,lgID STRING,note STRING,pos STRING);
create table coaches (coachID STRING,year INT,tmID STRING,lgID STRING,stint INT,notes STRING,g INT,w INT,l INT,t INT,postg INT,postw INT,postl INT,postt INT);
create table master (playerID STRING,coachID STRING,hofID STRING,firstName STRING,lastName STRING,nameNote STRING,nameGiven STRING,nameNick STRING, height INT, weight INT,shootCatch STRING,legendsID STRING, ihdbID INT, hrefID STRING, firstNHL INT,lastNHL INT,firstWHA INT,lastWHA INT,pos STRING, birthYear INT,birthMon INT,birthDay INT,birthCountry STRING,birthState STRING,birthCity STRING,deathYear INT,deathMon INT,deathDay INT,deathCountry STRING,deathState STRING,deathCity STRING);
create table scoring (playerID STRING,year INT, stint INT, tmID STRING,lgID STRING,pos STRING,GP INT,G INT,A INT,Pts INT,PIM INT,`+/-` INT,PPG INT,PPA INT,SHG INT,SHA INT,GWG INT,GTG INT,SOG INT,PostGP INT,PostG INT,PostA INT,PostPts INT,PostPIM INT,`Post+/-` INT,PostPPG INT,PostPPA INT,PostSHG INT,PostSHA INT,PostGWG INT,PostSOG INT);
create table teams (year INT,lgID STRING,tmID STRING,franchID STRING,confID STRING,divID STRING, rank INT, playoff STRING, G INT, W INT, L INT, T INT, OTL INT, Pts INT, SoW INT, SoL INT, GF INT, GA INT, name STRING, PIM INT, BenchMinor INT, PPG INT, PPC INT, SHA INT, PKG INT, PKC INT, SHF INT);