[ djovan01 @ 26.12.2006. 19:28 ] @
kada kreirate tabelu1 i u njoj definisete Primary key i Foreign Key koji references primary key u tabeli2 znaci da ce foreign key vrednost biti prenesena iz njegove tabele2 u tabelu1? Jesam li u pravu? Kreirala sam bazu sa tabelama i bila ubedjena da sam ih povezala preko Foreign Key-a. Ovako sam ja to uradila. U cemu je moja greska? CREATE TABLE customer (c_id INT(6), c_name VARCHAR(10), contact_name VARCHAR(20), phone INT(10), email VARCHAR(40), j_location VARCHAR(40), start_date VARCHAR(10), e_id INT(10), f_id INT(10), p_id INT(10), r_id INT(10), CONSTRAINT customer_c_id_pk PRIMARY KEY(c_id), CONSTRAINT customer_e_id_fk FOREIGN KEY(e_id) REFERENCES facility(e_id)); CREATE TABLE facility (c_id INT(6), hours VARCHAR(10), ceiling_ht VARCHAR(10), floor VARCHAR(10), loading_dock VARCHAR(4), ground_door VARCHAR(4), crane VARCHAR(4), CONSTRAINT facility_c_id_pk PRIMARY KEY(c_id)); |