TCGames database

CREATE DATABASE TCGames;
CREATE TABLE TCG(
id_jogo int primary key,
 formato char(50)
 );

CREATE TABLE Loja(
id_loja int primary key,
 nome char(60),
  localizaçao char(100)
  );

CREATE TABLE Torneio(
id_torneio int primary key,
 jogo_t int,
 loja int,
 foreign key (jogo_t) references TCG(id_jogo),
  foreign key(loja) references Loja(id_loja)
  );

CREATE TABLE Utilizadores(
id_utilizador int primary key,
username char(50),
morada char(100),
u_pass char(100),
inscriçao_torn int,
email char(140),
foreign key (inscriçao_torn) references Torneio(id_torneio)
);

CREATE TABLE Carta(
id_carta int primary key,
nome char(30),
carta_jogo int,
info char(15),
foreign key (carta_jogo) references TCG(id_jogo)
);

CREATE TABLE Decks(
id_deck int primary key,
autor int,
jogo int,
nome char(50),
foreign key (autor) references Utilizadores(id_utilizador),
);

CREATE TABLE Anuncios(
id_anuncio int,
vendedor int,
carta int,
preço money,
data_p date,
data_c date,
quantidade int,
foreign key(vendedor) references Utilizadores(id_utilizador),
foreign key (carta) references Carta(id_carta)
);

Insert into TCG values
(1, 'Magic the Gathering'),
(2, 'Yu-Gi-Oh'),
(3,'Pokémon')

Insert into Loja values
(1,'Loja do Bacon', 'Lousada'),
(2,'Arena Splinter', 'Porto'),
(3,'Nut-Shopping', 'Lisboa')

Insert into Torneio values
(1, 1, 2),
(2, 2, 3),
(3, 1, 1)

Insert into Deck values
(1,2,1,'Buff David'),
(2,1,1,'OTK Little Dude'),
(3,4,1,'Freeze'),
(4,1,2,'Burn'),
(5,1,2,'Ritual Nig'),
(6,3,3,'Pika's Fate'),

Insert into Utilizadores values
(1, 'Tiagovski', 'Rua das Lajes', '112232234', 1, 'paysafe@gmail.com'),
(2, 'Toast', 'Rua Canada', '12321345', 1, 'pay2win@gmail.com'),
(3, 'Forsen', 'Rua Foor Saan', '123456', 3, 'zulul@gmail.com'),
(4, 'Tiagovski', 'Rua do BigNut', '12245234', 1, 'Yetfe@gmail.com'),
(5, 'Grilo98', 'Rua Snax', '324542345', 5, 'JoaoManuel@gmail.com'),
(6, 'Adolfo', 'Rua Bela Suc', '1231342456', 3, 'RadioQUim@gmail.com')

Insert into Carta values
(1,'Murloc man', 1, '6124'),
(2,'SI_agent', 2, '129764'),
(3,'garden witch', 1, '4215367'),
(4,'Big Monster', 5, '987123'),
(5,'Backstab', 2, '983724'),
(6,'Plantificate', 1, '21345')

Insert into Anuncios values
(1,2,1,3.42,'11/09/2018','03/12/2018',1),
(2,1,3,1.1,'05/11/2018','11/12/2018',3),
(3,1,1,12.25,'08/12/2018','12/12/2018',2),
(4,2,1,0.42,'01/09/2018','03/12/2018',1),
(5,1,3,4.12,'15/09/2018','11/12/2018',1),
(6,1,1,71.25,'12/12/2018','19/12/2018',2)