Differences

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

--- podoc:location_sql_table [2007/04/12 12:14] – Luud
+++ podoc:location_sql_table [2007/04/20 13:38] (current) – Luud
@@ Line 1: / Line 1: @@
-===== Database Table Description =====
+===== Database Table Description of "location" =====
 === Name ===
+location
 === Description ===
@@ Line 8: / Line 10: @@
 === Schema ===
+<code sql>
+create table location ( -- location is the place the photo was taken
+  identifier            integer not null primary key,
+  place                 varchar(300),
+  state                 integer references state(identifier),
+  country               integer references country(identifier),
+  last_modified_date 	timestamp,
+  users                 integer references users(identifier),
+  city                  varchar(300),
+  latitude              varchar(10),
+  longitude             varchar(10),
+  private               boolean not null
+);
+</code>
+=== References tables ===
+  * country references [[country sql table|country]](identifier)
+  * state references [[state sql table|state]](identifier)
+  * users references [[users sql table|users]](identifier)
+=== Is referenced by tables ===
+  * [[photo sql table|photo]](location) references identifier
 === Related sequences ===
+  * [[location_id_sequence sql sequence|location_id_sequence]]
 === Related indexes ===
+None.
 === Related functions ===
+  * [[number_of_location_references sql function|number_of_location_references]]
+=== Related views ===
+  * [[view_location sql view|view_location]]
 === History ===
@@ Line 25: / Line 62: @@
 Still in use
-== Change history ==
+== Schema change history ==
 = Version 2.5 =
-  create table ... (
+<code sql>
-    ...
+create table location ( -- location is the place the photo was taken
-  );
+  identifier            integer not null primary key,
+  place                 varchar(300),
+  state                 integer references state(identifier),
+  country               integer references country(identifier),
+  last_modified_date 	timestamp,
+  last_modifying_users  integer references users(identifier),
+  city                  varchar(300),
+  latitude              varchar(10),
+  longitude             varchar(10)
+);
+</code>
+= Version 2.33 =
+<code sql>
+alter table location rename last_modifying_users to users;
+alter table location add private boolean;
+update location set private='f';
+alter table location alter private set not null;
+</code>
+== Data change history ==
+= Version 2.31 =
+<code sql>
+-- Ensure referential integrity with the locations.
+insert into location (identifier, place) values (0, 'Unknown');
+</code>