CREATE TABLE players (

id BIGSERIAL PRIMARY KEY NOT NULL,

nickname TEXT NOT NULL,

real_name TEXT NOT NULL,

role TEXT NOT NULL,

status TEXT NOT NULL,

joined_at TIMESTAMP NOT NULL,

photo_url TEXT NOT NULL,

bio TEXT NOT NULL);

CREATE TABLE gear (

id BIGSERIAL PRIMARY KEY NOT NULL,

player_id BIGINT NOT NULL,

manufacturer TEXT NOT NULL,

model TEXT NOT NULL,

amazon_link TEXT NOT NULL);

CREATE TABLE matches (

id BIGSERIAL PRIMARY KEY NOT NULL,

time TIMESTAMP NOT NULL,

versus TEXT NOT NULL,

result_us INTEGER(2),

result_enemy INTEGER(2));

CREATE TABLE skins (

id BIGSERIAL PRIMARY KEY NOT NULL,

player_id BIGSERIAL NOT NULL,

weapon TEXT NOT NULL,

paint TEXT NOT NULL,

wear DOUBLE PRECISION(1,8) NOT NULL DEFAULT 0.00,

pattern INTEGER(3) NOT NULL DEFAULT 0,

nametag TEXT NOT NULL,

csfloat_link TEXT NOT NULL);

CREATE TABLE specs (

id BIGSERIAL PRIMARY KEY NOT NULL,

player_id BIGSERIAL NOT NULL,

cpu_manufacturer TEXT NOT NULL,

cpu_model TEXT NOT NULL,

gpu_manufacturet TEXT NOT NULL,

gpu_model TEXT NOT NULL,

ram_size_gb INTEGER NOT NULL,

ram_manufacturer TEXT NOT NULL,

gpu_amazon_link TEXT NOT NULL,

cpu_amazon_link TEXT NOT NULL,

ram_amazon_link TEXT NOT NULL);

ALTER TABLE gear ADD CONSTRAINT gear_player_id_players_id FOREIGN KEY (player_id) REFERENCES players(id) ON DELETE CASCADE ON UPDATE NO ACTION;

ALTER TABLE skins ADD CONSTRAINT skins_player_id_players_id FOREIGN KEY (player_id) REFERENCES players(id) ON DELETE CASCADE ON UPDATE NO ACTION;

ALTER TABLE specs ADD CONSTRAINT specs_player_id_players_id FOREIGN KEY (player_id) REFERENCES players(id) ON DELETE CASCADE ON UPDATE NO ACTION;