User Tools

Site Tools


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)
);

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