RelationalDesign: kreiranje.sql

create table Clubs(
ClubID INT primary key,
ClubName VARCHAR(255) not null
);

delete Clubs;

create table Players(
PlayerID INT primary key,
PlayerName VARCHAR(255) not null,
clubID INT,
foreign key (clubID) references clubs(clubid)
);

delete Players;

create table stadiums(
stadiumID INT primary key,
stadiumName VARCHAR(255) not null,
clubID INT,
foreign key (clubID) references clubs(clubid)
);

delete stadiums;

create table injuries(
InjuryID INT primary key,
PlayerID INT,
InjuryType VARCHAR(255) not null,
InjuryDate DATE,
foreign key (PlayerID) references Players(Playerid)
);

delete injuries;

create table cards(
CardID INT primary key,
PlayerID INT,
CardType VARCHAR(255) not null,
CardDate DATE,
foreign key (PlayerID) references Players(Playerid)
);

delete cards;

create table Ratings(
ID INT primary key,
Rating1 INT,
Rating2 INT 
);

delete Ratings;

create table Users(
ID INT primary key,
Username VARCHAR(255) not null,
Password1 VARCHAR(255) not null,
Email VARCHAR(255) not null
);

delete Users;