CREATE TABLE `payment` (

`payment_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,

`customer_id` smallint(5) unsigned NOT NULL,

`staff_id` tinyint(3) unsigned NOT NULL,

`rental_id` int(11) DEFAULT NULL,

`amount` decimal(5,2) NOT NULL,

`payment_date` datetime NOT NULL,

`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (`payment_id`),

KEY `idx_fk_staff_id` (`staff_id`),

KEY `idx_fk_customer_id` (`customer_id`),

KEY `fk_payment_rental` (`rental_id`),

CONSTRAINT `fk_payment_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON UPDATE CASCADE,

CONSTRAINT `fk_payment_rental` FOREIGN KEY (`rental_id`) REFERENCES `rental` (`rental_id`) ON DELETE SET NULL ON UPDATE CASCADE,

CONSTRAINT `fk_payment_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`staff_id`) ON UPDATE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=16050 DEFAULT CHARSET=utf8