SQL
CREATE TABLE projects (
pid INTEGER PRIMARY KEY,
title TEXT,
username TEXT,
n_ships INTEGER,
total_hours REAL,
total_payout INTEGER,
ships_json TEXT,
devlogs_json TEXT,
embedding_text TEXT,
last_checked REAL,
refresh_after REAL
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
pid |
INTEGER |
✓ | ✓ | read-only |
title |
TEXT |
✓ | read-only | |
username |
TEXT |
✓ | read-only | |
n_ships |
INTEGER |
✓ | read-only | |
total_hours |
REAL |
✓ | read-only | |
total_payout |
INTEGER |
✓ | read-only | |
ships_json |
TEXT |
✓ | read-only | |
devlogs_json |
TEXT |
✓ | read-only | |
embedding_text |
TEXT |
✓ | read-only | |
last_checked |
REAL |
✓ | read-only | |
refresh_after |
REAL |
✓ | read-only |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|