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 deleted char(1) check (deleted in ('t', 'f')); );
Related tables
Related sequences
Related indexes
None.
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;
= Version 2.29 =
alter table photo_item add deleted char(1) check (deleted in ('t', 'f'));
Data change history
= Version 2.29 =
update photo_item set deleted='f';
podoc/photo_item_sql_table.1176905184.txt.gz · Last modified: 2007/04/18 14:06 by Luud