podoc:lens_sql_table
This is an old revision of the document!
Database Table Description of "lens"
Name
lens
Description
Purpose
Schema
create table lens ( identifier integer not null primary key, type integer not null references lens_type(identifier), users integer not null references users(identifier), serial_number varchar(20), date_of_purchase timestamp, purchased_new char(1) check (purchased_new in ('t', 'f')), access_rights integer not null references access_type(identifier) );
Related sequences
Related indexes
Related functions
Related views
History
Used first
Version 2.5
Used last
Still in use
Change history
= Version 2.5 =
create table lens ( identifier integer not null primary key, type integer not null references lens_type(identifier), users integer not null references users(identifier), serial_number varchar(20), date_of_purchase timestamp, purchased_new char(1) check (purchased_new in ('t', 'f')), access_rights integer not null references access_type(identifier) );
podoc/lens_sql_table.1176901194.txt.gz · Last modified: 2007/04/18 12:59 by Luud