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 3,626–3,650 of 5,412

payment, page 146 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3626credit_card30002018-08-29 18:20:54
3627credit_card60002018-08-30 07:45:55
3628digital_wallet51002018-08-30 09:01:12
3629credit_card30002018-08-30 10:30:14
3630debit_card34002018-08-30 10:47:46
3631digital_wallet15002018-08-30 12:42:06
3632credit_card75002018-08-30 16:50:14
3633debit_card75002018-08-31 09:03:46
3634debit_card4002018-08-31 10:18:52
3635debit_card68002018-08-31 14:49:07
3636credit_card30002018-09-02 07:54:01
3637cash85002018-09-02 10:00:39
3638cash8002018-09-02 10:18:12
3639debit_card30002018-09-02 11:08:45
3640credit_card30002018-09-03 16:42:03
3641debit_card4002018-09-03 18:29:38
3642digital_wallet17002018-09-04 11:10:57
3643credit_card30002018-09-05 10:11:37
3644cash34002018-09-05 10:32:13
3645cash17002018-09-05 11:03:07
3646cash8002018-09-05 11:50:51
3647credit_card4002018-09-05 17:31:50
3648cash34002018-09-06 13:59:29
3649cash8002018-09-06 14:49:29
3650credit_card60002018-09-09 18:48:06
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;