Differences

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

--- podoc:aperture_sql_table [2007/04/19 04:25]
Luud
+++ podoc:aperture_sql_table [2007/04/20 10:22] (current)
Luud
@@ Line 17: / Line 17: @@
 === 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 ===
@@ Line 53: / Line 65: @@
 = Version 2.5 =
-<code>
+<code sql>
 create table aperture (
   identifier            integer not null primary key,
@@ Line 62: / Line 74: @@
 = Version 2.32 =
-<code>
+<code sql>
 -- Convert aperture from a varchar to a numeric type
 alter table aperture add value_num numeric;
@@ Line 74: / Line 86: @@
 = 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.75');

Photo Organizer