SQL
CREATE TABLE campaign_offers (
campaign_id INTEGER NOT NULL REFERENCES campaigns(id) ON DELETE CASCADE,
offer_id INTEGER NOT NULL REFERENCES offers(id) ON DELETE CASCADE,
sort INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (campaign_id, offer_id)
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
campaign_id |
INTEGER |
✓ | Rename | Drop | |
offer_id |
INTEGER |
✓ | Rename | Drop | |
sort |
INTEGER |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
offer_id |
offers.id |
campaign_id |
campaigns.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_campaign_offers_1 |
|
✓ | SQL | Drop |