return to first page linux journal archive
keywordscontents

Listing 5. A Three-Column Appoinments Table

CREATE TABLE Appointments (<\n>
   person_id   INT4       NOT NULL,
   appt_when   TIMESTAMP  NOT NULL,
   notes       TEXT       NULL       CHECK (notes <>
''),

   UNIQUE(appt_when)
);