Re: [phpXperts] Problem about database design

try this one     CREATE TABLE EMPLOYEE( branch_id      VARCHAR(10)  NOT NULL, dept_id        VARCHAR(10)  NOT NULL, employee_id    VARCHAR(10)  NOT NULL, PRIMARY KEY( branch_id, dept_id, employee_id ), FOREIGN KEY( branch_id ) REFERENCES table name(table field), FOREIGN KEY( dept_id ) REFERENCES table name(field) )type=innodb; --- On Tue, 9/16/08, shiplu <shiplu.net@gmail.com> wrote: From: shiplu <shiplu.net@gmail.com> Subject: Re: [phpXperts] Problem about database design To: phpexperts@yahoogroups.com Date: Tuesday, September 16, 2008, 8:24 AM CREATE TABLE EMPLOYEE( branch_id      VARCHAR(10)           NOT NULL, dept_id         VARCHAR(10)           NOT NULL, employee_id   VARCHAR(10)           NOT NULL,   PRIMARY KEY( branch_id, dept_id, employee_id ), FOREIGN KEY( branch_id ) REFERENCES( branch ), FOREIGN KEY( dept_id ) REFERENCES( dept ) ); -- A K M Mokaddim http://talk. cmyweb.net http://twitter. com/shiplu Stop Top Posting !!

__._,_.___

Visit phpXperts website at www.phpxperts.net

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___