SQL
CREATE TABLE produkte (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
preis REAL NOT NULL,
kategorie TEXT NOT NULL,
dokument_json TEXT NOT NULL
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
INTEGER |
✓ | ✓ | read-only |
name |
TEXT |
read-only | ||
preis |
REAL |
read-only | ||
kategorie |
TEXT |
read-only | ||
dokument_json |
TEXT |
read-only |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|