Povezivanje dve tabele pomocu foreign keys...Pomoc
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));
 |  |
 |
