SQL
CREATE TABLE feedback (
id TEXT NOT NULL,
user_id TEXT,
version BIGINT,
type TEXT,
data JSON,
meta JSON,
snapshot JSON,
created_at BIGINT NOT NULL,
updated_at BIGINT NOT NULL,
PRIMARY KEY (id)
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
TEXT |
✓ | Rename | Drop | |
user_id |
TEXT |
✓ | Rename | Drop | |
version |
BIGINT |
✓ | Rename | Drop | |
type |
TEXT |
✓ | Rename | Drop | |
data |
JSON |
✓ | Rename | Drop | |
meta |
JSON |
✓ | Rename | Drop | |
snapshot |
JSON |
✓ | Rename | Drop | |
created_at |
BIGINT |
Rename | Drop | ||
updated_at |
BIGINT |
Rename | Drop |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_feedback_1 |
id
|
✓ | SQL | Drop |