podoc:aperture_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
podoc:aperture_sql_table [2007/04/12 12:34] – Luud | podoc:aperture_sql_table [2007/04/20 13:37] – Luud | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Database Table Description ===== | + | ===== Database Table Description |
=== Name === | === Name === | ||
+ | |||
+ | aperture | ||
=== Description === | === Description === | ||
+ | |||
+ | This table contains a list of all valid apertures (eg f/2, f/5.6, etc). | ||
=== Purpose === | === 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 === | === Schema === | ||
+ | |||
+ | <code sql> | ||
+ | create table aperture ( | ||
+ | identifier | ||
+ | value | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | === References tables === | ||
+ | |||
+ | None. | ||
+ | |||
+ | === Is referenced by tables === | ||
+ | |||
+ | * [[lens_type sql table|lens_type]](max_aperture) references identifier | ||
+ | * [[lens_type sql table|lens_type]](min_aperture) references identifier | ||
=== Related sequences === | === Related sequences === | ||
+ | |||
+ | * [[aperture_id_sequence sql sequence|aperture_id_sequence]] | ||
=== Related indexes === | === Related indexes === | ||
+ | |||
+ | None. | ||
=== Related functions === | === Related functions === | ||
+ | |||
+ | None. | ||
=== Related views === | === Related views === | ||
+ | |||
+ | * [[view_lens sql view|view_lens]] | ||
+ | * [[view_lens_type sql view|view_lens_type]] | ||
=== History === | === History === | ||
Line 27: | Line 60: | ||
Still in use | Still in use | ||
- | == Change | + | == Schema change |
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | ... | + | create table aperture ( |
- | ); | + | identifier |
+ | value | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | = Version 2.32 = | ||
+ | |||
+ | <code sql> | ||
+ | -- Convert aperture from a varchar to a numeric type | ||
+ | alter table aperture add value_num numeric; | ||
+ | update aperture set value_num = value:: | ||
+ | alter table aperture drop value; | ||
+ | alter table aperture rename value_num to value; | ||
+ | </ | ||
+ | |||
+ | == Data change history == | ||
+ | |||
+ | = Version 2.5 = | ||
+ | |||
+ | <code sql> | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | insert into aperture values (nextval(' | ||
+ | </ |
podoc/aperture_sql_table.txt · Last modified: 2007/04/20 14:22 by Luud