User Tools

Site Tools


podoc:focal_length_sql_table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
podoc:focal_length_sql_table [2007/04/17 13:10] Luudpodoc:focal_length_sql_table [2007/04/20 14:27] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-<code>+<code sql>
 create table focal_length ( create table focal_length (
   identifier            integer not null primary key,   identifier            integer not null primary key,
Line 17: Line 17:
 ); );
 </code> </code>
 +
 +=== References tables ===
 +
 +None.
 +
 +=== Is referenced by tables ===
 +
 +  * [[lens_type sql table|lens_type]](max_focal_length) references identifier
 +  * [[lens_type sql table|lens_type]](min_focal_length) references identifier
 +  * [[photo_tech sql table|photo_tech]](focal_length) references identifier
  
 === Related sequences === === Related sequences ===
Line 23: Line 33:
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +None.
  
 === Related views === === Related views ===
  
-  * [[view_focal_length sql view|view_focal_length]] 
   * [[view_lens sql view|view_lens]]   * [[view_lens sql view|view_lens]]
   * [[view_lens_type sql view|view_lens_type]]   * [[view_lens_type sql view|view_lens_type]]
Line 46: Line 59:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 create table focal_length ( create table focal_length (
   identifier            integer not null primary key,   identifier            integer not null primary key,
Line 55: Line 68:
 = Version 2.32 = = Version 2.32 =
  
-<code>+<code sql>
 -- Convert focal length from a varchar to an integer -- Convert focal length from a varchar to an integer
 alter table focal_length add value_num integer; alter table focal_length add value_num integer;
Line 67: Line 80:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 insert into focal_length values (nextval('focal_length_id_sequence'), '5'); insert into focal_length values (nextval('focal_length_id_sequence'), '5');
 insert into focal_length values (nextval('focal_length_id_sequence'), '6'); insert into focal_length values (nextval('focal_length_id_sequence'), '6');
Line 117: Line 130:
 = Version 2.32 = = Version 2.32 =
  
-<code>+<code sql>
 -- Add more focal lengths. -- Add more focal lengths.
 insert into focal_length values (nextval('focal_length_id_sequence'), 75); insert into focal_length values (nextval('focal_length_id_sequence'), 75);
Line 125: Line 138:
 = Version 2.33 = = Version 2.33 =
  
-<code>+<code sql>
 -- Add more focal lengths. -- Add more focal lengths.
 insert into focal_length values (nextval('focal_length_id_sequence'), 65); insert into focal_length values (nextval('focal_length_id_sequence'), 65);
podoc/focal_length_sql_table.1176815430.txt.gz · Last modified: 2007/04/17 13:10 by Luud