--
-- Host: localhost    Database: bank
-- ------------------------------------------------------


--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `uuid` varchar(36) NOT NULL,
  `amount` decimal(10,0) NOT NULL,
  `date` varchar(255) NOT NULL DEFAULT '',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `status` enum('DECLINED','PENDING','ACEPTED') NOT NULL DEFAULT 'PENDING',
  `type` enum('SEND','RECEIVE') NOT NULL DEFAULT 'RECEIVE',
  `from` varchar(255) NOT NULL,
  `to` varchar(255) NOT NULL,
  `userUuid` varchar(36) NOT NULL,
  PRIMARY KEY (`uuid`),
  KEY `FK_88653dbe9b078bbd43b3534d44d` (`userUuid`),
  CONSTRAINT `FK_88653dbe9b078bbd43b3534d44d` FOREIGN KEY (`userUuid`) REFERENCES `users` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `transactions`
--



