Difference between revisions of "Public.categories (table)"

From dbscript Online Help
Jump to: navigation, search
Line 55: Line 55:
 
|- valign="top"
 
|- valign="top"
 
| category_idx
 
| category_idx
| Unique
+
|  
 
| categoryname
 
| categoryname
 
|}
 
|}

Revision as of 11:19, 27 August 2011

wikibot

Table public.categories

Columns

Column Data Type Nullable Default Description
categoryid integer not null
categoryname varchar(64) not null
categorydescription varchar(256) null

Primary Key

Primary Key Columns
category_pkey categoryid

Indexes

Index Type Columns
category_idx categoryname

Foreign Keys

Relation Column Referenced Column
public.categories categoryid categoryid