User Tools

Site Tools


podoc:photo_dupe_sql_table

This is an old revision of the document!


Database Table Description of "photo_dupe"

Name

photo_dupe

Description

Purpose

Schema

create table photo_dupe (
  identifier            integer not null primary key,
  key                   integer not null,
  photo                 integer not null references photo(identifier),
  date_of_creation      timestamp,        -- date when it was inserted in the system
  storage_location      varchar(50),
  storage_index         varchar(10),
  remark                text              -- dupe remark
);

References other tables

  • photo references photo(identifier)

Is referenced by other tables

None.

History

Used first

Version 2.5

Used last

Still in use

Change history

= Version 2.5 =

create table photo_dupe (
  identifier            integer not null primary key,
  key                   integer not null,
  photo                 integer not null references photo(identifier),
  date_of_creation      timestamp,        -- date when it was inserted in the system
  storage_location      varchar(50),
  storage_index         varchar(10),
  remark                text              -- dupe remark
);
podoc/photo_dupe_sql_table.1176973863.txt.gz · Last modified: 2007/04/19 09:11 by Luud