[tyche]

How to manage reflexive relation ?

 

create table menu_me
(
   me_id                int not null auto_increment,
   men_me_id            int not null,
   me_libelle           varchar(50),
   me_url               varchar(100),
   primary key (me_id)
);

alter table menu_me add constraint fk_association_1 foreign key (men_me_id)
      references menu_me (me_id) on delete restrict on update restrict;