SQL
CREATE TABLE account_credits (
user_id INTEGER PRIMARY KEY,
balance INTEGER NOT NULL DEFAULT 0,
updated_at TEXT NOT NULL,
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
user_id |
INTEGER |
✓ | ✓ | Rename | Drop |
balance |
INTEGER |
Rename | Drop | ||
updated_at |
TEXT |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
user_id |
users.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|