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,276–3,300 of 5,412

payment, page 132 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3276debit_card34002018-05-30 11:29:23
3277credit_card8002018-05-30 12:00:32
3278digital_wallet15002018-05-30 12:55:15
3279credit_card4002018-05-30 13:42:57
3280debit_card4002018-05-30 21:39:26
3281digital_wallet30002018-05-31 09:52:38
3282cash17002018-05-31 10:56:35
3283debit_card34002018-05-31 12:12:46
3284digital_wallet60002018-05-31 14:32:14
3285debit_card45002018-05-31 15:05:42
3286credit_card15002018-06-01 10:35:27
3287digital_wallet8002018-06-01 10:51:07
3288digital_wallet75002018-06-01 17:14:38
3289debit_card30002018-06-01 23:03:22
3290debit_card4002018-06-02 00:38:56
3291credit_card8002018-06-02 12:03:31
3292debit_card8002018-06-02 12:43:48
3293credit_card17002018-06-02 13:49:33
3294credit_card8002018-06-02 14:29:21
3295credit_card30002018-06-02 19:11:07
3296credit_card615002018-06-02 19:24:46
3297debit_card30002018-06-03 20:14:33
3298credit_card4002018-06-04 07:13:27
3299digital_wallet17002018-06-04 10:16:05
3300credit_card4002018-06-05 04:13:29
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;