Deborah

Aus ProgrammingWiki

Archivierte Version vom 2024-03-07T18:38:29+00:00. Aktuelle Version

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)
);

Deborah

Suche