User Tools

Site Tools


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),
  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
);

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
);
Data change history

= Version 2.8 =

None.

podoc/photo_item_sql_table.1176723100.txt.gz · Last modified: 2007/04/16 11:31 by Luud