MmR7hfKk

1CREATE TABLE IF NOT EXISTS POKEMON (
2  POKE_NUM SMALLINT,
3  POKE_NAME varchar(50),
4  POKE_HEIGHT DECIMAL(2,1),
5  POKE_WEIGHT DECIMAL(4,1),
6  GEN_NUM tinyint,
7  PRIMARY KEY (POKE_NUM),
8  FOREIGN KEY (GEN_NUM) REFERENCES GEN(GEN_NUM)
9);
10
11CREATE TABLE IF NOT EXISTS STATS (
12  POKE_NUM smallint,
13  STATS_BASE_HP smallint,
14  STATS_BASE_ATTACK smallint,
15  STATS_BASE_DEFENSE smallint,
16  STATS_BASE_SPATTACK smallint,
17  STATS_BASE_SPDEFENSE smallint,
18  STATS_BASE_SPEED smallint,
19  STATS_MAX_HP smallint,
20  STATS_MAX_ATTACK smallint,
21  STATS_MAX_DEFENSE smallint,
22  STATS_MAX_SPATTACK smallint,
23  STATS_MAX_SPDEFENSE smallint,
24  STATS_MAX_SPEED smallint,
25  PRIMARY KEY (POKE_NUM),
26  FOREIGN KEY (POKE_NUM) REFERENCES POKEMON(POKE_NUM)
27);
28
29CREATE TABLE IF NOT EXISTS GEN (
30  GEN_NUM tinyint,
31  GEN_YEAR smallint,
32  PRIMARY KEY (GEN_NUM)
33);
34
35CREATE TABLE IF NOT EXISTS BELONGS (
36  POKE_NUM smallint,
37  TYPE_ID tinyint,
38  PRIMARY KEY (POKE_NUM), FOREIGN KEY (POKE_NUM) REFERENCES POKEMON(POKE_NUM),
39  PRIMARY KEY (TYPE_ID), FOREIGN KEY (TYPE_ID) REFERENCES POKEMON(TYPE_ID)
40);
41
42CREATE TABLE IF NOT EXISTS LEARNS (
43	POKE_NUM SMALLINT,
44	MOVE_ID smallint,
45	LEARN_LEVEL tinyint,
46    PRIMARY KEY (POKE_NUM), FOREIGN KEY (POKE_NUM) REFERENCES POKEMON(POKE_NUM),
47    PRIMARY KEY (MOVE_ID), FOREIGN KEY (MOVE_ID) REFERENCES POKEMON(MOVE_ID)
48);
49
50CREATE TABLE IF NOT EXISTS MOVE (
51	MOVE_NAME varchar(50),
52    MOVE_ID smallint,
53	MOVE_CATEGORY varchar(25),
54	MOVE_POWER smallint,
55	MOVE_ACCURACY smallint,
56	MOVE_PP tinyint,
57	GEN_NUM tinyint,
58	TYPE_ID tinyint,
59    PRIMARY KEY (MOVE_ID),
60    FOREIGN KEY (GEN_NUM) REFERENCES GEN(GEN_NUM),
61    FOREIGN KEY (TYPE_ID) REFERENCES TYPE(TYPE_ID)
62);
63
64CREATE TABLE IF NOT EXISTS TYPE (
65  TYPE_ID tinyint,
66  TYPE_NAME varchar(50),
67  TYPE_AVG_HP decimal(3,2),
68  TYPE_AVG_ATTACK decimal(3,2),
69  TYPE_AVG_DEFENSE decimal (3,2),
70  TYPE_AVG_SPATTACK decimal (3,2),
71  TYPE_AVG_SPDEFENSE decimal (3,2),
72  TYPE_AVG_SPEED decimal (3,2),
73  PRIMARY KEY (TYPE_ID)
74);