User Tools

Site Tools


podoc:camera_type_sql_table

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

References tables

  • manufacturer references manufacturer(identifier)
  • users references users(identifier)

Is referenced by tables

  • camera(type) references identifier

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.txt · Last modified: 2007/04/20 08:02 by Luud