podoc:aperture_sql_table
This is an old revision of the document!
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
None.
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.1177068659.txt.gz · Last modified: 2007/04/20 11:30 by Luud