Re: [SQL] problem with uniques and foreing keys

[kernel.alert kernel.alert]

Sorry i had a mistake in the post it was with the definition of the primary key in the empresa table...

I'm having the same error when i build the last table...


thanks for your answers...
 

Hi list...

Please i have a problem with this...

I create the follow tables...

--------------------------------------------------------

CREATE TABLE empresa (
  id_empresa         integer  NOT NULL primary key,
  nombre             varchar(45),

      primary key(id_empresa)

);
CREATE TABLE casino (
  id_casino          integer  NOT NULL,
  id_empresa         integer      REFERENCES empresa(id_empresa),

  nombre             varchar(45),

  primary key(id_casino,id_empresa)
);
CREATE TABLE maq_casino (
  id_empresa      integer  NOT NULL REFERENCES  casino(id_empresa),
  id_casino       integer  NOT NULL REFERENCES  casino(id_casino),

  ubicacion_sala     varchar(45) default NULL,
  primary key(id_empresa,id_casino,id_tipo_maquina,id_maq_casino)
);

--------------------------------------------------------

When i'm gonna to create the last table i got this error:

 

ERROR:  no hay restriccion unique que coincida con las columnas dadas en la tabla referida <<casino>>

That in english is like .. there is no a unique constraint with columns referred  in casino table.


Please where is the problem...

Greetings ...

Krackem