payment

26 rows where customer_id = 111

✎ 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
2973 111 111 2 2 505 505 2.99 2005-05-28 02:06:37.000 2020-12-23 07:19:52
2974 111 111 1 1 1593 1593 6.99 2005-06-16 05:14:52.000 2020-12-23 07:19:52
2975 111 111 2 2 1974 1974 2.99 2005-06-17 09:30:05.000 2020-12-23 07:19:52
2976 111 111 2 2 1999 1999 1.99 2005-06-17 11:30:08.000 2020-12-23 07:19:52
2977 111 111 2 2 2297 2297 4.99 2005-06-18 08:17:41.000 2020-12-23 07:19:52
2978 111 111 2 2 3087 3087 2.99 2005-06-20 15:53:59.000 2020-12-23 07:19:52
2979 111 111 2 2 3333 3333 2.99 2005-06-21 10:01:36.000 2020-12-23 07:19:52
2980 111 111 2 2 3485 3485 1.99 2005-07-05 23:25:54.000 2020-12-23 07:19:52
2981 111 111 1 1 3551 3551 3.99 2005-07-06 02:33:48.000 2020-12-23 07:19:52
2982 111 111 2 2 3963 3963 9.99 2005-07-06 22:19:17.000 2020-12-23 07:19:52
2983 111 111 1 1 4249 4249 4.99 2005-07-07 14:05:17.000 2020-12-23 07:19:52
2984 111 111 2 2 4286 4286 0.99 2005-07-07 15:36:44.000 2020-12-23 07:19:52
2985 111 111 1 1 6896 6896 2.99 2005-07-12 21:25:37.000 2020-12-23 07:19:52
2986 111 111 2 2 8525 8525 0.99 2005-07-29 10:20:19.000 2020-12-23 07:19:52
2987 111 111 2 2 9933 9933 0.99 2005-07-31 15:24:46.000 2020-12-23 07:19:52
2988 111 111 2 2 10039 10039 2.99 2005-07-31 18:50:40.000 2020-12-23 07:19:52
2989 111 111 2 2 10602 10602 4.99 2005-08-01 14:30:23.000 2020-12-23 07:19:52
2990 111 111 1 1 10952 10952 4.99 2005-08-02 03:28:21.000 2020-12-23 07:19:52
2991 111 111 2 2 10990 10990 4.99 2005-08-02 04:41:06.000 2020-12-23 07:19:52
2992 111 111 2 2 11239 11239 2.99 2005-08-02 13:27:11.000 2020-12-23 07:19:52
2993 111 111 2 2 12196 12196 3.99 2005-08-18 02:08:48.000 2020-12-23 07:19:52
2994 111 111 2 2 13251 13251 2.99 2005-08-19 16:48:37.000 2020-12-23 07:19:52
2995 111 111 2 2 13525 13525 5.99 2005-08-20 02:50:44.000 2020-12-23 07:19:52
2996 111 111 1 1 14949 14949 0.99 2005-08-22 06:12:16.000 2020-12-23 07:19:52
2997 111 111 2 2 15174 15174 6.99 2005-08-22 15:26:36.000 2020-12-23 07:19:52
2998 111 111 2 2 15542 15542 2.99 2006-02-14 15:16:03.000 2020-12-23 07:19:52

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