Skip to content
Louvre Ops DB

Table

payment

One row per payment; the method is a single column.

Replaces in 2020: Payment Methods

Download CSV Query in playground

Rows 676–700 of 5,412

payment, page 28 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
676credit_card8002015-09-27 13:23:22
677debit_card4002015-09-28 12:49:33
678credit_card30002015-09-28 21:39:26
679credit_card30002015-09-29 07:20:35
680credit_card75002015-09-30 11:20:43
681debit_card34002015-09-30 11:56:49
682debit_card8002015-09-30 12:36:08
683cash34002015-10-01 11:13:54
684credit_card8002015-10-01 11:41:39
685credit_card45002015-10-01 16:57:45
686credit_card4002015-10-01 20:53:41
687credit_card15002015-10-02 07:47:11
688cash85002015-10-02 08:53:12
689debit_card8002015-10-02 09:27:06
690credit_card17002015-10-02 12:39:07
691credit_card17002015-10-02 13:08:16
692cash51002015-10-02 14:39:51
693cash8002015-10-02 15:00:29
694credit_card8002015-10-02 15:29:13
695credit_card8002015-10-04 10:48:21
696credit_card15002015-10-04 11:56:43
697debit_card68002015-10-04 12:38:58
698cash8002015-10-04 13:07:01
699credit_card4002015-10-04 19:14:56
700debit_card4002015-10-04 23:39:17
Table definition
CREATE TABLE payment (
  payment_id   INTEGER PRIMARY KEY,
  method       TEXT NOT NULL
               CHECK (method IN ('credit_card', 'debit_card', 'digital_wallet', 'cash')),
  amount_cents INTEGER NOT NULL CHECK (amount_cents >= 0),
  paid_at      TEXT NOT NULL CHECK (paid_at GLOB '[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9]')
) STRICT;