SQL-Befehle für Aufgabenverwaltung

• Previous message: Erik Tews: "Supporter"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Hallo

Ich habe das DB-Design mal in SQL umgesetzt:

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

CREATE TABLE work (
        id SERIAL NOT NULL,
        work TEXT NOT NULL,
        min INT4,
        max INT4,
        location TEXT,
        starttime timestamp NOT NULL,
        endtime timestamp,
        comment TEXT,
        priority INT4
);

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

• Previous message: Erik Tews: "Supporter"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.3 : Sun May 05 2002 - 15:05:44 CEST