SQL-Entwurf

From: Erik Tews (erik.tews@gmx.net)
Date: Sun May 05 2002 - 22:32:54 CEST

Hier mein aktueller Entwurf:

CREATE TABLE freetime (
        name TEXT NOT NULL references person(name),
        starttime TIMESTAMP NOT NULL,
        endtime TIMESTAMP,
        comment TEXT
);

CREATE TABLE job (
        id SERIAL NOT NULL,
        work TEXT NOT NULL,
        location TEXT,
        description TEXT,
        priority INT4
);

CREATE TABLE jobfragment (
        id SERIAL NOT NULL,
        jobid INT4 NOT NULL references job(id),
        min INT4,
        max INT4,
        starttime timestamp NOT NULL,
        endtime timestamp,
        comment TEXT
);

CREATE TABLE assignment (
        id INT4 references jobfragment(id),
        helper TEXT references person(name),
        starttime timestamp NOT NULL,
        endtime timestamp NOT NULL
);

This archive was generated by hypermail 2.1.3 : Sun May 05 2002 - 22:34:52 CEST