CREATE TABLE client_roles
(
client_role_id bigint NOT NULL,
client_role_description character varying(50),
client_role_name character varying(50),
CONSTRAINT client_roles_pkey PRIMARY KEY (client_role_id)
)
CREATE TABLE clients
(
client_id bigint NOT NULL,
client_address character varying(255),
client_document character varying(255),
client_phone character varying(255),
client_username character varying(255),
client_player_id bigint,
client_role_id bigint,
CONSTRAINT clients_pkey PRIMARY KEY (client_id),
CONSTRAINT fk5e1711e851a4154 FOREIGN KEY (client_player_id)
REFERENCES players (player_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk5e1711e85438139f FOREIGN KEY (client_role_id)
REFERENCES client_roles (client_role_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
CREATE TABLE daysoff
(
dayoff_id bigint NOT NULL,
dayoff_date date,
dayoff_name character varying(255),
CONSTRAINT daysoff_pkey PRIMARY KEY (dayoff_id)
)
CREATE TABLE goals
(
goal_id bigint NOT NULL,
goal_minute integer,
goal_match_id bigint,
goal_player_id bigint,
CONSTRAINT goals_pkey PRIMARY KEY (goal_id),
CONSTRAINT fk40d6ba020936ed8 FOREIGN KEY (goal_match_id)
REFERENCES matches (match_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk40d6ba06358529c FOREIGN KEY (goal_player_id)
REFERENCES players (player_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
CREATE TABLE matches
(
match_id bigint NOT NULL,
match_date timestamp without time zone,
match_first_team bigint,
match_second_team bigint,
CONSTRAINT matches_pkey PRIMARY KEY (match_id),
CONSTRAINT fk5cea1513505d65d1 FOREIGN KEY (match_first_team)
REFERENCES teams (team_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk5cea1513fd430859 FOREIGN KEY (match_second_team)
REFERENCES teams (team_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
CREATE TABLE notifications
(
notification_id bigint NOT NULL,
notification_readiness boolean,
notification_match_id bigint,
notification_player_id bigint,
CONSTRAINT notifications_pkey PRIMARY KEY (notification_id),
CONSTRAINT fk594acc81d61ee74 FOREIGN KEY (notification_player_id)
REFERENCES players (player_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk594acc8c37af800 FOREIGN KEY (notification_match_id)
REFERENCES matches (match_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
CREATE TABLE penalties
(
penalty_id bigint NOT NULL,
penalty_description character varying(255),
penalty_expiration_date date,
penalty_match_id bigint,
penalty_player_id bigint,
CONSTRAINT penalties_pkey PRIMARY KEY (penalty_id),
CONSTRAINT fke67b1ac717cefa22 FOREIGN KEY (penalty_match_id)
REFERENCES matches (match_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fke67b1ac7538e3092 FOREIGN KEY (penalty_player_id)
REFERENCES players (player_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
CREATE TABLE players
(
player_id bigint NOT NULL,
player_email character varying(255),
player_first_name character varying(255),
player_last_name character varying(255),
player_nationalid character varying(255),
player_team_id bigint,
CONSTRAINT players_pkey PRIMARY KEY (player_id),
CONSTRAINT fkd604d92a56ff76a FOREIGN KEY (player_team_id)
REFERENCES teams (team_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
CREATE TABLE reservations
(
reservation_id bigint NOT NULL,
reservation_date timestamp without time zone,
reservation_description character varying(255),
reservation_client_id bigint,
CONSTRAINT reservations_pkey PRIMARY KEY (reservation_id),
CONSTRAINT fk41f21e27a308a3d5 FOREIGN KEY (reservation_client_id)
REFERENCES clients (client_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
CREATE TABLE team_groups
(
team_group_id bigint NOT NULL,
team_group_description character varying(255),
team_group_name character varying(255),
CONSTRAINT team_groups_pkey PRIMARY KEY (team_group_id)
)
CREATE TABLE teams
(
team_id bigint NOT NULL,
team_colour character varying(255),
team_description character varying(255),
team_name character varying(255),
team_group_id bigint,
CONSTRAINT teams_pkey PRIMARY KEY (team_id),
CONSTRAINT fk4c01196d53b7331 FOREIGN KEY (team_group_id)
REFERENCES team_groups (team_group_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)