payment

17 rows where customer_id = 223

✎ 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
6024 223 223 2 2 524 524 2.99 2005-05-28 03:57:28.000 2020-12-23 07:20:34
6025 223 223 2 2 1839 1839 5.99 2005-06-16 23:22:22.000 2020-12-23 07:20:34
6026 223 223 1 1 2334 2334 4.99 2005-06-18 10:56:24.000 2020-12-23 07:20:34
6027 223 223 1 1 3513 3513 5.99 2005-07-06 00:45:57.000 2020-12-23 07:20:34
6028 223 223 1 1 3705 3705 0.99 2005-07-06 10:17:59.000 2020-12-23 07:20:34
6029 223 223 1 1 4874 4874 4.99 2005-07-08 19:23:38.000 2020-12-23 07:20:34
6030 223 223 2 2 5996 5996 2.99 2005-07-11 01:18:33.000 2020-12-23 07:20:34
6031 223 223 2 2 7085 7085 5.99 2005-07-27 04:35:44.000 2020-12-23 07:20:34
6032 223 223 2 2 8362 8362 3.99 2005-07-29 05:09:11.000 2020-12-23 07:20:34
6033 223 223 2 2 10053 10053 7.99 2005-07-31 19:15:39.000 2020-12-23 07:20:34
6034 223 223 2 2 11040 11040 4.99 2005-08-02 06:03:22.000 2020-12-23 07:20:34
6035 223 223 1 1 12927 12927 5.99 2005-08-19 05:02:46.000 2020-12-23 07:20:34
6036 223 223 1 1 13576 13576 0.99 2005-08-20 05:19:56.000 2020-12-23 07:20:34
6037 223 223 2 2 14496 14496 4.99 2005-08-21 14:07:35.000 2020-12-23 07:20:34
6038 223 223 1 1 15257 15257 7.99 2005-08-22 18:21:04.000 2020-12-23 07:20:34
6039 223 223 2 2 15546 15546 5.99 2005-08-23 04:20:38.000 2020-12-23 07:20:34
6040 223 223 1 1 15662 15662 2.99 2005-08-23 08:52:50.000 2020-12-23 07:20:34

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