Northwind Explorer

Categories table

Eight product groups, each with a bitmap picture stored as a BLOB. 8 rows.

Columns

PRAGMA table_info

#	Name	Type	Not null	Default	Key
0	`CategoryID`	`INTEGER`	no	—	PK
1	`CategoryName`	`TEXT`	yes	—
2	`Description`	`TEXT`	no	—
3	`Picture`	`BLOB`	no	—

Indexes

PRAGMA index_list

Name	Columns	Unique	Created by
`Categories_CategoryName`	`CategoryName`	no	CREATE INDEX

Referenced by

Products.CategoryID → Categories.CategoryID

Definition

from sqlite_schema

CREATE TABLE Categories (
    CategoryID   INTEGER PRIMARY KEY,
    CategoryName TEXT NOT NULL,
    Description  TEXT,
    Picture      BLOB
)