User Tools

Site Tools


podoc:aperture_sql_table

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
podoc:aperture_sql_table [2007/04/20 07:30]
Luud
podoc:aperture_sql_table [2007/04/20 10:22] (current)
Luud
Line 17: Line 17:
 === Schema === === Schema ===
  
-  create table aperture ( +<code sql> 
-    identifier            integer not null primary key, +create table aperture ( 
-    value                 varchar(10) +  identifier            integer not null primary key, 
-  ); +  value                 varchar(10) 
 +);  
 +</code>
  
 === References tables === === References tables ===
Line 28: Line 30:
 === Is referenced by tables === === Is referenced by tables ===
  
-None.+  * [[lens_type sql table|lens_type]](max_aperture) references identifier 
 +  * [[lens_type sql table|lens_type]](min_aperture) references identifier 
 +  * [[photo_tech sql table|photo_tech]](aperture) references identifier
  
 === Related sequences === === Related sequences ===
Line 61: Line 65:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 create table aperture ( create table aperture (
   identifier            integer not null primary key,   identifier            integer not null primary key,
Line 70: Line 74:
 = Version 2.32 = = Version 2.32 =
  
-<code>+<code sql>
 -- Convert aperture from a varchar to a numeric type -- Convert aperture from a varchar to a numeric type
 alter table aperture add value_num numeric; alter table aperture add value_num numeric;
Line 82: Line 86:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 insert into aperture values (nextval('aperture_id_sequence'), '0.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'), '0.75');
podoc/aperture_sql_table.1177068659.txt.gz · Last modified: 2007/04/20 07:30 by Luud