foreign key relationship - MySQL for 1-to-1 relation with relational integrity -
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
Post a Comment