sql

CREATE DATABASE smite2;

USE smite2;

CREATE TABLE Players (
    PlayerID int NOT NULL UNIQUE PRIMARY KEY,
    RoleID   int NOT NULL,
    PlayerName  varchar (40) NOT NULL,
	 InGameName   varchar (40) NOT NULL,
    PlayerRole  varchar (40) NOT NULL,
    TeamID  int NOT NULL
);

CREATE TABLE Teams (
	 TeamID  int NOT NULL,
    PlayerID int NOT NULL,
    TeamName   VARCHAR (30) NOT NULL,
	 PRIMARY KEY (TeamID),
	 FOREIGN KEY (PlayerID) REFERENCES Players(PlayerID)
);

CREATE TABLE Gods (
	 GodID  int NOT NULL,
    GodName varchar (30) NOT NULL,
    RoleID  int NOT NULL,
    GodRole varchar (30),
	 PRIMARY KEY (GodID),
	 FOREIGN KEY (RoleID) REFERENCES Players(RoleID)
);

CREATE TABLE Matches (
	 MatchID  int NOT NULL ,
    Versus varchar (40) NOT NULL,
    MatchLength   int NOT NULL,
    TeamID int NOT NULL,
	 PRIMARY KEY (MatchID),
	 FOREIGN KEY (MatchID) REFERENCES GodBans(MatchID)
);

CREATE TABLE GodBans (
	 MatchID  int NOT NULL,
    GodID int NOT NULL,
    BanRate  int NOT NULL,
	 FOREIGN KEY (MatchID) REFERENCES Matches(MatchID),
	 FOREIGN KEY (GodID) REFERENCES Gods(GodID)
);

CREATE TABLE ProLeague (
	 TeamID  int NOT NULL ,
    Standing int NOT NULL,
	 FOREIGN KEY (TeamID) REFERENCES Teams(TeamID)
);