{ "query": "CREATE TABLE `payment` (\n `payment_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `customer_id` smallint(5) unsigned NOT NULL,\n `staff_id` tinyint(3) unsigned NOT NULL,\n `rental_id` int(11) DEFAULT NULL,\n `amount` decimal(5,2) NOT NULL,\n `payment_date` datetime NOT NULL,\n `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n PRIMARY KEY (`payment_id`),\n KEY `idx_fk_staff_id` (`staff_id`),\n KEY `idx_fk_customer_id` (`customer_id`),\n KEY `fk_payment_rental` (`rental_id`),\n CONSTRAINT `fk_payment_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON UPDATE CASCADE,\n CONSTRAINT `fk_payment_rental` FOREIGN KEY (`rental_id`) REFERENCES `rental` (`rental_id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `fk_payment_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`staff_id`) ON UPDATE CASCADE\n) ENGINE=InnoDB AUTO_INCREMENT=16050 DEFAULT CHARSET=utf8", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "CREATE TABLE `payment` (\n `payment_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n `customer_id` smallint(5) unsigned NOT NULL,\n `staff_id` tinyint(3) unsigned NOT NULL,\n `rental_id` int(11) DEFAULT NULL,\n `amount` decimal(5,2) NOT NULL,\n `payment_date` datetime NOT NULL,\n `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n PRIMARY KEY (`payment_id`),\n KEY `idx_fk_staff_id` (`staff_id`),\n KEY `idx_fk_customer_id` (`customer_id`),\n KEY `fk_payment_rental` (`rental_id`),\n CONSTRAINT `fk_payment_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON UPDATE CASCADE,\n CONSTRAINT `fk_payment_rental` FOREIGN KEY (`rental_id`) REFERENCES `rental` (`rental_id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `fk_payment_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`staff_id`) ON UPDATE CASCADE\n) ENGINE=InnoDB AUTO_INCREMENT=16050 DEFAULT CHARSET=utf8", "len": 940, "last": 940, "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CREATE", "value": "CREATE", "keyword": "CREATE", "type": 1, "flags": 3, "position": 0 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 6 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TABLE", "value": "TABLE", "keyword": "TABLE", "type": 1, "flags": 3, "position": 7 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 12 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`payment`", "value": "payment", "keyword": null, "type": 8, "flags": 2, "position": 13 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 22 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 23 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 24 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`payment_id`", "value": "payment_id", "keyword": null, "type": 8, "flags": 2, "position": 27 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 39 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "smallint", "value": "SMALLINT", "keyword": "SMALLINT", "type": 1, "flags": 11, "position": 40 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 48 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "5", "value": 5, "keyword": null, "type": 6, "flags": 0, "position": 49 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 50 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 51 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "unsigned", "value": "UNSIGNED", "keyword": "UNSIGNED", "type": 1, "flags": 3, "position": 52 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 60 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 61 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 69 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AUTO_INCREMENT", "value": "AUTO_INCREMENT", "keyword": "AUTO_INCREMENT", "type": 1, "flags": 1, "position": 70 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 84 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 85 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`customer_id`", "value": "customer_id", "keyword": null, "type": 8, "flags": 2, "position": 88 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 101 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "smallint", "value": "SMALLINT", "keyword": "SMALLINT", "type": 1, "flags": 11, "position": 102 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 110 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "5", "value": 5, "keyword": null, "type": 6, "flags": 0, "position": 111 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 112 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 113 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "unsigned", "value": "UNSIGNED", "keyword": "UNSIGNED", "type": 1, "flags": 3, "position": 114 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 122 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 123 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 131 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 132 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`staff_id`", "value": "staff_id", "keyword": null, "type": 8, "flags": 2, "position": 135 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 145 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "tinyint", "value": "TINYINT", "keyword": "TINYINT", "type": 1, "flags": 11, "position": 146 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 153 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "3", "value": 3, "keyword": null, "type": 6, "flags": 0, "position": 154 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 155 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 156 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "unsigned", "value": "UNSIGNED", "keyword": "UNSIGNED", "type": 1, "flags": 3, "position": 157 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 165 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 166 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 174 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 175 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`rental_id`", "value": "rental_id", "keyword": null, "type": 8, "flags": 2, "position": 178 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 189 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "int", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 190 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 193 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "11", "value": 11, "keyword": null, "type": 6, "flags": 0, "position": 194 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 196 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 197 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT", "value": "DEFAULT", "keyword": "DEFAULT", "type": 1, "flags": 35, "position": 198 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 205 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NULL", "value": "NULL", "keyword": "NULL", "type": 1, "flags": 3, "position": 206 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 210 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 211 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`amount`", "value": "amount", "keyword": null, "type": 8, "flags": 2, "position": 214 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 222 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "decimal", "value": "DECIMAL", "keyword": "DECIMAL", "type": 1, "flags": 11, "position": 223 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 230 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "5", "value": 5, "keyword": null, "type": 6, "flags": 0, "position": 231 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 232 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "2", "value": 2, "keyword": null, "type": 6, "flags": 0, "position": 233 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 234 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 235 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 236 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 244 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 245 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`payment_date`", "value": "payment_date", "keyword": null, "type": 8, "flags": 2, "position": 248 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 262 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "datetime", "value": "datetime", "keyword": "DATETIME", "type": 1, "flags": 9, "position": 263 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 271 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 272 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 280 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 281 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`last_update`", "value": "last_update", "keyword": null, "type": 8, "flags": 2, "position": 284 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 297 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "timestamp", "value": "timestamp", "keyword": "TIMESTAMP", "type": 1, "flags": 41, "position": 298 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 307 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 308 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 316 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT", "value": "DEFAULT", "keyword": "DEFAULT", "type": 1, "flags": 35, "position": 317 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 324 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CURRENT_TIMESTAMP", "value": "CURRENT_TIMESTAMP", "keyword": "CURRENT_TIMESTAMP", "type": 1, "flags": 35, "position": 325 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 342 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON UPDATE", "value": "ON UPDATE", "keyword": "ON UPDATE", "type": 1, "flags": 7, "position": 343 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 352 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CURRENT_TIMESTAMP", "value": "CURRENT_TIMESTAMP", "keyword": "CURRENT_TIMESTAMP", "type": 1, "flags": 35, "position": 353 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 370 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 371 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PRIMARY KEY", "value": "PRIMARY KEY", "keyword": "PRIMARY KEY", "type": 1, "flags": 23, "position": 374 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 385 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 386 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`payment_id`", "value": "payment_id", "keyword": null, "type": 8, "flags": 2, "position": 387 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 399 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 400 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 401 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "KEY", "value": "KEY", "keyword": "KEY", "type": 1, "flags": 19, "position": 404 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 407 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`idx_fk_staff_id`", "value": "idx_fk_staff_id", "keyword": null, "type": 8, "flags": 2, "position": 408 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 425 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 426 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`staff_id`", "value": "staff_id", "keyword": null, "type": 8, "flags": 2, "position": 427 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 437 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 438 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 439 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "KEY", "value": "KEY", "keyword": "KEY", "type": 1, "flags": 19, "position": 442 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 445 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`idx_fk_customer_id`", "value": "idx_fk_customer_id", "keyword": null, "type": 8, "flags": 2, "position": 446 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 466 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 467 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`customer_id`", "value": "customer_id", "keyword": null, "type": 8, "flags": 2, "position": 468 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 481 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 482 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 483 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "KEY", "value": "KEY", "keyword": "KEY", "type": 1, "flags": 19, "position": 486 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 489 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`fk_payment_rental`", "value": "fk_payment_rental", "keyword": null, "type": 8, "flags": 2, "position": 490 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 509 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 510 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`rental_id`", "value": "rental_id", "keyword": null, "type": 8, "flags": 2, "position": 511 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 522 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 523 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 524 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CONSTRAINT", "value": "CONSTRAINT", "keyword": "CONSTRAINT", "type": 1, "flags": 3, "position": 527 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 537 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`fk_payment_customer`", "value": "fk_payment_customer", "keyword": null, "type": 8, "flags": 2, "position": 538 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 559 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FOREIGN KEY", "value": "FOREIGN KEY", "keyword": "FOREIGN KEY", "type": 1, "flags": 23, "position": 560 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 571 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 572 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`customer_id`", "value": "customer_id", "keyword": null, "type": 8, "flags": 2, "position": 573 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 586 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 587 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "REFERENCES", "value": "REFERENCES", "keyword": "REFERENCES", "type": 1, "flags": 3, "position": 588 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 598 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`customer`", "value": "customer", "keyword": null, "type": 8, "flags": 2, "position": 599 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 609 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 610 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`customer_id`", "value": "customer_id", "keyword": null, "type": 8, "flags": 2, "position": 611 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 624 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 625 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON UPDATE", "value": "ON UPDATE", "keyword": "ON UPDATE", "type": 1, "flags": 7, "position": 626 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 635 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CASCADE", "value": "CASCADE", "keyword": "CASCADE", "type": 1, "flags": 3, "position": 636 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 643 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 644 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CONSTRAINT", "value": "CONSTRAINT", "keyword": "CONSTRAINT", "type": 1, "flags": 3, "position": 647 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 657 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`fk_payment_rental`", "value": "fk_payment_rental", "keyword": null, "type": 8, "flags": 2, "position": 658 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 677 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FOREIGN KEY", "value": "FOREIGN KEY", "keyword": "FOREIGN KEY", "type": 1, "flags": 23, "position": 678 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 689 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 690 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`rental_id`", "value": "rental_id", "keyword": null, "type": 8, "flags": 2, "position": 691 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 702 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 703 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "REFERENCES", "value": "REFERENCES", "keyword": "REFERENCES", "type": 1, "flags": 3, "position": 704 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 714 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`rental`", "value": "rental", "keyword": null, "type": 8, "flags": 2, "position": 715 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 723 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 724 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`rental_id`", "value": "rental_id", "keyword": null, "type": 8, "flags": 2, "position": 725 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 736 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 737 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON DELETE", "value": "ON DELETE", "keyword": "ON DELETE", "type": 1, "flags": 7, "position": 738 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 747 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET NULL", "value": "SET NULL", "keyword": "SET NULL", "type": 1, "flags": 7, "position": 748 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 756 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON UPDATE", "value": "ON UPDATE", "keyword": "ON UPDATE", "type": 1, "flags": 7, "position": 757 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 766 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CASCADE", "value": "CASCADE", "keyword": "CASCADE", "type": 1, "flags": 3, "position": 767 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 774 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 775 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CONSTRAINT", "value": "CONSTRAINT", "keyword": "CONSTRAINT", "type": 1, "flags": 3, "position": 778 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 788 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`fk_payment_staff`", "value": "fk_payment_staff", "keyword": null, "type": 8, "flags": 2, "position": 789 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 807 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FOREIGN KEY", "value": "FOREIGN KEY", "keyword": "FOREIGN KEY", "type": 1, "flags": 23, "position": 808 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 819 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 820 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`staff_id`", "value": "staff_id", "keyword": null, "type": 8, "flags": 2, "position": 821 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 831 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 832 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "REFERENCES", "value": "REFERENCES", "keyword": "REFERENCES", "type": 1, "flags": 3, "position": 833 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 843 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`staff`", "value": "staff", "keyword": null, "type": 8, "flags": 2, "position": 844 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 851 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 852 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`staff_id`", "value": "staff_id", "keyword": null, "type": 8, "flags": 2, "position": 853 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 863 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 864 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON UPDATE", "value": "ON UPDATE", "keyword": "ON UPDATE", "type": 1, "flags": 7, "position": 865 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 874 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CASCADE", "value": "CASCADE", "keyword": "CASCADE", "type": 1, "flags": 3, "position": 875 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 882 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 883 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 884 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ENGINE", "value": "ENGINE", "keyword": "ENGINE", "type": 1, "flags": 1, "position": 885 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 891 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "InnoDB", "value": "InnoDB", "keyword": null, "type": 0, "flags": 0, "position": 892 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 898 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AUTO_INCREMENT", "value": "AUTO_INCREMENT", "keyword": "AUTO_INCREMENT", "type": 1, "flags": 1, "position": 899 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 913 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "16050", "value": 16050, "keyword": null, "type": 6, "flags": 0, "position": 914 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 919 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT CHARSET", "value": "DEFAULT CHARSET", "keyword": "DEFAULT CHARSET", "type": 1, "flags": 7, "position": 920 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 935 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "utf8", "value": "utf8", "keyword": null, "type": 0, "flags": 0, "position": 936 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 212, "idx": 212 }, "delimiter": ";", "delimiterLen": 1, "strict": false, "errors": [] }, "parser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "@1" }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "payment", "column": null, "expr": "`payment`", "alias": null, "function": null, "subquery": null }, "entityOptions": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": { "name": "ENGINE", "equals": true, "expr": "InnoDB", "value": "InnoDB" }, "2": { "name": "AUTO_INCREMENT", "equals": true, "expr": "16050", "value": "16050" }, "4": { "name": "DEFAULT CHARSET", "equals": true, "expr": "utf8", "value": "utf8" } } }, "fields": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "payment_id", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "SMALLINT", "parameters": [ "5" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "4": "UNSIGNED" } } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "NOT NULL", "3": "AUTO_INCREMENT" } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "customer_id", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "SMALLINT", "parameters": [ "5" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "4": "UNSIGNED" } } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "NOT NULL" } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "staff_id", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "TINYINT", "parameters": [ "3" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "4": "UNSIGNED" } } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "NOT NULL" } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "rental_id", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "INT", "parameters": [ "11" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "2": { "name": "DEFAULT", "equals": false, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "NULL", "alias": null, "function": null, "subquery": null }, "value": "NULL" } } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "amount", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "DECIMAL", "parameters": [ "5", "2" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "NOT NULL" } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "payment_date", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "DATETIME", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "NOT NULL" } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "last_update", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "TIMESTAMP", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "NOT NULL", "2": { "name": "DEFAULT", "equals": false, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "CURRENT_TIMESTAMP", "alias": null, "function": null, "subquery": null }, "value": "CURRENT_TIMESTAMP" }, "7": { "name": "ON UPDATE", "equals": false, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "CURRENT_TIMESTAMP", "alias": null, "function": null, "subquery": null }, "value": "CURRENT_TIMESTAMP" } } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": null, "isConstraint": null, "type": null, "key": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Key", "name": null, "columns": [ { "name": "payment_id" } ], "type": "PRIMARY KEY", "expr": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "references": null, "options": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": null, "isConstraint": null, "type": null, "key": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Key", "name": "idx_fk_staff_id", "columns": [ { "name": "staff_id" } ], "type": "KEY", "expr": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "references": null, "options": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": null, "isConstraint": null, "type": null, "key": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Key", "name": "idx_fk_customer_id", "columns": [ { "name": "customer_id" } ], "type": "KEY", "expr": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "references": null, "options": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": null, "isConstraint": null, "type": null, "key": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Key", "name": "fk_payment_rental", "columns": [ { "name": "rental_id" } ], "type": "KEY", "expr": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "references": null, "options": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "fk_payment_customer", "isConstraint": true, "type": null, "key": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Key", "name": null, "columns": [ { "name": "customer_id" } ], "type": "FOREIGN KEY", "expr": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "references": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Reference", "table": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "customer", "column": null, "expr": "`customer`", "alias": null, "function": null, "subquery": null }, "columns": [ "customer_id" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "3": { "name": "ON UPDATE", "equals": false, "expr": "CASCADE", "value": "CASCADE" } } } }, "options": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "fk_payment_rental", "isConstraint": true, "type": null, "key": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Key", "name": null, "columns": [ { "name": "rental_id" } ], "type": "FOREIGN KEY", "expr": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "references": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Reference", "table": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "rental", "column": null, "expr": "`rental`", "alias": null, "function": null, "subquery": null }, "columns": [ "rental_id" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "2": { "name": "ON DELETE", "equals": false, "expr": "SET NULL", "value": "SET NULL" }, "3": { "name": "ON UPDATE", "equals": false, "expr": "CASCADE", "value": "CASCADE" } } } }, "options": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "fk_payment_staff", "isConstraint": true, "type": null, "key": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Key", "name": null, "columns": [ { "name": "staff_id" } ], "type": "FOREIGN KEY", "expr": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "references": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Reference", "table": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "staff", "column": null, "expr": "`staff`", "alias": null, "function": null, "subquery": null }, "columns": [ "staff_id" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "3": { "name": "ON UPDATE", "equals": false, "expr": "CASCADE", "value": "CASCADE" } } } }, "options": null } ], "with": null, "select": null, "like": null, "partitionBy": null, "partitionsNum": null, "subpartitionBy": null, "subpartitionsNum": null, "partitions": null, "table": null, "return": null, "parameters": null, "body": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "6": "TABLE" } }, "first": 0, "last": 211 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }