podoc:aperture_sql_table
Database Table Description of "aperture"
Name
aperture
Description
This table contains a list of all valid apertures (eg f/2, f/5.6, etc).
Purpose
To enforce referential integrity.
Note: This table will likely be eliminated in the future in favor of direct aperture representation – this is an unnecessary abstraction.
Schema
CREATE TABLE aperture ( identifier INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10) );
References tables
None.
Is referenced by tables
- lens_type(max_aperture) references identifier
- lens_type(min_aperture) references identifier
- photo_tech(aperture) references identifier
Related sequences
Related indexes
None.
Related functions
None.
Related views
History
Used first
Version 2.5
Used last
Still in use
Schema change history
= Version 2.5 =
CREATE TABLE aperture ( identifier INTEGER NOT NULL PRIMARY KEY, VALUE NUMERIC );
= Version 2.32 =
-- Convert aperture from a varchar to a numeric type ALTER TABLE aperture ADD value_num NUMERIC; UPDATE aperture SET value_num = VALUE::text::NUMERIC; ALTER TABLE aperture DROP VALUE; ALTER TABLE aperture RENAME value_num TO VALUE;
Data change history
= Version 2.5 =
INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '0.5'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '0.75'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '1.0'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '1.2'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '1.3'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '1.4'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '1.6'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '1.8'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '2.0'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '2.2'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '2.5'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '2.8'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '3.2'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '3.5'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '4.0'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '4.5'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '5.0'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '5.6'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '6.3'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '7.1'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '8.0'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '9.0'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '10'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '11'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '13'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '14'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '16'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '18'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '20'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '22'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '25'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '28'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '32'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '36'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '40'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '45'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '51'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '57'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '64'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '72'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '81'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '90'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '103'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '115'); INSERT INTO aperture VALUES (NEXTVAL('aperture_id_sequence'), '128');
podoc/aperture_sql_table.txt · Last modified: 2007/04/20 14:22 by Luud