Table structure:
CREATE TABLE `deadlines` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `due_date` date NOT NULL,
  `notes` text DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_client_id` (`client_id`),
  KEY `idx_due_date` (`due_date`),
  KEY `idx_deleted_at` (`deleted_at`),
  CONSTRAINT `deadlines_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Column details:
Column: id
Type: int(11)
Null: NO
Key: PRI
Default: 
Extra: auto_increment

Column: client_id
Type: int(11)
Null: NO
Key: MUL
Default: 
Extra: 

Column: title
Type: varchar(255)
Null: NO
Key: 
Default: 
Extra: 

Column: due_date
Type: date
Null: NO
Key: MUL
Default: 
Extra: 

Column: notes
Type: text
Null: YES
Key: 
Default: 
Extra: 

Column: created_at
Type: datetime
Null: NO
Key: 
Default: 
Extra: 

Column: updated_at
Type: datetime
Null: NO
Key: 
Default: 
Extra: 

Column: deleted_at
Type: datetime
Null: YES
Key: MUL
Default: 
Extra: 

Indexes:
Key name: PRIMARY
Column name: id
Non unique: 0

Key name: idx_client_id
Column name: client_id
Non unique: 1

Key name: idx_due_date
Column name: due_date
Non unique: 1

Key name: idx_deleted_at
Column name: deleted_at
Non unique: 1