DB_tableCreationQuery.txt

# this is table creation - db query !
"""
   CREATE TABLE `shipment_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `origin` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `expected_shipment_datetime` text DEFAULT NULL,
  `types_of_service` varchar(255) DEFAULT NULL,
  `warehouse` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `quantities` text DEFAULT NULL,
  `carrier_details` varchar(255) DEFAULT NULL,
  `sender` varchar(255) DEFAULT NULL,
  `receiver` varchar(255) DEFAULT NULL,
  `cc` varchar(255) DEFAULT NULL,
  `bcc` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
"""