i create a postgresql schema with table . In my table player i have id positive but in my table referee i have id negative. I don’t understand why are ids different , i use the same proprieties.
ALTER TABLE IF EXISTS i_match.td_player
ADD COLUMN id_player bigint NOT NULL;
the same for my table referee and this is the definition of my table referee => — Table: i_match.td_referee
— DROP TABLE IF EXISTS i_match.td_referee;
CREATE TABLE IF NOT EXISTS i_match.td_referee
(
last_name character varying(100) COLLATE pg_catalog.”default” NOT NULL,
first_name character varying(100) COLLATE pg_catalog.”default” NOT NULL,
id_referee bigint NOT NULL,
birth_date date,
CONSTRAINT “PK_TD_REFEREE” PRIMARY KEY (id_referee)
)
TABLESPACE pg_default;
ALTER TABLE IF EXISTS i_match.td_referee
OWNER to elodie_nebulot;
ALTER TABLE IF EXISTS i_match.td_referee
ALTER COLUMN id_referee SET STATISTICS 1;
my row player 1 => id = 1 name => john datebegin = 23/09/2023
my row referee 1=> id = -1 ……. i want a positif number not a negatif number
elodie neb is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.