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/18 08:42]
pizza description.
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 === 
 + 
 +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 
 +  * [[photo_tech sql table|photo_tech]](aperture) references identifier
  
 === Related sequences === === Related sequences ===
Line 27: Line 39:
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +None.
  
 === Related views === === Related views ===
Line 49: 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 58: 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 70: 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.1176900152.txt.gz · Last modified: 2007/04/18 08:42 by pizza