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
- access_rights references access_type(identifier)
- type references filter_type(identifier)
- users references users(identifier)
Is referenced by tables
- photo_tech(filter) references identifier
Related sequences
Related indexes
Related functions
Related views
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 14:27 by Luud