payment

27 rows where customer_id = 59

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: staff_id, amount, payment_date (date), last_update (date)

payment_id ▼ customer_id staff_id rental_id amount payment_date last_update
1620 59 59 2 2 212 212 4.99 2005-05-26 08:34:41.000 2020-12-23 07:19:32
1621 59 59 2 2 951 951 2.99 2005-05-30 16:10:35.000 2020-12-23 07:19:32
1622 59 59 1 1 1154 1154 5.99 2005-05-31 21:42:09.000 2020-12-23 07:19:32
1623 59 59 1 1 1269 1269 2.99 2005-06-15 07:29:59.000 2020-12-23 07:19:32
1624 59 59 1 1 1728 1728 3.99 2005-06-16 15:29:29.000 2020-12-23 07:19:32
1625 59 59 1 1 2921 2921 3.99 2005-06-20 04:13:04.000 2020-12-23 07:19:32
1626 59 59 2 2 4148 4148 2.99 2005-07-07 08:36:58.000 2020-12-23 07:19:32
1627 59 59 1 1 4384 4384 4.99 2005-07-07 20:46:45.000 2020-12-23 07:19:32
1628 59 59 1 1 4631 4631 4.99 2005-07-08 08:38:22.000 2020-12-23 07:19:32
1629 59 59 1 1 4891 4891 3.99 2005-07-08 20:06:19.000 2020-12-23 07:19:32
1630 59 59 2 2 5195 5195 8.99 2005-07-09 10:39:31.000 2020-12-23 07:19:32
1631 59 59 1 1 5207 5207 3.99 2005-07-09 11:15:44.000 2020-12-23 07:19:32
1632 59 59 1 1 5830 5830 4.99 2005-07-10 16:34:00.000 2020-12-23 07:19:32
1633 59 59 1 1 7991 7991 4.99 2005-07-28 14:45:45.000 2020-12-23 07:19:32
1634 59 59 2 2 8643 8643 4.99 2005-07-29 14:45:23.000 2020-12-23 07:19:32
1635 59 59 1 1 9469 9469 8.99 2005-07-30 22:56:34.000 2020-12-23 07:19:32
1636 59 59 2 2 9573 9573 6.99 2005-07-31 02:45:38.000 2020-12-23 07:19:32
1637 59 59 2 2 11396 11396 4.99 2005-08-02 18:48:29.000 2020-12-23 07:19:32
1638 59 59 1 1 12833 12833 5.99 2005-08-19 01:42:28.000 2020-12-23 07:19:32
1639 59 59 2 2 13282 13282 2.99 2005-08-19 18:08:18.000 2020-12-23 07:19:32
1640 59 59 1 1 13573 13573 2.99 2005-08-20 05:10:14.000 2020-12-23 07:19:32
1641 59 59 2 2 13921 13921 4.99 2005-08-20 16:57:11.000 2020-12-23 07:19:32
1642 59 59 1 1 14135 14135 5.99 2005-08-21 01:53:54.000 2020-12-23 07:19:32
1643 59 59 1 1 14977 14977 5.99 2005-08-22 07:12:53.000 2020-12-23 07:19:32
1644 59 59 2 2 15271 15271 5.99 2005-08-22 18:48:48.000 2020-12-23 07:19:32
1645 59 59 2 2 15744 15744 4.99 2005-08-23 12:15:51.000 2020-12-23 07:19:32
1646 59 59 2 2 15905 15905 2.99 2005-08-23 17:33:04.000 2020-12-23 07:19:32

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE payment (
  payment_id int NOT NULL,
  customer_id INT  NOT NULL,
  staff_id SMALLINT NOT NULL,
  rental_id INT DEFAULT NULL,
  amount DECIMAL(5,2) NOT NULL,
  payment_date TIMESTAMP NOT NULL,
  last_update TIMESTAMP NOT NULL,
  PRIMARY KEY  (payment_id),
  CONSTRAINT fk_payment_rental FOREIGN KEY (rental_id) REFERENCES rental (rental_id) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT fk_payment_customer FOREIGN KEY (customer_id) REFERENCES customer (customer_id) ,
  CONSTRAINT fk_payment_staff FOREIGN KEY (staff_id) REFERENCES staff (staff_id)
);
CREATE INDEX idx_fk_staff_id ON payment(staff_id)
;
CREATE INDEX idx_fk_customer_id ON payment(customer_id)
;