payment

1 row where rental_id = 8326

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

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

payment_id ▼ customer_id staff_id rental_id amount payment_date last_update
20 1 1 2 2 8326 8326 2.99 2005-07-29 03:58:49.000 2020-12-23 07:19:10

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