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