9 lines
259 B
MySQL
9 lines
259 B
MySQL
|
CREATE TABLE modelle (
|
||
|
|
id SERIAL PRIMARY KEY,
|
||
|
|
name VARCHAR NOT NULL,
|
||
|
|
typ_id SERIAL,
|
||
|
|
hersteller_id SERIAL,
|
||
|
|
CONSTRAINT fk_typ FOREIGN KEY(typ_id) REFERENCES typen(id),
|
||
|
|
CONSTRAINT fk_hersteller FOREIGN KEY (hersteller_id) REFERENCES hersteller(id)
|
||
|
|
)
|