Database Reference
In-Depth Information
Figure 3.1
Illustration of how data may be stored using a
PRIMARY KEY
Listing 3.1
Illustration of How Data May Be Stored Using a Single
PRIMARY
KEY
CREATE TABLE animals (
name TEXT PRIMARY KEY,
species TEXT,
subspecies TEXT,
genus TEXT,
family TEXT
);
SELECT * FROM animals;
name |family
| genus | species
| sub-
species
......+..........+.......+..................+.................
dog | Canidae | Canis |
C. lupus | C. l.
familiaris
cat | Felidae | Felis |
F. catus
| null
duck | Anatidae | Anas | A. platy-
rhynchos | null
wolf | Canidae | Canis |
C. lupus
|
null
