SQL
CREATE TABLE tickers (
id INTEGER PRIMARY KEY,
symbol TEXT NOT NULL UNIQUE,
contract_id INTEGER UNIQUE
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
INTEGER |
✓ | ✓ | Rename | Drop |
symbol |
TEXT |
Rename | Drop | ||
contract_id |
INTEGER |
✓ | Rename | Drop |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_tickers_1 |
symbol
|
✓ | SQL | Drop |
| sqlite_autoindex_tickers_2 |
contract_id
|
✓ | SQL | Drop |