CREATE TABLE `appreciations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `award` varchar(255) NOT NULL,
  `given_to` bigint(20) unsigned NOT NULL,
  `date` date NOT NULL,
  `summary` longtext NOT NULL,
  `photo` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `appreciations_given_to_foreign` (`given_to`),
  CONSTRAINT `appreciations_given_to_foreign` FOREIGN KEY (`given_to`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci