Account:

A_ID int NOT NULL UNIQUE
nickname varchar(32) NOT NULL UNIQUE
password varchar(16) NOT NULL
PRIMARY KEY (A_ID)
CHECK(Whether the amount of linked accounts does not exceed the number of 8)

Character:

C_ID int NOT NULL UNIQUE PRIMARY KEY
name varchar(32) NOT NULL UNIQUE

level int NOT NULL
CHECK(level >= 0 and level <= 2715)
class int NOT NULL
race int NOT NULL
FOREIGN KEY (A_ID) REFERENCES Account(A_ID)

Bank_Balance:

C_ID int NOT NULL UNIQUE
FOREIGN KEY (C_ID) REFERENCES Character(C_ID)

copper_coins int NOT NULL
CHECK(copper_coins >= 0 and copper_coins <= 9999)
silver_coins int NOT NULL
CHECK(silver_coins >= 0 and copper_coins <= 9999)
gold_coins int NOT NULL
CHECK(gold_coins >= 0 and copper_coins <= 9999)

Equipment:

C_ID int NOT NULL UNIQUE
FOREIGN KEY (C_ID) REFERENCES Character(C_ID)
armor int
enchants int
accessoiries int

Guild:

guild_ID int
CHECK(Whether the player still exists in database)

Player Rankings:

C_ID int NOT NULL UNIQUE
FOREIGN KEY (C_ID) REFERENCES Character(C_ID)
name varchar(32) NOT NULL UNIQUE
ranking_placement int
CHECK(ranking_placement >= 1 and ranking_placement <= sp_spaceused Character)


Battle_Logs:

L_ID int NOT NULL UNIQUE
PRIMARY KEY(L_ID)
C_ID int NOT NULL UNIQUE
FOREIGN KEY (C_ID) REFERENCES Character(C_ID)

damage_output int NOT NULL
CHECK(damage_output >= 0)
healing_output int NOT NULL
CHECK(healing_output >= 0)
date varchar(9) (Formatted as yyyy/mm/dd)
deaths int NOT NULL
CHECK(deaths >= 0)
kills int NOT NULL
CHECK(kills >= 0)

Game_Content:

quests int
maps int NOT NULL UNIQUE
enemy_data int NOT NULL