User Tools

Site Tools


podoc:filter_sql_table

Database Table Description of "filter"

Name

filter

Description

Purpose

Schema

CREATE TABLE FILTER (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  TYPE                  INTEGER NOT NULL REFERENCES filter_type(identifier),
  users                 INTEGER NOT NULL REFERENCES users(identifier),
  date_of_purchase      TIMESTAMP,
  purchased_new         CHAR(1) CHECK (purchased_new IN ('t', 'f')),
  access_rights         INTEGER NOT NULL REFERENCES access_type(identifier),
  serial_number         VARCHAR(20);
);

References tables

Is referenced by tables

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= Version 2.5 =

CREATE TABLE FILTER (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  TYPE                  INTEGER NOT NULL REFERENCES filter_type(identifier),
  users                 INTEGER NOT NULL REFERENCES users(identifier),
  date_of_purchase      TIMESTAMP,
  purchased_new         CHAR(1) CHECK (purchased_new IN ('t', 'f')),
  access_rights         INTEGER NOT NULL REFERENCES access_type(identifier)
);

= Version 2.33 =

-- Add another column to the filters
ALTER TABLE FILTER ADD serial_number VARCHAR(20);
Data change history
podoc/filter_sql_table.txt · Last modified: 2007/04/20 10:27 by Luud