payment

26 rows where customer_id = 570

✎ 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
15262 570 570 2 2 1060 1060 7.99 2005-05-31 08:21:43.000 2020-12-23 07:22:45
15263 570 570 1 1 1259 1259 4.99 2005-06-15 06:37:55.000 2020-12-23 07:22:45
15264 570 570 2 2 1417 1417 4.99 2005-06-15 17:45:51.000 2020-12-23 07:22:45
15265 570 570 2 2 1804 1804 2.99 2005-06-16 20:33:15.000 2020-12-23 07:22:45
15266 570 570 2 2 2008 2008 5.99 2005-06-17 11:48:05.000 2020-12-23 07:22:45
15267 570 570 2 2 2031 2031 6.99 2005-06-17 13:14:03.000 2020-12-23 07:22:45
15268 570 570 2 2 2261 2261 3.99 2005-06-18 05:46:15.000 2020-12-23 07:22:45
15269 570 570 2 2 3138 3138 2.99 2005-06-20 19:43:45.000 2020-12-23 07:22:45
15270 570 570 2 2 3984 3984 0.99 2005-07-06 23:22:36.000 2020-12-23 07:22:45
15271 570 570 1 1 4069 4069 0.99 2005-07-07 04:35:06.000 2020-12-23 07:22:45
15272 570 570 1 1 4698 4698 0.99 2005-07-08 11:19:31.000 2020-12-23 07:22:45
15273 570 570 2 2 5638 5638 4.99 2005-07-10 06:32:49.000 2020-12-23 07:22:45
15274 570 570 1 1 6253 6253 4.99 2005-07-11 15:07:19.000 2020-12-23 07:22:45
15275 570 570 1 1 6556 6556 0.99 2005-07-12 05:10:16.000 2020-12-23 07:22:45
15276 570 570 2 2 7174 7174 4.99 2005-07-27 08:00:36.000 2020-12-23 07:22:45
15277 570 570 2 2 8735 8735 4.99 2005-07-29 18:28:54.000 2020-12-23 07:22:45
15278 570 570 1 1 9385 9385 7.99 2005-07-30 19:25:49.000 2020-12-23 07:22:45
15279 570 570 1 1 9398 9398 0.99 2005-07-30 20:09:00.000 2020-12-23 07:22:45
15280 570 570 2 2 9432 9432 2.99 2005-07-30 21:26:18.000 2020-12-23 07:22:45
15281 570 570 1 1 9766 9766 4.99 2005-07-31 09:46:29.000 2020-12-23 07:22:45
15282 570 570 1 1 10004 10004 0.99 2005-07-31 17:51:23.000 2020-12-23 07:22:45
15283 570 570 2 2 10168 10168 2.99 2005-07-31 23:25:24.000 2020-12-23 07:22:45
15284 570 570 1 1 11098 11098 3.99 2005-08-02 08:06:18.000 2020-12-23 07:22:45
15285 570 570 2 2 12042 12042 4.99 2005-08-17 20:36:37.000 2020-12-23 07:22:45
15286 570 570 2 2 14768 14768 3.99 2005-08-21 23:44:53.000 2020-12-23 07:22:45
15287 570 570 1 1 12716 12716 0.99 2006-02-14 15:16:03.000 2020-12-23 07:22:45

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)
;