User Tools

Site Tools


podoc:shop_item_generator_rule_sql_table

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

Version 2.33

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

= Version 2.34 =

DROP TABLE shop_item_generator_rule;
Data change history
podoc/shop_item_generator_rule_sql_table.txt · Last modified: 2007/10/19 11:51 by Luud