camera_type
A listing of all known camera types in the system.
We could have several cameras of the same type, so this is a way of specifiying the common stuff.
For example, I could have several 'Nikon D70' cameras, which are otherwise identical – but the specifics (like serial number) are stored in the camera table.
CREATE TABLE camera_type ( identifier INTEGER NOT NULL PRIMARY KEY, manufacturer INTEGER NOT NULL REFERENCES manufacturer(identifier), model VARCHAR(100), variation VARCHAR(100), last_modified_date TIMESTAMP, last_modifying_users INTEGER REFERENCES users(identifier), raw_icc_profile INTEGER );
Version 2.5
Still in use
= Version 2.5 =
CREATE TABLE camera_type ( identifier INTEGER NOT NULL PRIMARY KEY, manufacturer INTEGER NOT NULL REFERENCES manufacturer(identifier), model VARCHAR(100), variation VARCHAR(100), last_modified_date TIMESTAMP, last_modifying_users INTEGER REFERENCES users(identifier) );
= Version 2.29 =
ALTER TABLE camera_type ADD raw_icc_profile INTEGER;
= Version 2.29 =
UPDATE camera_type SET raw_icc_profile=NULL;