User Tools

Site Tools


podoc:shop_category_sql_table

Database Table Description of "shop_category"

Name

shop_category

Description

Purpose

Schema

CREATE TABLE shop_category (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  users                 INTEGER NOT NULL REFERENCES users(identifier),
  caption               VARCHAR(300),
  date_of_creation      TIMESTAMP
);

References tables

  • users references users(identifier)

Is referenced by tables

None.

None.

None.

History

Used first

Version 2.19

Used last

Version 2.33

Schema change history

= Version 2.19 =

CREATE TABLE shop_category (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  users                 INTEGER NOT NULL REFERENCES users(identifier),
  caption               VARCHAR(300),
  date_of_creation      TIMESTAMP
);

= Version 2.34 =

DROP TABLE shop_category;
Data change history
podoc/shop_category_sql_table.txt · Last modified: 2007/10/19 15:51 by Luud