===== 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_sql_table|camera]] table.

=== Schema ===

<code sql>
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
);
</code>

=== References tables ===

  * manufacturer references [[manufacturer sql table|manufacturer]](identifier)
  * users references [[users sql table|users]](identifier)

=== Is referenced by tables ===

  * [[camera sql table|camera]](type) references identifier

=== Related tables ===

  * [[camera sql table|camera]]

=== Related sequences ===

  * [[camera_type_id_sequence sql sequence|camera_type_id_sequence]]

=== Related indexes ===

  * [[camera_type_manufacturer_idx sql index|camera_type_manufacturer_idx]]

=== Related functions ===

  * [[number_of_manufacturer_ref sql function|number_of_manufacturer_ref]]

=== Related views ===

  * [[view_camera sql view|view_camera]]
  * [[view_camera_type sql view|view_camera_type]]

=== History ===

== Used first ==

Version 2.5

== Used last ==

Still in use

== Schema change history ==

= Version 2.5 =

<code sql>
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)
);
</code>

= Version 2.29 =

<code sql>
alter table camera_type add raw_icc_profile integer;
</code>

== Data change history ==

= Version 2.29 =

<code sql>
update camera_type set raw_icc_profile=null;
</code>