User Tools

Site Tools


podoc:photo_item_sql_table

Differences

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

Link to this comparison view

Next revision
Previous revision
podoc:photo_item_sql_table [2007/04/16 11:31]
Luud created
podoc:photo_item_sql_table [2007/10/19 15:51] (current)
Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-<code>+<code sql>
 create table photo_item ( create table photo_item (
   identifier            integer not null primary key,   identifier            integer not null primary key,
   photo                 integer not null references photo(identifier),   photo                 integer not null references photo(identifier),
-  format                integer not null references photo_format(identifier),+  shop_item             integer not null references shop_item(identifier),
   price                 numeric,   price                 numeric,
   currency              integer references currency(identifier),   currency              integer references currency(identifier),
Line 21: Line 21:
   date_of_creation      timestamp,   date_of_creation      timestamp,
   date_of_last_edit     timestamp   date_of_last_edit     timestamp
 +  deleted               char(1) check (deleted in ('t', 'f'));
 ); );
 </code> </code>
  
-=== Related tables ===+=== References tables ===
  
-  * [[photo sql table|photo]]+  * currency references [[currency sql table|currency]](identifier) 
 +  * photo references [[photo sql table|photo]](identifier) 
 +  * shop_item references [[shop_item sql table|shop_item]](identifier) 
 + 
 +=== Is referenced by tables === 
 + 
 +  * [[shop_order sql table|shop_order]](item) references identifier
  
 === Related sequences === === Related sequences ===
Line 33: Line 40:
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +  * [[is_photo_for_sale sql function|is_photo_for_sale]]
 +  * [[photo_shop_transaction_references sql function|photo_shop_transaction_references]]
  
 === Related views === === Related views ===
 +
 +None.
  
 === History === === History ===
Line 46: Line 60:
 == Used last == == Used last ==
  
-Still in use+Version 2.33
  
 == Schema change history == == Schema change history ==
Line 52: Line 66:
 = Version 2.8 = = Version 2.8 =
  
-<code>+<code sql>
 create table photo_item ( create table photo_item (
   identifier            integer not null primary key,   identifier            integer not null primary key,
Line 63: Line 77:
   date_of_last_edit     timestamp   date_of_last_edit     timestamp
 ); );
 +</code>
 +
 += Version 2.19 =
 +
 +<code sql>
 +alter table photo_item rename column format to shop_item;
 +</code>
 +
 += Version 2.29 =
 +
 +<code sql>
 +alter table photo_item add deleted char(1) check (deleted in ('t', 'f'));
 +</code>
 +
 += Version 2.34 =
 +
 +<code sql>
 +drop table photo_item;
 </code> </code>
  
 == Data change history == == Data change history ==
  
-= Version 2.=+= Version 2.29 = 
 + 
 +<code sql> 
 +update photo_item set deleted='f'; 
 +</code>
  
-None. 
  
podoc/photo_item_sql_table.1176723100.txt.gz · Last modified: 2007/04/16 11:31 by Luud