podoc:camera_type_sql_table
This is an old revision of the document!
Database Table Description of "camera_type"
Name
camera_type
Description
A listing of all known camera types in the system.
Purpose
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.
Schema
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 );
Related tables
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 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;
Data change history
= Version 2.29 =
update camera_type set raw_icc_profile=null;
podoc/camera_type_sql_table.1176907812.txt.gz · Last modified: 2007/04/18 14:50 by Luud