create table USERS (
PK_USER int not null auto_increment primary key,
EMAIL varchar(100) not null,
PASSWORD char(40) not null
);
create table CIRCLES (
PK_CIRCLE int not null auto_increment primary key,
CIRCLE varchar(45),
FK_CREATOR int,
foreign key(FK_CREADOR) references USERS(PK_USER)
);
create table MEMBERS (
FK_MEMBERS int,
FK_CIRCLES int,
foreign key(FK_MEMBER) references USERS(PK_USER),
foreign key(FK_CIRCLE) references CIRCLES(PK_CIRCLE)
);
is correct to have this dual reference to PK_USER
?
(for ref. USERS=USUARIOS, MEMBERS=MIEMBROS, CIRCLES=CIRCULOS, CREATOR=CREADOR)
By what I can «infer» they are playing two different roles :
So: you're ok provided those were your intentions :)