User Tools

Site Tools


podoc:shop_item_generator_rule_sql_table

This is an old revision of the document!


Database Table Description of "shop_item_generator_rule"

Name

shop_item_generator_rule

Description

Purpose

Schema

CREATE TABLE shop_item_generator_rule (
  identifier             INTEGER NOT NULL PRIMARY KEY,
  users                  INTEGER NOT NULL REFERENCES users(identifier),
  shop_item              INTEGER NOT NULL REFERENCES shop_item(identifier),
  price                  NUMERIC,
  currency               INTEGER REFERENCES currency(identifier),
  comment                text,
  date_of_creation       TIMESTAMP,
  date_of_last_edit      TIMESTAMP
);

References tables

  • currency references currency(identifier)
  • shop_item references shop_item(identifier)
  • users references users(identifier)

Is referenced by tables

None.

None.

None.

History

Used first

Version 2.26

Used last

Still in use

Schema change history

= Version 2.26 =

CREATE TABLE shop_item_generator_rule (
  identifier             INTEGER NOT NULL PRIMARY KEY,
  users                  INTEGER NOT NULL REFERENCES users(identifier),
  shop_item              INTEGER NOT NULL REFERENCES shop_item(identifier),
  price                  NUMERIC,
  currency               INTEGER REFERENCES currency(identifier),
  comment                text,
  date_of_creation       TIMESTAMP,
  date_of_last_edit      TIMESTAMP
);
Data change history
podoc/shop_item_generator_rule_sql_table.1177081601.txt.gz · Last modified: 2007/04/20 15:06 by Luud