SQL

CREATE TABLE `manager_budgets`  (
  `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  `draft_id` integer NOT NULL,
  `manager_id` integer NOT NULL,
  `initial_budget` real DEFAULT 100 NOT NULL,
  `remaining_budget` real DEFAULT 100 NOT NULL,
  FOREIGN KEY (`draft_id`) REFERENCES `drafts`(`id`) ON UPDATE no action ON DELETE no action,
  FOREIGN KEY (`manager_id`) REFERENCES `managers`(`id`) ON UPDATE no action ON DELETE no action
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
draft_id INTEGER Rename | Drop
manager_id INTEGER Rename | Drop
initial_budget REAL Rename | Drop
remaining_budget REAL Rename | Drop

Foreign Keys

Column Destination
manager_id managers.id
draft_id drafts.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
uq_budget
  • draft_id
  • manager_id
 ✓ SQL 
CREATE UNIQUE INDEX `uq_budget`
ON `manager_budgets` (`draft_id`,`manager_id`)
Drop