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,151–3,175 of 5,412

payment, page 127 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3151credit_card4002018-04-27 05:45:28
3152digital_wallet34002018-04-27 09:58:34
3153digital_wallet8002018-04-27 10:57:29
3154credit_card8002018-04-27 11:13:29
3155credit_card4002018-04-27 20:01:55
3156credit_card15002018-04-28 07:57:25
3157debit_card85002018-04-28 10:24:11
3158digital_wallet15002018-04-28 11:30:02
3159credit_card17002018-04-28 12:19:18
3160digital_wallet34002018-04-29 11:19:40
3161credit_card8002018-04-29 11:53:42
3162credit_card8002018-04-30 11:20:33
3163debit_card4002018-04-30 16:49:26
3164credit_card17002018-05-01 10:54:42
3165digital_wallet30002018-05-01 19:12:28
3166digital_wallet17002018-05-02 10:02:42
3167digital_wallet17002018-05-02 14:02:31
3168debit_card4002018-05-02 15:28:04
3169digital_wallet75002018-05-02 19:38:49
3170credit_card30002018-05-04 07:18:00
3171debit_card15002018-05-04 07:35:13
3172debit_card15002018-05-04 12:13:40
3173credit_card34002018-05-04 15:01:59
3174credit_card4002018-05-04 16:51:35
3175credit_card15002018-05-04 19:06:28
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;