SQL
CREATE TABLE ticker_date (
ticker_id INTEGER NOT NULL REFERENCES tickers,
day INTEGER NOT NULL,
PRIMARY KEY(ticker_id,day)
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
ticker_id |
INTEGER |
✓ | Rename | Drop | |
day |
INTEGER |
✓ | Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
ticker_id |
tickers.None |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|