Differences

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

--- podoc:shop_transaction_status_sql_table [2007/04/16 11:41] – created Luud
+++ podoc:shop_transaction_status_sql_table [2007/10/19 15:51] (current) – Luud
@@ Line 11: / Line 11: @@
 === Schema ===
-<code>
+<code sql>
 create table shop_transaction_status (
   identifier            integer not null primary key,
@@ Line 18: / Line 18: @@
 </code>
-=== Related tables ===
+=== References tables ===
+None.
+=== Is referenced by tables ===
+  * [[shop_transaction sql table|shop_transaction]](status) references identifier
 === Related sequences ===
@@ Line 25: / Line 31: @@
 === Related indexes ===
+None.
 === Related functions ===
+None.
 === Related views ===
+None.
 === History ===
@@ Line 34: / Line 46: @@
 == Used first ==
-Version 2.5
+Version 2.8
 == Used last ==
-Still in use
+Version 2.33
 == Schema change history ==
@@ Line 44: / Line 56: @@
 = Version 2.8 =
-<code>
+<code sql>
 create table shop_transaction_status (
   identifier            integer not null primary key,
   value                 varchar(15)
 );
+</code>
+= Version 2.34 =
+<code sql>
+drop table shop_transaction_status;
 </code>
@@ Line 55: / Line 73: @@
 = Version 2.8 =
-<code>
+<code sql>
 insert into shop_transaction_status values (nextval('shop_transaction_status_id_sequence'), 'Ordered');
 insert into shop_transaction_status values (nextval('shop_transaction_status_id_sequence'), 'Shipped');
 </code>