SQL
CREATE TABLE balances (
user_id TEXT PRIMARY KEY REFERENCES users(id),
amount INTEGER NOT NULL DEFAULT 30
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
user_id |
TEXT |
✓ | ✓ | Rename | Drop |
amount |
INTEGER |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
user_id |
users.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_balances_1 |
user_id
|
✓ | SQL | Drop |