DBDesigner 4 og foreign keys

[remi sture]

Halla!

 

Se på denne datamodellen her (laget i DBDesigner 4). Hvorfor får "user" fremmednøklene til "postal" også (postal_borough_id, postal_borough_county_id)? Blir dette riktig?

 

Skal altså tabellen opprettes slik? (SQL Create eksportert fra programmet)

 

CREATE TABLE 'user' (
 id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
 postal_id INTEGER UNSIGNED NOT NULL,
 postal_borough_id INTEGER UNSIGNED NOT NULL,
 postal_borough_county_id INTEGER UNSIGNED NOT NULL,
 user_level_id INTEGER UNSIGNED NOT NULL,
 firstname VARCHAR NOT NULL,
 surname VARCHAR NOT NULL,
 address VARCHAR NULL,
 phone INTEGER UNSIGNED NULL,
 email VARCHAR NOT NULL,
 'password' VARCHAR NOT NULL,
 birthdate DATE NULL,
 default_persons INTEGER UNSIGNED NULL,
 PRIMARY KEY(id, postal_id, postal_borough_id, postal_borough_county_id, user_level_id),
 INDEX 'user'_FKIndex1(postal_id, postal_borough_id, postal_borough_county_id),
 INDEX 'user'_FKIndex2(user_level_id)
)
TYPE=InnoDB;

[

Endret 9. november 2006 av remi sture