User Tools

Site Tools


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.

None.

None.

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