lens
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) );
Version 2.5
Still in use
= 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) );