Photo Organizer

shop_item_generator_rule

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

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

None.

• shop_item_generator_rule_id_sequence

None.

None.

• view_shop_item_generator_rule

Version 2.26

Version 2.33

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