PMG2224 4/DB Beleg/Deborah

Wiki-Quelltext dieser Seite.

<language>SQL</language>
<code id="65ea0965a5ce3">
DROP TABLE IF EXISTS universities;
CREATE TABLE universities (
    _id varchar NOT NULL UNIQUE,
    name varchar NOT NULL,
    city varchar(255),
    postalCode varchar(10),
    studyprograms varchar,

    PRIMARY KEY (_id)
);

DROP TABLE IF EXISTS studyprograms;
CREATE TABLE studyprograms (
    _id varchar NOT NULL UNIQUE,
    name varchar NOT NULL,
    content varchar,
    nc float,
    conditions varchar(255),

    PRIMARY KEY  (_id)
);

DROP TABLE IF EXISTS professors;
CREATE TABLE professors (
    _id varchar NOT NULL UNIQUE,
    lastName varchar,
    firstName varchar,
    age int,
    university varchar,
    

    PRIMARY KEY (_id),
    FOREIGN KEY (university) REFERENCES universities(_id),
    CHECK (age >= 18 AND age <= 100)
);
</code>

<run id="65ea09a56bdfb">

</run>