podoc:photo_item_sql_table
This is an old revision of the document!
Database Table Description of "photo_item"
Name
photo_item
Description
Purpose
Schema
create table photo_item ( identifier integer not null primary key, photo integer not null references photo(identifier), shop_item integer not null references photo_format(identifier), price numeric, currency integer references currency(identifier), comment text, date_of_creation timestamp, date_of_last_edit timestamp );
Related tables
Related sequences
Related indexes
Related functions
Related views
History
Used first
Version 2.8
Used last
Still in use
Schema change history
= Version 2.8 =
create table photo_item ( identifier integer not null primary key, photo integer not null references photo(identifier), format integer not null references photo_format(identifier), price numeric, currency integer references currency(identifier), comment text, date_of_creation timestamp, date_of_last_edit timestamp );
= Version 2.19 =
alter table photo_item rename column format to shop_item;
Data change history
None.
podoc/photo_item_sql_table.1176739164.txt.gz · Last modified: 2007/04/16 15:59 by Luud