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
- shop_item(category) references identifier
Related sequences
Related indexes
None.
Related functions
None.
Related views
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