foreign key relationship - MySQL for 1-to-1 relation with relational integrity -


enter image description here

i'm trying write create table statement relationship above. i'm not sure if i've represented correctly every outlet has 1 manager , every manager manages 1 outlet. believe either 1 of primary keys either table able supply primary key relationship table, can pick either of them?

i've been told don't need create separate table relationship unless many-to-many relationship?

i'd have sort of constraint (if thats right word) if store cant deleted if manager attached , can't delete manager if attached outlet.

i've written create table statement think right i've been doing stuff 2 weeks , have no idea if going behave way want:

create table managers (     mgr_id int(10) not null auto_increment,     mgr_name varchar(255),     primary key (mgr_id) );  create table outlet (     store_id int(10) not null auto_increment,     store_name varchar(255),     primary key (store_id) );  create table store_manager (     mgr_id int(10) default '0' not null,     store_id int(10) default '0' not null,     primary key (store_id),     foreign key (mgr_id) references managers(mgr_id)         on delete no action ); 

will statements create tables behave according requirements?

thanks


Comments

Popular posts from this blog

php - isset function not working properly -

javascript - Thinglink image not visible until browser resize -

firebird - Error "invalid transaction handle (expecting explicit transaction start)" executing script from Delphi -